> 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 ...
|-| __ Robert Vojta <vojta-at-ipex.cz> -= Oo.oO =-
|=| [Ll] IPEX, s.r.o.
In response to
pgsql-hackers by date
|Next:||From: Colin 't Hart||Date: 2001-07-27 12:33:33|
|Subject: Re: Re: Re: Storing XML in PostgreSQL|
|Previous:||From: mlw||Date: 2001-07-27 11:40:38|
|Subject: From TODO, XML?|