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:33:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Scott Marlowe [scott(dot)marlowe(at)gmail(dot)com] wrote:
> There's bits spread throughout the file, but the summary is at the bottom.

Here's a tail of the 'vacuum verbose' output:

INFO:  vacuuming "pg_toast.pg_toast_797619965"
INFO:  index "pg_toast_797619965_index" now contains 0 row versions in 1 
DETAIL:  0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  "pg_toast_797619965": found 0 removable, 0 nonremovable row 
versions in 0 pages
DETAIL:  0 dead row versions cannot be removed yet.
There were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.

I don't see anything that looks like a "summary".


pgsql-general by date

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

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