On Fri, Jul 14, 2006 at 05:36:58PM +0200, Florian G. Pflug wrote: > That was the idea - providing pg_rotate_wal(), which would guarantee that > the wal is rotatted at least once if called. Thinking further about this, > for a first prove of concept, I'd be enough to write a C function > pg_current_walsegment(). pg_rotate_wal() could then be a plpgsql function, > that e.g. creates a temporary table, and fills it with data, until the > return value of pg_current_walsegment() changes.
Temporary tables don't get xlogged. It would probably be easier to hook into the xlog machinery and create NOP records, like you originally suggested. Have a nice day, -- Martijn van Oosterhout <firstname.lastname@example.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
Description: Digital signature