Optimisation help
От | dforums |
---|---|
Тема | Optimisation help |
Дата | |
Msg-id | 47CDCB62.9070302@vieonet.com обсуждение исходный текст |
Ответы |
Re: Optimisation help
(Alan Hodgson <ahodgson@simkin.ca>)
Re: Optimisation help (Greg Smith <gsmith@gregsmith.com>) |
Список | pgsql-performance |
<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>
В списке pgsql-performance по дате отправления:
Предыдущее
От: "Chris Kratz"Дата:
Сообщение: Re: Ramifications of turning off Nested Loops for slow queries