Re: [SQL] [PERFORM] 7.3.1 index use / performance

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, <pgsql-performance(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] [PERFORM] 7.3.1 index use / performance
Date: 2003-01-07 22:51:35
Message-ID: Pine.LNX.4.44.0301072051100.9883-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance pgsql-sql

On Tue, 7 Jan 2003, Tom Lane wrote:

> Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)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(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2003-01-07 23:10:06 Re: [HACKERS] I feel the need for speed. What am I doing wrong?
Previous Message Jean-Luc Lachance 2003-01-07 22:42:45 Re: [HACKERS] I feel the need for speed. What am I doing

Browse pgsql-performance by date

  From Date Subject
Next Message scott.marlowe 2003-01-07 23:16:09 Re: [PERFORM] PostgreSQL and memory usage
Previous Message Achilleus Mantzios 2003-01-07 22:38:17 Re: [SQL] [PERFORM] 7.3.1 index use / performance

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas O'Connell 2003-01-07 23:12:08 double precision to numeric overflow error
Previous Message Achilleus Mantzios 2003-01-07 22:38:17 Re: [SQL] [PERFORM] 7.3.1 index use / performance