Re: Index scan is not working

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: Index scan is not working
Дата
Msg-id 20160919132722.7bz7jcaqxpqgxj6z@hermes.hilbert.loc
обсуждение исходный текст
Ответ на Re: Index scan is not working  (Kiran <bangalore.kiran@gmail.com>)
Список pgsql-general
On Mon, Sep 19, 2016 at 02:56:17PM +0200, Kiran wrote:

> I want to know whatever the Analyze output I am getting is normal for a
> table having few records or something is wrong.
> Will the DB engine uses whatever the best way to execute a query
> irrespective of the indexing in this case?

It will use whatever it concluded to seem to be the "best"
way at a given moment, yes.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


В списке pgsql-general по дате отправления:

Предыдущее
От: Kiran
Дата:
Сообщение: Re: Index scan is not working
Следующее
От: Willy-Bas Loos
Дата:
Сообщение: journaling / time travel