Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system - Mailing list pgsql-hackers

From Tomáš Vondra
Subject Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Date
Msg-id 8fhp7g5fg5swsobklx5o0kyu.1359845644540@email.android.com
Whole thread Raw
List pgsql-hackers
Ok, thanks for the info. I'll look into that and I'll also post info from some of our production systems (we've deployed a 9.1-backpatched version about 2 weeks ago).

T.



-------- Původní zpráva --------
Od: Jeff Janes <jeff.janes@gmail.com>
Datum:
Komu: Tomas Vondra <tv@fuzzy.cz>
Kopie: pgsql-hackers@postgresql.org
Předmět: Re: PATCH: Split stats file per database WAS: [HACKERS] autovacuum stress-testing our system


On Sat, Jan 5, 2013 at 8:03 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
> On 3.1.2013 20:33, Magnus Hagander wrote:
>>
>> Yeah, +1 for a separate directory not in global.
>
> OK, I moved the files from "global/stat" to "stat".

This has a warning:

pgstat.c:5132: warning: 'pgstat_write_statsfile_needed' was used with
no prototype before its definition

I plan to do some performance testing, but that will take a while so I
wanted to post this before I get distracted.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Next
From: Andres Freund
Date:
Subject: Re: autovacuum not prioritising for-wraparound tables