Horton

Re: Mnogosearch (Was: Re: website doc search is ... )

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Marc G. Fournier" <scrappy@postgresql.org>
Cc: Mark Kirkwood <markir@paradise.net.nz>, Bruce Momjian <pgman@candle.pha.pa.us>, "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2004-01-01T18:20:32Z
Lists: pgsql-general 
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> 'k, and for todays question ... how does one 'knock up the stats target'?

ALTER TABLE [ ONLY ] name [ * ]
    ALTER [ COLUMN ] column SET STATISTICS integer

The default is 10; try 100, or even 1000 (don't think it will let you
go higher than 1000).

			regards, tom lane