Postgres Pro
Downloads
Home   >   mailing lists

Re: Index only scan sometimes switches to sequential scan for small amount of rows - Mailing list pgsql-performance

From Feike Steenbergen
Subject Re: Index only scan sometimes switches to sequential scan for small amount of rows
Date
Msg-id CAK_s-G1fH2Rv8K7i6vKRj1=xr6s3E1bJvFT7RcgEMz5BBAtgDw@mail.gmail.com
Whole thread Raw
In response to Re: Index only scan sometimes switches to sequential scan for small amount of rows  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
Tree view 
On 25 March 2015 at 22:45, Jeff Janes <jeff.janes@gmail.com> wrote:

> How can the avg_width be 4 when the vast majority of entries are 7
> characters long?

The datatype is an enum, as I understand it, an enum type always
occupies 4 bytes

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Index only scan sometimes switches to sequential scan for small amount of rows
Next
From: Feike Steenbergen
Date:
Subject: Re: Index only scan sometimes switches to sequential scan for small amount of rows