Re: Multiple databases - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Multiple databases
Date
Msg-id 200301131432.47468.josh@agliodbs.com
Whole thread Raw
In response to Re: Multiple databases  (Noah Silverman <noah@allresearch.com>)
List pgsql-performance
Noah,

> Can someone give me a good description of what the various directories
> and files actually are.  I have RTFMed, but the descriptions there
> don't seem to match what I have on my machine.

Within $PGDATA:

/base is all database files unless you use WITH LOCATION
/pg_clog is the Clog, which keeps a permanent count of transactions
/pg_xlog is the transaction log (WAL)
/global are a small number of relations, like pg_database or pg_user, which
are available in all databases.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco


pgsql-performance by date:

Previous
From: Noah Silverman
Date:
Subject: Re: Multiple databases
Next
From: Justin Clift
Date:
Subject: Re: Sun vs. Mac - best Postgres platform?