he EXPLAIN ANALYZE output and try to figure out
which part of the plan is being mis-estimated.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
e's only one materialize node in the whole
plan.
And just incidentally, do you have any of the other enable_* settings
turned off?
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To ma
On Tue, May 24, 2011 at 7:45 AM, Jasmin Dizdarevic
wrote:
> Hi,
> found the problem.
> 238 sec. with set enable_material = 'on'
> 4(!) sec. with set enable_material = 'off'
>
> @Robert Haas: I thought it would be interesting to you, because
> you've c
