Re: tstzrange on large table gives poor estimate of expected rows

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Tom Dearman <tom(dot)dearman(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: tstzrange on large table gives poor estimate of expected rows
Date: 2022-01-24 17:43:17
Message-ID: CAHOFxGq_Xvh-OnF3MEn1q57znrATTN=V5XoSN-Kd6HxS01GqHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If interval_end_date is always 1 day ahead, why store it at all?

Dependencies on a custom stats object wouldn't do anything I don't think
because they are offset. They are 100% correlated, but not in a way that
any of the existing stat types capture as far as I can figure.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2022-01-24 17:59:45 Re: Cannot find hstore operator
Previous Message Adrian Klaver 2022-01-24 16:39:51 Re: Cannot find hstore operator