Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cVhgG-0006Oy-Qg for pgsql-admin@arkaria.postgresql.org; Mon, 23 Jan 2017 16:41:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cVhgG-0008CB-B3 for pgsql-admin@arkaria.postgresql.org; Mon, 23 Jan 2017 16:41:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cVhLS-0001Dq-HC for pgsql-admin@postgresql.org; Mon, 23 Jan 2017 16:19:50 +0000 Received: from mail01.usask.ca ([128.233.195.233] helo=mail.usask.ca) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cVhLK-0002vW-8H for pgsql-admin@postgresql.org; Mon, 23 Jan 2017 16:19:49 +0000 Received: from Mail02.usask.ca (192.168.228.183) by Mail01.usask.ca (192.168.228.182) with Microsoft SMTP Server (TLS) id 15.0.1178.4; Mon, 23 Jan 2017 10:19:38 -0600 Received: from Mail02.usask.ca ([fe80::e496:8290:d631:ef58]) by Mail02.usask.ca ([fe80::e496:8290:d631:ef58%14]) with mapi id 15.00.1178.000; Mon, 23 Jan 2017 10:19:38 -0600 From: "Tharmarajah, Sam" To: "pgsql-admin@postgresql.org" Subject: Req. for some help with temp tables Thread-Topic: Req. for some help with temp tables Thread-Index: AdJ1k5E0U8JAHGS7Tdae0cqRhiQcNg== Date: Mon, 23 Jan 2017 16:19:38 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.80.30.37] Content-Type: multipart/alternative; boundary="_000_c138f0693f524e7db788d836036172f8Mail02usaskca_" MIME-Version: 1.0 X-Pg-Spam-Score: -7.4 (-------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_c138f0693f524e7db788d836036172f8Mail02usaskca_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi We have a vendor delivered application running on postgres 9.1. It is creat= ing temp tables per session. Currently the application group is reporting t= he that they are seeing a very slow response on the application in producti= on 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 gl= assfish. 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 --_000_c138f0693f524e7db788d836036172f8Mail02usaskca_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi

 

We have a vendor delivered application running on po= stgres 9.1. It is creating temp tables per session. Currently the applicati= on 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.     &= nbsp; How can we mitigate this performance degradation fr= om the database side. The most interesting part is the application vendor d= oesn’t seem to response in a timely manner. Also this application is = connecting through glassfish.

2.     &= nbsp; What can we tune in the database to get this perfor= mance improve?

3.     &= nbsp; Every time the auto vacuum runs it pegs 1 CPU to 10= 0%.

 

Please bear with these novice questions as I am very= new to postgres…

 

Thanx,

Sam

--_000_c138f0693f524e7db788d836036172f8Mail02usaskca_--