From: HumanJHawkins <JHawkins@HumanitiesSoftware.Com>
To: pgsql-admin@postgresql.org
Subject: Re: what is the impact of Database size on Performemce
Date: Tue, 30 Mar 2004 21:09:10 GMT
Message-ID: <Wllac.7914$Dv2.545@newsread2.news.pas.earthlink.net> (raw)
References: <tSjac.16658$xb.714@newssvr27.news.prodigy.com>
"Avner" <avnera@cvdo.com> 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.
>
<CUT>
> 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!
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: JHawkins@HumanitiesSoftware.Com
Subject: Re: what is the impact of Database size on Performemce
In-Reply-To: <Wllac.7914$Dv2.545@newsread2.news.pas.earthlink.net>
References: <tSjac.16658$xb.714@newssvr27.news.prodigy.com> <Wllac.7914$Dv2.545@newsread2.news.pas.earthlink.net>
* 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