Re: Proposal of tunable fix for scalability of 8.4

Список

Период

Сортировка

От	Alvaro Herrera
Тема	Re: Proposal of tunable fix for scalability of 8.4
Дата	20 марта 2009 г. 22:05:27
Msg-id	20090320220513.GS8313@alvh.no-ip.org обсуждение исходный текст
Ответ на	Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera)
Ответы	Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah")
Список	pgsql-performance

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

Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 11 марта 2009 г., 21:48:21 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 11 марта 2009 г., 22:27:24 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 12 марта 2009 г., 00:55:52 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 12 марта 2009 г., 14:08:02 )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 12 марта 2009 г., 01:32:43 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 12 марта 2009 г., 02:20:45 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 17 марта 2009 г., 09:17:48 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 17 марта 2009 г., 13:18:23 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 17 марта 2009 г., 21:46:04 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 17 марта 2009 г., 22:59:45 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 18 марта 2009 г., 00:14:04 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 18 марта 2009 г., 00:43:32 )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 18 марта 2009 г., 11:36:30 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 18 марта 2009 г., 21:16:10 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 18 марта 2009 г., 22:01:54 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 12 марта 2009 г., 02:02:07 )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 12 марта 2009 г., 02:51:08 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 12 марта 2009 г., 03:48:46 )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, 14 марта 2009 г., 16:49:53 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 15 марта 2009 г., 20:40:10 )
Re: Proposal of tunable fix for scalability of 8.4 (Josh Berkus, 29 марта 2009 г., 21:33:53 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 12 марта 2009 г., 17:48:26 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 12 марта 2009 г., 18:41:47 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 12 марта 2009 г., 19:26:20 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 12 марта 2009 г., 22:57:21 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 13 марта 2009 г., 12:38:47 )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 13 марта 2009 г., 13:05:50 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 13 марта 2009 г., 13:37:40 )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 13 марта 2009 г., 13:54:19 )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, 14 марта 2009 г., 16:50:21 )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 13 марта 2009 г., 13:28:50 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 13 марта 2009 г., 14:56:56 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 13 марта 2009 г., 15:56:09 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 13 марта 2009 г., 16:54:14 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 13 марта 2009 г., 17:21:39 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 13 марта 2009 г., 16:18:29 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 13 марта 2009 г., 16:42:48 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 13 марта 2009 г., 17:30:14 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 13 марта 2009 г., 17:48:59 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 13 марта 2009 г., 18:48:43 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 13 марта 2009 г., 20:02:56 )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, 14 марта 2009 г., 16:50:33 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 15 марта 2009 г., 20:42:52 )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 16 марта 2009 г., 15:08:38 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 16 марта 2009 г., 19:43:28 )
Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, 13 марта 2009 г., 04:23:45 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 12 марта 2009 г., 15:01:24 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 12 марта 2009 г., 17:09:38 )
Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, 12 марта 2009 г., 20:35:36 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 12 марта 2009 г., 22:16:19 )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, 13 марта 2009 г., 01:30:08 )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 13 марта 2009 г., 17:16:53 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 13 марта 2009 г., 17:34:42 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 13 марта 2009 г., 18:02:51 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 13 марта 2009 г., 18:39:19 )
Re: Proposal of tunable fix for scalability of 8.4 (, 14 марта 2009 г., 04:29:47 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 16 марта 2009 г., 15:48:45 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 16 марта 2009 г., 16:53:55 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 16 марта 2009 г., 18:45:02 )
Re: Proposal of tunable fix for scalability of 8.4 (Heikki Linnakangas, 14 марта 2009 г., 08:24:09 )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 14 марта 2009 г., 16:10:18 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 15 марта 2009 г., 19:25:29 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 18 марта 2009 г., 07:48:52 )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, 16 марта 2009 г., 16:26:38 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 18 марта 2009 г., 07:54:54 )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, 18 марта 2009 г., 11:46:03 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 18 марта 2009 г., 12:07:00 )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, 18 марта 2009 г., 12:33:58 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 18 марта 2009 г., 13:42:10 )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, 18 марта 2009 г., 13:49:12 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 18 марта 2009 г., 23:07:41 )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 18 марта 2009 г., 20:26:55 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 18 марта 2009 г., 23:07:07 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 20 марта 2009 г., 06:31:10 )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, 20 марта 2009 г., 15:28:53 )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 20 марта 2009 г., 15:55:55 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 20 марта 2009 г., 18:54:08 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 21 марта 2009 г., 08:50:39 )
Re: Proposal of tunable fix for scalability of 8.4 (Heikki Linnakangas, 18 марта 2009 г., 11:49:11 )
Re: Proposal of tunable fix for scalability of 8.4 (Matthew Wakeling, 18 марта 2009 г., 11:49:39 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 18 марта 2009 г., 17:43:26 )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, 18 марта 2009 г., 21:25:15 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 18 марта 2009 г., 22:15:45 )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, 19 марта 2009 г., 20:49:54 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 19 марта 2009 г., 21:43:33 )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, 20 марта 2009 г., 03:45:26 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 20 марта 2009 г., 06:05:46 )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, 20 марта 2009 г., 15:46:16 )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, 20 марта 2009 г., 21:58:38 )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, 20 марта 2009 г., 22:05:27 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 20 марта 2009 г., 23:39:21 )
Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, 21 марта 2009 г., 00:45:33 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 21 марта 2009 г., 23:02:54 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 19 марта 2009 г., 23:12:34 )
Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, 19 марта 2009 г., 17:38:04 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 19 марта 2009 г., 20:58:50 )
Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, 19 марта 2009 г., 23:27:26 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 19 марта 2009 г., 20:57:25 )
Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, 13 марта 2009 г., 03:00:54 )
8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 13 марта 2009 г., 12:44:53 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 13 марта 2009 г., 13:43:16 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 13 марта 2009 г., 13:57:19 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Alan Stange, 13 марта 2009 г., 15:37:53 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 13 марта 2009 г., 17:23:53 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 14 марта 2009 г., 01:59:00 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 14 марта 2009 г., 02:06:26 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Robert Haas, 14 марта 2009 г., 02:37:41 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 14 марта 2009 г., 04:03:01 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 14 марта 2009 г., 16:02:37 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, 02 апреля 2009 г., 23:09:01 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian, 07 апреля 2009 г., 22:49:39 )
Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Greg Smith, 13 марта 2009 г., 17:15:48 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 12 марта 2009 г., 15:13:46 )
Re: Proposal of tunable fix for scalability of 8.4 (Grzegorz Jaśkiewicz, 12 марта 2009 г., 15:31:31 )
Re: Proposal of tunable fix for scalability of 8.4 ("Kevin Grittner", 12 марта 2009 г., 15:44:59 )
Re: Proposal of tunable fix for scalability of 8.4 (Ron, 12 марта 2009 г., 18:33:00 )
Re: Proposal of tunable fix for scalability of 8.4 (Gregory Stark, 12 марта 2009 г., 17:10:09 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 12 марта 2009 г., 18:08:56 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 12 марта 2009 г., 17:39:24 )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 12 марта 2009 г., 18:28:19 )
Re: Proposal of tunable fix for scalability of 8.4 (Alvaro Herrera, 12 марта 2009 г., 19:11:39 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 12 марта 2009 г., 19:26:43 )
Re: Proposal of tunable fix for scalability of 8.4 (decibel, 14 марта 2009 г., 16:50:12 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 12 марта 2009 г., 21:46:16 )
Re: Proposal of tunable fix for scalability of 8.4 (Tom Lane, 12 марта 2009 г., 17:53:28 )
Re: Proposal of tunable fix for scalability of 8.4 (Scott Carey, 12 марта 2009 г., 18:09:50 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 12 марта 2009 г., 17:53:33 )
Re: Proposal of tunable fix for scalability of 8.4 (Simon Riggs, 14 марта 2009 г., 13:30:27 )
Re: Proposal of tunable fix for scalability of 8.4 ("Jignesh K. Shah", 15 марта 2009 г., 20:37:02 )

Alvaro Herrera escribió:

> So Simon's correct.

And perhaps this explains why Jignesh is measuring an improvement on his
benchmark.  Perhaps an useful experiment would be to turn this behavior
off and compare performance.  This lack of measurement is probably the
cause that the suggested patch to fix it was never applied.

The patch is here
http://archives.postgresql.org//pgsql-hackers/2004-11/msg00935.php

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее

От: Robert Haas
Дата: 20 марта 2009 г., 18:45:33
Сообщение: Re: Proposal of tunable fix for scalability of 8.4

Следующее

От: "M. Edward (Ed) Borasky"
Дата: 20 марта 2009 г., 22:17:21
Сообщение: "iowait" bug?