Re: Pointers needed on optimizing slow SQL statements - Mailing list pgsql-performance

From Віталій Тимчишин
Subject Re: Pointers needed on optimizing slow SQL statements
Date
Msg-id 331e40660906082358l67054c93x2721e91cb82c47b1@mail.gmail.com
Whole thread Raw
In response to Re: Pointers needed on optimizing slow SQL statements  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Pointers needed on optimizing slow SQL statements  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-performance
I'd prefer ALTER VIEW <name> SET ANALYZE=true; or CREATE/DROP ANALYZE <SQL>;
Also it should be possible to change statistics target for analyzed columns.

Such a statement would allow to analyze multi-table correlations. Note that for view planner should be able to use correlation information even for queries that do not use view, but may benefit from the information.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problems with autovacuum
Next
From: Dimitri Fontaine
Date:
Subject: Re: Pointers needed on optimizing slow SQL statements