Re: Help me recovering data - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Help me recovering data
Date
Msg-id 4214601B.9020103@familyhealth.com.au
Whole thread Raw
In response to Re: Help me recovering data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>And most databases get a mix of updates and selects. I would expect it would
>>be pretty hard to go that long with any significant level of update activity
>>and no vacuums and not notice the performance problems from the dead tuples.
> 
> 
> I think the people who've managed to shoot themselves in the foot this
> way are those who decided to "optimize" their cron jobs to only vacuum
> their user tables, and forgot about the system catalogs. 

That's certainly the case with one of the people we helped in IRC - 3 
user tables only being vacuumed.

Chris


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Terminating a SETOF function call sequence
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Strange RETURN NEXT behaviour in Postgres 8.0