Re: capacity of tables

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/24/07 13:06, guillermo arias wrote:
> Hello, i am Guillermo Arias, from Peru. I have a doubt about
> capacity of tables. I am developing a software for accountants,
> and my principal problem is about the table for the vouchers. I
> have to decide to make a table for each year or only one table
> for all the years.
>
> This table has 11 fields: varchar(10) and 2 fields: numeric
> (12,2) and is intended to have 900,000 records per year x 13
> years = 11'700,000 records

PostgreSQL will easily handle 12 million rows.

> What can you suggest me? i do not want the system to be slow
> using this table.

Performance (*not* including hardware) is based on:
1. Well-written queries.
2. How the indexes match the queries. EXPLAIN ANALYZE is your
friend!!
3. The knowledge that it is expensive to insert into/update/delete
from an index, so create the indexes you need, but don't go
crazy.
4. Continual monitoring: production usage patterns will probably
be different from what you expected. Do not be surprised if you
have to add or modify indexes "later on".
5. Using an up-to-date version of PostgreSQL.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFt7LsS9HxQb37XmcRAo8QAJwLjj26KiJl7gNvt6joKTuo6oGrIwCfWHcz
y9EqHqWygdYKPss3J47TgUc=
=jaMf
-----END PGP SIGNATURE-----