| From: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| To: | Greg Stark <gsstark(at)mit(dot)edu> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Help me recovering data |
| Date: | 2005-02-17 07:10:05 |
| Message-ID: | Pine.LNX.4.44.0502170807540.4086-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 17 Feb 2005, Greg Stark wrote:
> Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
>
> > We do ~4000 txn/minute so in 6 month you are screewd up...
>
> Sure, but if you ran without vacuuming for 6 months, wouldn't you notice the
> huge slowdowns from all those dead tuples before that?
Most people that we have seen on irc that run into the problem do vacuum
some tables, but forget to vacuum all. Then their tables work fine but
suddenly some system tables like pg_databases and pg_shadow become empty
since they never was vacuumed...
--
/Dennis Björklund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-02-17 08:14:08 | Re: Design notes for BufMgrLock rewrite |
| Previous Message | Jim C. Nasby | 2005-02-17 05:39:25 | Re: Design notes for BufMgrLock rewrite |