Re: [HACKERS] What I'm working on

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] What I'm working on
Дата
Msg-id 199808240351.XAA16956@candle.pha.pa.us
обсуждение исходный текст
Ответ на RE: [HACKERS] What I'm working on  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: [HACKERS] What I'm working on
Список pgsql-hackers
>
>     Oh...I like this :)  that would give us something that the "big
> guys" don't also, no?  Bruce?
>
>     Can someone clarify something for me?  If, for example, we have
> the blocksize set to 16k, but the file system size is 8k, would the OS do
> both reads at the same time in order to get the full 16k?  I hope someone
> can follow this through (unless I'm actually clear), but if we left the
> tuples size at 8k fixed, and had that 16k tuple span two rows, do we send
> a request to the OS for the one block, then, once we get that back,
> determine that we need the next and request that?

The filesystem block size really controls how fine-graned the file block
allocation is.  It keeps 8k blocks as one contigious chunk on the disk
(ignoring trailing file fragments which are blocksize/8 in size).

How the OS does the disk requests is different.  It is related to the
base size of a disk block(usually 512 bytes), and if multiple requests
can be sent to the drive at the same time(tagged queuing?).  These are
really not related to the filesystem block size, except that larger
block sizes are made up of larger contigious disk block groups.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] What I'm working on
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] What I'm working on