tablespace + RAM disk? - Mailing list pgsql-performance

From David Parker
Subject tablespace + RAM disk?
Date
Msg-id 07FDEE0ED7455A48AC42AC2070EDFF7C26BBB3@corpsrv2.tazznetworks.com
Whole thread Raw
Responses Re: tablespace + RAM disk?
List pgsql-performance
We are using 7.4.5 on Solaris 9.

We have a couple tables (holding information about network sessions, for instance) which don't need to persist beyond
thelife of the server, but while the server is running they are heavily hit, insert/update/delete. 

Temporary tables won't work for us because they are per-connection, and we are using a thread pool, and session data
couldbe accessed from multiple connections. 

Would 8.0 tablespaces, with a tablespace placed on a RAM disk be a potential solution for this? I have used RAM disks
fordisk caches in the past, but I don't know if there are any special issues with defining a tablespace that way. 

Thanks.

- DAP
----------------------------------------------------------------------------------
David Parker    Tazz Networks    (401) 709-5130
 

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: index use
Next
From: Chris Browne
Date:
Subject: Re: When to bump up statistics?