Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Appending "LIMIT" to query drastically decreases performance
- From: cluster <skrald(at)amossen(dot)dk>
- To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Appending "LIMIT" to query drastically decreases performance
- Date: Fri, 30 Nov 2007 17:01:11 +0100
- Message-id: <475033C7.9010708@amossen.dk> <text/plain>
Please post EXPLAIN ANALYZE output for the two queries.
As I wrote in my first post, I pasted this together with the two queries at pastebin.com:
http://pastebin.com/m3c0d1896
- References:
- Appending "LIMIT" to query drastically decreases performance
- From: cluster
- Re: Appending "LIMIT" to query drastically decreases performance
- From: Matthew
- Re: Appending "LIMIT" to query drastically decreases performance
- From: Bill Moran
- Appending "LIMIT" to query drastically decreases performance
- Prev by Date: Re: TB-sized databases
- Previous by thread: Re: Appending "LIMIT" to query drastically decreases performance
- Indexes: