Postgres Pro
Downloads
Home   >   mailing lists

Re: pg12 - partition by column that might have null values - Mailing list pgsql-performance

From Mariel Cherkassky
Subject Re: pg12 - partition by column that might have null values
Date
Msg-id CA+t6e1kGq1Ja-hW88gG7CkGSJBEiCrGrWZc7uOqy3U6Do-G2QA@mail.gmail.com
Whole thread Raw
In response to Re: pg12 - partition by column that might have null values  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses RE: pg12 - partition by column that might have null values  ("Mike Sofen" <msofen@runbox.com>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: pg12 - partition by column that might have null values
Next
From: "Mike Sofen"
Date:
Subject: RE: pg12 - partition by column that might have null values