Re: Sequential scan where Index scan expected (update)

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Sequential scan where Index scan expected (update)
Дата
Msg-id 20060303194039.GA12015@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Re: Sequential scan where Index scan expected (update)  (Bryce Nesbitt <bryce1@obviously.com>)
Список 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 по дате отправления:

Предыдущее
От: Bryce Nesbitt
Дата:
Сообщение: Re: Sequential scan where Index scan expected (update)
Следующее
От: Maciej Piekielniak
Дата:
Сообщение: pg_dump and diffrent sizes