Performance issue with Postgres instance deployed in K8s.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • anishaks
    New Member
    • Nov 2019
    • 1

    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
Working...