Bill Martin <bill.martin@xxxxxxxxxxxxx> writes: > Tom Lane <tgl@xxxxxxxxxxxxx> writes: >> He can do it without having to change his schema --- but it's the index >> column, not the underlying content column, that needs its statistics >> target adjusted. > How can I adjust the statistics target of the index? Just pretend it's a table. ALTER TABLE index_name ALTER COLUMN column_name SET STATISTICS ... You'll need to look at the index (eg with \d) to see what the name of the desired column is, since index expressions have system-assigned column names. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
