From: | "Marcin Kapski" <admin(at)bbi(dot)plNOSPAMEK> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Performance postgresql |
Date: | 2003-11-24 23:44:01 |
Message-ID: | bpu54f$7mf$1@atlantis.news.tpi.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi
sorry for my english
My serwer is:
p4 2.4 Ghz, 1 GB RAM, data from postgres on RAID 0 SCSI
(hardware scsi)
some tables (about 15) have 50.000 position, and all data (pgdumpall) are
about 600 MB
I have apache 1.3.29 - and he use the database for generate pages.
So my problem is performance this database.
If I run e.g. Apache Benchmark - ./ab -c 1000 -n 100 http://some adres who
use the all tables
my system halt (load about 200) , i see so many postmaster proces...
my config:
tcpip_socket = true
max_connections = 512
shared_buffers = 31000
sort_mem = 2096
vacuum_mem = 20480
max_fsm_pages = 589824
max_fsm_relations = 32768
wal_buffers = 1024
checkpoint_segments = 4
checkpoint_timeout = 1800
checkpoint_warning = 30
commit_delay = 10
commit_siblings = 2
enable_indexscan = true
enable_seqscan = true
enable_sort = true
effective_cache_size = 20000
random_page_cost = 4
please for help
From | Date | Subject | |
---|---|---|---|
Next Message | Klint Gore | 2003-11-25 00:39:03 | Re: variable not found in subplan target list? + test case |
Previous Message | Stephan Szabo | 2003-11-24 22:44:39 | Re: SELECT with MANY tables |