Postgres Pro
Downloads
Home   >   mailing lists

Re: TB-sized databases - Mailing list pgsql-performance

From Tom Lane
Subject Re: TB-sized databases
Date
Msg-id 25024.1205851772@sss.pgh.pa.us
Whole thread Raw
In response to Re: TB-sized databases  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Responses Re: TB-sized databases
List pgsql-performance
Tree view 
Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> Would another possible condition for considering
> Cartesian joins be be:

>    * Consider Cartesian joins when a unique constraint can prove
>      that at most one row will be pulled from one of the tables
>      that would be part of this join?

What for?  That would still lead us to consider large numbers of totally
useless joins.

            regards, tom lane

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: What is the best way to storage music files in Postgresql
Next
From: Michael Stone
Date:
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10