Query Analyser

From: "Gauri Kanekar" <meetgaurikanekar(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Query Analyser
Date: 2007-07-10 14:47:05
Message-ID: 7e4ba9550707100747r411cc2aex56f0c6d2fa273f73@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi List,

Is there anyway so as to indicate the Query Analyser not to use the
plan which it is using regularly, and use a new plan ?

From where do the Query Analyser gets the all info to prepare a plan?
Is it only from the pg_statistics table or are there anyother tables
which have this info. stored?

And can we change the statistic??

Thanx in advance
--
Regards
Gauri

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marc Mamin 2007-07-10 15:03:40 tuning a function to insert/retrieve values from a reference table
Previous Message Dimitri 2007-07-10 12:53:18 Re: Filesystem Direct I/O and WAL sync option