Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Souquieres Adam <adam(dot)souquieres(at)axege(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Date: 2014-05-12 15:10:25
Message-ID: 20140512151025.GO6018@eldon.alvh.no-ip.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Souquieres Adam wrote:

> The solution must be to define a *better strategy for tables
> statistics*... we dont really need stats on all the tables because
> the most part of them is static...

Tune autovacuum so that it does the analyses for you?

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-05-12 15:50:47 Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Previous Message Souquieres Adam 2014-05-12 14:49:38 Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory