Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Souquieres Adam <adam.souquieres@xxxxxxxxx>
Subject: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
From: Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx>
Date: Mon, 12 May 2014 11:10:25 -0400
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <5370DF82.20301@axege.com>
User-agent: Mutt/1.5.21 (2010-09-15)

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
  - From: David G Johnston

References:
- 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
  - From: Souquieres Adam
- Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
  - From: Merlin Moncure
- Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
  - From: Tom Lane
- Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
  - From: Souquieres Adam
- Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
  - From: Souquieres Adam
- Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
  - From: Tom Lane
- Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
  - From: Souquieres Adam

Prev by Date: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Next by Date: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Previous by thread: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Next by thread: Re: 8.4 -> 9.1 : ANALYSE VERBOSE; -> out of shared memory
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]