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:
One table. If you need to split, you can allways do that via inheritance
constraint exclusion, thereby creating table partitioning.
Best wishes,
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
-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
People
In my experience work very well con tables with
172.000.000 of records ( 172 millions).
In fact is not too large number of records for
postgresql.
important aspect of this installation is your .conf
file, take care of this, check old email with config
subject.
Best regards
mdc
---