Re: [PERFORM] ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number

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

[PERFORM] ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number

¿where is stored the value set by ALTER TABLE table_name ALTER COLUMN column_name SET STATISTICS = [1-1000]? I've set this to 1000, and I didn't remember in which column (doh!). Is there any table to look? (I did 'grep "set stat" $PGDATA/pg_log/*' and found it, but may be there is a better way) I