Re: ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Dario <dario_d_s(at)unitech(dot)com(dot)ar>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number
Date: 2005-07-06 20:07:52
Message-ID: 20050706200752.GA33295@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Niccolo Rigacci 2005-07-06 21:19:46 CURSOR slowes down a WHERE clause 100 times?
Previous Message Dario 2005-07-06 19:49:21 ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number