Re: database size grows (even after vacuum (full and analyze))....

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Joao Miguel Ferreira <jmf(at)estg(dot)ipvc(dot)pt>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: database size grows (even after vacuum (full and analyze))....
Date: 2006-05-03 20:07:21
Message-ID: 20060503200721.GA6188@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Wed, May 03, 2006 at 18:57:24 +0100,
Joao Miguel Ferreira <jmf(at)estg(dot)ipvc(dot)pt> wrote:
>
> 1) How can I check these possible open transactions ?

http://developer.postgresql.org/docs/postgres/monitoring-ps.html

> 2) what is FSM ?

http://developer.postgresql.org/docs/postgres/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-FSM

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guy Fraser 2006-05-03 20:28:25 Re: How does an application recognize the death of the
Previous Message Magnus Hagander 2006-05-03 19:36:40 Re: logfiles filling up

Browse pgsql-novice by date

  From Date Subject
Next Message John J. Urbaniak 2006-05-04 13:05:00 What is really necessary?
Previous Message Joao Miguel Ferreira 2006-05-03 18:19:47 Re: database size grows (even after vacuum (full and