Thank you Marti,
I will go with the ``reduced number of matched rows'' and naturally be waiting
for postgres 9.1 expectantly.
Kind regards,
Kim
On 2011-02-15 22:13, Marti Raudsepp wrote:
On Tue, Feb 15, 2011 at 21:33, Kim A. Brandt wrote:
removing the ORDER BY worked. But I
-02-15 15:49, Shaun Thomas wrote:
On 02/15/2011 08:23 AM, Kim A. Brandt wrote:
does `postgres (PostgreSQL) 8.4.5' use the LIMIT of a query when it
is run on a partitioned-table or am I doing something wrong? It looks
as if postgres queries all partitions and then LIMITing the records
after
Hello list,
does `postgres (PostgreSQL) 8.4.5' use the LIMIT of a query when it is run on a
partitioned-table or am I doing something wrong? It looks as if postgres queries
all partitions and then LIMITing the records afterwards!? This results in a long
(>3 minutes) running query. What can I d