pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database Scalability
2+ messages / 2 participants
[nested] [flat]

* Database Scalability
@ 2005-01-28 04:54 M.V. Jaga Mohan <jagan@syringacommunications.com>
  2005-01-28 17:05 ` Re: Database Scalability Christopher Browne <cbbrowne@acm.org>
  0 siblings, 1 reply; 2+ messages in thread

From: M.V. Jaga Mohan @ 2005-01-28 04:54 UTC (permalink / raw)
  To: pgsql-admin

HI All,

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. and what will be the data
retreival speed when multiple clients access the
database. Is there any software or mechanism to find
out this ?  

Any help in this regard is highly appreciated.

thanks 
Jagan

=====




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Database Scalability
  2005-01-28 04:54 Database Scalability M.V. Jaga Mohan <jagan@syringacommunications.com>
@ 2005-01-28 17:05 ` Christopher Browne <cbbrowne@acm.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Christopher Browne @ 2005-01-28 17:05 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-01-28 17:05 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-28 04:54 Database Scalability M.V. Jaga Mohan <jagan@syringacommunications.com>
2005-01-28 17:05 ` Christopher Browne <cbbrowne@acm.org>

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