Re: Many, many materialised views - Performance?

On Tue, 8 Oct 2013 19:08:45 -0700 (PDT) Kevin Grittner <kgrittn@ymail.com> 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@potentialtech.com>