X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3EB6E5282A for ; Tue, 31 May 2005 06:37:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82527-10 for ; Tue, 31 May 2005 09:37:53 +0000 (GMT) Received: from mail.sto.netlight.se (1-1-10-39a.sh.sth.bostream.se [82.182.50.216]) by svr1.postgresql.org (Postfix) with ESMTP id 811D75287E for ; Tue, 31 May 2005 06:37:51 -0300 (ADT) Received: from prraxp ([192.168.12.53]) by mail.sto.netlight.se (8.11.2/8.11.2) with ESMTP id j4VARD328550 for ; Tue, 31 May 2005 12:27:13 +0200 From: "Praveen Raja" To: Subject: very large table Date: Tue, 31 May 2005 11:37:48 +0200 Message-ID: <022801c565c4$6b1ac8c0$541510ac@sek.se> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0229_01C565D5.2EA398C0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.078 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200505/465 X-Sequence-Number: 12629 This is a multi-part message in MIME format. ------=_NextPart_000_0229_01C565D5.2EA398C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi I'm trying to move an existing solution from MySQL to PostgreSQL. As it is now the solution has 4 tables where data in inserted by an application. At regular intervals (10min) data from these tables is consolidated and moved to another table for reporting purposes. There exist many instances of these reporting tables and in total they are expected to hold about 500 million rows. There are about 200 of these reporting tables at the moment with data split among them. When a request comes in all these tables are searched. While moving to PostgreSQL is it a good idea to move from using multiple tables to one table for so many rows? ------=_NextPart_000_0229_01C565D5.2EA398C0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi

 

I’m trying to move an existing solution = from MySQL to PostgreSQL. As it is now the solution has 4 tables where data in = inserted by an application. At regular intervals (10min) data from these tables is consolidated and moved to another table for reporting purposes. There = exist many instances of these reporting tables and in total they are expected = to hold about 500 million rows. There are about 200 of these reporting tables at = the moment with data split among them. When a request comes in all these = tables are searched. While moving to PostgreSQL is it a good idea to move from = using multiple tables to one table for so many rows?

------=_NextPart_000_0229_01C565D5.2EA398C0--