From: Volkan YAZICI <yazicivo@ttnet.net.tr>
To: pgsql-sql@postgresql.org
Subject: Partitioning and Foreign Keys
Date: Sun, 04 Nov 2007 19:57:19 +0200
Message-ID: <87ejf57v28.fsf@ttnet.net.tr> (raw)
Hi,
We have a customers database growing ~1,000 rows per day. (Nearly, %40
of the table is garbage and won't get queried that often in the
future. But we keep them for statistical analysing purposes of
previous jobs.) Despite table allocates relatively small size on the
disk, requirement of instantaneous query execution times forms our
major bottleneck. I planned to partition this table, but I learnt that
PostgreSQL doesn't allow referencing views. Does anybody have any
suggestions?
Regards.
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-sql@postgresql.org
Cc: yazicivo@ttnet.net.tr
Subject: Re: Partitioning and Foreign Keys
In-Reply-To: <87ejf57v28.fsf@ttnet.net.tr>
* 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