From: Kenneth Marshall <ktm@rice.edu>
To: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_clogs hanging around
Date: Thu, 10 Mar 2011 08:04:05 -0600
Message-ID: <20110310140405.GZ8169@aart.is.rice.edu> (raw)
In-Reply-To: <15608934.14100.1299765386313.JavaMail.root@zimbra.int.journyx.com>
References: <5879018.14098.1299765304748.JavaMail.root@zimbra.int.journyx.com>
<15608934.14100.1299765386313.JavaMail.root@zimbra.int.journyx.com>
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.
Cheers,
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ktm@rice.edu, swhitney@journyx.com
Subject: Re: pg_clogs hanging around
In-Reply-To: <20110310140405.GZ8169@aart.is.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox