Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size
Date
Msg-id 20130828132145.GC5181@awork2.anarazel.de
Whole thread Raw
In response to Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size  (Valentine Gogichashvili <valgog@gmail.com>)
List pgsql-bugs
Tree view 
On 2013-08-28 11:50:17 +0200, Valentine Gogichashvili wrote:
> Oh, here is more context about this issue:
> http://www.postgresql.org/message-id/201208171307.16342.andres@2ndquadrant.com

I think that backtrace and explanation pretty much explained what's
going on. Did you try 9.3 to see whether things got better there?

Alternatively, it might be very worthwile to try to get way from
per-transaction or even per-function temporary tables. As you've
discovered, they have quite the cost...

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size
Next
From: syxjxia@gmail.com
Date:
Subject: BUG #8405: user can create a system table(eg, pg_class)