Postgres Pro
Downloads
Home   >   mailing lists

Re: database bloat,non removovable rows, slow query etc... - Mailing list pgsql-performance

From Tom Lane
Subject Re: database bloat,non removovable rows, slow query etc...
Date
Msg-id 12756.1157132120@sss.pgh.pa.us
Whole thread Raw
In response to Re: database bloat,non removovable rows, slow query etc...  (Matteo Sgalaberni <sgala@sgala.com>)
Responses Re: database bloat,non removovable rows, slow query etc... [RESOLVED]
List pgsql-performance
Tree view 
Matteo Sgalaberni <sgala@sgala.com> writes:
> Ok. I stopped all clients. No connections to this database.

When you say "this database", do you mean the whole postmaster cluster,
or just the one database?  Open transactions in other databases of the
same cluster can be a problem.

            regards, tom lane

pgsql-performance by date:

Previous
From: Matteo Sgalaberni
Date:
Subject: Re: database bloat,non removovable rows, slow query etc...
Next
From: "Merlin Moncure"
Date:
Subject: Re: increasing shared buffers: how much should be removed from OS filesystem cache?