Skip site navigation (1) Skip section navigation (2)

Re: Simply join in PostrgeSQL takes too long

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: Vitaly Belman <vitalib(at)012(dot)net(dot)il>,Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Simply join in PostrgeSQL takes too long
Date: 2004-04-29 17:13:49
Message-ID: lkd29018sbqg8bhcr3dabfjf6u6jckib3t@email.aon.at (view raw or flat)
Thread:
Lists: pgsql-performance
On Wed, 28 Apr 2004 08:23:35 -0400, Rod Taylor <pg(at)rbt(dot)ca> wrote:
>The below plpgsql forces the kind of algorithm we wish the planner could
>choose. It should be fairly quick irregardless of dataset.

That reminds me of hash aggregation.  So here's another idea for Vitaly:

	SELECT book_id
	  FROM ...
	 WHERE ...
	 GROUP BY book_id
	 LIMIT ...

Servus
 Manfred

In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2004-04-29 17:23:58
Subject: Re: Use arrays or not?
Previous:From: Manfred KoizarDate: 2004-04-29 17:03:03
Subject: Re: planner/optimizer question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group