On Donnerstag, 14. Mai 2009, Philipp Marek wrote: > On Donnerstag, 14. Mai 2009, Alvaro Herrera wrote: > > Philipp Marek wrote: > > > On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote: > > > > Do say, do you have any long-running transactions, or "idle" > > > > transactions? Maybe someone opened a terminal somewhere and left it > > > > open for days? Have a look at pg_stat_activity. > > > > > > Yes, I have two terminal windows for different users/schemas in the > > > same DB open - but they're set to auto-commit, and have no tables open > > > or locked. > > > > Please close them and try again. > > I'll try this tonight. Well, that doesn't seem to help either. * I had vacuum_freeze_min_age=0 set for the session doing CLUSTER. * No session were open during the CLUSTER. Result: * Indizes are not compacted. Compared to an earlier night with a similar number of records two btree- indizes went from 300M to ~400M (roughly). Regards, Phil -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
