caching/ virtual file systems
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?
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@gmx.net http://funkturm.homeip.net/~peter