| From: | Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> |
|---|---|
| To: | Diego <diego(at)unimedijui(dot)com(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Delete slow... |
| Date: | 2005-11-29 20:20:05 |
| Message-ID: | 1133295605.28236.1.camel@ekim |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-es-ayuda |
On Tue, 2005-11-29 at 18:13 -0300, Diego wrote:
> 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
That smells like a bad design. What do you delete from a 400.000 records
table?
I guess it's ok to be slow.
Mike
--
Mario Splivalo
Mob-Art
mario(dot)splivalo(at)mobart(dot)hr
"I can do it quick, I can do it cheap, I can do it well. Pick any two."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-11-29 20:36:35 | Re: Delete slow... |
| Previous Message | Andrea | 2005-11-29 20:16:16 | Fatal : IDENT authentication |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-11-29 20:36:35 | Re: Delete slow... |
| Previous Message | Andrea | 2005-11-29 20:16:16 | Fatal : IDENT authentication |