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 Rosset

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

2013-04-23 Thread Anne Rosset
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? Thanks, Anne No this issue

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

2013-04-23 Thread Steve Singer
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 release? On 13-04-22 11:46 PM, Anne

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 was

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

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

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

2013-04-22 Thread Anne Rosset
@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 created as a side effect

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

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

2013-04-22 Thread Anne Rosset
. 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: Hi, We

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

2013-04-22 Thread Steve Singer
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] Performance with the new security

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

2013-04-22 Thread Anne Rosset
Hi Steve, Yes I see these messages in our log. Is there a solution to this? Thanks, Anne -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

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

2013-04-22 Thread Steve Singer
and 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
] Performance with the new security release? On 13-04-22 04:41 PM, Anne Rosset wrote: Hi Steve, Yes I see these messages in our log. Is there a solution to this? Thanks, Anne A manual analyze of the effected tables should work and give you updated statistics. If your problem is just statistics