Re: Noobie: Problems with a query

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


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match