Thanks a lot for all your responses
I am impress, really impress. I never though I could get this amount of
responses in this shorter time. Wonderful support :)
Thanks a lot :) :)
I don't have details, I'll get them really soon. But all your input is
really valuable. I have much more information.
On Thu, Apr 29, 2010 at 1:41 PM, Scott Marlowe wrote:
> On Wed, Apr 28, 2010 at 7:08 PM, Jaime Rodriguez
> wrote:
>> hi,
>> Today is my first day looking at PostgreSQL
>> I am looking to migrate a MS SQL DB to PostgreSQL :) :)
>> My customer requires that DBMS shall support 4000 simultaneous requ
On Wed, Apr 28, 2010 at 7:08 PM, Jaime Rodriguez
wrote:
> hi,
> Today is my first day looking at PostgreSQL
> I am looking to migrate a MS SQL DB to PostgreSQL :) :)
> My customer requires that DBMS shall support 4000 simultaneous requests
> Also the system to be deploy maybe a cluster, with 12 mi
This whole sockets conversation has wandered way off topic. PostgreSQL
runs into high-connection scaling issues due to memory limitations (on
Windows in particular, as noted in the FAQ entry I suggested), shared
resource contention, and general per-connection overhead long before
socket issues
I dont think its that easy. 50,000 sockets open, sure, but whats the
performance? The programming model has everything to do with that,
and windows select() wont support that many sockets with any sort of
performance. For windows you have to convert to using non-blocking
sockets w/messages
On 4/29/2010 11:49 AM, Ozz Nixon wrote:
On 4/29/10 12:42 PM, Greg Smith wrote:
Alban Hertroys wrote:
The reason I'm asking is that Postgres doesn't perform at its best on
Windows and I seriously wonder whether the OS would be able to handle
a load like that at all (can Windows handle 4000 open
On 4/29/10 12:42 PM, Greg Smith wrote:
Alban Hertroys wrote:
The reason I'm asking is that Postgres doesn't perform at its best on
Windows and I seriously wonder whether the OS would be able to handle
a load like that at all (can Windows handle 4000 open sockets for
example?).
You have to g
Alban Hertroys wrote:
The reason I'm asking is that Postgres doesn't perform at its best on Windows and I seriously wonder whether the OS would be able to handle a load like that at all (can Windows handle 4000 open sockets for example?).
You have to go out of your way to even get >125 connecti
On 29 Apr 2010, at 3:08, Jaime Rodriguez wrote:
> hi,
> Today is my first day looking at PostgreSQL
> I am looking to migrate a MS SQL DB to PostgreSQL :) :)
> My customer requires that DBMS shall support 4000 simultaneous requests
> Also the system to be deploy maybe a cluster, with 12 microproce
On 29/04/2010 10:04 AM, Greg Smith wrote:
Jaime Rodriguez wrote:
My customer requires that DBMS shall support 4000 simultaneous requests
Also the system to be deploy maybe a cluster, with 12 microprocessors
[snip]
If most connections are read-only, there are a few ways to design a
cluster of sy
Jaime Rodriguez wrote:
My customer requires that DBMS shall support 4000 simultaneous requests
Also the system to be deploy maybe a cluster, with 12 microprocessors
In order to support 4000 true simultaneous requests, you'd need 4000
processor cores available. What you probably mean here is t
On Wed, Apr 28, 2010 at 8:08 PM, Jaime Rodriguez
wrote:
> hi,
> Today is my first day looking at PostgreSQL
> I am looking to migrate a MS SQL DB to PostgreSQL :) :)
> My customer requires that DBMS shall support 4000 simultaneous requests
and that requests come from the fantasy of some one or ar
Jaime Rodriguez wrote:
hi,
Today is my first day looking at PostgreSQL
I am looking to migrate a MS SQL DB to PostgreSQL :) :)
My customer requires that DBMS shall support 4000 simultaneous requests
thats a lot of connections and processes.
4000 concurrent queries will be generating a massiv
hi,
Today is my first day looking at PostgreSQL
I am looking to migrate a MS SQL DB to PostgreSQL :) :)
My customer requires that DBMS shall support 4000 simultaneous requests
Also the system to be deploy maybe a cluster, with 12 microprocessors
>From what I have read, PostgreSQL has really good p
14 matches
Mail list logo
