Re: [HACKERS] 8K block limit - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] 8K block limit
Date
Msg-id 36CB9A37.429BB98E@krs.ru
Whole thread Raw
In response to Re: [HACKERS] 8K block limit  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
Tatsuo Ishii wrote:
> 
> >
> >Did you use the same -B for 8K and 32K ?
> >You should use 4x buffers in 8K case!
> 
> Ok. This time I started postmaster as 'postmaster -S -i -B 256'.
> 
> test1:
> 0.03user 0.02system 3:21.65elapsed
> 
> test2:
> 0.01user 0.08system 5:30.94elapsed
> 
> a little bit faster, but no significant difference?

Yes. So, 32K is sure value for a few simultaneous sessions.

Vadim


pgsql-hackers by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Bushy Plans fixed
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Bushy Plans fixed