Enhancement Request

Поиск
Список
Период
Сортировка
От Campbell, Lance
Тема Enhancement Request
Дата
Msg-id B75CD08C73BD3543B97E4EF3964B7D701F79BDF8@CITESMBX1.ad.uillinois.edu
обсуждение исходный текст
Ответы Re: Enhancement Request  (Marcello Lorenzi <mlorenzi@sorint.it>)
Re: Enhancement Request  ("ktm@rice.edu" <ktm@rice.edu>)
Список pgsql-admin

Web Services at the University of Illinois has been using PostgreSQL for 11 years for serving up web content.  We generate around two million pages of database driven content a month.  We love the work you are doing.

 

I have an enhancement request.  Sometimes when using a database there is a need to have particular tables always in memory.  An example of this would be our web application session data.  The session data is used by a cluster of tomcat nodes.  It would be nice to have a way to say to PostgreSQL, put this particular table data in memory always.  If you already have this feature please let me know.  There would probably also need to be a way to see how much data is being taken up by these preferred tables.  This would probably require other things to also be put into memory as well like indexes. 

 

To get around this issue we are planning on implementing a second PostgreSQL database on a dedicated server in order to make sure the session data is always in memory.  But it would be nice to not actually have a second server for just session data if we really don’t need it.

 

Thanks for considering this idea.

 

 

Thanks,

 

Lance Campbell

Software Architect

Web Services at Public Affairs

217-333-0382

University of Illinois at Urbana-Champaign logo

 

 

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Autovacuum progressing slow (with high activity on the system).
Следующее
От: Marcello Lorenzi
Дата:
Сообщение: Re: Enhancement Request