Re: How to improve db performance with $7K?

Список

Период

Сортировка

От	Tom Lane
Тема	Re: How to improve db performance with $7K?
Дата	7 апреля 2005 г. 08:15:32
Msg-id	13449.1112847297@sss.pgh.pa.us обсуждение исходный текст
Ответ на	Re: How to improve db performance with $7K? (Greg Stark)
Ответы	Re: How to improve db performance with $7K? (Kevin Brown)
Список	pgsql-performance

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

How to improve db performance with $7K? (Steve Poe, 26 марта 2005 г., 03:24:19 )
Re: How to improve db performance with $7K? (Tom Lane, 26 марта 2005 г., 03:59:24 )
Re: How to improve db performance with $7K? (Steve Poe, 26 марта 2005 г., 04:32:05 )
Re: How to improve db performance with $7K? (Will LaShell, 26 марта 2005 г., 04:03:25 )
Re: How to improve db performance with $7K? ("Joshua D. Drake", 26 марта 2005 г., 04:13:53 )
Re: How to improve db performance with $7K? (Steve Poe, 26 марта 2005 г., 11:25:14 )
Re: How to improve db performance with $7K? (Bjoern Metzdorf, 26 марта 2005 г., 12:59:43 )
Re: How to improve db performance with $7K? (Josh Berkus, 26 марта 2005 г., 23:56:47 )
Re: How to improve db performance with $7K? (Steve Poe, 27 марта 2005 г., 00:16:48 )
Re: How to improve db performance with $7K? (Cott Lang, 29 марта 2005 г., 02:43:39 )
Re: How to improve db performance with $7K? (Steve Poe, 29 марта 2005 г., 08:31:47 )
Re: How to improve db performance with $7K? (Cott Lang, 29 марта 2005 г., 18:53:04 )
Follow-Up: How to improve db performance with $7K? (Steve Poe, 01 апреля 2005 г., 06:01:17 )
Re: Follow-Up: How to improve db performance with $7K? (Thomas F.O'Connell, 01 апреля 2005 г., 12:10:12 )
Re: Follow-Up: How to improve db performance with $7K? (Kevin Brown, 06 апреля 2005 г., 08:45:14 )
Re: Follow-Up: How to improve db performance with $7K? ("Steinar H. Gunderson", 06 апреля 2005 г., 15:28:22 )
Re: Follow-Up: How to improve db performance with $7K? (Thomas F.O'Connell, 07 апреля 2005 г., 08:40:43 )
Re: Follow-Up: How to improve db performance with $7K? (Vivek Khera, 02 апреля 2005 г., 01:23:44 )
Re: Follow-Up: How to improve db performance with $7K? (Will LaShell, 02 апреля 2005 г., 20:21:50 )
Re: How to improve db performance with $7K? (Steve Poe, 27 марта 2005 г., 00:31:21 )
Re: Follow-Up: How to improve db performance with $7K? (PFC, 06 апреля 2005 г., 17:26:36 )
Re: Follow-Up: How to improve db performance with $7K? ("Steinar H. Gunderson", 06 апреля 2005 г., 17:33:56 )
Re: How to improve db performance with $7K? (PFC, 29 марта 2005 г., 13:50:06 )
Re: How to improve db performance with $7K? (Dave Cramer, 29 марта 2005 г., 16:17:13 )
Re: How to improve db performance with $7K? (Greg Stark, 29 марта 2005 г., 22:11:23 )
Re: How to improve db performance with $7K? (Alex Turner, 04 апреля 2005 г., 17:44:08 )
Re: How to improve db performance with $7K? (Steve Poe, 04 апреля 2005 г., 19:52:07 )
Re: How to improve db performance with $7K? (Alex Turner, 04 апреля 2005 г., 23:13:59 )
Re: How to improve db performance with $7K? (Vivek Khera, 04 апреля 2005 г., 23:25:22 )
Re: How to improve db performance with $7K? (Alex Turner, 04 апреля 2005 г., 23:33:40 )
Re: How to improve db performance with $7K? (William Yu, 06 апреля 2005 г., 11:30:57 )
Re: How to improve db performance with $7K? (Alex Turner, 06 апреля 2005 г., 19:35:18 )
Re: How to improve db performance with $7K? (William Yu, 07 апреля 2005 г., 00:01:52 )
Re: How to improve db performance with $7K? (Alex Turner, 07 апреля 2005 г., 02:12:22 )
Re: How to improve db performance with $7K? ("Jim C. Nasby", 07 апреля 2005 г., 02:41:40 )
Re: How to improve db performance with $7K? (Alex Turner, 07 апреля 2005 г., 04:32:54 )
Re: How to improve db performance with $7K? (Alex Turner, 07 апреля 2005 г., 05:12:25 )
Re: How to improve db performance with $7K? (Alex Turner, 07 апреля 2005 г., 05:24:01 )
Re: How to improve db performance with $7K? (Greg Stark, 07 апреля 2005 г., 07:01:24 )
Re: How to improve db performance with $7K? (Alex Turner, 07 апреля 2005 г., 07:06:58 )
Re: How to improve db performance with $7K? (Tom Lane, 07 апреля 2005 г., 08:15:32 )
Re: How to improve db performance with $7K? (Kevin Brown, 14 апреля 2005 г., 05:57:10 )
Re: How to improve db performance with $7K? (Greg Stark, 14 апреля 2005 г., 06:37:39 )
Re: How to improve db performance with $7K? (Kevin Brown, 14 апреля 2005 г., 08:36:15 )
Re: How to improve db performance with $7K? (Tom Lane, 14 апреля 2005 г., 14:44:20 )
Re: How to improve db performance with $7K? (Kevin Brown, 15 апреля 2005 г., 02:03:51 )
Re: How to improve db performance with $7K? (Alex Turner, 15 апреля 2005 г., 02:24:39 )
Re: How to improve db performance with $7K? (PFC, 15 апреля 2005 г., 10:14:04 )
Re: How to improve db performance with $7K? (Tom Lane, 15 апреля 2005 г., 02:42:19 )
Re: How to improve db performance with $7K? (Kevin Brown, 15 апреля 2005 г., 05:03:52 )
Re: How to improve db performance with $7K? (Tom Lane, 15 апреля 2005 г., 05:29:08 )
Re: How to improve db performance with $7K? (Kevin Brown, 16 апреля 2005 г., 00:53:55 )
Re: How to improve db performance with $7K? (Greg Stark, 15 апреля 2005 г., 18:01:52 )
Re: How to improve db performance with $7K? (Vivek Khera, 15 апреля 2005 г., 15:43:46 )
Re: How to improve db performance with $7K? ("Joshua D. Drake", 15 апреля 2005 г., 15:58:34 )
Re: How to improve db performance with $7K? (Vivek Khera, 15 апреля 2005 г., 16:10:20 )
Re: How to improve db performance with $7K? (Kevin Brown, 16 апреля 2005 г., 00:58:35 )
Re: How to improve db performance with $7K? (Matthew Nuzum, 19 апреля 2005 г., 01:44:30 )
Re: How to improve db performance with $7K? ("Jim C. Nasby", 19 апреля 2005 г., 23:08:46 )
Re: How to improve db performance with $7K? (Rosser Schwarz, 14 апреля 2005 г., 14:48:56 )
Re: How to improve db performance with $7K? (Kevin Brown, 16 апреля 2005 г., 01:33:40 )
Re: How to improve db performance with $7K? (Greg Stark, 14 апреля 2005 г., 18:03:50 )
Re: How to improve db performance with $7K? (Bruce Momjian, 18 апреля 2005 г., 20:58:44 )
Re: How to improve db performance with $7K? (Alex Turner, 18 апреля 2005 г., 22:49:56 )
Re: How to improve db performance with $7K? (Alvaro Herrera, 18 апреля 2005 г., 22:56:36 )
Re: How to improve db performance with $7K? (Bruce Momjian, 19 апреля 2005 г., 01:51:38 )
Re: How to improve db performance with $7K? ("Douglas J. Trainor", 07 апреля 2005 г., 08:59:21 )
Re: How to improve db performance with $7K? (, 07 апреля 2005 г., 19:38:44 )
Re: How to improve db performance with $7K? (Alex Turner, 07 апреля 2005 г., 19:46:41 )
Re: How to improve db performance with $7K? (, 07 апреля 2005 г., 20:30:10 )
Re: How to improve db performance with $7K? ("Douglas J. Trainor", 07 апреля 2005 г., 13:56:09 )
Re: How to improve db performance with $7K? (PFC, 15 апреля 2005 г., 10:07:51 )
Re: How to improve db performance with $7K? (Alan Stange, 15 апреля 2005 г., 13:12:02 )
Re: How to improve db performance with $7K? (Dave Cramer, 03 апреля 2005 г., 06:52:14 )
Re: How to improve db performance with $7K? ("Alexander Kirpa", 27 марта 2005 г., 19:23:10 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 14 апреля 2005 г., 15:02:49 )
Re: How to improve db performance with $7K? ("Matthew Nuzum", 14 апреля 2005 г., 15:55:52 )
Re: How to improve db performance with $7K? (Greg Stark, 14 апреля 2005 г., 17:55:27 )
Re: How to improve db performance with $7K? (PFC, 14 апреля 2005 г., 18:42:40 )
Re: How to improve db performance with $7K? (Tom Lane, 14 апреля 2005 г., 18:22:21 )
Re: How to improve db performance with $7K? ("Dave Held", 14 апреля 2005 г., 18:21:20 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 14 апреля 2005 г., 18:32:02 )
Re: How to improve db performance with $7K? (Steve Poe, 14 апреля 2005 г., 18:45:12 )
Re: How to improve db performance with $7K? ("Joshua D. Drake", 14 апреля 2005 г., 19:17:14 )
Re: How to improve db performance with $7K? (William Yu, 18 апреля 2005 г., 08:18:09 )
Re: How to improve db performance with $7K? (Greg Stark, 18 апреля 2005 г., 15:00:52 )
Re: How to improve db performance with $7K? (Alex Turner, 18 апреля 2005 г., 15:17:31 )
Re: How to improve db performance with $7K? (Greg Stark, 18 апреля 2005 г., 15:44:10 )
Re: How to improve db performance with $7K? (Alex Turner, 18 апреля 2005 г., 16:56:55 )
Re: How to improve db performance with $7K? (Jacques Caron, 18 апреля 2005 г., 17:32:38 )
Re: How to improve db performance with $7K? (Alex Turner, 18 апреля 2005 г., 18:16:26 )
Re: How to improve db performance with $7K? (Alex Turner, 18 апреля 2005 г., 18:21:08 )
Re: How to improve db performance with $7K? (Jacques Caron, 18 апреля 2005 г., 18:51:53 )
Re: How to improve db performance with $7K? (Alex Turner, 18 апреля 2005 г., 19:30:07 )
Re: How to improve db performance with $7K? (Jacques Caron, 18 апреля 2005 г., 18:28:41 )
Re: How to improve db performance with $7K? (Greg Stark, 18 апреля 2005 г., 18:24:44 )
Re: How to improve db performance with $7K? (Alan Stange, 18 апреля 2005 г., 17:34:58 )
Re: How to improve db performance with $7K? (John A Meinel, 18 апреля 2005 г., 17:36:22 )
Re: How to improve db performance with $7K? (Alex Turner, 18 апреля 2005 г., 18:18:29 )
Re: How to improve db performance with $7K? ("Joshua D. Drake", 18 апреля 2005 г., 18:28:41 )
Re: How to improve db performance with $7K? (Alex Turner, 18 апреля 2005 г., 18:50:58 )
Re: How to improve db performance with $7K? (Steve Poe, 18 апреля 2005 г., 17:46:52 )
Re: How to improve db performance with $7K? (Alex Turner, 18 апреля 2005 г., 18:19:39 )
Re: How to improve db performance with $7K? (Jacques Caron, 18 апреля 2005 г., 17:42:51 )
Re: How to improve db performance with $7K? ("Jim C. Nasby", 20 апреля 2005 г., 00:03:40 )
Re: How to improve db performance with $7K? (William Yu, 18 апреля 2005 г., 20:37:58 )
Re: How to improve db performance with $7K? ("Dave Held", 14 апреля 2005 г., 18:46:23 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 15 апреля 2005 г., 18:27:24 )
Re: How to improve db performance with $7K? ("Dave Held", 18 апреля 2005 г., 15:20:49 )
Re: How to improve db performance with $7K? ("Jim C. Nasby", 20 апреля 2005 г., 00:05:37 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 18 апреля 2005 г., 18:42:23 )
Re: How to improve db performance with $7K? ("Jim C. Nasby", 20 апреля 2005 г., 00:12:25 )
Re: How to improve db performance with $7K? (Alex Turner, 20 апреля 2005 г., 17:40:41 )
Re: How to improve db performance with $7K? ("Dave Held", 19 апреля 2005 г., 13:34:24 )
Re: How to improve db performance with $7K? (Alex Turner, 20 апреля 2005 г., 18:52:02 )
Re: How to improve db performance with $7K? (William Yu, 21 апреля 2005 г., 05:02:58 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 19 апреля 2005 г., 14:35:46 )
Re: How to improve db performance with $7K? (Bruce Momjian, 19 апреля 2005 г., 16:10:34 )
Re: How to improve db performance with $7K? (, 19 апреля 2005 г., 16:23:17 )
Re: How to improve db performance with $7K? ("Jim C. Nasby", 20 апреля 2005 г., 00:15:31 )
What to do with 6 disks? (Jeff Frost, 20 апреля 2005 г., 01:00:53 )
Re: What to do with 6 disks? ("Jim C. Nasby", 20 апреля 2005 г., 01:56:07 )
Re: What to do with 6 disks? (Josh Berkus, 20 апреля 2005 г., 03:02:32 )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Jeff Frost, 20 апреля 2005 г., 04:40:42 )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) ("J. Andrew Rogers", 20 апреля 2005 г., 06:03:21 )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Jeff Frost, 20 апреля 2005 г., 06:21:39 )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (William Yu, 20 апреля 2005 г., 15:09:58 )
Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Vivek Khera, 20 апреля 2005 г., 15:38:11 )
Re: What to do with 6 disks? (Vivek Khera, 20 апреля 2005 г., 15:36:34 )
Re: What to do with 6 disks? (William Yu, 20 апреля 2005 г., 03:07:00 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 19 апреля 2005 г., 16:13:25 )
Re: How to improve db performance with $7K? (Bruce Momjian, 19 апреля 2005 г., 16:16:14 )
Re: How to improve db performance with $7K? (Dawid Kuroczko, 20 апреля 2005 г., 08:55:49 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 19 апреля 2005 г., 16:26:06 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 20 апреля 2005 г., 16:18:52 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 20 апреля 2005 г., 16:44:32 )
Re: How to improve db performance with $7K? ("Dave Held", 20 апреля 2005 г., 18:49:17 )
Re: How to improve db performance with $7K? ("Mohan, Ross", 20 апреля 2005 г., 19:02:15 )

Greg Stark <> writes:
> In any case the issue with the IDE protocol is that fundamentally you
> can only have a single command pending. SCSI can have many commands
> pending.

That's the bottom line: the SCSI protocol was designed (twenty years ago!)
to allow the drive to do physical I/O scheduling, because the CPU can
issue multiple commands before the drive has to report completion of the
first one.  IDE isn't designed to do that.  I understand that the latest
revisions to the IDE/ATA specs allow the drive to do this sort of thing,
but support for it is far from widespread.

            regards, tom lane

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

Предыдущее

От: "Douglas J. Trainor"
Дата: 07 апреля 2005 г., 07:56:09
Сообщение: Re: How to improve db performance with $7K?

Следующее

От: Harald Fuchs
Дата: 07 апреля 2005 г., 10:23:20
Сообщение: Re: COPY Hacks (WAS: RE: Postgresql vs SQLserver for this application ?)