"Tom Lane" <[EMAIL PROTECTED]> writes: > Gregory Stark <[EMAIL PROTECTED]> writes: >>> 2007/7/4, Bruce Momjian <[EMAIL PROTECTED]>: >> The solution is to fix the bloat, not add a work-around. > >> The bloat is a direct consequence of performing DDL in the midst of an OLTP >> transaction. > > Hardly. It's a consequence of our current implementation of temp > tables; that does not necessarily imply that we cannot fix it without > an API change.
Sure, we could change our regular temporary tables to not create new records in pg_class at all, but I don't think it would make a big difference to DSS users. And I think for OLTP you would still want all the other advantages the standard api gives you. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster