Re: Opteron vs Xeon (Was: What to do with 6 disks?)

Список

Период

Сортировка

От	Jeff Frost
Тема	Re: Opteron vs Xeon (Was: What to do with 6 disks?)
Дата	20 апреля 2005 г. 04:40:42
Msg-id	Pine.LNX.4.62.0504192134450.21883@discord.dyndns.org обсуждение исходный текст
Ответ на	Re: What to do with 6 disks? (Josh Berkus)
Ответы	Re: Opteron vs Xeon (Was: What to do with 6 disks?) ("J. Andrew Rogers") Re: Opteron vs Xeon (Was: What to do with 6 disks?) (Vivek Khera)
Список	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 )

> RAID1 2 disks OS, pg_xlog
> RAID 1+0 4 disks pgdata

Looks like the consensus is RAID 1 for OS, pg_xlog and RAID10 for pgdata.  Now
here's another performance related question:

I've seen quite a few folks touting the Opteron as 2.5x faster with postgres
than a Xeon box.  What makes the Opteron so quick?  Is it that Postgres
really prefers to run in 64-bit mode?

When I look at AMD's TPC-C scores where they are showing off the Opteron
http://www.amd.com/us-en/Processors/ProductInformation/0,,30_118_8796_8800~96125,00.html
It doesn't appear 2.5x as fast as the Xeon systems, though I have heard from a
few Postgres folks that a dual Opteron is 2.5x as fast as a dual Xeon.  I
would think that AMD would be all over that press if they could show it, so
what am I missing?  Is it a bus speed thing?  Better south bridge on the
boards?

--
Jeff Frost, Owner     <>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954

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

Предыдущее

От: Dawid Kuroczko
Дата: 20 апреля 2005 г., 02:55:49
Сообщение: Re: How to improve db performance with $7K?

Следующее

От: Richard van den Berg
Дата: 20 апреля 2005 г., 08:22:42
Сообщение: When are index scans used over seq scans?