pOSTGRESSQL dATABASE FILE SIZES - Mailing list pgsql-cygwin

From Richard Sydney-Smith
Subject pOSTGRESSQL dATABASE FILE SIZES
Date
Msg-id 001201c3748a$6ed33470$09211ad3@athlon2000
Whole thread Raw
Responses Re: pOSTGRESSQL dATABASE FILE SIZES  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-cygwin
Having just started to use POSTGRES 7.3.1 for windows I have been quite happy with most of the results.
 
However I have just checked the datafile sizes in my postgresql data directory and found it is 990mb. The original database concerned (Sybase SQL Anywhere 8) is 100mb in size.
 
In PGAdminII I have been clicking on the "Vacume/Analyse" button so why would the postgresql database be SO large? Is the data storage really that inefficient?
 
 
Thanks very much for a lovely product. But I will have to wait before promoting this package to clients. Its other problem is it does not re-start seemlessly if the user "crashes" the machine. Many users do not have very much experise at all when it comes to their machines.
 
Richard
 

pgsql-cygwin by date:

Previous
From: Nick Stone
Date:
Subject: Re: Error raised whilst running Postgres as a service (W
Next
From: raj_14_11@rec-all.com
Date:
Subject: ipc-daemon2 not starting