From:
Gregory Stark <stark(at)enterprisedb(dot)com>
To:
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"Hannes Dorbath" <light(at)theendofthetunnel(dot)de>, <pgsql-general(at)postgresql(dot)org>
Subject:
Re: Index trouble with 8.3b4
Date:
2008-01-07 14:46:19
Message-ID:
877iil7kxw.fsf@oxford.xeocode.com (view raw or flat )
Thread:
2008-01-06 19:42:00 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-07 02:22:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-07 14:46:19 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-07 15:18:46 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-07 16:15:35 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-07 16:43:50 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-13 18:50:51 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 19:02:34 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2008-01-13 19:39:27 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 19:48:29 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 19:55:59 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 20:54:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-13 21:01:49 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 22:14:34 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-14 00:15:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-14 00:31:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-13 23:52:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-14 01:43:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-14 10:44:42 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-14 15:36:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-14 17:59:45 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-14 11:36:18 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-14 21:29:18 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-01-14 21:53:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-15 02:51:42 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-15 03:10:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-15 13:33:43 from Kenneth Marshall <ktm(at)rice(dot)edu>
2008-01-15 17:27:15 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-01-15 19:01:32 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-15 19:22:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-08 23:21:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-08 23:47:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-09 02:03:26 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-09 02:33:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-09 03:18:22 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-01-07 19:46:01 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
Lists:
pgsql-general pgsql-hackers
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> Hannes Dorbath <light(at)theendofthetunnel(dot)de> writes:
>> hannes=> CREATE INDEX CONCURRENTLY "ts_fts_tsv" ON "public"."fts" USING gin ("tsv");
>> ERROR: item pointer (0,1) alreadt exists
>
>> I was able to reproduce that error a few times, but not always. It seems
>> it only happens with CONCURRENTLY.
>...
> I didn't have any luck reproducing either of these behaviors --- maybe
> it's data-dependent. Can you extract a test case?
I the GIN problem kicks in with the "posting tree" representation. That would
require more than about 85 records with the same matching lexeme-key.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!
In response to
pgsql-hackers by date
Next :From: Usama DarDate: 2008-01-07 14:49:47
Subject : Re: Tuning Postgresql on Windows XP Pro 32 bit
Previous :From : Csaba NagyDate : 2008-01-07 13:32:03
Subject : Re: Dynamic Partitioning using Segment Visibility Maps
pgsql-general by date
Next :From: Naz GassiepDate: 2008-01-07 14:49:53
Subject : Re: Hash Indexes
Previous :From : GeoffreyDate : 2008-01-07 14:07:36
Subject : Re: Memory on 32bit machine