Postgres Pro
Downloads
Home   >   mailing lists

Thread: Splitting tables or databases? That's the problem

Splitting tables or databases? That's the problem

From
v.demartino2@virgilio.it
Date:
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

Re: Splitting tables or databases? That's the problem

From
"Greg Patnude"
Date:
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...
> 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
>