Can anybody please tell me whether there are any disadvantage of SQL
joins in terms of space and time and how postgres has implemented SQL
joins? I am in the impression that SQL join takes more time for
execution as well as space because database internally builds Cartesian
product and then evaluates for condition. Recently I normalized by DB
and changed my application Data model which resulted in writing lots of
inner join queries. Later I found that DB server is consuming more
memory. And once my Database also crashed. I am assuming that because of
normalization and inner joins, my DB crashed.
Can anybody please give a thought into my assumption?
In response to
pgsql-general by date
|Next:||From: Michal Taborsky - Internet Mall||Date: 2006-11-29 15:47:49|
|Subject: LOCK ... NOWAIT throws error|
|Previous:||From: Merlin Moncure||Date: 2006-11-29 15:34:21|
|Subject: Re: backend crash following load command|