Re: Sequential scan where Index scan expected (update) - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Sequential scan where Index scan expected (update)
Date
Msg-id 20060303194039.GA12015@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Sequential scan where Index scan expected (update)  (Bryce Nesbitt <bryce1@obviously.com>)
List 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@crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.    --Bruce Schneier


pgsql-sql by date:

Previous
From: Bryce Nesbitt
Date:
Subject: Re: Sequential scan where Index scan expected (update)
Next
From: Maciej Piekielniak
Date:
Subject: pg_dump and diffrent sizes