Re: What to do with 6 disks?

Список

Период

Сортировка

От	Jim C. Nasby
Тема	Re: What to do with 6 disks?
Дата	20 апреля 2005 г. 01:56:07
Msg-id	20050420015558.GY58835@decibel.org обсуждение исходный текст
Ответ на	What to do with 6 disks? (Jeff Frost)
Список	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 )

http://stats.distributed.net is setup with the OS, WAL, and temp on a
RAID1 and the database on a RAID10. The drives are 200G SATA with a
3ware raid card. I don't think the controller has battery-backed cache,
but I'm not sure. In any case, it's almost never disk-bound on the
mirror; when it's disk-bound it's usually the RAID10. But this is a
read-mostly database. If it was write-heavy, that might not be the case.

Also, in general, I see very little disk activity from the OS itself, so
I don't think there's a large disadvantage to having it on the same
drives as part of your database. I would recommend different filesystems
for each, though. (ie: not one giant / partition)

On Tue, Apr 19, 2005 at 06:00:42PM -0700, Jeff Frost wrote:
> Now that we've hashed out which drives are quicker and more money equals
> faster...
>
> Let's say you had a server with 6 separate 15k RPM SCSI disks, what raid
> option would you use for a standalone postgres server?
>
> a) 3xRAID1 - 1 for data, 1 for xlog, 1 for os?
> b) 1xRAID1 for OS/xlog, 1xRAID5 for data
> c) 1xRAID10 for OS/xlong/data
> d) 1xRAID1 for OS, 1xRAID10 for data
> e) .....
>
> I was initially leaning towards b, but after talking to Josh a bit, I
> suspect that with only 4 disks the raid5 might be a performance detriment
> vs 3 raid 1s or some sort of split raid10 setup.
>
> --
> Jeff Frost, Owner     <>
> Frost Consulting, LLC     http://www.frostconsultingllc.com/
> Phone: 650-780-7908    FAX: 650-649-1954
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>

--
Jim C. Nasby, Database Consultant               
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

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

Предыдущее

От: Jeff Frost
Дата: 20 апреля 2005 г., 00:21:39
Сообщение: Re: Opteron vs Xeon (Was: What to do with 6 disks?)

Следующее

От: Dawid Kuroczko
Дата: 20 апреля 2005 г., 02:35:58
Сообщение: Re: immutable functions vs. join for lookups ?