postgresql 10.1 scanning all partitions instead of 1

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-performance(at)postgresql(dot)org>
Subject: postgresql 10.1 scanning all partitions instead of 1
Date: 2018-02-04 09:23:01
Message-ID: CA+t6e1=xgGquoSwR7FgpzUZnx0WXxg_X_ZjvYn80Jb-Hd44-bw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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
.....

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mariel Cherkassky 2018-02-04 09:28:47 Re: postgresql 10.1 scanning all partitions instead of 1
Previous Message Vitaliy Garnashevich 2018-02-03 23:05:05 Re: effective_io_concurrency on EBS/gp2