Re: Why are tables sizes so big?

God_Of_Pain wrote:
>
> 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?

char  = 10 + 4
floats= 8 * 3
int   = 4
oid   = 4

That's at least 46 bytes per row plus indexes - which can take up a lot.
Does that look plausible?

 - Richard Huxton