Data mining setup/hardware?

From: Mike Harding <mvh(at)ix(dot)netcom(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Data mining setup/hardware?
Date: 2005-03-11 12:26:30
Message-ID: 1110543990.69075.0.camel@bsd.mvh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Any suggestions on how to set up a server -strictly- for data mining?
This means:

- I want queries to run as quickly as possible, and
- I don't care if I lose data if the power goes down.

A solid state disk would obviously speed things up, like the to-disk
sorts that Postgres does when it runs out of RAM, and help the seek
time, etc. This would also be somewhat expensive, of course.

I can buy a custom server and throw lots of RAM in it and so on.
Commodity PC hardware seems to limited to about 4G, or 8G or so for the
AMD64 hardware, so it seems unlikely I can run a pure memory disk.

I'm using FreeBSD , so any FreeBSD related hints are appreciated, but I
can run Linux or whatever if needed for this server.

Thanks,

--
Mike Harding <mvh(at)ix(dot)netcom(dot)com>

Browse pgsql-general by date

  From Date Subject
Next Message Steven Verhoeven 2005-03-11 12:36:17 sql question
Previous Message Steven Verhoeven 2005-03-11 12:26:07 sql question