Can we load all database objects in memory?

Can we load all database objects in memory?

am 25.03.2009 20:20:08 von DM

--000e0cd229d8443d7f0465f663ba
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

--000e0cd229d8443d7f0465f663ba
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi All,

=A0

I have a database of 10GB.

My Database Server has a RAM of 16GB

=A0

Is there a way that I can load all the database objects to memory? iv>
=A0

Thanks for your time and taking a look at this question.

=A0

=A0

Thanks

Deepak


--000e0cd229d8443d7f0465f663ba--

Re: [SQL] Can we load all database objects in memory?

am 25.03.2009 20:59:01 von ries van Twisk

--Apple-Mail-52--141579989
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

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






--Apple-Mail-52--141579989
Content-Disposition: attachment;
filename=smime.p7s
Content-Type: application/pkcs7-signature;
name=smime.p7s
Content-Transfer-Encoding: base64

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIGITCCAtow
ggJDoAMCAQICEEdVn86vD7sYeYYQChjVDWcwDQYJKoZIhvcNAQEFBQAwYjEL MAkGA1UEBhMCWkEx
JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNV BAMTI1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MTAxNDEzNDAxM1oX DTA5MTAxNDEzNDAx
M1owQjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEfMB0GCSqG SIb3DQEJARYQcmll
c0B2YW50d2lzay5ubDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEB ANI3RVszlmBQMn0F
foHyY+doGtHsmG41YcctPJTpqw2O8u3sCbNZt2mb/Z5J4glWcGXKA4ZTjvvR N5IHQ80SpdhmDbiZ
G+KjjucHMF5PBwj+i8k2ma2UItPqDUo/o7AhcJO/okCwPzEDE5VhNJSSJl95 AAEH+llIs88DViBW
CoRweyAFzGJbrUSGKFRncQ++TeqsvneLTetP8xf1dkAre32p4wmjqRQ97qBg WJzdxaaDq49c4iDx
U9vtR+vF7xNbnuTMEb75NTIN9MtbN+8QqTwIK4XghmCi89PT740gLbeVlRIJ l8Wr6roFJt3DAh+q
Fgg+7Kh7qeZbWb4ODHCj46ECAwEAAaMtMCswGwYDVR0RBBQwEoEQcmllc0B2 YW50d2lzay5ubDAM
BgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAIpznwbVjQ5F91SJ86Nd PIrQe1IL9xSRS2Zl
zJqiOMgHsn37gaKO3I3lleDrSqnhqz8UJhdA8Hl03w2S5tusSf/RChKvFgeM swlBlRd+GKP7T32x
10LvKWl8wWVBKeTnVkv94FWEOpaXx7rpIwZJQZSgqX9RDcoNxjUrynL7nZqC MIIDPzCCAqigAwIB
AgIBDTANBgkqhkiG9w0BAQUFADCB0TELMAkGA1UEBhMCWkExFTATBgNVBAgT DFdlc3Rlcm4gQ2Fw
ZTESMBAGA1UEBxMJQ2FwZSBUb3duMRowGAYDVQQKExFUaGF3dGUgQ29uc3Vs dGluZzEoMCYGA1UE
CxMfQ2VydGlmaWNhdGlvbiBTZXJ2aWNlcyBEaXZpc2lvbjEkMCIGA1UEAxMb VGhhd3RlIFBlcnNv
bmFsIEZyZWVtYWlsIENBMSswKQYJKoZIhvcNAQkBFhxwZXJzb25hbC1mcmVl bWFpbEB0aGF3dGUu
Y29tMB4XDTAzMDcxNzAwMDAwMFoXDTEzMDcxNjIzNTk1OVowYjELMAkGA1UE BhMCWkExJTAjBgNV
BAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1Ro YXd0ZSBQZXJzb25h
bCBGcmVlbWFpbCBJc3N1aW5nIENBMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCB iQKBgQDEpjxVc1X7
TrnKmVoeaMB1BHCd3+n/ox7svc31W/Iadr1/DDph8r9RzgHU5VAKMNcCY1os iRVwjt3J8CuFWqo/
cVbLrzwLB+fxH5E2JCoTzyvV84J3PQO+K/67GD4Hv0CAAmTXp6a7n2XRxSpU hQ9IBH+nttE8YQRA
HmQZcmC3+wIDAQABo4GUMIGRMBIGA1UdEwEB/wQIMAYBAf8CAQAwQwYDVR0f BDwwOjA4oDagNIYy
aHR0cDovL2NybC50aGF3dGUuY29tL1RoYXd0ZVBlcnNvbmFsRnJlZW1haWxD QS5jcmwwCwYDVR0P
BAQDAgEGMCkGA1UdEQQiMCCkHjAcMRowGAYDVQQDExFQcml2YXRlTGFiZWwy LTEzODANBgkqhkiG
9w0BAQUFAAOBgQBIjNFQg+oLLswNo2asZw9/r6y+whehQ5aUnX9MIbj4Nh+q LZ82L8D0HFAgk3A8
/a3hYWLD2ToZfoSxmRsAxRoLgnSeJVCUYsfbJ3FXJY3dqZw5jowgT2Vfldr3 94fWxghOrvbqNOUQ
Gls1TXfjViF4gtwhGTXeJLHTHUb/XV9lTzGCAxAwggMMAgEBMHYwYjELMAkG A1UEBhMCWkExJTAj
BgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJz
b25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhBHVZ/Orw+7GHmGEAoY1Q1nMAkG BSsOAwIaBQCgggFv
MBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTA5 MDMyNTE5NTkwMVow
IwYJKoZIhvcNAQkEMRYEFEJu1vS85QA9ia9WosI4gGV8YqSnMIGFBgkrBgEE AYI3EAQxeDB2MGIx
CzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5 KSBMdGQuMSwwKgYD
VQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQR1Wf zq8Puxh5hhAKGNUN
ZzCBhwYLKoZIhvcNAQkQAgsxeKB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQK ExxUaGF3dGUgQ29u
c3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwg RnJlZW1haWwgSXNz
dWluZyBDQQIQR1Wfzq8Puxh5hhAKGNUNZzANBgkqhkiG9w0BAQEFAASCAQBO VNT3sXV6VzBfC9Tx
Oa3xuczno2FA1UAu6sMuwu76k9IVxj6njIRIDpyG5SF8DRq1lxvCv9Q4YWRG SWDdPd89Ysb+T2Z6
kNmBbxCWUnM1OA7asvGBj7WOrbi2g38uHB8k6DIkTTIhhLeNtajTkAN43deU /RSa0HInitpesThc
oBaexVfM8p8IA42MTE0P3jfvmziLUTRgYkWWpgUnieB0tMgNY5k+OP2DnkSK 2CLxLxSn6GGguSm6
2GwQcSV/YQjxe5Q+cv36owlhPX+acvkH5OrMoiTRxZOLVjNshjNxLFFGhCmF npCazkiMfFQmQyzH
TzwX7rl7/0ZSjENSuRujAAAAAAAA

--Apple-Mail-52--141579989--

Re: Can we load all database objects in memory?

am 25.03.2009 21:07:21 von ries van Twisk

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







--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: Can we load all database objects in memory?

am 25.03.2009 21:09:45 von imartinez

--=-fCcXYXFu2V7ga6+6Vla0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Increase effective_cache_size parameter.

An "effective_cache_size=11GB" should be more than enough.

-----Original Message-----
From: DM
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

--=-fCcXYXFu2V7ga6+6Vla0
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit








Increase effective_cache_size parameter.



An "effective_cache_size=11GB" should be more than enough.



-----Original Message-----

From: DM <>

To:

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



--=-fCcXYXFu2V7ga6+6Vla0--

Re: [SQL] Can we load all database objects in memory?

am 25.03.2009 21:11:21 von imartinez

--=-McFKuN8LhTeO2WuFCbc9
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

And I replied to all list also...
Sorry. :(

-----Original Message-----
From: ries van Twisk
To: DM
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








--=-McFKuN8LhTeO2WuFCbc9
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 7bit








And I replied to all list also...

Sorry. :(



-----Original Message-----

From: ries van Twisk <>

To: DM <>

Cc:

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











--=-McFKuN8LhTeO2WuFCbc9--