| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jarosław Pałka <jaroslaw(dot)palka(at)mrt-system(dot)pl> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Never ending delete story |
| Date: | 2005-04-11 06:40:58 |
| Message-ID: | 22410.1113201658@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
=?UTF-8?B?SmFyb3PFgmF3IFBhxYJrYQ==?= <jaroslaw(dot)palka(at)mrt-system(dot)pl> writes:
> We are running PostgreSQL server version 7.4.6 on RedHat 9 (Shrike) on
> single Pentium 4 (2.66 GHz) box with SCSI disc and 512 MB RAM.
> Our database contains several tables (small size) and one special table
> with ~1000000 records (it contains log entries from system activity).We
> decided that its time to do a little clean-up and it's still running
> (for about 12 hours) and it seems that it won't stop :((
Do you have any foreign keys linking *to* (not from) this table?
If so, they probably need indexes on the far end. Also check for
datatype discrepancies.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tambet Matiisen | 2005-04-11 12:59:56 | Re: performance - triggers, row existence etc. |
| Previous Message | Tom Lane | 2005-04-11 06:29:25 | Re: Server crashing |