Re: Incorrect behaviour when using a GiST index on points
From:
Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Incorrect behaviour when using a GiST index on points
Date:
2012-03-12 11:50:33
Message-ID:
CAPpHfdsgk+N=kf+HUn7CUtg6ThNQcKH6q3VZZwUzsB3zpjpRfA@mail.gmail.com (view raw or flat )
Thread:
2012-02-16 07:43:11 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-02-20 08:44:29 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-02-20 15:22:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-02-20 17:34:21 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-02-22 13:56:03 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-03-12 11:50:33 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-04-09 08:52:12 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-06-21 18:53:43 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-07-03 15:28:50 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-07-03 15:34:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-07-03 15:44:13 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-07-03 15:48:41 from Oleg Bartunov <obartunov(at)gmail(dot)com>
2012-07-03 15:58:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-07-03 21:46:26 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-10-23 14:18:48 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
2012-10-23 16:35:15 from Noah Misch <noah(at)leadboat(dot)com>
2012-08-27 22:43:56 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-08-27 23:43:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-28 02:20:29 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-08-28 02:21:27 from Bruce Momjian <bruce(at)momjian(dot)us>
2012-08-28 20:38:36 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-08-28 21:04:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-08-29 03:08:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-10-02 17:58:40 from Noah Misch <noah(at)leadboat(dot)com>
2012-10-11 11:17:28 from Noah Misch <noah(at)leadboat(dot)com>
2012-10-18 19:18:28 from Noah Misch <noah(at)leadboat(dot)com>
2012-11-02 12:05:30 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-11-02 12:46:41 from Noah Misch <noah(at)leadboat(dot)com>
2012-11-02 17:01:17 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-11-03 00:23:56 from Noah Misch <noah(at)leadboat(dot)com>
2012-11-03 21:53:19 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>
2012-11-10 15:54:55 from Noah Misch <noah(at)leadboat(dot)com>
2013-02-08 23:32:53 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:
pgsql-hackers
I believe that attached version of patch can be backpatched. It fixes this
problem without altering of index building procedure. It just makes checks
in internal pages softener enough to compensate effect of gist_box_same
implementation.
------
With best regards,
Alexander Korotkov.
In response to
Responses
pgsql-hackers by date
Next :From: Fujii MasaoDate: 2012-03-12 13:27:09Subject : Re: Bug: walsender and high CPU usagePrevious :From : Heikki LinnakangasDate : 2012-03-12 10:58:51Subject : Re: Bug: walsender and high CPU usage
