Postgres Pro
Downloads
Home   >   mailing lists

Re: slow seqscan - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: slow seqscan
Date
Msg-id 408649C1.3000904@familyhealth.com.au
Whole thread Raw
In response to Re: slow seqscan  (Edoardo Ceccarelli <eddy@axa.it>)
Responses Re: slow seqscan
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Edoardo Ceccarelli
Date:
Subject: Re: slow seqscan
Next
From: ohp@pyrenet.fr
Date:
Subject: Re: Wierd context-switching issue on Xeon