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

Re: query performance

From: Brian Cox <brian(dot)cox(at)ca(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: query performance
Date: 2008-04-25 00:23:00
Message-ID: 48112464.5010604@ca.com (view raw or flat)
Thread:
Lists: pgsql-general
Tom Lane [tgl(at)sss(dot)pgh(dot)pa(dot)us] wrote:
> You need a database-wide vacuum verbose (not just 1 table) to get that
> output ...

I ran:

 > pgsql -U admin -d cemdb -c 'vacuum verbose' > /tmp/pgvac.log 2>&1

the output file has 2593 lines and, while I haven't looked at all of 
them, a:

 > fgrep -i fsm /tmp/pgvac.log

returns no lines.

Any hints as to where the FSM info is in this file?

Thanks,
Brian


Responses

pgsql-general by date

Next:From: Scott MarloweDate: 2008-04-25 00:29:01
Subject: Re: query performance
Previous:From: Tom LaneDate: 2008-04-25 00:12:36
Subject: Re: query performance

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