| From: | Enrico <scotty(at)linuxtime(dot)it> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Index Scanning |
| Date: | 2007-01-03 17:27:09 |
| Message-ID: | 20070103182709.d0d9ccc4.scotty@linuxtime.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 03 Jan 2007 12:21:31 +0000
Richard Huxton <dev(at)archonet(dot)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(at)linuxtime(dot)it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Pawley | 2007-01-03 18:07:50 | Re: Backup Restore |
| Previous Message | Richard Huxton | 2007-01-03 17:19:29 | Re: "no unpinned buffers available" ? why? (hstore and |