Re: Testing 9.2 in ~production environment

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: James Cloos <cloos(at)jhcloos(dot)com>
Subject: Re: Testing 9.2 in ~production environment
Date: 2012-06-17 23:06:24
Message-ID: 201206180106.25665.andres@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Monday, June 18, 2012 12:51:51 AM James Cloos wrote:
> I'm giving 9.2-beta2 a test simulating a production workflow.
>
> Everything looks OK except the speed. Most (all?) queries take about
> five to six times as long as they do with 9.1.
>
> The configurations are essentially the same, the query plans are the same.
Is it possible that you compiled with assertions enabled? That would roughly
fit that magnitude. SHOW debug_assertions; Should show you whether it was
enabled.

Greetings,

Andres

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2012-06-17 23:11:03 Re: Testing 9.2 in ~production environment
Previous Message Peter Geoghegan 2012-06-17 22:58:05 Re: sortsupport for text