Re: Help with date query - Mailing list pgsql-novice

From Matthew Walden
Subject Re: Help with date query
Date
Msg-id AANLkTin-Y2fsG5i9EgFg7kBgy9NPTqfJyzZ35ydKmS3_@mail.gmail.com
Whole thread Raw
In response to Help with date query  (richard terry <rterry@pacific.net.au>)
List pgsql-novice
That sounds a bit more reasonable!  Glad it worked out OK.

--
View my Linkedin profile


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.


pgsql-novice by date:

Previous
From: Richard Broersma
Date:
Subject: Re: Change Data Capture
Next
From: richard terry
Date:
Subject: Re: Help with date query