Fredrik Olsson <[EMAIL PROTECTED]> writes:
> Is a self contained test-case for the old way with the "proxy-view" is
> still wanted?
Yes, something still seems funny there. And for that matter it wasn't
clear what was wrong with your proxy view, either.
regards, tom lane
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 = 'contacts'::name) THE
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 = 'contacts'::name) THEN
> ischildof(
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 cases, not
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 cases, not just EXPLAIN?
It seem
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.
Before analyze the plan for the query is this:
Nested Loop (cost=16.80..34.33 rows=1 width=28)
Join Filter: (ischildof(2, "o
