Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster

Поиск
Список
Период
Сортировка
От Anoo Sivadasan Pillai
Тема Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster
Дата
Msg-id 772CDA49C515244FA14E34443F62E56403AFC9B8@EX-INDIA1.internal.rmplc.net
обсуждение исходный текст
Ответ на After Vacuum Analyse - Procedure performance not improved - Innner select is faster  ("Anoo Sivadasan Pillai" <aspillai@in.rm.com>)
Ответы Re: After Vacuum Analyse - Procedure performance notimproved - Innner select is faster  (Erik Jones <erik@myemma.com>)
Список pgsql-performance
>> Why the procedure is not getting the performance advantage of Vacuum
>> analyse?

>Plan caching by the function, probably.  Try disconnecting the session
>and reconnecting to prove the hypothesis.

>If it is a recurring problem for you, you could put the SELECT under
>EXECUTE in the function.  But most likely this is just a one-time
>problem.

Is there any way to clear the  cached plan manually other than
disconnecting (With the help of some commands/Configuration settings) ?



Visit our Website at http://www.rmesi.co.in

This message is confidential. You should not copy it or disclose its contents to anyone. You may use and apply the
informationfor the intended purpose only. Internet communications are not secure; therefore, RMESI does not accept
legalresponsibility for the contents of this message. Any views or opinions presented are those of the author only and
notof RMESI. If this email has come to you in error, please delete it, along with any attachments. Please note that
RMESImay intercept incoming and outgoing email communications.  

Freedom of Information Act 2000
This email and any attachments may contain confidential information belonging to RMESI.  Where the email and any
attachmentsdo contain information of a confidential nature, including without limitation information relating to trade
secrets,special terms or prices these shall be deemed for the purpose of the Freedom of Information Act 2000 as
informationprovided in confidence by RMESI and the disclosure of which would be prejudicial to RMESI's commercial
interests.

This email has been scanned for viruses by Trend ScanMail.



В списке pgsql-performance по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: After Vacuum Analyse - Procedure performance not improved - Innner select is faster
Следующее
От: Adrian Moisey
Дата:
Сообщение: big database performance