| From: | 李海龙 <hailong(dot)li(at)qunar(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>, 何伟平 <weiping(dot)he(at)qunar(dot)com>, 王冬 <dong(dot)wang(at)qunar(dot)com>, 于超超 <chaochao(dot)yu(at)qunar(dot)com>, 李妍 <angela(dot)li(at)qunar(dot)com> |
| Subject: | Re: BUG #8327: a bug of spgist index in a heavy write condition |
| Date: | 2013-08-07 06:51:10 |
| Message-ID: | 5201EE46.4070401@qunar.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
My dear Tom Lane && pgsql-hackers
Thanks very very much!
I have modified the postgres source code that Tom lane fixed, and the origin phenomenon of that bug no longer appears in my old test case.
Thanks again!
Best Regards!
at 2013-07-24 19:08, Andres Freund wrote:
Hi,
On 2013-07-24 10:54:07 +0000, hailong(dot)li(at)qunar(dot)com<mailto:hailong(dot)li(at)qunar(dot)com> wrote:
The following bug has been logged on the website:
Bug reference: 8327
Logged by: hailong.li
Email address: hailong(dot)li(at)qunar(dot)com<mailto:hailong(dot)li(at)qunar(dot)com>
PostgreSQL version: 9.2.4
Operating system: CentOS release 5.5 (Final)
Description:
http://www.postgresql.org/message-id/519A5917.40704@qunar.com
There's a thread that discussed the issue on the -hackers list:
http://archives.postgresql.org/message-id/5829.1370555205%40sss.pgh.pa.us
This resulted in a fix:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=e472b921406407794bab911c64655b8b82375196
Which has also been backported to the 9.2 branch. There hasn't been a
release since the commit though.
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vishalakshi Navaneethakrishnan | 2013-08-07 09:46:54 | How to avoid Force Autovacuum |
| Previous Message | Kevin Grittner | 2013-08-06 21:14:14 | Re: BUG #8366: getClob() stopped working from which version? |