Hi Tom,
I should have looked at the analyzed plan first. The culprit for the
slow query were trigger function calls on foreign keys.
Ciao,
Viktor
Am 08.05.2009 um 01:06 schrieb Tom Lane:
Viktor Rosenfeld writes:
-> Seq Scan on corpus toplevel
(cost=0.00..1.39
Viktor Rosenfeld writes:
> -> Seq Scan on corpus toplevel (cost=0.00..1.39
> rows=1 width=54)
> Filter: (top_level AND (id = 25::numeric))
> Specifically, I'm wondering why the innermost scan on corpus
> (toplevel) does not use the
Hi everybody,
I'm wondering why a DELETE statement of mine does not make use of
defined indexes on the tables.
I have the following tables which are linked as such: component ->
rank -> node -> corpus;
Now I want to delete all entries in component by giving a list of
corpus ids.
The q
