From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: Database Scalability
Date: Fri, 28 Jan 2005 12:05:11 -0500
Message-ID: <m3r7k5pjqw.fsf@knuth.knuth.cbbrowne.com> (raw)
References: <20050128045400.62180.qmail@web207.biz.mail.re2.yahoo.com>
In an attempt to throw the authorities off his trail, jagan@syringacommunications.com ("M.V. Jaga Mohan") transmitted:
> I am using PgSQL 7.3 for my Application. My problem how can I scale
> my database ? I mean how many records I can have in my database.
That depends mainly on how much disk space you have. If you haven't
got much disk, you won't be able to store many records. If you have
8TB of free space, you should be able to store rather a lot, depending
on how large they might be.
> and what will be the data retreival speed when multiple clients
> access the database. Is there any software or mechanism to find out
> this ?
Retrieval speed will depend on various things, including:
- How fast your disk subsystem is;
- How much data you can cache in memory;
- How effectively you have tuned PostgreSQL's use of caches
- How useful the set of indices are on your tables
- How efficient the queries you have written for data retrieval
are at utilizing all of the above.
You would likely find that 7.4 releases would be quite a bit faster
and more efficient than the 7.3 series, due to various improvements to
the query planner, and possibly that the new version 8.0 is even
faster still. I find it curious that you want to use so old a version
of PostgreSQL.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com').
http://cbbrowne.com/info/linuxxian.html
"Did you ever walk in a room and forget why you walked in? I think
that's how dogs spend their lives." -- Sue Murphy
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: cbbrowne@acm.org
Subject: Re: Database Scalability
In-Reply-To: <m3r7k5pjqw.fsf@knuth.knuth.cbbrowne.com>
References: <20050128045400.62180.qmail@web207.biz.mail.re2.yahoo.com> <m3r7k5pjqw.fsf@knuth.knuth.cbbrowne.com>
* 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