Re: [PERFORM] Force another plan.

2006-02-20 Thread Fredrik Olsson
Tom Lane skrev: Fredrik Olsson <[EMAIL PROTECTED]> writes: -> Seq Scan on t_entities (cost=0.00..1.49 rows=7 width=4) (actual time=404.539..409.302 rows=2 loops=1) Filter: ((haveaccess(createdby, responsible, "class", false) OR CASE WHEN (partof

Re: [PERFORM] Force another plan.

2006-02-19 Thread Fredrik Olsson
Tom Lane skrev: Fredrik Olsson <[EMAIL PROTECTED]> writes: I have some quite huge queries, inside functions, so debugging is kind of hard. But I have located the query that for some reason gets 4 times as slow after an analyze. Could we see EXPLAIN ANALYZE output for these case

[PERFORM] Force another plan.

2006-02-18 Thread Fredrik Olsson
f = 'events'::name) This takes on approximately 4.5s. So obviously it has degraded. I count myself as a newbie here, so any hints on what goes on, why a plan might be chosen, and how I can make is better is appreciated. Naturally the I can provide scripts to set up all or parts of the