Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Tom LaneDate: 2007-10-17 15:56:14
Subject: Re: Vacuum goes worse
Previous:From: Stefano Dal PraDate: 2007-10-17 14:35:16
Subject: Re: Vacuum goes worse

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group