Postgres Pro
Downloads
Home   >   mailing lists

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

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

            regards, tom lane

pgsql-general by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: [SQL] [PERFORM] 7.3.1 index use / performance
Next
From: Joe Conway
Date:
Subject: Re: 7.3.1 function problem: ERROR: cache lookup failed