Alter table command is pretty slow

Поиск
Список
Период
Сортировка
От Sreenivas K
Тема Alter table command is pretty slow
Дата
Msg-id 74f8b81f05081202102dcd6a40@mail.gmail.com
обсуждение исходный текст
Список pgsql-novice
Hi,

I have installed the PostgreSQL native Windows (8.0 using the Windows
MSI installer) on a Windows 2K box.  I accepted all of the
installation defaults.  It is running successfully  and my application
that stores data via Hibernate 2.0 is working. But it is taking too
long [>15 mimutes] if I try to execute any DDL commands . I Issued
vacuum command just before running a DDL. My computer has 512 MB of
RAM.  Why is it so slow?

Any help would be great.
Thanks in advance

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Forcing WAL switch
Следующее
От: Aarni Ruuhimäki
Дата:
Сообщение: CFMX7 / Linux / PgSQL