Re: Remove xmin and cmin from frozen tuples
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Josh Berkus <josh@agliodbs.com>, pgsql-hackers@postgresql.org, ITAGAKI Takahiro <itagaki.takahiro@lab.ntt.co.jp>
Date: 2005-09-02T22:35:10Z
Lists: pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes: > I remember somebody mentioned some time ago that if you create a table > and then crash before ending the transaction, the tuple in pg_class is > no longer valid, but the file remains. Right --- it will be removed on transaction rollback, but not if the backend crashes first. There was a patch submitted earlier this year to try to clean out such files, but it got rejected (as too messy IIRC). I think we still have a TODO item about it. regards, tom lane