Re: Postgres INSERT performance and scalability

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Postgres INSERT performance and scalability
Дата
Msg-id 20110920013241.GR12765@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Postgres INSERT performance and scalability  (Jon Nelson <jnelson+pgsql@jamponi.net>)
Список pgsql-performance
* Jon Nelson (jnelson+pgsql@jamponi.net) wrote:
> Isn't the WAL basically COW?

eh..?  No..  The WAL is used to record what changes are made to the
various files in the database, it certainly isn't an kind of
"copy-on-write" system, where we wait until a change is made to data
before copying it..

If you INSERT .. SELECT, you're going to get the real data in the WAL,
and also in the heap of the new table..

    Thanks,

        Stephen

Вложения

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

Предыдущее
От: Jon Nelson
Дата:
Сообщение: Re: Postgres INSERT performance and scalability
Следующее
От: "Anibal David Acosta"
Дата:
Сообщение: where is max_fsm_pages in PG9.0?