Postgres Pro
Downloads
Home   >   mailing lists

Re: space taken by a row & compressed data - Mailing list pgsql-general

From Bruce Momjian
Subject Re: space taken by a row & compressed data
Date
Msg-id 200408261505.i7QF5FR26375@candle.pha.pa.us
Whole thread Raw
In response to space taken by a row & compressed data  ("Leonardo Francalanci" <lfrancalanci@simtel.ie>)
Responses R: space taken by a row & compressed data  ("Leonardo Francalanci" <lfrancalanci@simtel.ie>)
List pgsql-general
Tree view 
Leonardo Francalanci wrote:
> With mysql I know how much space a row will take, based on the datatype
> of it columns. I also (approximately) know the size of indexes.
> Is there a way to know that in postgresql?

We have an FAQ item about this.

> Is there a way to pack (compress) data, as with myisampack for mysql?

Long data values are automatically compressed.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Graeme Hinchliffe
Date:
Subject: Re: detecting a dead db not seeming to work
Next
From: "Jim Wilson"
Date:
Subject: Re: Substring RegExp Extract path