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
> combinations and permutations to see what was fastest.
> on the 18000 documents in the table it reduced the time from 30 seconds
> 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 terry||Date: 2010-11-22 20:59:06|
|Subject: Re: Help with date query|
|Previous:||From: Richard Broersma||Date: 2010-11-22 17:20:00|
|Subject: Re: Change Data Capture|