Hi,
I'm trying to create an availability table for existing products. I'm
fetching the suitable schema to design in order to get good performance
when I fetch products in a table contains millions of rows.
I think to make a schema like this:
*create table availability (product_id integer, product_name varchar(255),
start_date date, end_date date)*.

E.g:
Given an example 'product-1' which has a product_id = 1 and available
from *27/03/2018
to 31/03/2018*:



*product_id     product_name    start_date        end_date      *



*     1                product-1          27-03-2018    31-03-2018*
However if the product is not available in 29/03/2018 I have to divide the
period to 2 intervals:











*product_id     product_name    start_date        end_date
1                product-1          27-03-2018        28-03-2018
1                product-1          30-03-2018        31-03-2018With a
table contains millions of products and if I divide the availability by
intervals I will got a huge number of rows and fetching data will degrade
the performance. Is there any solution to use such as range types or
anything which mentions the unavailable dates.Based on the example
mentioned above, can I mention a data type like range type that take the
start_date and end_date and exclude the unavailable dates?*

Reply via email to