[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] Advice on MyXactMade* flags, MyLastRecPtr, pendingDeletes and lazy XID assignment
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2007-08-31 1:55:24
Message-ID: 12280.1188525324 () sss ! pgh ! pa ! us
[Download RAW message or body]

Alvaro Herrera <alvherre@commandprompt.com> writes:
> Why don't we create temp tables in a separate directory, anyway?  That
> would make it trivially easy to get rid of them during recovery: just
> zap all the files in there.

Hmm ... doesn't do anything to fix the problem of file leakage for
crashes when making/deleting non-temp tables, but at least we could be
reasonably confident we weren't throwing away any data someone had a
long-term interest in.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate
[prev in list] [next in list] [prev in thread] [next in thread]