| From: | Pallav Kalva <pkalva(at)deg(dot)cc> |
|---|---|
| To: | Postgres Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Very Bad Performance. |
| Date: | 2005-01-03 22:19:15 |
| Message-ID: | 41D9C4E3.3050001@deg.cc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi ,
I am experiencing a very bad performance on my production database
lately , all my queries are slowing down. Our application is a webbased
system with lot of selects and updates. I am running "vacuumdb" daily on
all the databases, are the below postgres configuration parameters are
set properly ? can anyone take a look. Let me know if you need anymore
information.
Postgres Version: 7.4
Operating System: Linux Red Hat 9
Cpus: 2 Hyperthreaded
RAM: 4 gb
Postgres Settings:
max_fsm_pages | 20000
max_fsm_relations | 1000
shared_buffers | 65536
sort_mem | 16384
vacuum_mem | 32768
wal_buffers | 64
effective_cache_size | 393216
Thanks!
Pallav
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2005-01-03 23:44:01 | Re: Very Bad Performance. |
| Previous Message | Adam Palmblad | 2005-01-03 21:44:27 | Bad Index Choices with user defined data type |