Обсуждение: [pgsql-performance] Performance Problems
Hello Newsgroup I have trouble with postgres 7.2.3. This system works fine, but last week every postmaster process exhausted my system to 100%. What can i do ? When I dump all databases it has 16MB. I start my system with the following command: postmaster -i -c shared_buffers=1024 -c sort_mem=16384 -c effective_cache_size=2048 -c max_connections=128 -c fsync=false -c enable-seqscan=false -c enable_indexscan=false -c enable_tidscan=false -c enable_sort=false -c enable_nestloop=false -c enable_hashjoin=false -c enable-mergejoin=false -c show_parser_stats=false -c show_planner_stats=false -c show_executor_stats=false -c show_query_stats=false -c random_page_cost=0.99 -o -F Can someone help me ? -- Lars Maschke --- Es gibt Tage, da verliert man und es gibt Tage, da gewinnen die anderen.
On Mon, Oct 28, 2002 at 12:00:52PM +0100, Lars Maschke wrote: > Can someone help me ? Maybe. You need to tell us what "exhausted your system" means. Did it crash? Were you swapping? Were your CPUs pegged? A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <andrew@libertyrms.info> M2P 2A8 +1 416 646 3304 x110