From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Index trouble with 8.3b4 |
Date: | 2008-01-06 19:42:00 |
Message-ID: | flraun$1f87$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I decided to play a bit with 8.3-b4. I did a fresh install from source,
fresh initdb, and created a single test table (about 700K rows) to play
with in-core FTS:
> Welcome to psql 8.3beta4, the PostgreSQL interactive terminal.
>
> hannes=> \d fts
> Table "public.fts"
> Column | Type | Modifiers
> --------+----------+--------------------------------------------------
> id | integer | not null default nextval('fts_id_seq'::regclass)
> text | text | not null
> tsv | tsvector |
> Indexes:
> "pk_fts" PRIMARY KEY, btree (id)
>
>
> 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.
After creating a GIST index instead of GIN I tried to cluster on that:
> hannes=> CLUSTER fts USING ts_fts_tsv;
> ERROR: could not create unique index "pk_fts"
> DETAIL: Table contains duplicated values.
So duplicate values in my PK column?
> hannes=> SET enable_indexscan = off;
> SET
> hannes=>
> hannes=> SELECT
> hannes-> f.id,
> hannes-> COUNT(f.id)
> hannes-> FROM
> hannes-> public.fts f
> hannes-> GROUP BY
> hannes-> f.id
> hannes-> HAVING
> hannes-> COUNT(f.id) > 1;
> id | count
> ----+-------
> (0 rows)
Where are they?
I'm a bit short of time and will probably not find time to debug this
further until next weekend, sorry.
--
Best regards,
Hannes Dorbath
From | Date | Subject | |
---|---|---|---|
Next Message | Clodoaldo | 2008-01-06 19:46:33 | Re: Performance problem. Could it be related to 8.3-beta4? |
Previous Message | Goboxe | 2008-01-06 18:58:38 | Re: Using syslog on pg for Windows |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-06 19:44:47 | Re: BUG #3852: Could not create complex aggregate |
Previous Message | jMartinez | 2008-01-06 17:32:58 | Re: pg 8.3 Windows installer suggestion |