Re: ALTER TABLE .. SET STATISTICS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: ALTER TABLE .. SET STATISTICS
Date: 2018-08-05 15:43:53
Message-ID: 396.1533483833@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron <ronljohnsonjr(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message wouter-postgresql 2018-08-05 17:05:31 Conditional JOINs to optimise expensive views
Previous Message Alvaro Herrera 2018-08-05 14:43:29 Re: ALTER TABLE .. SET STATISTICS