Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 1FBD4476879; Tue,  7 Jan 2003 13:43:17 -0500 (EST)
Received: from matrix.gatewaynet.com (unknown [217.19.69.50])
	by postgresql.org (Postfix) with ESMTP
	id 657DE4773B4; Tue,  7 Jan 2003 13:43:07 -0500 (EST)
Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50])
	by matrix.gatewaynet.com (8.12.5/8.12.5) with ESMTP id h07MpZXR009941;
	Tue, 7 Jan 2003 20:51:35 -0200
Received: from localhost (achill@localhost)
	by matrix.gatewaynet.com (8.12.5/8.12.5/Submit) with ESMTP id
	h07MpZxh009937; Tue, 7 Jan 2003 20:51:35 -0200
Date: Tue, 7 Jan 2003 20:51:35 -0200 (GMT+2)
From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>,
	<pgsql-performance@postgresql.org>, <pgsql-general@postgresql.org>,
	<pgsql-sql@postgresql.org>
Subject: Re: [SQL] [PERFORM] 7.3.1 index use / performance 
In-Reply-To: <19585.1041964797@sss.pgh.pa.us>
Message-ID: <Pine.LNX.4.44.0301072051100.9883-100000@matrix.gatewaynet.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/250
X-Sequence-Number: 35371

On Tue, 7 Jan 2003, Tom Lane wrote:

> Achilleus Mantzios <achill@matrix.gatewaynet.com> writes:
> > My case persists:
> > After clean install of the database, and after vacuum analyze,
> > i get
>
> Um ... is it persisting?  That looks like it's correctly picked the
> vcode index this time.  Strange behavior though.  By "clean install"
> do you mean you rebuilt Postgres, or just did dropdb/createdb/reload
> data?

Just dropdb/createdb/reload.

>
> 			regards, tom lane
>

==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel:    +30-10-8981112
fax:    +30-10-8981877
email:  achill@matrix.gatewaynet.com
        mantzios@softlab.ece.ntua.gr