DROP TABLESPACE with crash-resistance (remove unused files)

DropTablespaceProblem

We are facing a problem in dropping a tablespace after crash recovery. The
recovery starts from the last checkpoint, but the tables that were created by
a transaction in a tablespace before the checkpoint are still lying around; the
transaction had not finished by the time of crash.

After recovery, when the app tries to drop the tablespace, the command fails
since the tablespace directory is not empty.

Solving this problem has become quite critical since the the platform where
Postgres is being used is supposed to run unattended for a few years. The
problem is currently being solved by a kluge, which is highly undesirable.

Has this problem been reported/discussed earlier? Any suggestions to avoid this
situation?

Bookmark https://savannah.nongnu.org/projects/libunwind/
http://www.google.com.hk/search?q=github+edit+files&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
Cool GitHub feature: edit file in-place « require 'brain'
http://lwn.net/Articles/282261/
http://uploads.enterprisedb.com/download.php?file=855c824b60a97339b371c2bdbe644946


File Name: create_multi_index.day2feature_complete.zip
File Size: 0 MB
Time Stamp: November 11, 2010, 11:23 pm
Download Link:
http://uploads.enterprisedb.com/download.php?file=06ddcc2b683ba08ad4f98c1bbe262676
Delete Link:
http://uploads.enterprisedb.com/download.php?file=06ddcc2b683ba08ad4f98c1bbe262676&del=190856

File Name: create_multi_index.day1.zip
File Size: 0 MB
Time Stamp: November 11, 2010, 11:25 pm
Download Link:
http://uploads.enterprisedb.com/download.php?file=b04c12c815676a8ca1bef57257558386
Delete Link:
http://uploads.enterprisedb.com/download.php?file=b04c12c815676a8ca1bef57257558386&del=669617

File Name: diffnew.zip
File Size: 0 MB
Time Stamp: November 12, 2010, 1:35 am
Download Link:
http://uploads.enterprisedb.com/download.php?file=0e346967cf4def8317510ae934c02a8d
Delete Link:
http://uploads.enterprisedb.com/download.php?file=0e346967cf4def8317510ae934c02a8d&del=230441

File Name: create_multi_index.day2_end.zip
File Size: 0 MB
Time Stamp: November 12, 2010, 4:05 am
Download Link:
http://uploads.enterprisedb.com/download.php?file=5432f920fa1d96cb85e333180a44cbcc
Delete Link:
http://uploads.enterprisedb.com/download.php?file=5432f920fa1d96cb85e333180a44cbcc&del=118489

File Name: CreateMultiIndex.perf.txt
File Size: 0 MB
Time Stamp: November 12, 2010, 4:14 am
Download Link:
http://uploads.enterprisedb.com/download.php?file=76afd84f896989be75fdd6329e26fc2f
Delete Link:
http://uploads.enterprisedb.com/download.php?file=76afd84f896989be75fdd6329e26fc2f&del=143744

File Name: Disk Page Validity Check Using Magic Number_diff.rarr
File Size: 0 MB
Time Stamp: November 14, 2010, 5:54 pm
Download Link:
http://uploads.enterprisedb.com/download.php?file=6b16930ab23bb35233969f0e46a5f202
Delete Link:
http://uploads.enterprisedb.com/download.php?file=6b16930ab23bb35233969f0e46a5f202&del=352401

Bookmark http://www.cs.uwaterloo.ca/~h8chen/course/798/ConceptArch.pdf

File Name: AHC_Queries.sql
File Size: 0.01 MB
Time Stamp: November 18, 2010, 6:32 pm
Download Link:
http://uploads.enterprisedb.com/download.php?file=509be4f304bd56d1e082080b8c38e8d5
Delete Link:
http://uploads.enterprisedb.com/download.php?file=509be4f304bd56d1e082080b8c38e8d5&del=544486

Bookmark: http://lifehacker.com/5391308/build-a-silent-standalone-xbmc-media-center-on-the-cheap

Ask Postgres community why we don't allow 
CREATE INDEX i on t( a+b )
and insist on 
((a+b))
gram.y can be changed to allow it by change:
index_elem: ...
          | '(' a_expr ')' opt_class opt_asc_desc opt_nulls_order

to
index_elem: ...
          | a_expr opt_class opt_asc_desc opt_nulls_order


File Name: replace_pkey_index.uniq.doc.revised1.zip
File Size: 0 MB
Time Stamp: November 22, 2010, 3:13 am
Download Link:
http://uploads.enterprisedb.com/download.php?file=ecf7ebd3c345f0048956a675df340b0e
Delete Link:
http://uploads.enterprisedb.com/download.php?file=ecf7ebd3c345f0048956a675df340b0e&del=338349

File Name: replace_pkey_index.uniq.doc.revised1.zip
File Size: 0 MB
Time Stamp: November 22, 2010, 3:42 am
Download Link:
http://uploads.enterprisedb.com/download.php?file=08763a75cb6c5ccb4051c48bafc4e495
Delete Link:
http://uploads.enterprisedb.com/download.php?file=08763a75cb6c5ccb4051c48bafc4e495&del=895169

File Name: replace_pkey_index.uniq.doc.revised1.full.part1.rar
File Size: 0 MB
Time Stamp: November 22, 2010, 3:45 am
Download Link:
http://uploads.enterprisedb.com/download.php?file=00bd948aa74873633a4a6cb37aaf3432
Delete Link:
http://uploads.enterprisedb.com/download.php?file=00bd948aa74873633a4a6cb37aaf3432&del=844091

File Name: replace_pkey_index.uniq.doc.revised1.full.part2.rar
File Size: 0 MB
Time Stamp: November 22, 2010, 3:45 am
Download Link:
http://uploads.enterprisedb.com/download.php?file=563d5c92dcdc2cf673794efa84565e66
Delete Link:
http://uploads.enterprisedb.com/download.php?file=563d5c92dcdc2cf673794efa84565e66&del=692133

Bookmark: Perl Color tail linux
http://fixunix.com/unix/83044-tail-color.html
http://www.davidpashley.com/articles/writing-robust-shell-scripts.html

TOREAD:
http://msdn.microsoft.com/en-us/magazine/cc301708.aspx
http://msdn.microsoft.com/en-us/magazine/cc301711.aspx