-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 21 Mar 2008 21:50:57 +0100 "Markus Wollny" <Markus.Wollny@xxxxxxxxxxx> wrote: > That's what I just did, but the problem persists. Whenever I issue a > 'vacuum', the number of transactions simply decreases. > > This is PostgreSQL 8.2.4 on x86_64-unknown-linux-gnu, compiled by GCC > gcc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) > > I am absolutely lost about what to do now - and it's a puzzle how > this could have happened in the first place. I have configured > autovaccum AND I run a vacuum verbose analyze over all databases > every single night. What do I do now? Is there some alternative to > reinit and going back to the last dump? > > Urgent help would be very much appreciated. > Vacuum every database. (template1,postgres too). This could happen if you have long running transactions that are not allow VACUUM to actually work. Sincerely, Joshua D. Drake > Kind regards > > Markus > > > > Computec Media AG > Sitz der Gesellschaft und Registergericht: Fürth (HRB 8818) > Vorstandsmitglieder: Johannes S. Gözalan (Vorsitzender) und Niels > Herrmann Vorsitzender des Aufsichtsrates: Jürg Marquard > Umsatzsteuer-Identifikationsnummer: DE 812 575 276 > > - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ United States PostgreSQL Association: http://www.postgresql.us/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFH5CcAATb/zqfZUUQRAl7CAJ9QGYJVqNVfHFgjVyCBswp1+d8kJgCfe+io 5d28sM4Gw4OkSBh/+U4jMDI= =iBx9 -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
