Delete slow...

From: Diego <diego(at)unimedijui(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Delete slow...
Date: 2005-11-29 21:13:23
Message-ID: 438CC473.9030409@unimedijui.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-es-ayuda

Hi,
I have a table with 400,000 records, but in delete comand is very slow
(4 seconds for operation)
Why is very slow? There is some special configuration for this?

Ps.: Version = Postgresql 7.4.6

Thanks
Diego Ziquinatti

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Diego 2005-11-29 21:32:43 Re: Delete slow...
Previous Message Scott Marlowe 2005-11-29 20:36:35 Re: Delete slow...

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Martín Marqués 2005-11-29 21:13:33 Re: registro de operaciones
Previous Message Jaime Casanova 2005-11-29 20:38:33 Re: pg_dump Remoto