management of pg-schemas: pg_temp_n and pg_toast_n ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This is occurring In an 8.4.2 pg database, and I have noticed it in 8.3.10 as well.

We do a lot of work with temp tables here, and over time a lot of pg_temp_[n] schemas have appeared.

Similarly, we notice build-up of pg_toast_[n] schemas.

 

Is it ok to drop these if they contain no tables?

Or is there a way to prevent them from persisting past a given life-time??

 

Mr

 

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux