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@momjian.us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
