Re: [HACKERS] 8K block limit

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: t-ishii(at)sra(dot)co(dot)jp
Cc: Stupor Genius <stuporg(at)erols(dot)com>, Pgsql-Hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] 8K block limit
Date: 1999-02-18 04:42:31
Message-ID: 36CB9A37.429BB98E@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-02-18 04:43:45 Re: [HACKERS] Bushy Plans fixed
Previous Message Vadim Mikheev 1999-02-18 04:35:39 Re: [HACKERS] Bushy Plans fixed