When data is large, Powa takes up CPU of memory

powa-team / powa

PostgreSQL Workload Analyzer

http://powa.readthedocs.io/

PostgreSQL License

768 stars 57 forks source link

When data is large, Powa takes up CPU of memory #100

Closed walnut-tom closed 5 years ago

walnut-tom commented 7 years ago

When data is large, Powa takes up CPU of memory

rjuju commented 7 years ago

Hello,

I'm sorry but I'm not sure I understand your issue. Could you elaborate a little more, and/or show some metrics about consumption?

walnut-tom commented 7 years ago

client use jdbc prepared statment, pg schema more than 10 thousand, Perform SQL more than 20 thousand per minute. The database server is out of memory. Restore normal after deleting Powa database.

rjuju commented 7 years ago

With this few details, it's hard to be really sure, but the latest release (v3.1.1) fix 2 bugs that have similar symptoms.

Can you try with last version and tell me if the problem is fixed?