| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Brian Cox" <brian(dot)cox(at)ca(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: query performance |
| Date: | 2008-04-25 00:29:01 |
| Message-ID: | dcc563d10804241729y775a01acme80f00fad75af4fd@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Apr 24, 2008 at 6:23 PM, Brian Cox <brian(dot)cox(at)ca(dot)com> wrote:
> 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?
There's bits spread throughout the file, but the summary is at the bottom.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Cox | 2008-04-25 00:33:52 | Re: query performance |
| Previous Message | Brian Cox | 2008-04-25 00:23:00 | Re: query performance |