Hi all,
Hopefully a quick query.
Is there anything special I should look at when configuring either
PostgreSQL and Linux to work together on an 8-way Intel P-III based system?
I currently have the database system running fairly nicely on a 2 CPU
Pentium-II 400 server with 512MB memory, hardwar
Hi all,
I'm working on a project that has a data set of approximately 6million rows
with about 12,000 different elements, each element has 7 columns of data.
I'm wondering what would be faster from a scanning perspective (SELECT
statements with some calculations) for this type of set up;
July 2003 11:06 AM
To: Castle, Lindsay
Cc: [EMAIL PROTECTED]
Subject: Re: [PERFORM] One table or many tables for data set
Castle, Lindsay wrote:
> The data structure looks like this:
> element
> date
> num1
> num2
> num3
> num4
>
Thanks Rod
My explanations will be better next time. :-)
-Original Message-
From: Rod Taylor [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 23 July 2003 11:41 AM
To: Castle, Lindsay
Cc: Postgresql Performance
Subject: Re: One table or many tables for data set
On Tue, 2003-07-22 at 21:50
there is no relationship between the different elements that
I need to cater for.
Cheers,
Linz
Castle, Lindsay wrote and :
> I'm working on a project that has a data set of approximately 6million
rows
> with about 12,000 different elements, each element has 7 columns of data.
>
>