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
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
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