User Profile
Collapse
Profile Sidebar
Collapse
anishaks
Last Activity: Nov 20 '19, 04:54 AM
Joined: Nov 20 '19
Location:
-
Performance issue with Postgres instance deployed in K8s.
I have a postgres(12.0) instance deployed in K8s.My table has got 14 million records ,~29 GB in size.It is partitioned and has got 32 partitions based on a business key.The table has got a pk sequence id.If I fire a select query with filter on partition ,I am able to get results.But if I try to execute a query with pk,it is not responding.Even explain analyze is also not responsing.It has got 24 GB RAM .Someone please guide me on this issue
No activity results to display
Show More