On Tue, 8 Oct 2013 19:08:45 -0700 (PDT) Kevin Grittner <kgrittn@xxxxxxxxx> wrote: > > In this instance, we have a lot of queries that build certain aggregate > > results, which are very slow. The queries were initially all implemented > > as views, but then we started doing a type of materialising of our own, > > turning them into tables with CREATE TABLE AS SELECT .... > > This does make the results very fast to access now, but the side effect > > is a vast number of (very small) tables. I missed the start of this thread, so apologies if my suggestion is off-base. When there are lots of tables, I've seen performance improvements from distributing the tables through schemas. It seems to improve name resolution performance. -- Bill Moran <wmoran@xxxxxxxxxxxxxxxxx> -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
