Re: Splitting queries across servers

From: "Max" <maxdl(at)adelphia(dot)net>
To: "PgSql General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Splitting queries across servers
Date: 2005-01-29 20:37:01
Message-ID: CDEJIJMPHJJNHGFMBPBKMEADFHAA.maxdl@adelphia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> I won't say anything on linux vs windows performance
> (although I sure do
> have an opinion), but simply keep in mind that postgres on window
> is young
> and postgres on linux is vary mature ; therefore one is likely to have a
> lot more performance refinements than the other.

This is a good point.

>
> In your case recompiling everything is also a bonus because
> you'll be
> sure that everything is 64-bit optimized down to the last driver.
> I wonder how long your killer machine will take to compile
> the whole OS.
> And Postgres too... could you post that ?

You probably want to ask Mike Rylander (who posted before) because he's
already done it.

> If you are concerned about security, you can compile
> everything with the
> stack protector (Propolice SSP) enabled. It's extremely
> advisable. All the
> other options like grsec et al are nice but require careful thinking,
> propolice just needs to be activated. If you don't know what it is I'll
> post docs.
>

I have never heard of Propolice SSP. What is it ? Any relation to the honey
'Propolys'. just kidding.

Max

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2005-01-29 20:43:09 Re: question about porting least and greatest from oracle
Previous Message Lonni J Friedman 2005-01-29 20:23:11 Re: dumping the schema ?