Re: [SQL] [PERFORM] 7.3.1 index use / performance - Mailing list pgsql-general

From Achilleus Mantzios
Subject Re: [SQL] [PERFORM] 7.3.1 index use / performance
Date
Msg-id Pine.LNX.4.44.0301072051100.9883-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Re: [SQL] [PERFORM] 7.3.1 index use / performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: 7.3.1 function problem: ERROR: cache lookup failed
Next
From: Medi Montaseri
Date:
Subject: Re: Have people taken a look at pgdiff yet?