Skip site navigation (1) Skip section navigation (2)

Re: Help with date query

From: Matthew Walden <matthew(dot)walden(at)bcs(dot)org>
To: richard terry <rterry(at)pacific(dot)net(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Help with date query
Date: 2010-11-22 20:58:39
Message-ID: AANLkTin-Y2fsG5i9EgFg7kBgy9NPTqfJyzZ35ydKmS3_@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
That sounds a bit more reasonable!  Glad it worked out OK.

-- 
View my Linkedin profile <http://uk.linkedin.com/in/matthewdwalden>


> Thanks, I did just that after some consideration. I ran the query in
> various
> combinations and permutations to see what was fastest.
>
> on the 18000 documents in the table it reduced the time from 30 seconds
> down
> to 600msec which is acceptable to me - to pull out say all the documents
> imported in the last month.
>
> Thanks for taking the time to reply.
>

In response to

pgsql-novice by date

Next:From: richard terryDate: 2010-11-22 20:59:06
Subject: Re: Help with date query
Previous:From: Richard BroersmaDate: 2010-11-22 17:20:00
Subject: Re: Change Data Capture

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group