Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

Next:From: DiegoDate: 2005-11-29 21:32:43
Subject: Re: Delete slow...
Previous:From: Scott MarloweDate: 2005-11-29 20:36:35
Subject: Re: Delete slow...

pgsql-es-ayuda by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group