| Lists: | pgsql-cygwin |
|---|
| From: | "Richard Sydney-Smith" <richard(at)ibisaustralia(dot)com> |
|---|---|
| To: | <pgsql-cygwin(at)postgresql(dot)org> |
| Subject: | pOSTGRESSQL dATABASE FILE SIZES |
| Date: | 2003-09-06 15:20:32 |
| Message-ID: | 001201c3748a$6ed33470$09211ad3@athlon2000 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Richard Sydney-Smith <richard(at)ibisaustralia(dot)com> |
| Cc: | pgsql-cygwin(at)postgresql(dot)org |
| Subject: | Re: pOSTGRESSQL dATABASE FILE SIZES |
| Date: | 2003-09-07 19:58:07 |
| Message-ID: | Pine.LNX.4.44.0309072155200.3161-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-cygwin |
Richard Sydney-Smith writes:
> 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?
Maybe you are vacuuming the wrong database, or PgAdmin is not executing
the full vacuum, just the lazy one. Read the documentation on the topic.
> 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.
What do you mean by "seamlessly"?
--
Peter Eisentraut peter_e(at)gmx(dot)net