PGSQL and Nested Loops

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PGSQL and Nested Loops
Date: 2005-09-05 23:29:30
Message-ID: 20050905232930.4058.qmail@web33308.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi all, i read the followin gon slashdot...

(*) Nested loops are like candy to SQL server, and
I've heard this is the same for Sybase
(understandably). Deep sets of nested loops will kick
the other databases I've tested in the teeth. Given an
instruction with several nested loops and 16 million
rows of data, I got results from SQL server in 5
minutes, results from Oracle 9 in an hour, and results
from Postgres in 18 hours. This was a year ago and
Postgres has changed, so it might be better now. Does
MySQL handle them well?

i don't see myself ever running into this kind of
traffic, but i'm curious to know more about my db of
choice - pgsql. is this person's assessment correct
(for a year old version of pgsql) and has it improved
since then?

tia...



______________________________________________________
Click here to donate to the Hurricane Katrina relief effort.
http://store.yahoo.com/redcross-donate3/

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-09-05 23:36:39 Re: PGSQL and Nested Loops
Previous Message Tom Lane 2005-09-04 23:33:16 Re: problems when comparing text with special chars