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

Re: caching/ virtual file systems

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Clayton Vernon <cvernon(at)enron(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: caching/ virtual file systems
Date: 2001-04-27 15:22:14
Message-ID: Pine.LNX.4.30.0104271720390.758-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-general
Clayton Vernon writes:

> A newbie question as I prepare to dive into this:
>
> Under $PGDATA, can I expect to see subdirectories emerge within databases, say for INDICES, TABLES, etc?

The layout (in 7.1) is $PGDATA/base/<oid of database>/<oid of table,index...>

> The reason:
>
> On Solaris,
>
> I have some RAM in /tmp I want to employ as a virtual file system to increase the performance of PG. I've mounted the software in /tmp/pgsql/...., and I would also like to mount some of the data files here as well. Since PG will create files I will need for the symbolic links to be at the directory level, so I was wondering if anyone had developed any "tricks" to get certain blocks of data files to fall into subdirectories?

Unless you like your data, don't do that.  What happens in case of a
crash?

-- 
Peter Eisentraut   peter_e(at)gmx(dot)net   http://funkturm.homeip.net/~peter


In response to

pgsql-general by date

Next:From: Michelle MurrainDate: 2001-04-27 15:42:26
Subject: pg_encoding
Previous:From: Steve WamplerDate: 2001-04-27 15:20:46
Subject: Re: Re: I am now Linux and PostgreSQL user, have a question

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