On Thu, Aug 6, 2009 at 11:32, Todd A. Cook<tc...@blackducksoftware.com> wrote: > Tom Lane wrote: >> >> I took a look through the CVS history and verified that there were >> no post-8.4 commits that looked like they'd affect performance in >> this area. So I think it's got to be a platform difference not a >> PG version difference. In particular I think we are probably looking >> at a filesystem issue: how fast can you delete [...] 30000 files. > > I'm still on Fedora 7, so maybe this will be motivation to upgrade. > > FYI, on my 8.2.13 system, the test created 30001 files which were all > deleted during the commit. On my 8.4.0 system, the test created 60001 > files, of which 30000 were deleted at commit and 30001 disappeared > later (presumably during a checkpoint?).
Smells like fsm? With double the number of files maybe something simple like turning on dir_index if you are ext3 will help? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers