Bruce,
First of all, I'd like to thank you for taking some interest in this issue.
We'd love to migrate to the latest PG version, but this issue is currently
preventing us from doing so.
Regardless of the DB used (base application schema _or_ restored DB with
additional app data + base applica
On Tue, Sep 10, 2013 at 02:06:08AM +, Mel Llaguno wrote:
> We're currently using an embedded PG 8.4.17 for our application. Our
> PG 9.x tests consists of one of the following :
>
> - Take a 8.4.17 DB which contains only our application schema and
> required seed data and use pg_upgrade to crea
We're currently using an embedded PG 8.4.17 for our application. Our PG 9.x
tests consists of one of the following :
- Take a 8.4.17 DB which contains only our application schema and required seed
data and use pg_upgrade to create a 9.x database directory, run the
analyze_new_cluster.sh script
On Tue, Sep 10, 2013 at 01:36:27AM +, Mel Llaguno wrote:
> Let me clarify further - when we reconstruct our schema (without the
> upgrade step) via a sql script, the problem still persists. Restoring
> an upgraded DB which contains existing data into exactly the same
> instance will correct the
Let me clarify further - when we reconstruct our schema (without the upgrade
step) via a sql script, the problem still persists. Restoring an upgraded DB
which contains existing data into exactly the same instance will correct the
behavior.
Mel Llaguno | Principal Engineer (Performan
On Mon, Sep 9, 2013 at 08:38:09PM -0400, Andrew Dunstan wrote:
>
> On 08/01/2013 03:20 PM, Jeff Janes wrote:
> >On Thu, Aug 1, 2013 at 10:58 AM, Josh Berkus wrote:
> >>Amit, All:
> >>
> >>So we just retested this on 9.3b2. The performance is the same as 9.1
> >>and 9.2; that is, progressively w
On 08/01/2013 03:20 PM, Jeff Janes wrote:
On Thu, Aug 1, 2013 at 10:58 AM, Josh Berkus wrote:
Amit, All:
So we just retested this on 9.3b2. The performance is the same as 9.1
and 9.2; that is, progressively worse as the test cycles go on, and
unacceptably slow compared to 8.4.
Some issue in
