Re: Pointers needed on optimizing slow SQL statements

From: Віталій Тимчишин <tivv00(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Pointers needed on optimizing slow SQL statements
Date: 2009-06-09 06:58:51
Message-ID: 331e40660906082358l67054c93x2721e91cb82c47b1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dimitri Fontaine 2009-06-09 08:31:25 Re: Pointers needed on optimizing slow SQL statements
Previous Message Tom Lane 2009-06-08 20:16:54 Re: Problems with autovacuum