Re: pg12 - migrate tables to partitions structure

From: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
To: Michael Lewis <mlewis(at)entrata(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: pg12 - migrate tables to partitions structure
Date: 2019-09-18 20:13:14
Message-ID: CA+t6e1m2MUyVc1iJqnP2=Hfk1EkXwEuYLGAznmortd31KMEitQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Well, if u have 10M rows, and all your queries use the same column in the
query and the data can split pretty even between the partitions, any
specific reason not to use is ? An index will help u reach a complexity of
(logn) while partition + index can be in complexity of (logm) when m = rows
in partition , n=total rows

>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2019-09-18 20:39:37 Re: Question regarding fast-hashing in PGSQL
Previous Message Michael Lewis 2019-09-18 20:08:16 Re: pg12 - migrate tables to partitions structure