Re: Multicolumn index for single-column queries?

Поиск
Список
Период
Сортировка
От Gavin Flower
Тема Re: Multicolumn index for single-column queries?
Дата
Msg-id 2105d821-e1cc-4ca0-1df3-d87178d3992b@archidevsys.co.nz
обсуждение исходный текст
Ответ на Re: Multicolumn index for single-column queries?  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
On 19/04/2019 02:12, Ron wrote:
> On 4/18/19 8:45 AM, Gavin Flower wrote:
>> On 19/04/2019 01:24, Ron wrote:
>>> On 4/18/19 2:14 AM, Andreas Kretschmer wrote:
> [snip]
>>>
>>> (Prefix compression would obviate the need for this question. Then 
>>> your multi-column index would be *much* smaller.)
>>
>> True, but a multi column index will still be bigger than single 
>> column index.
>
> TANSTAAFL.
>
>
QUOTE: [Oh, 'tanstaafl.' Means ~There ain't no such thing as a free lunch.']
 From The Moon is a Harsh Mistress, by Robert Heinlein. Published 1966
Is where I first came across TANSTAAFL.

However, it appears to have been used at least as early as 1949.

Just adding this, as probably there are many people who don't know the 
acronym.




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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Method to pass data between queries in a multi-statement transaction
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: Multicolumn index for single-column queries?