Re: The REAL cost of joins

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Marcin Krol <mrkafk(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: The REAL cost of joins
Date: 2010-03-04 10:01:50
Message-ID: 2f4958ff1003040201n675db88eu64a402242923f54b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

the reason you are using joins, most often is because your schema is
normalized. One way or another, de-normalisation + queries will cost you
more, than normalised tables and joins.
That's at least the short answer.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Moran 2010-03-04 10:25:57 Re: Larger volumes of chronologically ordered data and the planner
Previous Message Richard Huxton 2010-03-04 09:04:37 Re: Failed to run initdb: 128