Re: Partitioning options - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Partitioning options
Date
Msg-id CAKAnmmLMs8pR69HbwG0rnbj2HPrffpvVr80oT1biB+8MUUzmRg@mail.gmail.com
Whole thread Raw
In response to Partitioning options  (sud <suds1434@gmail.com>)
Responses Re: Partitioning options  (veem v <veema0000@gmail.com>)
List pgsql-general
On Thu, Feb 8, 2024 at 12:42 AM sud <suds1434@gmail.com> wrote:
...
The key transaction table is going to have ~450 Million transactions per day and the data querying/filtering will always happen based on the "transaction date" column.
... 
Should we go for simple daily range partitioning on the transaction_date column?

This one gets my vote. That and some good indexes.

Cheers,
Greg

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: How to do faster DML
Next
From: Siraj G
Date:
Subject: Fwd: pgadmin not opening in concurrent sessions