On Dienstag, 1. April 2008 Thomas Bräutigam wrote:
> Okay thanks for that advice. Sorry its my first day on a mailing
> list.
No problem.
> But do Postgres have a special recommendation which SUN equipment
> runs perfect with a Postgres Database?
I have nothing to do with postgres (well, I have to admin some servers
running it). Maybe other can give hints. Or where you can get paid
support/information.
> A time for a query over 30 seconds I would say is to long. So the
> machine should be fast enough to handle it in 10-20 Seconds. Price
> for the Machine doesn’t matter at all. The machine should just fit
> and can handle this kinda huge database.
Still, we have no idea what kind of data is in there, what the queries
would look like etc.
I'd say any Sun equipment will be running fine, as it's fine hardware.
For the sizing of that machine, I can only suggest running your
application on a test server. I'm far from being a specialist for
postgresql, but maybe other can help here too.
mfg zmi
--
// Michael Monnerie, Ing.BSc ----- http://it-management.at
// Tel: 0676/846 914 666 .network.your.ideas.
// PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net Key-ID: 1C1209B4