| From: | "Gaetano Mendola" <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | DB totaly in memory |
| Date: | 2002-09-18 10:49:58 |
| Message-ID: | am9lob$12el$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi all,
My database size is ~ 43M
$> pwd
/var/lib/pgsql/data/base
$> du . -h
1.7M ./1
1.7M ./16555
39M ./220628
43M .
the postgres is running with the parameter
shared_buffers = 30400
So I'm using 256MB of shared memory.
Now my question is, apparently all my entire database
can be in memory, how should I set the others parameters
to suggest that all my database is in memory? I'm wondering
about in particular to the parameter:
random_page_cost
Some one have some suggestions ?
Ciao
Gaetano.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Elielson Fontanezi | 2002-09-18 11:37:01 | An Oracle opnion |
| Previous Message | Andreas Schlegel | 2002-09-18 08:37:14 | Re: URGENT: pg_restore problem |