Re: Index scan is not working - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Index scan is not working
Date
Msg-id 20160919132722.7bz7jcaqxpqgxj6z@hermes.hilbert.loc
Whole thread Raw
In response to Re: Index scan is not working  (Kiran <bangalore.kiran@gmail.com>)
List 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 by date:

Previous
From: Kiran
Date:
Subject: Re: Index scan is not working
Next
From: Willy-Bas Loos
Date:
Subject: journaling / time travel