Re: [PERFORM] Performance Issue -- "Materialize"

Any thoughts on this? -- View this message in context: http://www.postgresql-archive.org/Performance-Issue-Materialize-tp5979128p5979481.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.o

[PERFORM] Performance Issue -- "Materialize"

I am a Postgres Newbie and trying to learn :)We have a scenario wherein, one of the SQL with different input value for import_num showing different execution plan.As an example, with import_num = '4520440' the execution plan shows Nested Loop and is taking ~12secs. With import_num = '4520460' exec