Why are tables sizes so big?

From: God_Of_Pain <silicontao_roy(at)technologist(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Why are tables sizes so big?
Date: 2001-03-05 16:34:37
Message-ID: xePo6.12274$pF4.2378523@news1.telusplanet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a Win32 app connecting to a PostgreSQL server via Delphi -> BDE ->
ODBC -> PostgreSQL. The app takes CSV files and stores them on the
PostgreSQL server. An empty CSV file makes a table that is 8kB in size on
the server and that is fine but for every 1kB of text in the CSV file the
PostgreSQL file gains about 5kB.

The CSV file has 5 text fields that I change to char size 10, float, float,
int and float. That in it's self sould make the data on the server much
smaller, but it is not, it is bigger, why?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mike 2001-03-05 16:53:18 name vs text vs varchar
Previous Message Rini Dutta 2001-03-05 16:32:49 Re: Re: [INTERFACES] 'Unknown Result Type' - JDBC Driver