| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Mark Mielke <mark(at)mark(dot)mielke(dot)cc> |
| Cc: | Matthew <matthew(at)flymine(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: RAID arrays and performance |
| Date: | 2007-12-16 06:39:48 |
| Message-ID: | 200712160639.lBG6dmD20275@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Mark Mielke wrote:
> Asynchronous I/O is no more a magic bullet than threading. It requires a
> lot of work to get it right, and if one gets it wrong, it can be slower
> than the regular I/O or single threaded scenarios. Both look sexy on
> paper, neither may be the solution to your problem. Or they may be. We
> wouldn't know without numbers.
Agreed. We currently don't use multiple CPUs or multiple disks
efficiently for single-query loads. There is certainly more we could do
in these areas, and it is on the TODO list.
The good news is that most work loads are multi-user and we use
resources more evenly in those cases.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | H. Hall | 2007-12-16 11:42:09 | Re: update 600000 rows |
| Previous Message | andrew | 2007-12-16 05:21:47 | Re: update 600000 rows |