Re: Sequential scan where Index scan expected (update)

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Sequential scan where Index scan expected (update)
Date: 2006-03-03 19:40:39
Message-ID: 20060303194039.GA12015@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Mar 03, 2006 at 11:35:55AM -0800, Bryce Nesbitt wrote:
> 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.
>

Well, you could upgrade from 7.4.

> Also:
> Any hints on the table statistics? I turn them on, in a session, as
> user postgres, but get nothing:

You have to SIGHUP to get those to take effect, IIRC.

A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Maciej Piekielniak 2006-03-03 20:10:26 pg_dump and diffrent sizes
Previous Message Bryce Nesbitt 2006-03-03 19:35:55 Re: Sequential scan where Index scan expected (update)