Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron
Subject ALTER TABLE .. SET STATISTICS
Date
Msg-id 45407d90-85dc-f5ba-58a5-d07fe99e852a@gmail.com
Whole thread Raw
Responses Re: ALTER TABLE .. SET STATISTICS
Re: ALTER TABLE .. SET STATISTICS
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Peter Hicks
Date:
Subject: Re: jndi jdbc url with ssl authenticat in tomcat ... failsorg.xml.sax.SAXParseException columnNumber: 79; The reference to entity "ssl"must end with the ';' delimiter
Next
From: Andres Freund
Date:
Subject: Re: Walsender waiting on SnapbuildSync