| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Valentine Gogichashvili <valgog(at)gmail(dot)com> |
| Cc: | PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size |
| Date: | 2013-08-28 13:21:45 |
| Message-ID: | 20130828132145.GC5181@awork2.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2013-08-28 15:27:11 | Re: BUG #8405: user can create a system table(eg, pg_class) |
| Previous Message | Heikki Linnakangas | 2013-08-28 12:34:58 | Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size |