Re: [GENERAL] Issue with pg_toast tables

2012-11-26 Thread Pavel Stehule
2012/11/26 Ranjeet Dhumal : > Hi Pavel , > > For Tunning this which parameter i have to change from the configuration , > and at the time of setting it up which thinks i have to care i mean what > will be the impact of that ? you have to use full vacuum Regards Pavel > > > On 26 November 201

Re: [GENERAL] Issue with pg_toast tables

2012-11-26 Thread Ranjeet Dhumal
Hi Pavel , For Tunning this which parameter i have to change from the configuration , and at the time of setting it up which thinks i have to care i mean what will be the impact of that ? On 26 November 2012 12:09, Pavel Stehule wrote: > Hello > > 2012/11/26 Ranjeet Dhumal : > > Hi All , > >

Re: [GENERAL] Issue with pg_toast tables

2012-11-26 Thread John R Pierce
On 11/25/12 10:36 PM, Ranjeet Dhumal wrote: Am facing one problem related to pg_toast table , its grown very huge upto 31GB , even am vacuuming(not full) it daily , my fsm parameters are default, can anyone tell how to decrease the size , if am firing any query on gen_bulk_20121126 its respon

Re: [GENERAL] Issue with pg_toast tables

2012-11-25 Thread Pavel Stehule
Hello 2012/11/26 Ranjeet Dhumal : > Hi All , > > Am facing one problem related to pg_toast table , its grown very huge upto > 31GB , even am vacuuming(not full) it daily , my fsm parameters are default, > can anyone tell how to decrease the size , if am firing any query on > gen_bulk_20121126 its