pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@qwest.net>
To: Gaetano Mendola <mendola@bigfoot.com>
Cc: Hervé Piedvache <footcow@noos.fr>
Cc: pgsql-performance@postgresql.org
Subject: Re: Insert are going slower ...
Date: Mon, 26 Jul 2004 10:25:38 -0600
Message-ID: <1090859137.22512.12.camel@localhost.localdomain> (raw)
In-Reply-To: <4105131F.9050005@bigfoot.com>
References: <200407131850.52095.herve@elma.fr>
	<200407131010.30790.josh@agliodbs.com>
	<200407140142.11720.footcow@noos.fr>
	<4105131F.9050005@bigfoot.com>

On Mon, 2004-07-26 at 08:20, Gaetano Mendola wrote:
> Hervé Piedvache wrote:

SNIP

> > sort_mem =   512000
> 
> This is too much, you are instructing Postgres to use 512MB
> for each backend ( some time each backend can use this quantity
> more then one )

agreed.  If any one process needs this much sort mem, you can set it in
that sessions with set sort_mem anyway, so to let every sort consume up
to 512 meg is asking for trouble.

> > effective_cache_size = 5000000
> 
> 5GB for 8 GB system is too much

No, it's not.  Assuming that postgresql with all it's shared buffers is
using <2 gig, it's quite likely that the kernel is caching at least 5
gigs of disk data.  Effective cache size doesn't set any cache size, it
tells the planner about how much the kernel is caching.

> > random_page_cost = 3	
> 
> on your HW you can decrease it to 2
> and also decrease the other cpu costs

On fast machines it often winds up needing to be set somewhere around
1.2 to 2.0




view thread (17+ messages)

Message-ID: <1090859137.22512.12.camel@localhost.localdomain>
Permalink:  ../1090859137.22512.12.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1090859137.22512.12.camel@localhost.localdomain

 · 

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: smarlowe@qwest.net, mendola@bigfoot.com, footcow@noos.fr
  Subject: Re: Insert are going slower ...
  In-Reply-To: <1090859137.22512.12.camel@localhost.localdomain>

* 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