From: | ries van Twisk <ries(at)vantwisk(dot)nl> |
---|---|
To: | DM <dm(dot)aeqa(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [SQL] Can we load all database objects in memory? |
Date: | 2009-03-25 19:59:01 |
Message-ID: | E11323FB-852D-48AE-9ACB-90E569B282F3@vantwisk.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-sql |
Deepak,
please don't cross-post the same question to 3 different lists.
The short answer is no, you cannot force PostgreSQL to load all
objects into memory.
However when you proper configure PostgreSQL most, if not all of your
data will be cached
by the OS and/or PostgreSQL shared memory system.
Ries
> 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?
>
> Thanks for your time and taking a look at this question.
>
>
> Thanks
> Deepak
From | Date | Subject | |
---|---|---|---|
Next Message | ries van Twisk | 2009-03-25 20:07:21 | Re: [SQL] Can we load all database objects in memory? |
Previous Message | DM | 2009-03-25 19:20:08 | Can we load all database objects in memory? |
From | Date | Subject | |
---|---|---|---|
Next Message | ries van Twisk | 2009-03-25 20:07:21 | Re: [SQL] Can we load all database objects in memory? |
Previous Message | DM | 2009-03-25 19:20:08 | Can we load all database objects in memory? |
From | Date | Subject | |
---|---|---|---|
Next Message | ries van Twisk | 2009-03-25 20:07:21 | Re: [SQL] Can we load all database objects in memory? |
Previous Message | DM | 2009-03-25 19:20:08 | Can we load all database objects in memory? |