Re: Performance on inserts

> > * Prevent index lookups (or index entries using partial index) on most
> >   common values; instead use sequential scan 
> 
> This behavior already exists for the most common value, and would
> exist for any additional values that we had stats for.  Don't see
> why you think a separate TODO item is needed.

You mean the optimizer already skips an index lookup for the most common
value, and instead does a sequential scan?  Seems you are way ahead of
me.


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026