PGSQL and Nested Loops
От | |
---|---|
Тема | PGSQL and Nested Loops |
Дата | |
Msg-id | 20050905232930.4058.qmail@web33308.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: PGSQL and Nested Loops
|
Список | 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/
В списке pgsql-novice по дате отправления: