space taken by a row & compressed data

From: "Leonardo Francalanci" <lfrancalanci(at)simtel(dot)ie>
To: <pgsql-general(at)postgresql(dot)org>
Subject: space taken by a row & compressed data
Date: 2004-08-26 13:51:04
Message-ID: KNEFJLENOMMIGOKNCBFAAEHBEMAA.lfrancalanci@simtel.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

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

Thank you

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-08-26 14:28:07 Re: copy a database
Previous Message Anony Mous 2004-08-26 13:35:59 Re: Problem to connect to the Windows Port