From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
---|---|
To: | Chris Boget <chris(at)wild(dot)net> |
Cc: | PGSql Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Noobie: Problems with a query |
Date: | 2003-06-30 12:35:16 |
Message-ID: | 1056976515.6646.6.camel@billy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-06-30 12:37:25 | Re: Noobie: Problems with a query |
Previous Message | Chris Boget | 2003-06-30 12:27:30 | Re: Noobie: Problems with a query |