Re: pOSTGRESSQL dATABASE FILE SIZES

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: pOSTGRESSQL dATABASE FILE SIZES
Дата
Msg-id Pine.LNX.4.44.0309072155200.3161-100000@peter.localdomain
обсуждение исходный текст
Ответ на pOSTGRESSQL dATABASE FILE SIZES  ("Richard Sydney-Smith" <richard@ibisaustralia.com>)
Список 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
databaseconcerned (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
thedata 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
problemis it does not re-start seemlessly if the user "crashes" the machine. Many users do not have very much experise
atall when it comes to their machines. 

What do you mean by "seamlessly"?

--
Peter Eisentraut   peter_e@gmx.net


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

Предыдущее
От: Bipinchandra Ranpura
Дата:
Сообщение: UNSUBSCRIBE
Следующее
От: Manfred Spraul
Дата:
Сообщение: Re: [PATCHES] WIN32_CONSOLE usage