Search Postgresql Archives

Re: capacity of tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux