Re: GSoC proposal - "make an unlogged table logged"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GSoC proposal - "make an unlogged table logged"
Дата
Msg-id 10144.1393867355@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: GSoC proposal - "make an unlogged table logged"  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: GSoC proposal - "make an unlogged table logged"  (Hannu Krosing <hannu@2ndQuadrant.com>)
Список pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> * Robert Haas (robertmhaas@gmail.com) wrote:
>> On Mon, Mar 3, 2014 at 11:28 AM, Fabr�zio de Royes Mello
>> <fabriziomello@gmail.com> wrote:
>>> Is the TODO item "make an unlogged table logged" [1] a good GSoC project?

>> I'm pretty sure we found some problems in that design that we couldn't
>> figure out how to solve.  I don't have a pointer to the relevant
>> -hackers discussion off-hand, but I think there was one.

> 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.
        regards, tom lane



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: patch: option --if-exists for pg_dump
Следующее
От: Tan Tran
Дата:
Сообщение: Re: GSoC on WAL-logging hash indexes