Re: Multicolumn index for single-column queries? - Mailing list pgsql-general

From Gavin Flower
Subject Re: Multicolumn index for single-column queries?
Date
Msg-id 2105d821-e1cc-4ca0-1df3-d87178d3992b@archidevsys.co.nz
Whole thread Raw
In response to Re: Multicolumn index for single-column queries?  (Ron <ronljohnsonjr@gmail.com>)
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Method to pass data between queries in a multi-statement transaction
Next
From: Gavin Flower
Date:
Subject: Re: Multicolumn index for single-column queries?