Re: pg12 - partition by column that might have null values

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: pg12 - partition by column that might have null values
Date: 2019-10-02 07:37:11
Message-ID: CA+t6e1kGq1Ja-hW88gG7CkGSJBEiCrGrWZc7uOqy3U6Do-G2QA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Whenever I have a new revision of that object, I update the end_time of the
latest revision to be now() and I add a new record of that object with
end_date null.
The null value is used to find most recent revisions of objects..
Thanks for the suggestion of infinity ! I'll try it.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Sofen 2019-10-02 12:08:05 RE: pg12 - partition by column that might have null values
Previous Message Laurenz Albe 2019-10-02 07:29:58 Re: pg12 - partition by column that might have null values