From: Tharmarajah, Sam <sambavan.tharmarajah@usask.ca>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Req. for some help with temp tables
Date: Mon, 23 Jan 2017 16:19:38 +0000
Message-ID: <c138f0693f524e7db788d836036172f8@Mail02.usask.ca> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi
We have a vendor delivered application running on postgres 9.1. It is creating temp tables per session. Currently the application group is reporting the that they are seeing a very slow response on the application in production and in the logs we see tons and tons of autovaccum of oraphan temp table cleanups. So we have the following questions.
1. How can we mitigate this performance degradation from the database side. The most interesting part is the application vendor doesn't seem to response in a timely manner. Also this application is connecting through glassfish.
2. What can we tune in the database to get this performance improve?
3. Every time the auto vacuum runs it pegs 1 CPU to 100%.
Please bear with these novice questions as I am very new to postgres...
Thanx,
Sam
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sambavan.tharmarajah@usask.ca
Subject: Re: Req. for some help with temp tables
In-Reply-To: <c138f0693f524e7db788d836036172f8@Mail02.usask.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox