Skip site navigation (1) Skip section navigation (2)

Re: weird performances problem

From: Claus Guttesen <kometen(at)gmail(dot)com>
To: Guillaume Smet <guillaume(dot)smet(at)openwide(dot)fr>
Cc: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-performance(at)postgresql(dot)org
Subject: Re: weird performances problem
Date: 2005-11-18 00:15:28
Message-ID: b41c75520511171615g7c0fe923l@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
> I forgot to give our non default postgresql.conf parameters:
> shared_buffers = 28800
> sort_mem = 32768
> vacuum_mem = 32768
> max_fsm_pages = 350000
> max_fsm_relations = 2000
> checkpoint_segments = 16
> effective_cache_size = 270000
> random_page_cost = 2

Isn't sort_mem quite high? Remember that sort_mem size is allocated
for each sort, not for each connection. Mine is 4096 (4 MB). My
effective_cache_size is set to 27462.

What OS are you running?

regards
Claus

In response to

Responses

pgsql-performance by date

Next:From: Ron MayerDate: 2005-11-18 01:39:48
Subject: Re: Help speeding up delete
Previous:From: Guillaume SmetDate: 2005-11-17 23:35:06
Subject: Re: weird performances problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group