Re: [GENERAL] Seq scan X Index scan - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Seq scan X Index scan
Date
Msg-id CAKFQuwY0hvhm8hkh==dRFqhTzY8CfQL3WvaWdaO4zBHnv15Jag@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Seq scan X Index scan  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
On Wed, Mar 8, 2017 at 3:32 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
Why is SEQ SCAN faster than index scan?
 
Same number of evaluated record and less effort-per-record​.  You only win with an index if you can evaluate fewer records to make up for the extra effort per record that querying an index involves compared to just reading the actual data.

This is an environment t

​​
est but i'm running the same test on a production environment and also seq scan is cheaper than index.


Define (or show) production...

David J.

pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: [GENERAL] Seq scan X Index scan
Next
From: John Iliffe
Date:
Subject: Re: [GENERAL] Unable to start postgresql