From: Svenne Krap <svenne@krap.dk>
To: pgsql-performance@postgresql.org
Subject: Perfomance of views
Date: Wed, 26 Oct 2005 17:25:54 +0200
Message-ID: <435FA002.4060509@krap.dk> (raw)
Hi there.
I am currently building a system, where it would be nice to use multiple
levels of views upon each other (it is a staticstics system, where
traceability is important).
Is there any significant performance reduction in say 10 levels of views
instead of one giant, nested sql-statement ? I especially think exection
planner-wise.
The data mainly comes from one small to medium sized tabel (< 5 million
rows) and a handfull small (< 5000 rows) support tables.
The hardware will be okay for the job, but nothing really fancy (specs
are Xeon, 2G of memory, 6 SCSI-disks in a RAID1+0) . The base will be
version 8.1 provided that it gets out of beta around end-of-year.
Svenne
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: svenne@krap.dk
Subject: Re: Perfomance of views
In-Reply-To: <435FA002.4060509@krap.dk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox