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

Список

Период

Сортировка

От	Jim C. Nasby
Тема	Re: How to improve db performance with $7K?
Дата	20 апреля 2005 г. 00:12:25
Msg-id	20050420001224.GT58835@decibel.org обсуждение исходный текст
Ответ на	Re: How to improve db performance with $7K? ("Mohan, Ross")
Ответы	Re: How to improve db performance with $7K? (Alex Turner)
Список	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 )

On Mon, Apr 18, 2005 at 06:41:37PM -0000, Mohan, Ross wrote:
> Don't you think "optimal stripe width" would be
> a good question to research the binaries for? I'd
> think that drives the answer, largely.  (uh oh, pun alert)
>
> EG, oracle issues IO requests (this may have changed _just_
> recently) in 64KB chunks, regardless of what you ask for.
> So when I did my striping (many moons ago, when the Earth
> was young...) I did it in 128KB widths, and set the oracle
> "multiblock read count" according. For oracle, any stripe size
> under 64KB=stupid, anything much over 128K/258K=wasteful.
>
> I am eager to find out how PG handles all this.

AFAIK PostgreSQL requests data one database page at a time (normally
8k). Of course the OS might do something different.
--
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 по дате отправления:

Предыдущее

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

Следующее

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