shantanugupta-yb
shantanugupta-yb
Jira Link: [DB-2731](https://yugabyte.atlassian.net/browse/DB-2731) ### Description As a part of testing [changes](https://github.com/yugabyte/yugabyte-db/issues/8494) [[DB-2687](https://yugabyte.atlassian.net/browse/DB-2687) Make OOM killer prioritize PG backends with more memory], I observed that all the postgres backends got terminated...
Jira Link: [DB-2732](https://yugabyte.atlassian.net/browse/DB-2732) ### Description Segmentation fault observed when postmaster process restarted post killing of all the postgres backend process > 2022-06-21 18:51:09.881 UTC [18312] LOG: server process (PID 22487)...
Jira Link: [DB-2834](https://yugabyte.atlassian.net/browse/DB-2834) ### Description On 2.15, the postgres backend size has increased to 300MB+(Select). For the same workload on 2.12 the postgres backend usage was 67MB max. This increase...
Jira Link: [DB-10142](https://yugabyte.atlassian.net/browse/DB-10142) ### Description The tablet count on master’s “tablet server” page post tablet splitting is incorrect. The “active tablet” count is lesser than “user tablet-peer”. For one of...
Jira Link: [DB-10979](https://yugabyte.atlassian.net/browse/DB-10979) ### Description TPCC workload running while cluster upgrade from 2.18.7.0-b38 to 2.21.1.0-b90 is failing. `16:06:35,834 (Worker.java:546) WARN - The DBMS rejected the transaction without an error code:ERROR:...
Jira Link: [DB-11135](https://yugabyte.atlassian.net/browse/DB-11135) ### Description During rolling upgrade with workload is running in parallel one of the node becomes unreachable. [Upgrade 2.18.7.0-b38 >> 2.21.0.0-b509](https://perf.dev.yugabyte.com/perfstudio-dashboard/status/5707002) [Upgrade 2.18.7.0-b38 >> 2.21.0.0-b504](https://perf.dev.yugabyte.com/perfstudio-dashboard/status/5706902) On both...
Jira Link: [DB-5796](https://yugabyte.atlassian.net/browse/DB-5796) ### Description By default joins are performed using Nested loop which is taking around ~3+ min where as with Merge/Hash join is 50-60X less at ~3-4 sec....
Jira Link: [DB-11911](https://yugabyte.atlassian.net/browse/DB-11911) ### Description Test: https://perf.dev.yugabyte.com/perfstudio-dashboard/output/6439902 Cluster: http://10.9.131.126/universes/d2fab6ec-3628-47b9-ac08-b12631efdc72/nodes Can see memory allocation stacks dumped in the tserver logs. On one of the node I see a total of 8550...
Jira Link: [DB-12583](https://yugabyte.atlassian.net/browse/DB-12583) ### Description [Scan queries](https://perf.dev.yugabyte.com/report/view/W3sibmFtZSI6InRlc3QtaWQiLCJpc0Jhc2VsaW5lIjp0cnVlLCJ0ZXN0X2lkIjo3NDIwOTAyfV0=): 24 queries executed with parallel workers out of 40 queries | [Report](https://perf.dev.yugabyte.com/report/view/W3sibmFtZSI6IkRlZmF1bHQiLCJ0ZXN0X2lkIjoiNzM2MTUwMiIsImlzQmFzZWxpbmUiOmZhbHNlfSx7Im5hbWUiOiJQYXJhbGxlbF93b3JrZXJzIiwidGVzdF9pZCI6Ijc0MjA5MDIiLCJpc0Jhc2VsaW5lIjpmYWxzZX0seyJuYW1lIjoiUEciLCJ0ZXN0X2lkIjoiNDY4ODUwMiIsImlzQmFzZWxpbmUiOnRydWV9XQ==) | 4 queries have regressed [Report](https://perf.dev.yugabyte.com/report/view/W3sibmFtZSI6IkRlZmF1bHQiLCJ0ZXN0X2lkIjoiNzM2MTUwMiIsImlzQmFzZWxpbmUiOnRydWV9LHsibmFtZSI6IlBhcmFsbGVsX3dvcmtlcnMiLCJ0ZXN0X2lkIjoiNzQyMDkwMiIsImlzQmFzZWxpbmUiOmZhbHNlfV0=) which compares YB with and...
Jira Link: [DB-12582](https://yugabyte.atlassian.net/browse/DB-12582) ### Description [Join queries:](https://perf.dev.yugabyte.com/report/view/W3sibmFtZSI6InRlc3QtaWQiLCJpc0Jhc2VsaW5lIjp0cnVlLCJ0ZXN0X2lkIjo3NDE4ODAyfV0=) 43 queries executed with parallel workers out of 61 queries | [Report](https://perf.dev.yugabyte.com/report/view/W3sibmFtZSI6IkRlZmF1bHQiLCJ0ZXN0X2lkIjoiNzM2MTYwMiIsImlzQmFzZWxpbmUiOmZhbHNlfSx7Im5hbWUiOiJQYXJhbGxlbF93b3JrZXJzIiwidGVzdF9pZCI6Ijc0MTg4MDIiLCJpc0Jhc2VsaW5lIjpmYWxzZX0seyJuYW1lIjoiUEciLCJ0ZXN0X2lkIjoiNDk0OTcwMiIsImlzQmFzZWxpbmUiOnRydWV9XQ==) | 15+ queries have regressed [Report](https://perf.dev.yugabyte.com/report/view/W3sibmFtZSI6IkRlZmF1bHQiLCJ0ZXN0X2lkIjoiNzM2MTYwMiIsImlzQmFzZWxpbmUiOnRydWV9LHsibmFtZSI6IlBhcmFsbGVsX3dvcmtlcnMiLCJ0ZXN0X2lkIjoiNzQxODgwMiIsImlzQmFzZWxpbmUiOmZhbHNlfV0=) which compares YB with and...