ALTER TABLE .. SET STATISTICS

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: ALTER TABLE .. SET STATISTICS
Date: 2018-08-05 06:03:01
Message-ID: 45407d90-85dc-f5ba-58a5-d07fe99e852a@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


v9.6.9

For columns of type bytea which store image data (PDFs, JPGs, etc) would it
speed up the ANALYZE process to SET STATISTICS = 0?

That way, default_statistics_target could be cranked higher -- giving better
statistics for needed columns -- without polluting pg_statistics with
unneeded data?

Thanks

--
Angular momentum makes the world go 'round.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2018-08-05 14:36:41 Re: Walsender waiting on SnapbuildSync
Previous Message Peter Hicks 2018-08-04 23:34:48 Re: jndi jdbc url with ssl authenticat in tomcat ... fails org.xml.sax.SAXParseException columnNumber: 79; The reference to entity "ssl" must end with the ';' delimiter