Re: Noobie: Problems with a query - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Noobie: Problems with a query
Date
Msg-id 1056976515.6646.6.camel@billy
Whole thread Raw
In response to Re: Noobie: Problems with a query  ("Chris Boget" <chris@wild.net>)
List pgsql-novice
Am Mon, 2003-06-30 um 14.27 schrieb Chris Boget:

> What was that supposed to tell me?
>
> As (problem) db owner:
>
> => vacuum analyze;
> WARNING:  Skipping "pg_group" --- only table or database owner can VACUUM it
> WARNING:  Skipping "pg_shadow" --- only table or database owner can VACUUM it
> WARNING:  Skipping "pg_database" --- only table or database owner can VACUUM it
> VACUUM
> =>
>
> As root:
>
> =# vacuum analyze;
> VACUUM
> =#
>
> What am I missing?

Nothing, maybe.
The pg_* tables are only used internally and shouldn't have an impact on
your queries.
So the VACUUM should be ok as owner.

VACUUM ANALYZE tries to optimize your queries.
You should do this every now and then.

bye
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Noobie: Problems with a query
Next
From: "cristi"
Date:
Subject: blobs