Why are tables sizes so big?

Поиск
Список
Период
Сортировка
От God_Of_Pain
Тема Why are tables sizes so big?
Дата
Msg-id xePo6.12274$pF4.2378523@news1.telusplanet.net
обсуждение исходный текст
Список 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?

В списке pgsql-general по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: Why SELECT OWNER.TABLENAME.COLUMNNAME not working ?
Следующее
От: Bruce Momjian
Дата:
Сообщение: SQL article