Re: [PERFORM] Finalizing commit taking very long

Hello Tom, I can confirm that adding the indexes used by the deferred constraint triggers solved the issue. Thank you very much for your suggestions. Best regards, Giulio Cesare On 10/24/07, Giulio Cesare Solaroli [EMAIL PROTECTED] wrote: On 10/24/07, Tom Lane [EMAIL PROTECTED] wrote

Re: [PERFORM] Finalizing commit taking very long

On 10/24/07, Tom Lane [EMAIL PROTECTED] wrote: Giulio Cesare Solaroli [EMAIL PROTECTED] writes: How can I try to isolate the trigger taking so long, in oder to understand which is/are the missing index(es)? Try SET CONSTRAINTS ALL IMMEDIATE and then EXPLAIN ANALYZE the delete. This should

Re: [PERFORM] Newbie question about degraded performance on delete statement.

Hello Gregory, On 10/3/07, Greg Williamson [EMAIL PROTECTED] wrote: Giulio Cesare Solaroli wrote: Hello everybody, I have just joined the list, as I am experiencing a degradation on performances on my PostgreSQL instance, and I was looking for some insights on how to fix/avoid

Re: [PERFORM] Newbie question about degraded performance on delete statement. (SOLVED)

. THANKS EVERYBODY for your kind attention. Best regards, Giulio Cesare On 10/3/07, Giulio Cesare Solaroli [EMAIL PROTECTED] wrote: Hello Gregory, On 10/3/07, Greg Williamson [EMAIL PROTECTED] wrote: Giulio Cesare Solaroli wrote: Hello everybody, I have just joined the list, as I am

[PERFORM] Newbie question about degraded performance on delete statement.

development machine using a snapshot of the live data. Thanks for your attention. Best regards, Giulio Cesare Solaroli ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster