pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Torsten Schulz <comic@be-a-part.de>
To: pgsql-performance@postgresql.org
Subject: Re: Optimize
Date: Mon, 24 Nov 2003 22:33:05 +0100
Message-ID: <3FC27911.7070403@be-a-part.de> (raw)
In-Reply-To: <3FC267FB.806@bigfoot.com>
References: <3FC26E96.9090101@be-a-part.de>
	<3FC267FB.806@bigfoot.com>

Gaetano Mendola wrote:

> Torsten Schulz wrote:
>
>> Yes, I know: very difficult question, but I don't know what to do now.
>>
>> Our Server:
>> Dual-CPU with 1.2 GHz
>> 1.5 GB RAM
>>
>> Our Problem: We are a Community. Between 19 and 21 o clock we have 
>> >350 User in the Community. But then, the Database are very slow. And 
>> we have per CPU ~20-30% idle-time.
>
>
> May we know the postgres version that you are running and
> see the query that run slow ?

Postgres: 7.3.2
Query: All queries

Configuration:
max_connections = 1000  # Must be, if lower then 500 we become 
connection-errors
shared_buffers = 5000        # 2*max_connections, min 16
max_fsm_relations = 1000    # min 10, fsm is free space map
max_fsm_pages = 2000000      # min 1000, fsm is free space map
max_locks_per_transaction = 64 # min 10
wal_buffers = 2000            # min 4

sort_mem = 32768             # min 32
vacuum_mem = 32768           # min 1024

fsync = false

enable_seqscan = true
enable_indexscan = true
enable_tidscan = true
enable_sort = true
enable_nestloop = true
enable_mergejoin = true
enable_hashjoin = true

effective_cache_size = 96000  # default in 8k pages


That are all uncommented lines. I've found the values in internet and 
had tested it. But in performance are no difference between old 
configuration an this.

> Is also usefull take a look at your postgresql configuration.
> You can see doing   select * from pg_stat_activity the
> queries that are currently running on your server, and
> do a explain analize on it to see which one is the
> bottleneck. If you are running the 7.4 you can see on
> the log the total ammount for each query.
>
I'll show tomorrow for this, today it is too late, the performance is 
now perfect. It's only slow on this 2 hours with so many users on server.

Oh, and i can't update to 7.4. The Chat don't run with libraries of 7.4




view thread (8+ messages)  latest in thread

Message-ID: <3FC27911.7070403@be-a-part.de>
Permalink:  ../3FC27911.7070403@be-a-part.de/
Also on:    postgresql.org/message-id/3FC27911.7070403@be-a-part.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: comic@be-a-part.de
  Subject: Re: Optimize
  In-Reply-To: <3FC27911.7070403@be-a-part.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox