Re: [BUGS] BUG #8192: On very large tables the concurrent update with vacuum lag the hot_standby replica

2013-06-07 Thread Federico Campoli
On 06/06/13 21:22, Jeff Janes wrote: On Tue, Jun 4, 2013 at 8:36 AM, Federico Campoli mailto:feder...@brandwatch.com>> wrote: This is the gprof output for the profile. This looks to me like the gprof of a process that is either idle, or completely IO bound. I'd probably ap

Re: [BUGS] BUG #8192: On very large tables the concurrent update with vacuum lag the hot_standby replica

2013-06-04 Thread Federico Campoli
On 04/06/13 16:29, Andres Freund wrote: Hi, On 2013-06-04 16:20:12 +0100, Federico Campoli wrote: Well, if you check the output in that file you can see that 'apply' is progressing, so it's not stuck in some specific area. Is the startup process cpu bound during that time? If so

Re: [BUGS] BUG #8192: On very large tables the concurrent update with vacuum lag the hot_standby replica

2013-06-04 Thread Federico Campoli
On 02/06/13 01:17, Jeff Janes wrote: On Thursday, May 30, 2013, wrote: The following bug has been logged on the website: Bug reference: 8192 Logged by: Federico Campoli Email address: feder...@brandwatch.com PostgreSQL version: 9.2.4 Operating system