Re: PostgreSQL, NetBSD and NFS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL, NetBSD and NFS
Дата
Msg-id 6707.1044475749@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL, NetBSD and NFS  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Ответы Re: PostgreSQL, NetBSD and NFS  (Thor Lancelot Simon <tls@rek.tjls.com>)
Список pgsql-hackers
"D'Arcy J.M. Cain" <darcy@druid.net> writes:
> On Wednesday 05 February 2003 13:04, Ian Fry wrote:
>> How about adjusting the read and write-size used by the NetBSD machine? I
>> think the default is 32k for both read and write on i386 machines now.
>> Perhaps try setting them back to 8k (it's the -r and -w flags to mount_nfs,
>> IIRC)

> Hey!  That did it.

Hot diggety!

> So, why does this fix it?

I think now you file a bug report with the NetBSD kernel folk.  My
thoughts are running in the direction of a bug having to do with
scattering a 32K read into multiple kernel disk-cache buffers or
gathering together multiple cache buffer contents to form a 32K write.
Unless NetBSD has changed from its heritage, the kernel disk cache
buffers are 8K, and so an 8K NFS read or write would never cross a
cache buffer boundary.  But 32K would.

Or it could be a similar bug on the NFS server's side?
        regards, tom lane


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

Предыдущее
От: "D'Arcy J.M. Cain"
Дата:
Сообщение: Re: PostgreSQL, NetBSD and NFS
Следующее
От: Laurette Cisneros
Дата:
Сообщение: Re: [ANNOUNCE] PostgreSQL v7.3.2 Released