Re: Small table or partial index?

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Small table or partial index?
Дата
Msg-id cone.1134490135.372863.79998.1000@zoraida.natserv.net
обсуждение исходный текст
Ответ на Small table or partial index?  (Francisco Reyes <lists@stringsutils.com>)
Список pgsql-performance
Jim C. Nasby writes:

> On Fri, Dec 02, 2005 at 06:28:09PM -0500, Francisco Reyes wrote:
>> I am in the process of designing a new system.
>> There will be a long list of words such as
>>
>> -word table
>> word_id integer
>> word varchar
>> special boolean
>>
>> Some "special" words are used to determine if some work is to be done and
>> will be what we care the most for one type of operation.
>
> Tough call. The key here is the amount of time required to do a join. It
> also depends on if you need all the special words or not. Your best bet
> is to try and benchmark both ways.


In your opinion do you think performance will be comparable?
I am hoping I will have time to test, but not sure if will have time and the
tables will be pretty large. :-(

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: query from partitions
Следующее
От: Ключников А.С.
Дата:
Сообщение: Re: query from partitions