| From: | Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: slower with the time |
| Date: | 2003-07-01 08:17:06 |
| Message-ID: | 200307011347.06532.shridhar_daithankar@nospam.persistent.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tuesday 01 July 2003 13:40, Juraj Porada wrote:
> shared_buffers = 32
That is 32*8=256KB of memory. I thought default was 64. How much physical
memory you have?
I suggest you set it up something like 256 to start with. That may be too
small as well but you haven't provided enough details to come up with a
better one.
>
> I don't have much experience in tuning the database, but I think there
> is a problem with a fragmentation of memory or so.
> I don't known backgrounds.
Read postgresql.conf and admin guide about runtime parameters. You need to
tune shared buffers and effective_cache_size at least.
Search performance archives about tuning these two. There is lot of material
to cover in a single mail.
HTH
Shridhar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hilary Forbes | 2003-07-01 12:10:08 | Version 7 question |
| Previous Message | Juraj Porada | 2003-07-01 08:10:08 | Re: slower with the time |