| From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Multicolumn index for single-column queries? |
| Date: | 2019-04-18 22:58:10 |
| Message-ID: | 2105d821-e1cc-4ca0-1df3-d87178d3992b@archidevsys.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Flower | 2019-04-18 23:05:46 | Re: Multicolumn index for single-column queries? |
| Previous Message | David G. Johnston | 2019-04-18 21:34:10 | Re: Method to pass data between queries in a multi-statement transaction |