Tom Lane wrote:
I wrote:Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes:Regarding temp tables, I'd think that the pgstat entries should be getting dropped at some point in both releases. Maybe there's a bug preventing that in 8.2?Hmmm ... I did rewrite the backend-side code for that just recently for performance reasons ... could I have broken it?I did some testing with HEAD and verified that pgstat_vacuum_tabstat() still seems to do what it's supposed to, so that theory falls down. Alvaro, could you send Benjamin your stat-file-dumper tool so we can get some more info?
Alternatively, if Benjamin wants to send me a copy of his stats file (off-list), I'd be happy to take a look. regards, tom lane
When I checked on the server this morning, the huge stats file has returned to a normal size. I set up a script to track CPU usage and stats file size, and it appears to have decreased from 90MB down to about 2MB over roughly 6 hours last night. The CPU usage of the stats collector also decreased accordingly.
The application logs indicate that there was no variation in the workload over this time period, however the file size started to decrease soon after the nightly pg_dump backups completed. Coincidence perhaps?
Nonetheless, I would appreciate a copy of Alvaro's stat file tool just to see if anything stands out in the collected stats.
Thanks for your help, Tom. -- Benjamin Minshall <minshall@xxxxxxxxxxxxxx> Senior Developer -- Intellicon, Inc. http://www.intellicon.biz
Attachment:
smime.p7s
Description: S/MIME Cryptographic Signature
