Re: on disk and in memory

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Jayadevan M *EXTERN*" <jayadevan(dot)maymala(at)ibsplc(dot)com>, "'pgsql-performance(at)postgresql(dot)org'" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: on disk and in memory
Date: 2013-06-25 07:33:57
Message-ID: A737B7A37273E048B164557ADEF4A58B17BB645E@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Emrah Mehmedov 2013-06-25 10:15:00 Re: PHP Postgres query slower then PgAdmin
Previous Message Jayadevan M 2013-06-25 04:57:08 on disk and in memory