Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system

From: Tomáš Vondra <tv(at)fuzzy(dot)cz>
To: jeff(dot)janes(at)gmail(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Date: 2013-02-02 22:54:04
Message-ID: 8fhp7g5fg5swsobklx5o0kyu.1359845644540@email.android.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)janes(at)gmail(dot)com>
Datum:
Komu: Tomas Vondra <tv(at)fuzzy(dot)cz>
Kopie: pgsql-hackers(at)postgresql(dot)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(at)fuzzy(dot)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

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-02-03 01:40:04 Re: autovacuum not prioritising for-wraparound tables
Previous Message Jeff Janes 2013-02-02 22:33:10 Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system