Jayadevan M wrote:
> If a table takes 100 MB while on disk, approximately how much space will it
> take in RAM/database
> buffer?
100 MB. A block in memory has the same layout as a block on disk.
Yours,
Laurenz Albe
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
Hello,
If a table takes 100 MB while on disk, approximately how much space will it
take in RAM/database buffer?
Context - We are designing a database that will hold a couple of GBs of data.
We wanted to figure out how much shared_buffers we should provide to ensure
that most of the time, all th
