Re: Never ending delete story

От: Tom Lane
Тема: Re: Never ending delete story
Дата: ,
Msg-id: 22410.1113201658@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Never ending delete story  (Jarosław Pałka)
Список: pgsql-performance

=?UTF-8?B?SmFyb3PFgmF3IFBhxYJrYQ==?= <> 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


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: Never ending delete story
От: "Tambet Matiisen"
Дата:
Сообщение: Re: performance - triggers, row existence etc.