Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Date
Msg-id 20140512151025.GO6018@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory  (Souquieres Adam <adam.souquieres@axege.com>)
Responses Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Souquieres Adam
Date:
Subject: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Next
From: David G Johnston
Date:
Subject: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory