Re: [GENERAL] Delete very slow after deletion of many rows in dependent

2004-11-22 Thread Cornelius Buschka
Hi Stephan, caching of the execution plan is a good hint. We'll try it in a new connection. Best Regards Cornelius Stephan Szabo wrote: On Sun, 21 Nov 2004, Cornelius Buschka wrote: Hi, we saw the following problem: We deleted all rows from a table B referencing table A (~50 records). No probl

Re: [GENERAL] Delete very slow after deletion of many rows in

2004-11-21 Thread Stephan Szabo
On Sun, 21 Nov 2004, Cornelius Buschka wrote: > Hi, > > we saw the following problem: > > We deleted all rows from a table B referencing table A (~50 records). No > problem, but the following try to delete all records from table A (~18) > lead > to a "never ending" statement. We found ou

[GENERAL] Delete very slow after deletion of many rows in dependent table

2004-11-21 Thread Cornelius Buschka
Hi, we saw the following problem: We deleted all rows from a table B referencing table A (~50 records). No problem, but the following try to delete all records from table A (~18) lead to a "never ending" statement. We found out, that vacuuming table B after delete did the trick. It seem