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/>