Re: Seq scans roadmap - Mailing list pgsql-hackers

From Zeugswetter Andreas ADI SD
Subject Re: Seq scans roadmap
Date
Msg-id E1539E0ED7043848906A8FF995BDA5790211F032@m0143.s-mxs.net
Whole thread Raw
In response to Re: Seq scans roadmap  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-hackers
> > > > 32 buffers = 1MB with 32KB blocksize, which spoils the CPU L2
> > > > cache effect.

I'd say in a scenario where 32k pages are indicated you will also want
larger than average L2 caches.

> > > >
> > > > How about using 256/blocksize?

The reading ahead uses 1/4 ring size. To the best of our knowledge, this
1/4 needs to be 128k for reading.
So I'd say we need 512/blocksize.

Andreas


pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Windows Vista support (Buildfarm Vaquita)
Next
From: Hannu Krosing
Date:
Subject: Re: plperl vs. bytea