Alter table command is pretty slow

From: Sreenivas K <sreenivas(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Alter table command is pretty slow
Date: 2005-08-12 09:10:33
Message-ID: 74f8b81f05081202102dcd6a40@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Aarni Ruuhimäki 2005-08-12 12:45:12 CFMX7 / Linux / PgSQL
Previous Message Bruce Momjian 2005-08-12 00:24:54 Re: Forcing WAL switch