Re: Index Scanning - Mailing list pgsql-general

From Enrico
Subject Re: Index Scanning
Date
Msg-id 20070103182709.d0d9ccc4.scotty@linuxtime.it
Whole thread Raw
In response to Re: Index Scanning  (Richard Huxton <dev@archonet.com>)
List 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 by date:

Previous
From: "hubert depesz lubaczewski"
Date:
Subject: Re: "no unpinned buffers available" ? why? (hstore and plperl involved)
Next
From: novnov
Date:
Subject: Re: Generic timestamp function for updates where field