Re: Query Performance question - Mailing list pgsql-performance

From Magers, James
Subject Re: Query Performance question
Date
Msg-id b5a078be76e74517b341a9b76a3c136c@CO2PR07MB601.namprd07.prod.outlook.com
Whole thread Raw
In response to Re: Query Performance question  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Query Performance question  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-performance
Thomas,

Thank you.  I executed the query this morning after disabling the scan types.  I am including links to explain.depesz
outputfor each of the three variations that I executed.  
 

indexscan and bitmapscan off: http://explain.depesz.com/s/sIx
seqscan and bitmapscan off: http://explain.depesz.com/s/GfM
bitmapscan off: http://explain.depesz.com/s/3wna


Thank you,
James


pgsql-performance by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Query Performance question
Next
From: Thomas Kellerer
Date:
Subject: Re: Query Performance question