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

From Saptarshi Guha
Subject Re: Efficiency of inner joins across multiple tables
Date
Msg-id 388625CB-4B77-4836-8673-2238D72CDA07@gmail.com
Whole thread Raw
In response to Re: Efficiency of inner joins across multiple tables  ("David Wilson" <david.t.wilson@gmail.com>)
List pgsql-general
Hello,

>> 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.
>

Nice to hear.

>> 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?
>

Aah, very nice. I wasn't aware I could add a column once it has the
table has been created. I see the Alter command will do the trick.
Sounds good.

Thank you very much
Regards
Saptarshi


pgsql-general by date:

Previous
From: "David Wilson"
Date:
Subject: Re: Efficiency of inner joins across multiple tables
Next
From: Tom Lane
Date:
Subject: Re: question