Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE .. SET STATISTICS - Mailing list pgsql-general

From Tom Lane
Subject Re: ALTER TABLE .. SET STATISTICS
Date
Msg-id 396.1533483833@sss.pgh.pa.us
Whole thread Raw
In response to ALTER TABLE .. SET STATISTICS  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view 
Ron <ronljohnsonjr@gmail.com> writes:
> For columns of type bytea which store image data (PDFs, JPGs, etc) would it 
> speed up the ANALYZE process to SET STATISTICS = 0?

Should do, though I'm not sure how much of an effect you'd see.

            regards, tom lane

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ALTER TABLE .. SET STATISTICS
Next
From: wouter-postgresql@publica.duodecim.org
Date:
Subject: Conditional JOINs to optimise expensive views