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

Поиск
Список
Период
Сортировка
От Achilleus Mantzios
Тема Re: [SQL] [PERFORM] 7.3.1 index use / performance
Дата
Msg-id Pine.LNX.4.44.0301072051100.9883-100000@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: [SQL] [PERFORM] 7.3.1 index use / performance  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: 7.3.1 function problem: ERROR: cache lookup failed
Следующее
От: Medi Montaseri
Дата:
Сообщение: Re: Have people taken a look at pgdiff yet?