Re: Stability in Windows?

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема Re: Stability in Windows?
Дата
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A208D186FF@EXCHANGE.corp.perceptron.com
обсуждение исходный текст
Ответ на Re: Stability in Windows?  (Serge Fonville <serge.fonville@gmail.com>)
Ответы Re: Stability in Windows?  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general

“125_connections” – this is a problem related to “older” PG versions (and in my own experience, the number is closer to 230, not 125), and I believe it was fixed in newer versions.

Besides, it’s much more efficient to use connection pulling (PgBouncer, PgPool), when dealing with that many connections.

 

For last 5 years we are running PG on many, many (hundreds) servers under WIN, and we have no complains regarding PG stability.

 

Regards,

Igor Neyman

 

From: Serge Fonville [mailto:serge.fonville@gmail.com]
Sent: Friday, February 24, 2012 11:07 AM
To: mgould@isstrucksoftware.net
Cc: Durumdara; pgsql-general@postgresql.org
Subject: Re: Stability in Windows?

 

Doesn't  http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows#I_cannot_run_with_more_than_about_125_connections_at_once.2C_despite_having_capable_hardware  apply?

 

Kind regards/met vriendelijke groet,

 

Serge Fonville

 

http://www.sergefonville.nl

Convince Google!!
They need to add GAL support on Android (star to agree)
http://code.google.com/p/android/issues/detail?id=4602

2012/2/24 Serge Fonville <serge.fonville@gmail.com>


Kind regards/met vriendelijke groet,

 

Serge Fonville

 

http://www.sergefonville.nl

Convince Google!!
They need to add GAL support on Android (star to agree)
http://code.google.com/p/android/issues/detail?id=4602

2012/2/24 <mgould@isstrucksoftware.net>

 

We are using it on a rather beefy server with no problems with a Win32
client/server app.  There are additonal things you can do to tune the
database.  I've not seen any stability problems.  Remember it's been
several years since version 8 came out and the current version is 9.1.2.

Michael Gould
Intermodal Software Solutions, LLC
904-226-0978



-------- Original Message --------
Subject: [GENERAL] Stability in Windows?
From: Durumdara <durumdara@gmail.com>
Date: Fri, February 24, 2012 8:39 am
To: pgsql-general@postgresql.org

Hi!



We planned to port some very old DBASE db into PGSQL.


But somebody said in a developer list that he tried with PGSQL (8.x) and
it was very unstable in Windows (and it have problem when many users use
it).


Another people also said that they used PGSQL only in Linux - and there
is no problem with it, only some patches needed for speeding up
writes...


What is your experience in this theme?


Do you also have same experience in Windows?


The user number is from 20 to up 100 (concurrently).


Thanks for your every idea, help, link, information about this.


Regards:
  dd

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

 

 

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Maxium Share Memory in Debian 64bit
Следующее
От: psql@elbrief.de
Дата:
Сообщение: explain and index scan