Re: WAL logging of SELECT ... INTO command

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: WAL logging of SELECT ... INTO command
Дата
Msg-id 1143032914.24487.632.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: WAL logging of SELECT ... INTO command  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: WAL logging of SELECT ... INTO command  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
Дерево обсуждения 
On Wed, 2006-03-22 at 06:47 -0600, Jim C. Nasby wrote:

> Also, why do we log rows for CTAS/SELECT INTO when PITR is in use for
> simple SELECTs (ones that don't call non-deterministic functions)? The
> data should alread be available AFAICS...

Not sure what you're asking... SELECTs don't produce WAL.

PITR wants all changes. Without PITR we can optimise certain logging
actions.

Best Regards, Simon Riggs

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Migration study, step 1: bulk write performanceoptimization
Следующее
От: "Mikael Carneholm"
Дата:
Сообщение: Re: Migration study, step 1: bulk write performanceoptimization