Re: GSoC proposal - "make an unlogged table logged"
От | Fabrízio de Royes Mello |
---|---|
Тема | Re: GSoC proposal - "make an unlogged table logged" |
Дата | |
Msg-id | CAFcNs+odxM+GLheNrVNG2C6Us787vPQWnGyLc0t33-BhF-41Ag@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: GSoC proposal - "make an unlogged table logged" (Hannu Krosing <hannu@2ndQuadrant.com>) |
Ответы |
Re: GSoC proposal - "make an unlogged table logged"
|
Список | pgsql-hackers |
On Mon, Mar 3, 2014 at 2:40 PM, Hannu Krosing <hannu@2ndquadrant.com> wrote:
>
> On 03/03/2014 05:22 PM, Tom Lane wrote:
> > Stephen Frost <sfrost@snowman.net> writes:
> ...
> >> ISTR the discussion going something along the lines of "we'd have to WAL
> >> log the entire table to do that, and if we have to do that, what's the
> >> point?".
> > IIRC, the reason you'd have to do that is to make the table contents
> > appear on slave servers. If you don't consider replication then it might
> > seem easier.
> So switch on logging and then perform CLUSTER/VACUUM FULL ?
>
> Should this work, or is something extra needed ?
>
6) drop table foo; -- the old foo table
7) alter table tmp_foo rename to foo;
8) end transactionI know it's very ugly, but works... and works for standbys too... :-)
Regards,
--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog sobre TI: http://fabriziomello.blogspot.com
>> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
В списке pgsql-hackers по дате отправления: