[pgsql-performance] Performance Problems

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
Thread:
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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message James Kelty 2002-10-28 20:47:52 Clusters
Previous Message Josh Berkus 2002-10-27 00:14:35 Re: Setting shared buffers

Browse pgsql-general by date

  From Date Subject
Next Message Savita 2002-10-28 11:34:39 Re: IS IT POSSIBLE TO CREATE INDEX ON VIEW IN POSTGRE
Previous Message Alex Sandini 2002-10-28 10:59:04 use of PQconnectdb and PQfinish in a shared library