caching/ virtual file systems - Mailing list pgsql-general

From Clayton Vernon
Subject caching/ virtual file systems
Date
Msg-id 00d001c0cea3$f089fce0$5a2510ac@corp.enron.com
Whole thread Raw
Responses Re: caching/ virtual file systems
List pgsql-general
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 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?

pgsql-general by date:

Previous
From: Philip Poten
Date:
Subject: Returning tuple(s) from C-Functions
Next
From: Joel Burton
Date:
Subject: Re: I am now Linux and PostgreSQL user, have a question