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

Список

Период

Сортировка

От	Mark Kirkwood
Тема	Re: Feature Request --- was: PostgreSQL Performance Tuning
Дата	5 мая 2007 г. 07:19:27
Msg-id	463C2FED.8020400@paradise.net.nz обсуждение исходный текст
Ответ на	Re: Feature Request --- was: PostgreSQL Performance Tuning (Josh Berkus)
Ответы	Re: Feature Request --- was: PostgreSQL Performance Tuning (Sebastian Hennebrueder)
Список	pgsql-performance

Дерево обсуждения

Re: [GENERAL] PostgreSQL Performance Tuning (Steve Crawford, 26 апреля 2007 г., 21:29:05 )
Feature Request --- was: PostgreSQL Performance Tuning (Carlos Moreno, 27 апреля 2007 г., 01:58:36 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Tom Lane, 27 апреля 2007 г., 02:49:23 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Carlos Moreno, 27 апреля 2007 г., 13:27:17 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Michael Stone, 27 апреля 2007 г., 14:30:49 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Mark Lewis, 27 апреля 2007 г., 14:37:19 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Michael Stone, 27 апреля 2007 г., 15:32:14 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Jim Nasby, 27 апреля 2007 г., 16:12:29 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Dan Harris, 27 апреля 2007 г., 17:47:56 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Josh Berkus, 27 апреля 2007 г., 17:59:41 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Greg Smith, 30 апреля 2007 г., 11:48:28 )
Re: Feature Request --- was: PostgreSQL Performance Tuning ("Craig A. James", 30 апреля 2007 г., 16:19:35 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Kevin Hunter, 30 апреля 2007 г., 17:30:39 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Greg Smith, 02 мая 2007 г., 01:52:21 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Josh Berkus, 01 мая 2007 г., 16:23:22 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Carlos Moreno, 01 мая 2007 г., 23:40:08 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (, 01 мая 2007 г., 23:49:02 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Sebastian Hennebrueder, 04 мая 2007 г., 17:01:53 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Josh Berkus, 04 мая 2007 г., 17:11:14 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Sebastian Hennebrueder, 04 мая 2007 г., 17:22:37 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Mark Kirkwood, 05 мая 2007 г., 07:19:27 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Sebastian Hennebrueder, 05 мая 2007 г., 15:54:41 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Jim Nasby, 06 мая 2007 г., 05:38:11 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Andreas Kostyrka, 06 мая 2007 г., 07:07:16 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Greg Smith, 02 мая 2007 г., 02:59:56 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (, 02 мая 2007 г., 04:34:41 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Josh Berkus, 03 мая 2007 г., 19:21:35 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (, 03 мая 2007 г., 20:17:27 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Carlos Moreno, 03 мая 2007 г., 21:06:02 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (, 03 мая 2007 г., 21:24:26 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Carlos Moreno, 03 мая 2007 г., 22:41:32 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (, 03 мая 2007 г., 22:50:51 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Carlos Moreno, 04 мая 2007 г., 00:22:59 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (, 04 мая 2007 г., 00:53:38 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Carlos Moreno, 04 мая 2007 г., 01:12:38 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (, 04 мая 2007 г., 01:53:48 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Greg Smith, 04 мая 2007 г., 04:33:31 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Michael Stone, 04 мая 2007 г., 12:46:04 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Greg Smith, 05 мая 2007 г., 01:07:56 )
Re: Feature Request --- was: PostgreSQL Performance Tuning ("Steinar H. Gunderson", 05 мая 2007 г., 09:31:17 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Ron, 03 мая 2007 г., 19:15:37 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Bill Moran, 27 апреля 2007 г., 18:11:34 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Josh Berkus, 27 апреля 2007 г., 19:10:55 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Dan Harris, 27 апреля 2007 г., 20:28:01 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Josh Berkus, 28 апреля 2007 г., 00:46:07 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (, 28 апреля 2007 г., 01:39:30 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Tom Lane, 27 апреля 2007 г., 14:36:48 )
Re: Feature Request --- was: PostgreSQL Performance Tuning ("H.J. Sanders", 27 апреля 2007 г., 15:23:19 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Kevin Hunter, 27 апреля 2007 г., 18:40:30 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Ray Stell, 27 апреля 2007 г., 18:52:30 )
Re: Feature Request --- was: PostgreSQL Performance Tuning ("Harald Armin Massa", 28 апреля 2007 г., 08:31:42 )
Re: Feature Request --- was: PostgreSQL Performance Tuning ("Jonah H. Harris", 28 апреля 2007 г., 16:54:24 )
Re: Feature Request --- was: PostgreSQL Performance Tuning ("Harald Armin Massa", 28 апреля 2007 г., 18:15:59 )
Re: Feature Request --- was: PostgreSQL Performance Tuning (Carlos Moreno, 28 апреля 2007 г., 20:34:30 )

Josh Berkus wrote:
> Sebastian,
>
>> Before inventing a hyper tool, we might consider to provide 3-5 example
>> szenarios for common hardware configurations. This consumes less time
>> and be discussed and defined in a couple of days. This is of course not
>> the correct option for a brandnew 20 spindle Sata 10.000 Raid 10 system
>> but these are probably not the target for default configurations.
>
> That's been suggested a number of times, but some GUCs are really tied to the
> *exact* amount of RAM you have available.  So I've never seen how "example
> configurations" could help.
>

I'm not convinced about this objection - having samples gives a bit of a
heads up on *what* knobs you should at least look at changing.

Also it might be helpful on the -general or -perf lists to be able to
say "try config 3 (or whatever we call 'em) and see what changes..."

I've certainly found the sample config files supplied with that database
whose name begins with 'M' a useful *start* when I want something better
than default...

Cheers

Mark

В списке pgsql-performance по дате отправления:

Предыдущее

От: "Steinar H. Gunderson"
Дата: 05 мая 2007 г., 03:31:17
Сообщение: Re: Feature Request --- was: PostgreSQL Performance Tuning

Следующее

От: Sebastian Hennebrueder
Дата: 05 мая 2007 г., 09:54:41
Сообщение: Re: Feature Request --- was: PostgreSQL Performance Tuning