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: (view raw or whole thread)
Lists: 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.

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-2015 The PostgreSQL Global Development Group