Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id BAC529F9475 for ; Sun, 4 Nov 2007 13:57:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 16158-03 for ; Sun, 4 Nov 2007 13:57:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from fep01.ttnet.net.tr (mail.ttnet.net.tr [212.175.13.129]) by postgresql.org (Postfix) with ESMTP id C12139F9474 for ; Sun, 4 Nov 2007 13:57:21 -0400 (AST) Received: from (unknown) by AVGW-I-4.ttnet.net.tr with smtp id 4e59_63a3cf84_8aff_11dc_8abb_001422175f2f; Sun, 04 Nov 2007 19:57:21 +0200 Received: from alamut ([85.97.138.14]) by fep01.ttnet.net.tr with ESMTP id <20071104175717.JBSG27868.fep01.ttnet.net.tr@alamut> for ; Sun, 4 Nov 2007 19:57:17 +0200 Received: from (unknown [85.97.138.14]) by AVGW-I-5.ttnet.net.tr with smtp id 505c_5b78602c_8aff_11dc_a14a_001422143cb8; Sun, 04 Nov 2007 19:57:14 +0200 To: pgsql-sql@postgresql.org Subject: Partitioning and Foreign Keys From: Volkan YAZICI Date: Sun, 04 Nov 2007 19:57:19 +0200 Message-ID: <87ejf57v28.fsf@ttnet.net.tr> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-NAI-Spam-Rules: 2 Rules triggered BAYES_00=-2.5, HAS_X_HELO=0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/8 X-Sequence-Number: 29536 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.