Thank you Jeff !
My comments are inline.
explain SELECT tv.short_code, tv.chn as pkg_subscription_chn,
tv.vert as pkg_vert, ubs.campaign_id as campaign,
'none'::varchar as referer,
CAST('CAMPAIGNWISE_SUBSCRIBER_BASE' AS VARCHAR) as vn,
count(tv.msisdn) as
On Wed, Sep 12, 2012 at 12:57 AM, Venkat Balaji venkat.bal...@verse.in wrote:
We are using PostgreSQL-9.0.1.
You are missing almost 2 years of updates, bug fixes, and security fixes.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
Regarding the wiki page on reporting slow queries:
https://wiki.postgresql.org/wiki/Slow_Query_Questions
We currently recommend EXPLAIN ANALYZE over just EXPLAIN. Should we
recommend EXPLAIN (ANALYZE, BUFFERS) instead? I know I very often
wish I could see that data. I don't think turning