Re: Splitting queries across servers - Mailing list pgsql-general

From Max
Subject Re: Splitting queries across servers
Date
Msg-id CDEJIJMPHJJNHGFMBPBKMEADFHAA.maxdl@adelphia.net
Whole thread Raw
In response to Re: Splitting queries across servers  (PFC <lists@boutiquenumerique.com>)
Responses Re: Splitting queries across servers
List 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




pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: question about porting least and greatest from oracle
Next
From: "Max"
Date:
Subject: Re: Splitting queries across servers