Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Can we load all database objects in memory? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: [SQL] Can we load all database objects in memory?
Date
Msg-id dcc563d10903251312p1af78f2dt8d18a978eacf37bb@mail.gmail.com
Whole thread Raw
In response to Can we load all database objects in memory?  (DM <dm.aeqa@gmail.com>)
List pgsql-general
Tree view 
On Wed, Mar 25, 2009 at 1:20 PM, DM <dm.aeqa@gmail.com> wrote:
> Hi All,
>
> I have a database of 10GB.
> My Database Server has a RAM of 16GB
>
> Is there a way that I can load all the database objects to memory?

Just replying to pgsql-general...

Yeah, just select * from table for each table, then they'll be in
kernel cache and ready to go.

pgsql-general by date:

Previous
From: Richard Broersma
Date:
Subject: Re: 8.3.7 Windows Update Error
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Question about hosting and server grade