On Mon, Jun 10, 2013 at 2:38 PM, Andres Freund <and...@2ndquadrant.com>wrote:
> Hm. 13s for pg_depend locally vs 55s remotely. You need to have a > tremendous amount of dependencies. > Could you do a count(*) of pg_depend, pg_type and pg_class? > Yep, there's rather a lot: select count(*) from pg_depend; 7692365 select count(*) from pg_type; 1302222 select count(*) from pg_class; 1788727 It's a very-broad-scope heterogeneous data warehouse, hence the unusual table count. PostgreSQL has displayed tremendous grace under this fire, the only trouble we've encountered is small niggles like tab completion in psql and pg_dump performance (and the latter was helped a lot by the pg_dump perf improvements in 9.1.4 and 9.2, for larger dumps). All the same we will undoubtedly end up spreading all this to more instances/clusters eventually (the dependency structure allows for that). Gulli
