From: | Kenneth Marshall <ktm(at)rice(dot)edu> |
---|---|
To: | Scott Whitney <swhitney(at)journyx(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_clogs hanging around |
Date: | 2011-03-10 15:09:00 |
Message-ID: | 20110310150900.GA8169@aart.is.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, Mar 10, 2011 at 08:18:34AM -0600, Scott Whitney wrote:
> > On Thu, Mar 10, 2011 at 07:56:26AM -0600, Scott Whitney wrote:
> > > >
> > > > If you have hardware problems like that you have way more
> > > > problems. You could have corruption (silent) occurring in any of
> > > > the other
> > > > database files. Good luck.
> > >
> > > I am, in fact, aware of that, but every single machine ever
> > > manufactured will have hardware problems such at this at some point.
> > > It stems quite simply from Ohm's Law, one gross over-simplification
> > > of which is as simple as "if it's got a resistor in it, it's going
> > > to fail at some point", as I'm sure you know. It's merely a matter
> > > of whether proactive replacement, backups, standby systems, etc
> > > ameliorate that risk. When we had our failure a couple of years ago,
> > > it did not.
> > >
> > > Regardless, my question still stands, and I do, in fact, care about
> > > ANY database blocking cleanup of clogs (or anything else). There's
> > > this concept of "if this then what else," and if template0 (or
> > > anyone else) is blocking that ability to properly clean those up,
> > > what else is possibly screwed up in a similar fashion.
> > >
> > > So, what can I do to resolve this issue?
> > >
> >
> > True, entropy rules. I think that you can use "VACUUM FREEZE"
> > to allow the clogs to be cleaned up.
> >
> I thought I was. I've got -F in there. vacuumdb -a -v -F
>
Sorry about that, you are. I have never done it from the command-line
just from psql. I was thinking F for FULL... :)
Cheers,
Ken
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Whitney | 2011-03-10 15:18:02 | Re: pg_clogs hanging around |
Previous Message | Stephen Frost | 2011-03-10 15:06:00 | Re: Oracle Label Security/ Row Level Security on Postgresql |