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

Strange problem with an index.

From: "Blanco, Jose" <blancoj(at)umich(dot)edu>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Strange problem with an index.
Date: 2007-11-15 19:09:10
Message-ID: E0217C87D1BA1043AC897ACFA468CEE6015131F7@ECLUST2-VS3.adsroot.itcs.umich.edu (view raw or flat)
Thread:
Lists: pgsql-bugs
I have the following table          

Table "public.authorsort"
  Column  |         Type          | Modifiers 
----------+-----------------------+-----------
 ordernum | integer               | 
 handle   | character varying(30) | 
Indexes: author_handle_idx btree (handle)

As you can tell I have an index on handle.

In my perl script I loop trough series of select statements that look
like this:

Select ordernum from authorsort where handle = 'somvevalue';

Well, this was running very slowly, so I droped the index and recreated
it, and then it ran quickly.  I'm running versin 7.3 and I noticed that
in versin 8, the following has been done:

Prevent index corruption when a transaction inserts rows and then aborts
close to the end of a concurrent VACUUM on the same table (Tom)

And we recently added vacumm --full to our system.  Could this be the
reason?

Thanks!
Jose

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-11-15 21:12:20
Subject: Re: Strange problem with an index.
Previous:From: Magnus HaganderDate: 2007-11-15 18:40:47
Subject: Re: BUG #3750: Invalid frontend message type 112

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