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

Re: [HACKERS] Changing the default configuration

From: Daniel Kalchev <daniel(at)digsys(dot)bg>
To: PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>,pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [HACKERS] Changing the default configuration
Date: 2003-02-14 08:19:15
Message-ID: 200302140819.h1E8JFY05262@dcave.digsys.bg (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackers
>>>Josh Berkus said:
 > How about we take this discussion to the Performance List, where it belongs?

I believe the design and addition of code that collects and outputs the usage patterns of the database (statistics) belongs here.

If we take the approach to providing information to tune PostgreSQL based on real-world usage, I guess we need at least the following:

- Usage statistics on a per-database or even per-table level. I believe we already collect some;
- Statistics analysis tool/routine/process to produce suggestions;
- Of course lots of real-world data to justify the suggestions;

- Can we provide more knobs for tunable parameters that can be applied on a per-database or even per-table level. One first candidate might be the FSM?
- Can some of these parameters (when available) to auto-tune? 

Of course, this could move out of pgsql-hackers :)

Daniel


pgsql-hackers by date

Next:From: Manfred KoizarDate: 2003-02-14 10:28:51
Subject: Re: Incremental backup
Previous:From: Michael PaesoldDate: 2003-02-14 08:15:23
Subject: Re: Brain dump: btree collapsing

pgsql-advocacy by date

Next:From: jose antonio leoDate: 2003-02-14 08:51:28
Subject: uppercase = lowercase
Previous:From: Daniel KalchevDate: 2003-02-14 08:00:28
Subject: Re: [HACKERS] Changing the default configuration

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