How many rows are you dealing with currently? What are your queries like? Have you looked at doing a hash partition on product.id? Is this on a test system or destined for a production environment in the near future? I ask because PG12 is still in beta.
- pg12 - migrate tables to partitions structure Mariel Cherkassky
- Re: pg12 - migrate tables to partitions structure Michael Lewis
- Re: pg12 - migrate tables to partitions structu... Mariel Cherkassky
- Re: pg12 - migrate tables to partitions str... Michael Lewis
- Re: pg12 - migrate tables to partitions... Mariel Cherkassky
- Re: pg12 - migrate tables to parti... Michael Lewis