pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tobias Brox <tobias@nordicbet.com>
To: Frank Wiles <frank@wiles.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance Tuning Article
Date: Thu, 23 Jun 2005 09:06:04 +0800
Message-ID: <20050623010604.GI7839@tobias> (raw)
In-Reply-To: <20050622095227.05938982.frank@wiles.org>
References: <20050622095227.05938982.frank@wiles.org>

[Frank Wiles - Wed at 09:52:27AM -0500]
>   I've put together a short article and posted it online regarding
>   performance tuning PostgreSQL in general.  I believe it helps to bring
>   together the info in a easy to digest manner. I would appreciate any
>   feedback, comments, and especially any technical corrections.  

I did not read through the whole article, but I already have some comments;

work_mem was formerly sort_mem.  As many of us still use pg7, you should
probably have a note about it.

There are already quite some short articles at the web about this issue, and
that was actually my starting point when I was assigned the task of tweaking
the database performance.  I think diversity is a good thing, some of the
short articles was relatively outdated, others were not very well written.
And also - I still never had the chance to do proper benchmarking of the
impact of my changes in the configuration file, I just chose to trust some
of the advices when I saw almost the same advice repeated in several
articles.

I think we need some comprehensive chapter about this in the manual, with
plenty of pointers - or eventually some separate well-organized pages
telling about all known issues.  It seems to me that many of the standard
tips here are repeating themselves over and over again.

-- 
Tobias Brox, +86-13521622905
Nordicbet, IT dept



view thread (15+ messages)  latest in thread

Message-ID: <20050623010604.GI7839@tobias>
Permalink:  ../20050623010604.GI7839@tobias/
Also on:    postgresql.org/message-id/20050623010604.GI7839@tobias

 · 

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: tobias@nordicbet.com, frank@wiles.org
  Subject: Re: Performance Tuning Article
  In-Reply-To: <20050623010604.GI7839@tobias>

* 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