Search Postgresql Archives

Re: indexes are farked

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> When's the last time you analyzed this table?  And

a few hours before I posted this. vacuumdb --analyze
also runs every night.

> have you considered
> running the pg_autovacuum daemon, which will vacuum
> and analyze for you
> in the back ground?

We are using postgresql 7.3.2 which doesn't have
autovacuum.

Eugene


		
__________________________________ 
Yahoo! Mail for Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail 

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux