Re: Very slow planning performance on partition table

From: Rural Hunter <ruralhunter(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Very slow planning performance on partition table
Date: 2014-08-04 07:23:11
Message-ID: 53DF34DF.6010200@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

Hi Tom,

Could my problem be a victim of this issue?
http://postgresql.1045698.n5.nabble.com/Planner-performance-extremely-affected-by-an-hanging-transaction-20-30-times-td5771686.html

is the patch mentioned in that thread applied in 9.2.9?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2014-08-04 07:35:52 Re: PITR WAL Restore and configuration
Previous Message Techie 2014-08-04 05:53:42 Re: PITR WAL Restore and configuration

Browse pgsql-performance by date

  From Date Subject
Next Message Rural Hunter 2014-08-04 10:12:35 Re: Very slow planning performance on partition table
Previous Message Ryan Johnson 2014-08-02 18:12:26 Re: High rate of transaction failure with the Serializable Isolation Level