Skip site navigation (1) Skip section navigation (2)

Re: Huge number of disk writes after migration to 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcin <migor(at)op(dot)pl>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: Huge number of disk writes after migration to 8.1
Date: 2006-01-17 20:51:18
Message-ID: 21380.1137531078@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
Marcin <migor(at)op(dot)pl> writes:
> Attached you'll find the archive with data you've asked.

Well, breaking down the contents of the stats file I find:
	190 backends (218880 bytes)
	118 databases (8496 bytes)
	81952 tables (8523008 bytes)
And the ps listing shows there actually are about 190 live backends,
so the idea about leaked backend stats entries is clearly wrong.

The per-table data is 104 bytes/table, up from 80 in 8.0, so that's
a noticeable increase but hardly a killer.  What I have to conclude
is that 8.1 is tracking stats for a lot more tables than 8.0 was.
(Do you happen to have a number for the size of the stats file in
the 8.0 installation?  I don't need to see its contents, I just want
to know how big it is.)

Do you actually have 81952 tables in the installation?  Maybe we are
looking at a table-level leak.  Do you have autovacuum on where it was
not in 8.0?  Maybe that's causing it.

			regards, tom lane

Responses

pgsql-bugs by date

Next:From: Robert TreatDate: 2006-01-17 21:58:23
Subject: improper estimates even with high statistic values
Previous:From: Giles MorantDate: 2006-01-17 20:21:49
Subject: BUG #2177: (minor:) pgsql: Trailing semicolon on \d treated as argument

pgsql-patches by date

Next:From: Tom LaneDate: 2006-01-17 22:12:09
Subject: Re: Huge number of disk writes after migration to 8.1
Previous:From: Tom LaneDate: 2006-01-17 14:36:13
Subject: Re: TupleDesc refcounting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group