pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
what is the impact of  Database size on Performemce
4+ messages / 4 participants
[nested] [flat]

* what is the impact of  Database size on Performemce
@ 2004-03-30 19:27 Avner <avnera@cvdo.com>
  2004-03-30 21:09 ` Re: what is the impact of  Database size on Performemce HumanJHawkins <JHawkins@HumanitiesSoftware.Com>
  2004-03-30 21:48 ` Re: what is the impact of  Database size on Performemce Erland Sommarskog <sommar@algonet.se>
  2004-03-30 23:56 ` Re: what is the impact of  Database size on Performemce louis nguyen <louisducnguyen@hotmail.com>
  0 siblings, 3 replies; 4+ messages in thread

From: Avner @ 2004-03-30 19:27 UTC (permalink / raw)
  To: pgsql-admin



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






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

* Re: what is the impact of  Database size on Performemce
  2004-03-30 19:27 what is the impact of  Database size on Performemce Avner <avnera@cvdo.com>
@ 2004-03-30 21:09 ` HumanJHawkins <JHawkins@HumanitiesSoftware.Com>
  2 siblings, 0 replies; 4+ messages in thread

From: HumanJHawkins @ 2004-03-30 21:09 UTC (permalink / raw)
  To: pgsql-admin

"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!





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

* Re: what is the impact of  Database size on Performemce
  2004-03-30 19:27 what is the impact of  Database size on Performemce Avner <avnera@cvdo.com>
@ 2004-03-30 21:48 ` Erland Sommarskog <sommar@algonet.se>
  2 siblings, 0 replies; 4+ messages in thread

From: Erland Sommarskog @ 2004-03-30 21:48 UTC (permalink / raw)
  To: pgsql-admin

Avner (avnera@cvdo.com) writes:
> I need some information to understand what is the impact of Database
> size on the performemce. 
> 
> Few questions :
> 
> 1. Is there any impact?

Maybe. Maybe not. Depends whether you query the large table, and not the
least how you query them, and what indexes you have. As a matter of fact,
for the same amount of information, a database A twice as big as database
B, could give better performance for retrieving a certain subset of
that information, because in A data has been stored redudantly, maybe
preaggregated.

For instance, say that you have a transactions table for bank accounts,
and you need to be able to retrieve the balance on a certain date. Saving
the standings for each day is going to take up a lot of space, but
it will be much faster to retrieve the historic balance, than adding
up all transactions.

> 2. Does one very large table impact the performence of the the whole DB,
> meaning the overall performence and access the other tables.

If the table just sits there, no. However, it will have an impact on
backup operations.

> 3. What are the ways to reduce the impact of the DB size  on the DB
> performence

Good indexing is of course essential.

-- 
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp



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

* Re: what is the impact of  Database size on Performemce
  2004-03-30 19:27 what is the impact of  Database size on Performemce Avner <avnera@cvdo.com>
@ 2004-03-30 23:56 ` louis nguyen <louisducnguyen@hotmail.com>
  2 siblings, 0 replies; 4+ messages in thread

From: louisducnguyen@hotmail.com @ 2004-03-30 23:56 UTC (permalink / raw)
  To: pgsql-admin

> 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've run into 2 problems w/ very large DB.  
A) Backups.  I have a 50G DB.  I backup to file then delete
yesterday's backup file (I have another process which transfers the
backup file to tape).  So I have a 50G backup file and I need another
50G freespace, to run my backup process.

B) Reindexing.  On any given day maybe 5% (max) of new data is added
to my DB.  But DBCC reindex has to work on all the indexes.  So DBCC
reindex takes 3 hours a night.  Yuck.

Maybe there is a better way.  But I try to keep each database as small
as possible.



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


end of thread, other threads:[~2004-03-30 23:56 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-30 19:27 what is the impact of  Database size on Performemce Avner <avnera@cvdo.com>
2004-03-30 21:09 ` HumanJHawkins <JHawkins@HumanitiesSoftware.Com>
2004-03-30 21:48 ` Erland Sommarskog <sommar@algonet.se>
2004-03-30 23:56 ` louis nguyen <louisducnguyen@hotmail.com>

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