Lee Garrett wrote: >On 11/21/2013 04:15 PM, Arnt Gulbrandsen wrote: >>Stephen R. van den Berg wrote: >>>Arnt Gulbrandsen wrote: >>>Valid question. I asked my production db, about 5 minutes ago, the >>>query is still running. I'm not certain I can leave it running to >>>completion without disrupting service too much.
>>It locks nothing. >I think he means a performance drop due to the long running query, >not specifically a lock. Quite. When indexes get large enough, these "simple" queries can wreak havoc on the disk access patterns. -- Stephen.
