Yet one more stupid question

From: Dmitri Touretsky <dmitri(at)listsoft(dot)ru>
To: pgsql-novice(at)postgresql(dot)org
Subject: Yet one more stupid question
Date: 2002-12-04 18:00:09
Message-ID: 197231721888.20021204210009@listsoft.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Good time of the day!

One more question related to performance. I have a VERY BIG table
(abot 20 million records) which is accessed relatively seldom, like
once a day (basically, it's archived data which sometimes may be
needed). How this table affect performance of the database? Is it
worse to create another database for storing this data, and keep the
main DB small?

Best regards,
Dmitri ( mailto:dmitri(at)listsoft(dot)ru )

New SOFT daily (RUS): http://www.listsoft.ru/
(ENG): http://www.listsoft.com/
Articles, tips : http://www.diskovod.ru/
---
Спирт - это концентрированная водка.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Indira 2002-12-04 18:13:18 problem creating database..
Previous Message Ron Johnson 2002-12-04 17:35:05 Re: wat is the max number of rows that can be returned