Re: query performance - Mailing list pgsql-general

From Brian Cox
Subject Re: query performance
Date
Msg-id 48112464.5010604@ca.com
Whole thread Raw
In response to query performance  (Brian Cox <brian.cox@ca.com>)
Responses Re: query performance  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: query performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane [tgl@sss.pgh.pa.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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: query performance
Next
From: "Scott Marlowe"
Date:
Subject: Re: query performance