Re: Read/Write block sizes

Поиск
Список
Период
Сортировка
От Jeffrey W. Baker
Тема Re: Read/Write block sizes
Дата
Msg-id 1124861121.11270.1.camel@noodles
обсуждение исходный текст
Ответ на Re: Read/Write block sizes  (Guy Thornley <guy@esphion.com>)
Ответы Re: Read/Write block sizes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Wed, 2005-08-24 at 17:20 +1200, Guy Thornley wrote:
> As for the async IO, sure you might think 'oh async IO would be so cool!!'
> and I did, once, too. But then I sat down and _thought_ about it, and
> decided well, no, actually, theres _very_ few areas it could actually help,
> and in most cases it just make it easier to drive your box into lseek()
> induced IO collapse.
>
> Dont forget that already in postgres, you have a process per connection, and
> all the processes take care of their own I/O.

That's the problem.  Instead you want 1 or 4 or 10 i/o slaves
coordinating the I/O of all the backends optimally.  For instance, with
synchronous scanning.

-jwb


В списке pgsql-performance по дате отправления:

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: Re: Caching by Postgres
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Read/Write block sizes