Re: Testing 9.2 in ~production environment - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Testing 9.2 in ~production environment
Date
Msg-id 201206180106.25665.andres@2ndquadrant.com
Whole thread Raw
In response to Testing 9.2 in ~production environment  (James Cloos <cloos@jhcloos.com>)
Responses Re: Testing 9.2 in ~production environment  (James Cloos <cloos@jhcloos.com>)
List 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


pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: sortsupport for text
Next
From: Peter Eisentraut
Date:
Subject: Re: Testing 9.2 in ~production environment