Re: [PERFORM] Size of Temporary tablespace is increasing very much in postgresql 9.1.

2016-12-19 Thread Dinesh Chandra 12108
, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. -Original Message- From: Mark Kirkwood [mailto:mark.kirkw...@catalyst.net.nz] Sent: 17 December, 2016 7:28 AM To: Dinesh Chandra 12108 ; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Size of Temporary tablespace is

Re: [PERFORM] Size of Temporary tablespace is increasing very much in postgresql 9.1.

2016-12-16 Thread Mark Kirkwood
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 ?

[PERFORM] Size of Temporary tablespace is increasing very much in postgresql 9.1.

2016-12-15 Thread Dinesh Chandra 12108
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 ? Regards, Dinesh Chandra |Database administrator (Ora