Re: slow seqscan

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Edoardo Ceccarelli <eddy(at)axa(dot)it>
Cc: Nick Barr <nicky(at)chuckie(dot)co(dot)uk>, pgsql-performance(at)postgresql(dot)org
Subject: Re: slow seqscan
Date: 2004-04-21 10:15:29
Message-ID: 408649C1.3000904@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> enable_seqscan = false
>
> and I'm having all index scans, timing has improved from 600ms to 18ms
>
> wondering what other implications I might expect.

Lots of really bad implications...it's really not a good idea.

Chris

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ohp 2004-04-21 11:18:53 Re: Wierd context-switching issue on Xeon
Previous Message Edoardo Ceccarelli 2004-04-21 10:10:02 Re: slow seqscan