Igor, thank you , my tests showed better performance against the larger summary tables when I splited the index for datasource_id & datex , I use to have a composed index. Regarding that index statistics - should I analyze the tables? I thought auto vacuum takes care of it. helen -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-see-memory-usage-using-explain-analyze-tp4694962p4701919.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
