Re: indexes are farked

From: Dr NoName <spamacct11(at)yahoo(dot)com>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: indexes are farked
Date: 2005-08-02 18:26:56
Message-ID: 20050802182657.92319.qmail@web31513.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2005-08-02 18:27:33 Re: Slow Inserts on 1 table?
Previous Message Dr NoName 2005-08-02 18:24:25 Re: indexes are fucked