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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | jose antonio leo | 2003-02-14 08:51:28 | uppercase = lowercase |
Previous Message | Daniel Kalchev | 2003-02-14 08:00:28 | Re: [HACKERS] Changing the default configuration |
From | Date | Subject | |
---|---|---|---|
Next Message | Manfred Koizar | 2003-02-14 10:28:51 | Re: Incremental backup |
Previous Message | Michael Paesold | 2003-02-14 08:15:23 | Re: Brain dump: btree collapsing |