Postgres Pro
Downloads
Home   >   mailing lists

Re: tstzrange on large table gives poor estimate of expected rows - Mailing list pgsql-general

From Michael Lewis
Subject Re: tstzrange on large table gives poor estimate of expected rows
Date
Msg-id CAHOFxGq_Xvh-OnF3MEn1q57znrATTN=V5XoSN-Kd6HxS01GqHA@mail.gmail.com
Whole thread Raw
In response to tstzrange on large table gives poor estimate of expected rows  (Tom Dearman <tom.dearman@gmail.com>)
Responses Re: tstzrange on large table gives poor estimate of expected rows  (Tom Dearman <tom.dearman@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Cannot find hstore operator
Next
From: "David G. Johnston"
Date:
Subject: Re: Cannot find hstore operator