From: Bryce Nesbitt <bryce1@obviously.com>
To: pgsql-sql@postgresql.org
Subject: Re: Sequential scan where Index scan expected (update)
Date: Fri, 03 Mar 2006 11:35:55 -0800
Message-ID: <44089A9B.2030509@obviously.com> (raw)
In-Reply-To: <20060303124712.GC7057@phlogiston.dyndns.org>
References: <244004377.20060302124132@isb.com.pl>
<2873.1141312882@sss.pgh.pa.us>
<4407F031.6050706@obviously.com>
<20060303124712.GC7057@phlogiston.dyndns.org>
Andrew Sullivan wrote:
>> thing_event_id=10000;
>>
> ^^^^^
>
> in quotes. The automatic int4-int8 coercion is probably your
> problem. Also
>
Yup that's it. But this project uses (ugh) Hibernate. I can't change
it. I may have to change
from BIGINT primary keys to INT.
Also:
Any hints on the table statistics? I turn them on, in a session, as
user postgres, but get nothing:
stage=# SHOW ALL;
name | setting
--------------------------------+----------------
...
stats_block_level | on
stats_command_string | on
stats_reset_on_server_start | on
stats_row_level | on
stats_start_collector | on
stage=# select * from pg_statio_user_indexes;
relid | indexrelid | schemaname | relname
| indexrelname | idx_blks_read | idx_blks_hit
----------+------------+------------+-----------------------------+----------------------------------+---------------+--------------
18810975 | 18811183 | public | eg_invoice |
ix22f7bc70c7de2059 | 0 | 0
18810979 | 18811184 | public | eg_order |
ix522779518edf278d | 0 | 0
18810984 | 18811185 | public | eg_invoice_tax |
ix2f10773c8edf278d | 0 | 0
18810986 | 18811186 | public | eg_order_line |
ixf8331222783867cc | 0 | 0
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bryce1@obviously.com
Subject: Re: Sequential scan where Index scan expected (update)
In-Reply-To: <44089A9B.2030509@obviously.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox