<div class="moz-text-html" lang="x-western"> Hello<br /><br /><br /> We hace a Quad Xeon server, with 8GO of ram, sata
II750Go<br /><br /> An postgresql database, of 10 Go<br /><br /> I have several treatment every 2 minutes who select,
insert,update thousand of data in a table. It take a lot of time (0.3300 ms per line) just to check if a string of 15
charis present, and decide to update it under few constraint<br /><br /> I suppose the main problem is from database
serversettings.<br /><br /> This is my settings : <br /><br /><br /> max_connections = 256<br /> shared_buffers =
1500 # min 16 or max_connections*2, 8KB each<br /> temp_buffers = 500 # min 100,
8KBeach<br /> max_prepared_transactions = 100 <br /><br /> work_mem = 22000 # min 64, size in
KB<br/> maintenance_work_mem = 500000 # min 1024, size in KB<br /> max_stack_depth = 8192 <br /><br /><br />
max_fsm_pages= 100000 # min max_fsm_relations*16, 6 bytes each<br /> max_fsm_relations = 5000 <br
/><br/><br /> vacuum_cost_delay = 50 # 0-1000 milliseconds<br /> vacuum_cost_page_hit =
1000 # 0-10000 credits<br /> vacuum_cost_page_miss = 1000 # 0-10000 credits<br />
vacuum_cost_page_dirty= 120 # 0-10000 credits<br /> vacuum_cost_limit = 2000 # 0-10000
credits<br/><br /> # - Background writer -<br /><br /> bgwriter_delay = 50 # 10-10000 milliseconds
betweenrounds<br /> bgwriter_lru_percent = 1.0 # 0-100% of LRU buffers scanned/round<br />
bgwriter_lru_maxpages= 25 # 0-1000 buffers max written/round<br /> bgwriter_all_percent = 0.333
#0-100% of all buffers scanned/round<br /> bgwriter_all_maxpages = 50 # 0-1000 buffers max
written/round<br/><br /> wal_buffers = 16 # min 4, 8KB each<br /> commit_delay =
500 # range 0-100000, in microseconds<br /> commit_siblings = 50 # range
1-1000<br/><br /> # - Checkpoints -<br /><br /> checkpoint_segments = 50 # in logfile segments, min 1,
16MBeach<br /> checkpoint_timeout = 1800 # range 30-3600, in seconds<br /> checkpoint_warning = 180
<br/><br /> effective_cache_size = 2048 # typically 8KB each<br /> random_page_cost = 3 <br /><br /><br
/>Shared memory set to :<br /> echo /proc/sys/kernel/shmmax = 256000000<br /><br /> Could you help please...<br /><br
/>tx<br /><br /><br /> David<br /><br /><br /><br /><br /><br /><br /></div>
