| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| 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:36:35 |
| Message-ID: | 1133296595.28788.75.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-es-ayuda |
On Tue, 2005-11-29 at 15:32, Diego wrote:
> Thanks by answers...
>
> For each record deleted, my postgresql server spended 4 seconds...
> I know because i have logged each sql instruction, showing the time spended.
>
> My question is: is normal this time to a big table (400,000 records)
Do you have any foreign keys involved here? You might need some indexes
for faster lookups.
And don't worry about your english, I'm sure it's 1,000 times better
than most of our Portuguese.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Diego | 2005-11-29 21:13:23 | Delete slow... |
| Previous Message | Mario Splivalo | 2005-11-29 20:20:05 | Re: Delete slow... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2005-11-29 20:38:33 | Re: pg_dump Remoto |
| Previous Message | Mario Splivalo | 2005-11-29 20:20:05 | Re: Delete slow... |