From: | Robert Vojta <vojta(at)ipex(dot)cz> |
---|---|
To: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: indexes and big tables |
Date: | 2001-07-27 12:30:53 |
Message-ID: | 20010727143053.D6382@ipex.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> I would guess the problem is the restriction on counterstamp, because
> written like that, it probably can't use the index.
>
> try something where you avoid the use of the date_part function e.g.:
> AND counterstamp > '2001-07-26 00:00:00.0'
I will try it, but it use the index when there is a few amount of rows.
When I insert a lot of rows like me (in milions), index isn't used. I don't
know the number of rows which makes border between using and don't using
index and I can discover it if you want. Going to try your suggestions ...
Best regards,
Robert
--
_
|-| __ Robert Vojta <vojta-at-ipex.cz> -= Oo.oO =-
|=| [Ll] IPEX, s.r.o.
"^" ====`o
From | Date | Subject | |
---|---|---|---|
Next Message | Colin 't Hart | 2001-07-27 12:33:33 | Re: Re: Re: Storing XML in PostgreSQL |
Previous Message | mlw | 2001-07-27 11:40:38 | From TODO, XML? |