Re: Survey on backing up unlogged tables: help us with PostgreSQL development!

Поиск
Список
Период
Сортировка
От Marc Mamin
Тема Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Дата
Msg-id C4DAC901169B624F933534A26ED7DF31034BB90A@JENMAIL01.ad.intershop.net
обсуждение исходный текст
Ответ на Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  ("Marc Mamin" <M.Mamin@intershop.de>)
Ответы Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello, 
another question.
I haven't read the complete threads, so I apologize if this was already discussed.

Will it be possible to switch from unlogged to logged ?

To improve COPY performances, I currently: 

- make a copy of heavily indexed tables
- load new data in the shadow table
- add the indexes
- drop the live table
- rename the shadow table to the visible one.

Is it imaginable to use unlogged tables foe the shadow one and then enable logging after the switch ?

regards,

Marc Mamin

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

Предыдущее
От: Marco Colombo
Дата:
Сообщение: Re: Linux x Windows LOCALE/ENCODING compatibility
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!