X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 23D97D1E91C for ; Tue, 30 Mar 2004 19:50:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57868-04 for ; Tue, 30 Mar 2004 15:50:37 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 8C46DD1E916 for ; Tue, 30 Mar 2004 15:50:36 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i2UJoZYp041806 for ; Tue, 30 Mar 2004 19:50:36 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i2UJS1Eg037324 for pgsql-admin@postgresql.org; Tue, 30 Mar 2004 19:28:01 GMT From: "Avner" X-Newsgroups: comp.databases.ms-sqlserver, comp.databases.postgresql.admin, cz.comp.microsoft.sql, microsoft.public.il.hebrew.sqlserver, microsoft.public.sqlserver, microsoft.public.sqlserver.misc Subject: what is the impact of Database size on Performemce Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: X-Complaints-To: abuse@prodigy.net Organization: SBC http://yahoo.sbc.com X-UserInfo1: S[OQBU_DPRROVV\X\JK^OFXBWR\HPCTL@XT^OBPLAH[\RWYAKVUOPCW[ML\JXUCKVFDYZKBMSFX^OMSAFNTINTDDMVW[X\THOPXZRVOCJTUTPC\_JSBVX\KAOTBAJBVMZTYAKMNLDI_MFDSSOLXINH__FS^\WQGHGI^C@E[A_CF\AQLDQ\BTMPLDFNVUQ_VM Date: Tue, 30 Mar 2004 19:27:21 GMT To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=BAYES_10, PRIORITY_NO_NAME X-Spam-Level: X-Archive-Number: 200404/63 X-Sequence-Number: 13036 I need some information to understand what is the impact of Database size on the performemce. Few questions : 1. Is there any impact? 2. Does one very large table impact the performence of the the whole DB, meaning the overall performence and access the other tables. 3. What are the ways to reduce the impact of the DB size on the DB performence I will apreciate help in regards . Thanks Avner