capacity of tables - Mailing list pgsql-general

From guillermo arias
Subject capacity of tables
Date
Msg-id 20070124110625.477E0708@resin01.mta.everyone.net
Whole thread Raw
Responses Re: capacity of tables
Re: capacity of tables
List pgsql-general
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
yearor only one table for all the years. This table has 11 fields: varchar(10) and 2 fields: numeric (12,2) and is
intendedto have 900,000 records per year x 13 years = 11'700,000 recordsWhat can you suggest me? i do not want the
systemto be slow using this table.thanksguillermoariast@hotmail.com Get your FREE, LinuxWaves.com Email Now!
-->http://www.LinuxWaves.comJoin Linux Discussions! --> http://Community.LinuxWaves.com 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats collector frozen?
Next
From: "Harald Armin Massa"
Date:
Subject: Re: capacity of tables