Simon Riggs wrote: > On Mon, 2010-02-01 at 12:11 +0200, Heikki Linnakangas wrote: >> Simon Riggs wrote: >>> On Mon, 2010-02-01 at 11:33 +0200, Heikki Linnakangas wrote: >>>> Can you reproduce that? >>> Every time >> Ok, good :-). What I really meant was: How? > > As mentioned in first post: VACUUM FULL and CLUSTER.
I'm asking because I couldn't reproduce it. I added an elog(LOG) to XLogReportUnloggedStatement() so that I can see when an unlogged-record is written. Then I ran: CREATE TEMPORARY TABLE foo (id int4); VACUUM FULL foo; But XLogReportUnloggedStatement() was not executed. When I removed the "TEMPORARY" and tried again, it was executed. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
