From: | Michael Lewis <mlewis(at)entrata(dot)com> |
---|---|
To: | Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com> |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg12 - migrate tables to partitions structure |
Date: | 2019-09-18 20:08:16 |
Message-ID: | CAHOFxGqi5FrPrT--cUxh-q1V+yKDKdvhwv55G7x7JjE1E+Ffdw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
>
> All the queries uses the vendor product and thats why this column is a
> perfect fit as a partition column.
> My main table is big (10M+) (Product), but other tables can also be
> big(1M+)..
>
I assume you have query performance problems and are hoping partitioning
will help? Are you read heavy, or write intensive, or both? 10 million
rows, especially if they aren't super wide, doesn't seem like a huge number
to me. Do you have example queries with explain plans that you think would
benefit from the system being partitioned? I just know that as an engineer,
sometimes I like to make use of new tools, even when it isn't the best
solution for the problem I am actually experiencing. How confident are you
that you NEED partitions is my real question.
From | Date | Subject | |
---|---|---|---|
Next Message | Mariel Cherkassky | 2019-09-18 20:13:14 | Re: pg12 - migrate tables to partitions structure |
Previous Message | Mariel Cherkassky | 2019-09-18 19:29:35 | Re: pg12 - migrate tables to partitions structure |