Re: Sequential scan where Index scan expected (update)

Andrew Sullivan wrote:<br /><blockquote cite="mid20060303124712.GC7057@phlogiston.dyndns.org" type="cite"><blockquote
type="cite"><prewrap="">thing_event_id=10000;   </pre></blockquote><pre wrap="">                 ^^^^^
 

in quotes.  The automatic int4-int8 coercion is probably your
problem.  Also </pre></blockquote> Yup that's it.  But this project uses (ugh) Hibernate.  I can't change it.  I may
haveto change<br /> from BIGINT primary keys to INT.<br /><br /> Also:<br /> Any hints on the table statistics?  I turn
themon, in a session, as user postgres, but get nothing:<br /><br /><tt>stage=# SHOW ALL;<br />              
name             |    setting<br /> --------------------------------+----------------<br /> ...<br />
 stats_block_level             | on<br />  stats_command_string           | on<br />  stats_reset_on_server_start    |
on<br/>  stats_row_level                | on<br />  stats_start_collector          | on<br /><br /> stage=# select *
frompg_statio_user_indexes;<br />   relid   | indexrelid | schemaname |           relname           |          
indexrelname          | idx_blks_read | idx_blks_hit<br />
----------+------------+------------+-----------------------------+----------------------------------+---------------+--------------<br
/> 18810975 |   18811183 | public     | eg_invoice                  | ix22f7bc70c7de2059               |             0
|           0<br />  18810979 |   18811184 | public     | eg_order                    |
ix522779518edf278d              |             0 |            0<br />  18810984 |   18811185 | public     |
eg_invoice_tax             | ix2f10773c8edf278d               |             0 |            0<br />  18810986 |  
18811186| public     | eg_order_line               | ixf8331222783867cc               |             0 |            0<br
/></tt><br/>