Re: I/O on select count(*)

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: I/O on select count(*)
Дата
Msg-id 20080514201330.5293c5bf@jd-laptop
обсуждение исходный текст
Ответ на Re: I/O on select count(*)  (Luke Lonergan <llonergan@greenplum.com>)
Список pgsql-performance
On Thu, 15 May 2008 10:52:01 +0800
Luke Lonergan <llonergan@greenplum.com> wrote:

> BTW ­ we¹ve removed HINT bit checking in Greenplum DB and improved the
> visibility caching which was enough to provide performance at the
> same level as with the HINT bit optimization, but avoids this whole
> ³write the data, write it to the log also, then write it again just
> for good measure² behavior.
>
> For people doing data warehousing work like the poster, this Postgres
> behavior is miserable.  It should be fixed for 8.4 for sure
> (volunteers?)

Donations? You have the code Luke :)

Sincerely,

Joshua D. Drake

P.S. Sorry for the almost bad Star Wars pun.

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate



Вложения

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: I/O on select count(*)
Следующее
От: Tino Wildenhain
Дата:
Сообщение: Re: I/O on select count(*)