Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Performance Issue at Vertica
Would like to hear any feedback regarding performance issue that I'm noticing on my DB. I don't have any such activity going on at my Vertica DB but even then I see lot's of Network & IO Usages. Specially on IO, I see lots of write operations happening and I don't know what is causing that as there is no as such Data Loading/Projection Creation going on? Moreover, when I tried validating, I see lots of query requests but all those seem to be system level query but not some application level query. I had confronted similar issue sometime earlier because of which I ran into "out of memory error" while connecting via Application and I'd to restart my DB. Does anyone have any idea on what's going on here and if there is anything I could look upon specifically? Also, just querying even a single system table is taking noticeable seconds which I believe should not have happened. Any suggestions would be kindly appreciated. Should you require any further details, please revert back. Thanks, Asim