Skip site navigation (1) Skip section navigation (2)

Index trouble with 8.3b4

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2008-01-06 19:44:47
Subject: Re: BUG #3852: Could not create complex aggregate
Previous:From: jMartinezDate: 2008-01-06 17:32:58
Subject: Re: pg 8.3 Windows installer suggestion

pgsql-general by date

Next:From: ClodoaldoDate: 2008-01-06 19:46:33
Subject: Re: Performance problem. Could it be related to 8.3-beta4?
Previous:From: GoboxeDate: 2008-01-06 18:58:38
Subject: Re: Using syslog on pg for Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group