Re: query performance, though it was timestamps,maybe just table size?

Поиск
Список
Период
Сортировка
От Henry Drexler
Тема Re: query performance, though it was timestamps,maybe just table size?
Дата
Msg-id CAAtgU9TNigm2cF-b2EGkM40g2MiZak1viMTFKaxqX+mRra5DhQ@mail.gmail.com
обсуждение исходный текст
Ответ на query performance, though it was timestamps,maybe just table size?  (Henry Drexler <alonup8tb@gmail.com>)
Список pgsql-general
Дерево обсуждения



On Fri, Nov 30, 2012 at 8:22 AM, Henry Drexler <alonup8tb@gmail.com> wrote:
Hello, and thank you in advance.


Beyond the date vs timestamp troubleshooting I did,

I realize this could be confusing - since I ruled out that difference, the real question is - given this setup, why would the query time go from 4 minutes to over 50, for an increase in table rows from 30 million to 65 million?

В списке pgsql-general по дате отправления:

Предыдущее
От: ivan marchesini
Дата:
Сообщение: Re: difference in query performance due to the inclusion of a polygon geometry field
Следующее
От: David Greco
Дата:
Сообщение: Re: UPDATE syntax