Erik Jones <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to