Postgres Pro
Downloads
Home   >   mailing lists

Re: on disk and in memory - Mailing list pgsql-performance

From Albe Laurenz
Subject Re: on disk and in memory
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17BB645E@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to on disk and in memory  (Jayadevan M <jayadevan.maymala@ibsplc.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Jayadevan M
Date:
Subject: on disk and in memory
Next
From: Emrah Mehmedov
Date:
Subject: Re: PHP Postgres query slower then PgAdmin