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 19C29D1CCAB for ; Tue, 30 Mar 2004 21:20:43 +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 97806-05 for ; Tue, 30 Mar 2004 17:20:38 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 911E1D1CAFE for ; Tue, 30 Mar 2004 17:20: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 i2ULKZYn059807 for ; Tue, 30 Mar 2004 21:20:35 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i2UL99dS057611 for pgsql-admin@postgresql.org; Tue, 30 Mar 2004 21:09:09 GMT From: "HumanJHawkins" 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 References: Subject: Re: what is the impact of Database size on Performemce Lines: 29 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: Date: Tue, 30 Mar 2004 21:09:10 GMT X-Complaints-To: abuse@earthlink.net Organization: EarthLink Inc. -- http://www.EarthLink.net To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/57 X-Sequence-Number: 13030 "Avner" wrote in message news:tSjac.16658$xb.714@newssvr27.news.prodigy.com... > I need some information to understand what is the impact of Database size on > the performemce. > > 1. Is there any impact? In queries that make use of the data, yes. > 2. Does one very large table impact the performence of the the whole DB, > meaning the overall performence and access the other tables. Essentially no. > 3. What are the ways to reduce the impact of the DB size on the DB > performence DB size is so low on the radar of performance issues, that I think it is basically worth ignoring. If your database is so big that it fills the drive it is on, that could slow the whole system down as the page file has to get chunked up. But for all reasonable scenereos, you are much better off focusing on reducing the number of calls that are required to get work done, and improving the efficiency of your functions and procedures. Cheers!