Lists: | pgsql-generalpgsql-performance |
---|
From: | "Lars Maschke" <lars(at)gmeiner(dot)de> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | [pgsql-performance] Performance Problems |
Date: | 2002-10-28 11:00:52 |
Message-ID: | 90iv8-n4s.ln1@server.csg.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-performance |
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.
From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [pgsql-performance] Performance Problems |
Date: | 2002-10-29 13:38:24 |
Message-ID: | 20021029083824.C18292@mail.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general pgsql-performance |
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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110