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

Re: Configuration WAS: New project launched : PostgreSQL

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
Subject: Re: Configuration WAS: New project launched : PostgreSQL
Date: 2006-01-31 20:59:54
Message-ID: 200601311259.54750.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Jeffrey,

> I agree that some instrumentation of the backend might be needed.  But
> several of the performance-critical parameters seem tractable:
>
> Effective cache size - should be easy to monitor the system for this
> Shared buffers - easy to start from a rule-of-thumb and monitor usage
> Work mem - trace the size and frequency of temp files
> Wal buffers - trace the average or 80th percentile number of pages
> generated by transactions
> Commit delay - track the concurrency level and avg distance btw commits
> Checkpoint segments - should be very easy to auto-adjust
> Random page cost - should possible to determine this at runtime
> Vacuum* - may be possible to determine vacuum impact on concurrent
> queries

Great.  Wanna join the configurator project?  I won't have much time to 
work on it before March, but anyone with ideas is welcome.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-hackers by date

Next:From: Greg StarkDate: 2006-01-31 21:19:18
Subject: Re: Tab completion of SET TRANSACTION ISOLATION
Previous:From: Jeffrey W. BakerDate: 2006-01-31 20:36:31
Subject: Re: Configuration WAS: New project launched : PostgreSQL

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