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

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

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system
Date: 2013-01-03 17:47:40
Message-ID: 50E5C43C.5040309@vmware.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 03.01.2013 01:15, Tomas Vondra wrote:
> 2) a new global/stat directory
> ------------------------------
>
> The pgstat.stat file was originally saved into the "global" directory,
> but with so many files that would get rather messy so I've created a new
> global/stat directory and all the files are stored there.
>
> This also means we can do a simple "delete files in the dir" when
> pgstat_reset_all is called.

How about creating the new directory as a direct subdir of $PGDATA, 
rather than buried in global? "global" is supposed to contain data 
related to shared catalog relations (plus pg_control), so it doesn't 
seem like the right location for per-database stat files. Also, if we're 
going to have admins manually zapping the directory (hopefully when the 
system is offline), that's less scary if the directory is not buried as 
deep.

- Heikki


In response to

Responses

pgsql-hackers by date

Next:From: Christopher BrowneDate: 2013-01-03 17:54:45
Subject: Re: Re: Proposal: Store "timestamptz" of database creation on "pg_database"
Previous:From: Robert HaasDate: 2013-01-03 17:30:39
Subject: Re: pg_retainxlog for inclusion in 9.3?

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