Out of interest. Why is a UUID being stored as a varchar(64) and not as a
uuid type ?
Ny motivation is to makes tables much smaller and much faster to lookup a
key if the key is of the correct data-type.
On Sun, 22 Dec 2024 at 03:38, James Pang wrote:
>Yes, we have primary key and another i
Yes, we have primary key and another index that include bigint and uuid
that stored in database as varchar(64), many sessions inserting ...
values and at the same time, many sessions running the select query.
table size 13GB, primary is 6GB, the other index is 13GB too, the select
query
Depends on a lot of thongs...Visibility map sounds like it's impacted here.
Are your inserts towards the index (like a monotonically increasing serial
id) or scattered around the index values ? How big is the table index
and shared buffers ? An example would really help
On Sat, 21 Dec 2024,
