Postgres Pro
Downloads
Home   >   mailing lists

Re: Appending "LIMIT" to query drastically decreases performance - Mailing list pgsql-performance

From cluster
Subject Re: Appending "LIMIT" to query drastically decreases performance
Date
Msg-id 475033C7.9010708@amossen.dk
Whole thread Raw
In response to Re: Appending "LIMIT" to query drastically decreases performance  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Luke Lonergan
Date:
Subject: Re: TB-sized databases
Next
From: henk de wit
Date:
Subject: Utilizing multiple cores for one query