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

Re: Feature Request --- was: PostgreSQL Performance Tuning

From: Kevin Hunter <hunteke(at)earlham(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Carlos Moreno <moreno_pg(at)mochima(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Date: 2007-04-27 18:40:07
Message-ID: 341A85AA-38FC-43DA-B9E4-793F5E9222B5@earlham.edu (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
At 10:36a -0400 on 27 Apr 2007, Tom Lane wrote:
> That's been proposed and rejected before, too; the main problem being
> that initdb is frequently a layer or two down from the user (eg,
> executed by initscripts that can't pass extra arguments through, even
> assuming they're being invoked by hand in the first place).

And following after Dan Harris' response . . .

So what's the problem with having some sort of cronjob contrib module  
that utilizes the actual and current statistics to make  
recommendations?  I don't think it'd be right to simply change the  
configuration options as it sees fit (especially as it was pointed  
out that many run multiple postmasters or have other uses for the  
machines in question), but perhaps it could send a message (email?)  
along the lines of "Hey, I'm currently doing this many of X  
transactions, against this much of Y data, and working under these  
constraints.  You might get better performance (in this area ... ) if  
you altered the the configurations options like so: ..."

Certainly not for the masters, but perhaps for standard installation  
sort of deals, sort of liking bringing up the rear . . . just a thought.

Kevin

In response to

Responses

pgsql-performance by date

Next:From: Ray StellDate: 2007-04-27 18:52:25
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Previous:From: Bill MoranDate: 2007-04-27 18:11:27
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning

pgsql-general by date

Next:From: Ray StellDate: 2007-04-27 18:52:25
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Previous:From: Jeff DavisDate: 2007-04-27 18:19:22
Subject: Re: Store dates in database in different format

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