Re: [HACKERS] Performance with the new security release?

2013-04-23 Thread Alvaro Herrera
Anne Rosset wrote: > Thanks Steve. > I found this: http://www.postgresql.org/docs/current/static/release-9-2-3.html > " > Fix performance problems with autovacuum truncation in busy workloads (Jan > Wieck) > Truncation of empty pages at the end of a table requires exclusive lock, but > autovacuum

Re: [HACKERS] Performance with the new security release?

2013-04-23 Thread Steve Singer
rry to ask a second time but I really need to make sure). Thanks, Anne -Original Message- From: Steve Singer [mailto:st...@ssinger.info] Sent: Tuesday, April 23, 2013 6:33 AM To: Anne Rosset Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Performance with the new security releas

Re: [HACKERS] Performance with the new security release?

2013-04-23 Thread Anne Rosset
, April 23, 2013 6:33 AM To: Anne Rosset Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Performance with the new security release? On 13-04-22 11:46 PM, Anne Rosset wrote: > Thanks Steve. > I have read that a fix has been put in release 9.2.3 for this issue. Is that > right? > T

Re: [HACKERS] Performance with the new security release?

2013-04-23 Thread Steve Singer
but I haven't yet seen a patch. -Original Message- From: Steve Singer [mailto:st...@ssinger.info] Sent: Monday, April 22, 2013 4:35 PM To: Anne Rosset Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Performance with the new security release? On 13-04-22 04:41 PM, Anne R

Re: [HACKERS] Performance with the new security release?

2013-04-22 Thread Anne Rosset
nne >> >> -Original Message- >> From: Steve Singer [mailto:st...@ssinger.info] >> Sent: Monday, April 22, 2013 12:59 PM >> To: Anne Rosset >> Cc: pgsql-hackers@postgresql.org >> Subject: Re: [HACKERS] Performance with the new security release? >>

Re: [HACKERS] Performance with the new security release?

2013-04-22 Thread Steve Singer
doing manual vacuums during those times. -Original Message- From: Steve Singer [mailto:st...@ssinger.info] Sent: Monday, April 22, 2013 1:26 PM To: Anne Rosset Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Performance with the new security release? On 13-04-22 04:15 PM, Anne

Re: [HACKERS] Performance with the new security release?

2013-04-22 Thread Anne Rosset
; To: Anne Rosset > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] Performance with the new security release? > > On 13-04-22 01:38 PM, Anne Rosset wrote: >> Hi, >> We are seeing some overall performance degradation in our application >>since we installed t

Re: [HACKERS] Performance with the new security release?

2013-04-22 Thread Steve Singer
then you might be hitting this issue. I will dig into our logs to see for the query times. Thanks, Anne -Original Message- From: Steve Singer [mailto:st...@ssinger.info] Sent: Monday, April 22, 2013 12:59 PM To: Anne Rosset Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Perf

Re: [HACKERS] Performance with the new security release?

2013-04-22 Thread Anne Rosset
the query times. Thanks, Anne -Original Message- From: Steve Singer [mailto:st...@ssinger.info] Sent: Monday, April 22, 2013 12:59 PM To: Anne Rosset Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Performance with the new security release? On 13-04-22 01:38 PM, Anne Rosset wrote:

Re: [HACKERS] Performance with the new security release?

2013-04-22 Thread Steve Singer
On 13-04-22 01:38 PM, Anne Rosset wrote: Hi, We are seeing some overall performance degradation in our application since we installed the security release. Other commits were also done at the same time in the application so we don't know yet if the degradation has any relationship with the se

Re: [HACKERS] Performance with the new security release?

2013-04-22 Thread Anne Rosset
ckers@postgresql.org Subject: Re: [HACKERS] Performance with the new security release? On 04/22/2013 10:38 AM, Anne Rosset wrote: > While we are digging into this, I would like to know if it is > possible that the release has some impact on performance. After > reading this "It was creat

Re: [HACKERS] Performance with the new security release?

2013-04-22 Thread Josh Berkus
On 04/22/2013 10:38 AM, Anne Rosset wrote: > While we are digging into this, I would like to know if it is possible > that the release has some impact on performance. After reading this > "It was created as a side effect of a refactoring effort to make > establishing new connections to a Pos

Re: [HACKERS] Performance with the new security release?

2013-04-22 Thread Josh Berkus
On 04/22/2013 10:38 AM, Anne Rosset wrote: > While we are digging into this, I would like to know if it is possible > that the release has some impact on performance. After reading this > "It was created as a side effect of a refactoring effort to make > establishing new connections to a Pos

[HACKERS] Performance with the new security release?

2013-04-22 Thread Anne Rosset
Hi, We are seeing some overall performance degradation in our application since we installed the security release. Other commits were also done at the same time in the application so we don't know yet if the degradation has any relationship with the security release. While we are digging int