Re: Index Scanning

Поиск
Список
Период
Сортировка
От Enrico
Тема Re: Index Scanning
Дата
Msg-id 20070103182709.d0d9ccc4.scotty@linuxtime.it
обсуждение исходный текст
Ответ на Re: Index Scanning  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
On Wed, 03 Jan 2007 12:21:31 +0000
Richard Huxton <dev@archonet.com> wrote:

> Don't forget to cc the list

Ok thanks :)
>

> If you issue "set enable_seqscan = off" before the query that should
> force it to use the indexes first. What does that plan show you?

I try and then I post the results.

Regards Enrico




--
If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already
is!!!! 
scotty@linuxtime.it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi

В списке pgsql-general по дате отправления:

Предыдущее
От: "hubert depesz lubaczewski"
Дата:
Сообщение: Re: "no unpinned buffers available" ? why? (hstore and plperl involved)
Следующее
От: novnov
Дата:
Сообщение: Re: Generic timestamp function for updates where field