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

Re: Pet Peeves?

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Reece Hart <reece(at)harts(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-02-01 20:29:06
Message-ID: Pine.GSO.4.64.0902011519001.4427@westnet.com (view raw or flat)
Thread:
Lists: pgsql-general
On Sat, 31 Jan 2009, Reece Hart wrote:

> * lack of auto-tuning or tuning tools (or perhaps my lack of awareness
> of them?)

http://pgfoundry.org/projects/pgtune/ aims to provide a tool for 8.4, 
that's working but still needs documentation and some loose ends cleaned 
up.  Its suggestions aren't good yet for Windows systems yet, that's the 
biggest bug left in there.

That's aimed to automate the suggestions set out in 
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

One day I'll make that work better with older versions too.  It does 
basically the right thing for 8.3 already but could be smarter, it 
includes some parameters that aren't there in 8.2, and doesn't work at all 
on 8.1 or earlier.

If you step outside of just free solutions, Enterprise DB's commercial 
server product does more complicated autotuning via their DynaTune 
feature.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

pgsql-general by date

Next:From: Teodor SigaevDate: 2009-02-01 20:39:06
Subject: Re: Full text index not being used
Previous:From: Andreas WenkDate: 2009-02-01 20:23:30
Subject: Re: ALTER TABLE with TYPE serial does not work

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