Many, many materialised views - Performance?

From: Toby Corkindale <toby(dot)corkindale(at)strategicdata(dot)com(dot)au>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Many, many materialised views - Performance?
Date: 2013-10-08 07:36:41
Message-ID: 5253B609.4020808@strategicdata.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I've discovered previously that Postgres doesn't perform so well in some
areas once you have hundreds of thousands of small tables.

I'm wondering if materialised views will fare better, or if they too
create a lot of fluff in pg_catalog and many files on-disk?

-Toby

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 高健 2013-10-08 08:54:17 Can checkpoint creation be parallel?
Previous Message Amit Langote 2013-10-08 06:17:12 Re: Why there are no max_wal_receivers