From: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Size of Temporary tablespace is increasing very much in
 postgresql 9.1.
Thread-Topic: [PERFORM] Size of Temporary tablespace is increasing very much
 in postgresql 9.1.
Thread-Index: AdJWvf6QC04I2VK3R6GkiGvITK5pBwBHORuAAH94sAA=
Date: Mon, 19 Dec 2016 09:19:18 +0000
Message-ID: <62944b5c5ba94d10a76639956c1c548f@cyient.com>
References: <8e77559fe4f74e469c9079b098c42aca@cyient.com>
 <677ae7cf-d349-fe9d-a810-ba75f9885c44@catalyst.net.nz>
In-Reply-To: <677ae7cf-d349-fe9d-a810-ba75f9885c44@catalyst.net.nz>
Accept-Language: en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Dear Mark,

Thanks for your valuable comment.
Now problem is resolved.

Regards,
Dinesh Chandra
|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.
------------------------------------------------------------------
Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com
Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.

-----Original Message-----
From: Mark Kirkwood [mailto:mark.kirkwood@catalyst.net.nz]
Sent: 17 December, 2016 7:28 AM
To: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>; pgsql-performance@pos=
tgresql.org
Subject: Re: [PERFORM] Size of Temporary tablespace is increasing very much=
 in postgresql 9.1.

On 15/12/16 23:28, Dinesh Chandra 12108 wrote:

> Dear expert,
>
> In postgreSQL-9.1,the size of *pgsql_tmp* inside tablespace (Temp
> tablespace) is increased by 544G in one day.
>
> However, the DBsize is as usual but tablespace size is getting increased.
>
> Could you please suggest why it is happening ?
>
>

That is due to queries doing sorts or (hash) joins. You can log which queri=
es are doing this with the log_temp_files parameter.

Now it might be that this is just normal/expected (e.g complex data warehou=
se style workload), but it could also be many small queries that might bene=
fit from some additional indexes (logging the queries will help you decide =
what if anything needs to be done).

regards

Mark

________________________________

DISCLAIMER:

This email message is for the sole use of the intended recipient(s) and may=
 contain confidential and privileged information. Any unauthorized review, =
use, disclosure or distribution is prohibited. If you are not the intended =
recipient, please contact the sender by reply email and destroy all copies =
of the original message. Check all attachments for viruses before opening t=
hem. All views or opinions presented in this e-mail are those of the author=
 and may not reflect the opinion of Cyient or those of our affiliates.


--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance