From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: capacity of tables |
Date: | 2007-01-24 19:26:36 |
Message-ID: | 45B7B2EC.90702@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2007-01-24 19:38:02 | Re: Cannot Restart PostgreSQL-8.1.4 -- SOLVED! |
Previous Message | Jeremy Haile | 2007-01-24 19:19:05 | Re: Stats collector frozen? |