Just an observation, but when we cluster (or any other time we rebuild a heap)
we are creating a useless record type and array type for the temporary heap we
use which is subsequently dropped. 

postgres=# cluster;
DEBUG:  drop auto-cascades to type pg_temp_16474
DEBUG:  drop auto-cascades to type pg_temp_16474[]
DEBUG:  drop auto-cascades to type pg_temp_16471
DEBUG:  drop auto-cascades to type pg_temp_16471[]

I can't think of any serious negative effects this could have so perhaps it's
not worth worrying about. The worst I can think of is the catalog bloat but
we're already bloating pg_class and pg_attribute anyways so this doesn't seem
like a big deal.

But I thought I would mention it in case anyone else is offended or knows of a
more serious problem it could cause.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to