tablespace + RAM disk?

Поиск
Список
Период
Сортировка
От David Parker
Тема tablespace + RAM disk?
Дата
Msg-id 07FDEE0ED7455A48AC42AC2070EDFF7C26BBB3@corpsrv2.tazznetworks.com
обсуждение исходный текст
Ответы Re: tablespace + RAM disk?  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: index use
Следующее
От: Chris Browne
Дата:
Сообщение: Re: When to bump up statistics?