Re: Moving pgstat.stat and pgstat.tmp - Mailing list pgsql-general

From Tom Lane
Subject Re: Moving pgstat.stat and pgstat.tmp
Date
Msg-id 14371.1196720207@sss.pgh.pa.us
Whole thread Raw
In response to Moving pgstat.stat and pgstat.tmp  (Erik Jones <erik@myemma.com>)
Responses Re: Moving pgstat.stat and pgstat.tmp
List pgsql-general
Erik Jones <erik@myemma.com> writes:
> Hi, I'm currently doctoring a situation wherein we've got table
> inheritance scheme that over the years that has ballooned like only
> in your nightmares (think well over 100K tables + indexes on those).
> The obvious solution is to re-design the schema with a better
> partitioning scheme in mind (see another msg from me later today on
> that) but that's a big project that's just getting underway and an
> immediate concern is the I/O on out data partition due in large part
> to the stats file(s) getting hammered.

Which PG version?  Early 8.2.x releases had a nasty bug that caused
excessive stats file writes.

            regards, tom lane

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: PL/pgSQL and SETOF
Next
From: Alvaro Herrera
Date:
Subject: Re: postmaster logfile