Re: [PROPOSAL] Add SCTP network protocol to postgresql backend and frontend

Поиск
Список
Период
Сортировка
От Andreas Karlsson
Тема Re: [PROPOSAL] Add SCTP network protocol to postgresql backend and frontend
Дата
Msg-id 56F29423.1050900@proxel.se
обсуждение исходный текст
Ответ на [PROPOSAL] Add SCTP network protocol to postgresql backend and frontend  (Eduardo Morras <emorrasg@yahoo.es>)
Ответы Re: [PROPOSAL] Add SCTP network protocol to postgresql backend and frontend  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: [PROPOSAL] Add SCTP network protocol to postgresql backend and frontend  (Eduardo Morras <emorrasg@yahoo.es>)
Список pgsql-hackers
On 03/23/2016 01:55 PM, Eduardo Morras wrote:
> Benefits:
>
> Dynamic multihoming, modifiable at run time, don't need aggregate links at OS level or shutdown servers/clients for a
hardwareor topology network change.
 
> Message oriented connection.
> Message reliability.
> Inmune to SYN floods that affect tcp.
> Assimetric multihoming, a client with 4 links(3x 1GbEth + wifi) can connect to a server with 1 link (10GbEth).
> Metadata connection messages.

While SCTP has some nice advantages in general (I think it is a pity it 
is not used more) I wonder how well these benefits translate into the 
database space. Many databases are run either in a controlled server 
environment with no direct access from the Internet, or locally on the 
same machine as the application. In those environments you generally do 
not have to worry about SYN floods or asymmetric links.

Do you have any specific use case in mind?

Andreas



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

Предыдущее
От: Eduardo Morras
Дата:
Сообщение: [PROPOSAL] Add SCTP network protocol to postgresql backend and frontend
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Optimization for updating foreign tables in Postgres FDW