Re: Vacuum goes worse

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stéphane Schildknecht <stephane(dot)schildknecht(at)postgresqlfr(dot)org>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Vacuum goes worse
Date: 2007-10-17 15:53:46
Message-ID: 6788.1192636426@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?ISO-8859-1?Q?St=E9phane_Schildknecht?= <stephane(dot)schildknecht(at)postgresqlfr(dot)org> writes:
> Yes, I am. The command line is (in a shell script whom ouput is
> redirected in a global file) :

> vacuumdb -d $DBNAME -p $DBPORT -U $DBUSR -z -v

> That does not explain why we don't get FSM statitics display.

Is $DBUSR a superuser? If not, some tables are likely getting skipped.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-10-17 15:56:14 Re: Vacuum goes worse
Previous Message Stefano Dal Pra 2007-10-17 14:35:16 Re: Vacuum goes worse