Re: database bloat,non removovable rows, slow query etc...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matteo Sgalaberni <sgala(at)sgala(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: database bloat,non removovable rows, slow query etc...
Date: 2006-09-01 17:35:20
Message-ID: 12756.1157132120@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Matteo Sgalaberni <sgala(at)sgala(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2006-09-01 19:49:43 Re: increasing shared buffers: how much should be removed from OS filesystem cache?
Previous Message Matteo Sgalaberni 2006-09-01 17:28:29 Re: database bloat,non removovable rows, slow query etc...