Re: Help with date query

Поиск
Список
Период
Сортировка
От Matthew Walden
Тема Re: Help with date query
Дата
Msg-id AANLkTin-Y2fsG5i9EgFg7kBgy9NPTqfJyzZ35ydKmS3_@mail.gmail.com
обсуждение исходный текст
Ответ на Help with date query  (richard terry <rterry@pacific.net.au>)
Список 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 по дате отправления:

Предыдущее
От: Richard Broersma
Дата:
Сообщение: Re: Change Data Capture
Следующее
От: richard terry
Дата:
Сообщение: Re: Help with date query