From: Marcello Lorenzi <mlorenzi@sorint.it>
To: Campbell, Lance <lance@illinois.edu>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Enhancement Request
Date: Tue, 04 Mar 2014 16:02:15 +0100
Message-ID: <5315EAF7.2060703@sorint.it> (raw)
In-Reply-To: <B75CD08C73BD3543B97E4EF3964B7D701F79BDF8@CITESMBX1.ad.uillinois.edu>
References: <B75CD08C73BD3543B97E4EF3964B7D701F79BDF8@CITESMBX1.ad.uillinois.edu>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi Lance,
I don't know if you can create a tmpfs on your server and move the table
with a tablespace to the tmpfs mountpoint. In this case you can reach
the data on memory, but you have to mount and create the table to every
server restart.
Marcello
On 03/04/2014 03:49 PM, Campbell, Lance wrote:
>
> 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 <http://illinois.edu/person/lance;
>
> Software Architect
>
> Web Services at Public Affairs
>
> 217-333-0382
>
> University of Illinois at Urbana-Champaign logo <http://illinois.edu/;
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mlorenzi@sorint.it, lance@illinois.edu
Subject: Re: Enhancement Request
In-Reply-To: <5315EAF7.2060703@sorint.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox