Re: Efficiency of inner joins across multiple tables - Mailing list pgsql-general

From David Wilson
Subject Re: Efficiency of inner joins across multiple tables
Date
Msg-id e7f9235d0810071757y43e98e7bt92d06a1392af56e2@mail.gmail.com
Whole thread Raw
In response to Efficiency of inner joins across multiple tables  (Saptarshi Guha <saptarshi.guha@gmail.com>)
Responses Re: Efficiency of inner joins across multiple tables  (Saptarshi Guha <saptarshi.guha@gmail.com>)
List pgsql-general
On Tue, Oct 7, 2008 at 7:30 PM, Saptarshi Guha <saptarshi.guha@gmail.com> wrote:

> Q: How efficient is this?

If connectionHash is unique or near to it, and everything's indexed...
it could work for reasonable K values depending on your performance
requirements.

> Every time i create a new table should i create a table with all columns and
> query from that?

Is there any reason you can't just add the new column to the existing table?

--
- David T. Wilson
david.t.wilson@gmail.com

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_hba.conf use hostname not IP
Next
From: Saptarshi Guha
Date:
Subject: Re: Efficiency of inner joins across multiple tables