Re: Efficiency of inner joins across multiple tables

From: "David Wilson" <david(dot)t(dot)wilson(at)gmail(dot)com>
To: "Saptarshi Guha" <saptarshi(dot)guha(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Efficiency of inner joins across multiple tables
Date: 2008-10-08 00:57:27
Message-ID: e7f9235d0810071757y43e98e7bt92d06a1392af56e2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 7, 2008 at 7:30 PM, Saptarshi Guha <saptarshi(dot)guha(at)gmail(dot)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(dot)t(dot)wilson(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Saptarshi Guha 2008-10-08 01:04:16 Re: Efficiency of inner joins across multiple tables
Previous Message Michelle Konzack 2008-10-08 00:52:58 Re: how to use pam-pgsql