Many, many materialised views - Performance? - Mailing list pgsql-general

From Toby Corkindale
Subject Many, many materialised views - Performance?
Date
Msg-id 5253B609.4020808@strategicdata.com.au
Whole thread Raw
Responses Re: Many, many materialised views - Performance?  (Alban Hertroys <haramrae@gmail.com>)
Re: Many, many materialised views - Performance?  (John R Pierce <pierce@hogranch.com>)
List 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


pgsql-general by date:

Previous
From: Amit Langote
Date:
Subject: Re: Why there are no max_wal_receivers
Next
From: 高健
Date:
Subject: Can checkpoint creation be parallel?