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

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Kevin Brown <kevin(at)sysexperts(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How to improve db performance with $7K?
Date: 2005-04-14 14:48:58
Message-ID: 37d451f7050414074876acdb82@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

while you weren't looking, Kevin Brown wrote:

[reordering bursty reads]

> In other words, it's a corner case that I strongly suspect
> isn't typical in situations where SCSI has historically made a big
> difference.

[...]

> But I rather doubt that has to be a huge penalty, if any. When a
> process issues an fsync (or even a sync), the kernel doesn't *have* to
> drop everything it's doing and get to work on it immediately. It
> could easily gather a few more requests, bundle them up, and then
> issue them.

To make sure I'm following you here, are you or are you not suggesting
that the kernel could sit on -all- IO requests for some small handful
of ms before actually performing any IO to address what you "strongly
suspect" is a "corner case"?

/rls

--
:wq

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2005-04-14 14:54:45 Intel SRCS16 SATA raid?
Previous Message Joel Fradkin 2005-04-14 14:45:48 Re: speed of querry?