Performance Question Followup No.2
От | Gordan Bobic |
---|---|
Тема | Performance Question Followup No.2 |
Дата | |
Msg-id | 200111071316.fA7DGwM04352@sentinel.bobich.net обсуждение исходный текст |
Ответы |
Re: Performance Question Followup No.2
Re: Performance Question Followup No.2 Re: Performance Question Followup No.2 |
Список | pgsql-general |
After just having split the action into two parts (FTI delete + Master delete), it would appear that most of the delay does come from the triggers executing. delete from masterfti where masterfti.id = master.id and master.entrytime < '31-Oct-2001'; DELETE 172609 Came back in about 10 seconds. delete from master where entrytime < '31-Oct-2001'; is still going after 10 minutes even though there are no records in the FTI table that are being deleted. Is there an explanation for this? Anything that I should check? Any performance tweaks that would improve this situation? Sorry to go on about this, but I'm totally puzzled by this. Regards. Gordan
В списке pgsql-general по дате отправления: