Re: [HACKERS] star join optimization

2011-11-14 Thread Rudyar
On 14/11/11 13:09, Greg Smith wrote: On 11/14/2011 10:44 AM, Rudyar wrote: Ok, I'm working in that project. I will send you my results and comparision with SQL server HHJ optimization in one or two months. Please be careful not to share here details of how features like this are built in any

Re: [HACKERS] star join optimization

2011-11-14 Thread Robert Haas
On Mon, Nov 14, 2011 at 8:25 AM, Rudyar wrote: > the hybrid hash join algorithm implemented in the current version of > PostgreSQL has any kind of optimization > for star join queries for Data Warehouse model? Not really. As much as possible, we try to make the query optimizer a general-purpose

Re: [HACKERS] star join optimization

2011-11-14 Thread Greg Smith
On 11/14/2011 10:44 AM, Rudyar wrote: Ok, I'm working in that project. I will send you my results and comparision with SQL server HHJ optimization in one or two months. Please be careful not to share here details of how features like this are built in any commercial databases you evaluate. So

Re: [HACKERS] star join optimization

2011-11-14 Thread Rudyar
On 14/11/11 12:37, Robert Haas wrote: On Mon, Nov 14, 2011 at 10:36 AM, Rudyar wrote: On 14/11/11 12:20, Robert Haas wrote: On Mon, Nov 14, 2011 at 8:25 AM, Rudyarwrote: the hybrid hash join algorithm implemented in the current version of PostgreSQL has any kind of optimization for star j

Re: [HACKERS] star join optimization

2011-11-14 Thread Robert Haas
On Mon, Nov 14, 2011 at 10:36 AM, Rudyar wrote: > On 14/11/11 12:20, Robert Haas wrote: >> >> On Mon, Nov 14, 2011 at 8:25 AM, Rudyar  wrote: >>> >>> the hybrid hash join algorithm implemented in the current version of >>> PostgreSQL has any kind of optimization >>> for star join queries for Data

Re: [HACKERS] star join optimization

2011-11-14 Thread Rudyar
On 14/11/11 12:20, Robert Haas wrote: On Mon, Nov 14, 2011 at 8:25 AM, Rudyar wrote: the hybrid hash join algorithm implemented in the current version of PostgreSQL has any kind of optimization for star join queries for Data Warehouse model? Not really. As much as possible, we try to make the

[HACKERS] star join optimization

2011-11-14 Thread Rudyar
Hello, the hybrid hash join algorithm implemented in the current version of PostgreSQL has any kind of optimization for star join queries for Data Warehouse model? Regards. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.