Re: Appending "LIMIT" to query drastically decreases performance

From: cluster <skrald(at)amossen(dot)dk>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Subject: Re: Appending "LIMIT" to query drastically decreases performance
Date: 2007-11-30 16:01:11
Message-ID: 475033C7.9010708@amossen.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message henk de wit 2007-12-01 13:21:21 Utilizing multiple cores for one query
Previous Message Luke Lonergan 2007-11-30 15:45:27 Re: TB-sized databases