> IF txnid is real UUID , then you can test the
> https://www.postgresql.org/docs/11/datatype-uuid.html performance> see
> https://stackoverflow.com/questions/29880083/postgresql-uuid-type-performance>
> imho: it should be better.
Sure, thanks Imre
Thanks and Regards,
Ravi G
bles after bulk inserts, to set hint bits (and since> non-updated tuples
> won't be hit by autovacuum). Or maybe VACUUM FREEZE to> freeze tuples (since
> it sounds like a typical page is unlikely to ever be> updated).
Sure, I'll evaluate these settings, thanks.
Thanks and
of combinations/partition strategy we can test
considering data-volume/vacuum etc. Also let me know if some of the pg_settings
can help us tuning this (I have attached my pg_settings).
Thanks and Regards,
Ravi Garg,
Mob : +91-98930-66610
On Sunday, 23 February, 2020, 03:42:13 pm IST, Justin
g_20200223.loggingtime < '2020-02-24
00:00:00'::timestamp without time zone)) Buffers: shared hit=5
**Planning Time: 6.231 ms** Execution Time: 0.076 ms(9 rows)
There are around ~200 child partitions. Partition pruning enabled.PostgreSQL
Version: PostgreSQL 11.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-39), 64-bit
Thanks and Regards,
Ravi Garg,
