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