Re: Efficiency of inner joins across multiple tables

Поиск
Список
Период
Сортировка
От David Wilson
Тема Re: Efficiency of inner joins across multiple tables
Дата
Msg-id e7f9235d0810071757y43e98e7bt92d06a1392af56e2@mail.gmail.com
обсуждение исходный текст
Ответ на Efficiency of inner joins across multiple tables  (Saptarshi Guha <saptarshi.guha@gmail.com>)
Ответы Re: Efficiency of inner joins across multiple tables  (Saptarshi Guha <saptarshi.guha@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_hba.conf use hostname not IP
Следующее
От: Saptarshi Guha
Дата:
Сообщение: Re: Efficiency of inner joins across multiple tables