Re: Multiple databases

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Multiple databases
Дата
Msg-id 200301131432.47468.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Multiple databases  (Noah Silverman <noah@allresearch.com>)
Список 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 по дате отправления:

Предыдущее
От: Noah Silverman
Дата:
Сообщение: Re: Multiple databases
Следующее
От: Justin Clift
Дата:
Сообщение: Re: Sun vs. Mac - best Postgres platform?