Re: How to speed up min/max(id) in 50M rows table?

Поиск
Список
Период
Сортировка
От henk de wit
Тема Re: How to speed up min/max(id) in 50M rows table?
Дата
Msg-id BAY124-W88F2EFD03BE4A24E21F0EF5A00@phx.gbl
обсуждение исходный текст
Ответ на How to speed up min/max(id) in 50M rows table?  (henk de wit <henk53602@hotmail.com>)
Список pgsql-performance
> This query takes a totally unrealistic amount of time for execution (I have it running for >30 minutes now on a machine with 8GB and 4 cores@2.66Ghz, and it still isn't finished).

To correct myself, I looked at the wrong window earlier, when I typed the email the query had in fact finished already and took about 18 minutes (which is still really long for such a query of course), but more than 30 minutes was wrong.




Express yourself instantly with MSN Messenger! MSN Messenger

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: How to speed up min/max(id) in 50M rows table?
Следующее
От: henk de wit
Дата:
Сообщение: Re: Huge amount of memory consumed during transaction