Splitting tables or databases? That's the problem

Greg Patnude · *nix forums beginner Joined: 01 Mar 2005 Posts: 44

Get a better computer to run it on.... in teh long-term -- that will be your
best investment....

<v.demartino2@virgilio.it> wrote in message
news:420008E50004F793@ims3e.cp.tin.it...

Guest

On a 128MB RAM, 450 MHz pentium 3 server with linux gentoo and postgresql
7.4.6 on an office lan we can manage satisfactorily a db containing few
tables with a cumbersome amount of data (each table is around 650 thousand
records with 98 columns) relating to the year 2002.
We use M$-Access and ODBC to access those data.
Now similar data and amounts of records for the year 2003 need to be added.
Then queries to contrast 2003 data vs. 2002 ones will be needed.

In view of the poor hardware at our disposal, is it better from the standpoint
of efficiency to:

1) Create a new database for 2003 with the same structure of that for 2002;
2) Appending new 2003 data to 2002 data in the same tables;
3) Creating in the original database new, separate tables to contain data
for 2003.

Thanks
Vittorio

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Google