Re: How to see memory usage using explain analyze ?

From: hyelluas <helen_yelluas(at)mcafee(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: How to see memory usage using explain analyze ?
Date: 2011-08-15 18:32:34
Message-ID: 1313433154717-4701919.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2011-08-15 20:36:49 Re: strange pgbench results (as if blocked at the end)
Previous Message Igor Neyman 2011-08-15 18:19:45 Re: How to see memory usage using explain analyze ?