pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan we load all database objects in memory?
7+ messages / 6 participants
[nested] [flat]
* Can we load all database objects in memory?
@ 2009-03-25 19:20 DM <dm.aeqa@gmail.com>
0 siblings, 4 replies; 7+ messages in thread
From: DM @ 2009-03-25 19:20 UTC (permalink / raw)
To: pgsql-admin; pgsql-general@postgresql.org; pgsql-sql@postgresql.org
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL] Can we load all database objects in memory?
@ 2009-03-25 19:59 ries van Twisk <ries@vantwisk.nl>
parent: DM <dm.aeqa@gmail.com>
3 siblings, 0 replies; 7+ messages in thread
From: ries van Twisk @ 2009-03-25 19:59 UTC (permalink / raw)
To: DM <dm.aeqa@gmail.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org; pgsql-sql@postgresql.org
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
Attachments:
smime.p7s (application/pkcs7-signature, 2.4K) download
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL] Can we load all database objects in memory?
@ 2009-03-25 20:07 ries van Twisk <pg@rvt.dds.nl>
parent: DM <dm.aeqa@gmail.com>
3 siblings, 1 reply; 7+ messages in thread
From: ries van Twisk @ 2009-03-25 20:07 UTC (permalink / raw)
To: DM <dm.aeqa@gmail.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org; pgsql-sql@postgresql.org
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
On Mar 25, 2009, at 2:20 PM, DM 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?
>
> Thanks for your time and taking a look at this question.
>
>
> Thanks
> Deepak
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Can we load all database objects in memory?
@ 2009-03-25 20:09 Iñigo Martinez Lasala <imartinez@vectorsf.com>
parent: DM <dm.aeqa@gmail.com>
3 siblings, 1 reply; 7+ messages in thread
From: Iñigo Martinez Lasala @ 2009-03-25 20:09 UTC (permalink / raw)
To: DM <dm.aeqa@gmail.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org; pgsql-sql@postgresql.org
Increase effective_cache_size parameter.
An "effective_cache_size=11GB" should be more than enough.
-----Original Message-----
From: DM <dm.aeqa@gmail.com>
To: pgsql-admin@postgresql.org, pgsql-general@postgresql.org,
pgsql-sql@postgresql.org
Subject: [ADMIN] Can we load all database objects in memory?
Date: Wed, 25 Mar 2009 12:20:08 -0700
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
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL] Can we load all database objects in memory?
@ 2009-03-25 20:11 Iñigo Martinez Lasala <imartinez@vectorsf.com>
parent: ries van Twisk <pg@rvt.dds.nl>
0 siblings, 0 replies; 7+ messages in thread
From: Iñigo Martinez Lasala @ 2009-03-25 20:11 UTC (permalink / raw)
To: ries van Twisk <pg@rvt.dds.nl>; +Cc: pgsql-admin
And I replied to all list also...
Sorry. :(
-----Original Message-----
From: ries van Twisk <pg@rvt.dds.nl>
To: DM <dm.aeqa@gmail.com>
Cc: pgsql-admin@postgresql.org, pgsql-general@postgresql.org,
pgsql-sql@postgresql.org
Subject: Re: [ADMIN] [SQL] Can we load all database objects in memory?
Date: Wed, 25 Mar 2009 15:07:21 -0500
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
On Mar 25, 2009, at 2:20 PM, DM 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?
>
> Thanks for your time and taking a look at this question.
>
>
> Thanks
> Deepak
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [SQL] Can we load all database objects in memory?
@ 2009-03-25 20:12 Scott Marlowe <scott.marlowe@gmail.com>
parent: DM <dm.aeqa@gmail.com>
3 siblings, 0 replies; 7+ messages in thread
From: Scott Marlowe @ 2009-03-25 20:12 UTC (permalink / raw)
To: DM <dm.aeqa@gmail.com>; +Cc: pgsql-general@postgresql.org
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.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: [ADMIN] Can we load all database objects in memory?
@ 2009-03-26 09:44 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Iñigo Martinez Lasala <imartinez@vectorsf.com>
0 siblings, 0 replies; 7+ messages in thread
From: Albe Laurenz @ 2009-03-26 09:44 UTC (permalink / raw)
To: Iñigo Martinez Lasala *EXTERN* <imartinez@vectorsf.com>; DM <dm.aeqa@gmail.com>; +Cc: pgsql-general@postgresql.org
Iñigo Martinez Lasala 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? Thanks for your time and taking a look
>> at this question. Thanks Deepak
>
> Increase effective_cache_size parameter.
>
> An "effective_cache_size=11GB" should be more than enough.
Sorry, but that is quite wrong.
effective_cache_size only affects the planner, not memory utilization.
You can use shared_buffers=11GB to give PostgreSQL memory enough
to buffer all of a 10GB database in memory. But that does not
automatically put all the tables in memory.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2009-03-26 09:44 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-25 19:20 Can we load all database objects in memory? DM <dm.aeqa@gmail.com>
2009-03-25 19:59 ` ries van Twisk <ries@vantwisk.nl>
2009-03-25 20:07 ` ries van Twisk <pg@rvt.dds.nl>
2009-03-25 20:11 ` Iñigo Martinez Lasala <imartinez@vectorsf.com>
2009-03-25 20:09 ` Iñigo Martinez Lasala <imartinez@vectorsf.com>
2009-03-26 09:44 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2009-03-25 20:12 ` Scott Marlowe <scott.marlowe@gmail.com>
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