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

Список

Период

Сортировка

От	Jim Nasby
Тема	Re: Feature Request --- was: PostgreSQL Performance Tuning
Дата	6 мая 2007 г. 05:38:11
Msg-id	A319E17E-3214-4A05-8733-2913D2495B43@decibel.org обсуждение исходный текст
Ответ на	Re: Feature Request --- was: PostgreSQL Performance Tuning (Josh Berkus)
Ответы	Re: Feature Request --- was: PostgreSQL Performance Tuning (Andreas Kostyrka)
Список	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 )

On May 4, 2007, at 12:11 PM, 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.

Uh... what GUCs are that exacting on the amount of memory? For a
decent, base-line configuration, that is.
--
Jim Nasby                                            
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

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

Предыдущее

От: Yudhvir Singh Sidhu
Дата: 06 мая 2007 г., 03:35:48
Сообщение: Re: How to Find Cause of Long Vacuum Times - NOOB Question

Следующее

От: Robins
Дата: 06 мая 2007 г., 10:33:48
Сообщение: Re: Index not being used in sorting of simple table