Re: shared_buffers advice - Mailing list pgsql-performance

From Konrad Garus
Subject Re: shared_buffers advice
Date
Msg-id AANLkTimVO1B1XhbEcZmtkqrh-68Qd_fStwmJlwN-KlOp@mail.gmail.com
Whole thread Raw
In response to Re: shared_buffers advice  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: shared_buffers advice
List pgsql-performance
2010/5/27 Cédric Villemain <cedric.villemain.debian@gmail.com>:

> well, that is the projection of file in memory. only projection, but
> the memory is still acquire. It is ok to rework this part and project
> something like 128MB and loop. (in fact the code is needed for 9.0
> because segment can be > 1GB, I didn't check what is the optimum
> projection size yet)
> So both yes at your questions :)

So when I map 12 GB, this process will consume 1 GB and the time
needed to browse through the whole 12 GB buffer?

--
Konrad Garus

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Query timing increased from 3s to 55s when used as function instead of select
Next
From: David Jarvis
Date:
Subject: Re: Random Page Cost and Planner