On Sun, 9 Jun 2024 at 09:45, Lok P wrote:
>
> On Sat, Jun 8, 2024 at 7:03 PM veem v wrote:
>
>>
>> There is a blog below (which is for oracle), showing how the index should
>> be chosen and it states , "*Stick the columns you do range scans on
>> last in the index, filters that get equality pre
On Sat, Jun 8, 2024 at 7:03 PM veem v wrote:
> Hi ,
> It's postgres version 15.4. A table is daily range partitioned on a column
> transaction_timestamp. It has a unique identifier which is the ideal for
> primary key (say transaction_id) , however as there is a limitation in
> which we have to i
Hi ,
It's postgres version 15.4. A table is daily range partitioned on a column
transaction_timestamp. It has a unique identifier which is the ideal for
primary key (say transaction_id) , however as there is a limitation in
which we have to include the partition key as part of the primary key, so
i