Postgres Pro
Downloads
Home   >   mailing lists

Re: How to see memory usage using explain analyze ? - Mailing list pgsql-performance

From hyelluas
Subject Re: How to see memory usage using explain analyze ?
Date
Msg-id 1313433154717-4701919.post@n5.nabble.com
Whole thread Raw
In response to Re: How to see memory usage using explain analyze ?  ("Igor Neyman" <ineyman@perceptron.com>)
Responses Re: How to see memory usage using explain analyze ?  ("Igor Neyman" <ineyman@perceptron.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: David Boreham
Date:
Subject: Re: Reports from SSD purgatory
Next
From: Eyal Wilde
Date:
Subject: index not being used when variable is sent