Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Looking at the code, stats entries for dropped tables are cleaned out
>> only when a VACUUM command is done; which is something we probably ought
>> to change.
> I was going to ask if you were confusing pgstat_vacuum_tabstat with a
>
Tom Lane wrote:
> Marcin <[EMAIL PROTECTED]> writes:
> > So there's not 81952, BUT, the tables are created (and dropped) quite
> > often during the work hours (and they're regular, not TEMPORARY tables).
> > I also find out, that there were 11170 tables created (and most of them
> > dropped) toda
Marcin <[EMAIL PROTECTED]> writes:
> Autovacuum is off.
> The VACUUM FULL bottom line is:
> INFO: free space map contains 59842 pages in 25371 relations
> DETAIL: A total of 426720 page slots are in use (including overhead).
> 426720 page slots are required to track all free space.
> And the qu
After some extensive discussion on irc, berkus, myself and a few others
think we have uncovered a possible bug, or at the least some odd
behavior in > 8.1.1. It centers around my recent post to performance
http://archives.postgresql.org/pgsql-performance/2006-01/msg00248.php
and how I could not see
Marcin <[EMAIL PROTECTED]> 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 actual
Marcin <[EMAIL PROTECTED]> writes:
> After migration from 8.0.3 to 8.1.2 I noticed huge increase in number of
> bytes written to disk. I think it's caused by stats collector process,
> but I may be wrong.
The strace output shows that the collector is writing about 8.5MB to the
stats display file o
Short introduction:
After migration from 8.0.3 to 8.1.2 I noticed huge increase in number of
bytes written to disk. I think it's caused by stats collector process,
but I may be wrong.
Some details:
1. Hardware: 2*Opteron 275, Tyan motherboard, 8GBs DDR ECC RAM, 2*SCSI
73GB 15k RPM drives.
2. Sof
