Tom Lane <mailto:tgl@xxxxxxxxxxxxx> writes: > 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 I tried: ALTER TABLE ft_simple_core_content_content_idx ALTER column to_tsvector SET STATISTICS 10000; ANALYZE; and REINDEX INDEX ft_simple_core_content_content_idx; All the trouble was for nothing. Are there any other possibilities to solve my problem? Best regards, Bill Martin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
