Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number
Date
Msg-id 20050706200752.GA33295@winnie.fuhr.org
Whole thread Raw
In response to ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number  ("Dario" <dario_d_s@unitech.com.ar>)
List pgsql-performance
Tree view 
On Wed, Jul 06, 2005 at 04:49:21PM -0300, Dario wrote:
> where is stored the value set by ALTER TABLE table_name ALTER COLUMN
> column_name SET STATISTICS = [1-1000]?

pg_attribute.attstattarget

Example query:

SELECT attrelid::regclass, attname, attstattarget
FROM pg_attribute
WHERE attstattarget > 0;

See the "System Catalogs" chapter in the documentation for more
information.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-performance by date:

Previous
From: "Dario"
Date:
Subject: ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number
Next
From: Niccolo Rigacci
Date:
Subject: CURSOR slowes down a WHERE clause 100 times?