Postgres Professional

en English

en English

en English

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

в обсуждении

Список

Период

Сортировка

От:	Dave Held
Тема:	Re: How to improve db performance with $7K?
Дата:	19 апреля 2005 г. , 13:34:24
Msg-id:	49E94D0CFCD4DB43AFBA928DDD20C8F9026184BB@asg002.asg.local (см: обсуждение, исходный текст)
Ответ на:	How to improve db performance with $7K? (Steve Poe)
Ответы:	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 )

> -----Original Message-----
> From: Alex Turner [mailto:]
> Sent: Monday, April 18, 2005 5:50 PM
> To: Bruce Momjian
> Cc: Kevin Brown; 
> Subject: Re: [PERFORM] How to improve db performance with $7K?
>
> Does it really matter at which end of the cable the queueing is done
> (Assuming both ends know as much about drive geometry etc..)?
> [...]

The parenthetical is an assumption I'd rather not make.  If my
performance depends on my kernel knowing how my drive is laid
out, I would always be wondering if a new drive is going to
break any of the kernel's geometry assumptions.  Drive geometry
doesn't seem like a kernel's business any more than a kernel
should be able to decode the ccd signal of an optical mouse.
The kernel should queue requests at a level of abstraction that
doesn't depend on intimate knowledge of drive geometry, and the
drive should queue requests on the concrete level where geometry
matters.  A drive shouldn't guess whether a process is trying to
read a file sequentially, and a kernel shouldn't guess whether
sector 30 is contiguous with sector 31 or not.

__
David B. Held
Software Engineer/Array Services Group
200 14th Ave. East,  Sartell, MN 56377
320.534.3637 320.253.7800 800.752.8129

В списке pgsql-performance по дате сообщения:

Предыдущее:

От: Josh Berkus
Дата: 19 апреля 2005 г., 13:04:13
Сообщение: Bad n_distinct estimation; hacks suggested?

Следующее:

От: "Dave Held"
Дата: 19 апреля 2005 г., 14:02:05
Сообщение: Re: Bad n_distinct estimation; hacks suggested?