Postgres Pro
Downloads
Home   >   mailing lists

postgresql 10.1 scanning all partitions instead of 1 - Mailing list pgsql-performance

From Mariel Cherkassky
Subject postgresql 10.1 scanning all partitions instead of 1
Date
Msg-id CA+t6e1=xgGquoSwR7FgpzUZnx0WXxg_X_ZjvYn80Jb-Hd44-bw@mail.gmail.com
Whole thread Raw
Responses Re: postgresql 10.1 scanning all partitions instead of 1
List pgsql-performance
Tree view
Hi,
I configured range partitions on a date column of my main table(full_table). Each partition represents a day in the month. Every day partition has a list parition of 4 tables on a text column.

full table 
            table_01_11_2017  -->

            table_02_11_2017
               .....

pgsql-performance by date:

Previous
From: Vitaliy Garnashevich
Date:
Subject: Re: effective_io_concurrency on EBS/gp2
Next
From: Mariel Cherkassky
Date:
Subject: Re: postgresql 10.1 scanning all partitions instead of 1