Hi Experts,
The attached query is performing slow, this needs to be optimized to
improve the performance.
Could you help me with query rewrite (or) on new indexes to be created to
improve the performance?
Thanks a ton in advance for your support.
SELECT tab2.rulename,
tab2.totalexecuted,
>Easy first question: is the temp table analyzed before being used in a
> join ?
No, I haven't done that. Today, I tried to run
ANALYZE records_to_filter_on;
on the same sample data set (3.75 million rows) before the join, and it did not
seem to make much of a difference in terms
Please don't cross post to multiple lists like this.
Cc: pgsql-...@lists.postgresql.org, pgsql-performance@lists.postgresql.org,
pgsql-gene...@lists.postgresql.org,
pgsql-ad...@lists.postgresql.org
If you're hoping for help on the -performance list, see this page and send the
"exp
