[GENERAL] capacity of tables

2007-01-24 Thread guillermo arias
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:

Re: [GENERAL] capacity of tables

2007-01-24 Thread Harald Armin Massa
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 -

Re: [GENERAL] capacity of tables

2007-01-24 Thread Ron Johnson
-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

Re: [GENERAL] capacity of tables

2007-01-24 Thread marcelo Cortez
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 ---