Re: CLUSTER and synchronized scans and pg_dump et al

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CLUSTER and synchronized scans and pg_dump et al
Дата
Msg-id 3001.1201538162@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CLUSTER and synchronized scans and pg_dump et al  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: CLUSTER and synchronized scans and pg_dump et al  (Steve Atkins <steve@blighty.com>)
Re: CLUSTER and synchronized scans and pg_dump et al  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Kevin Grittner wrote:
>> It would seem reasonable to me for pg_dump to use ORDER BY to select
>> data from clustered tables.

> What will be the performance hit from doing that?

That worries me too.  Also, in general pg_dump's charter is to reproduce
the state of the database as best it can, not to "improve" it.
        regards, tom lane


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

Предыдущее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: system catalog constraints question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: GSSAPI doesn't play nice with non-canonical host names