Postgres Pro
Downloads
Home   >   mailing lists

Re: The REAL cost of joins - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: The REAL cost of joins
Date
Msg-id 2f4958ff1003040201n675db88eu64a402242923f54b@mail.gmail.com
Whole thread Raw
In response to Re: The REAL cost of joins  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Failed to run initdb: 128
Next
From: John Moran
Date:
Subject: Re: Larger volumes of chronologically ordered data and the planner