Re: changing MyDatabaseId

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: changing MyDatabaseId
Дата
Msg-id AANLkTikx_Vj9O4d2iubO_wXso=-3vo87SyQ_bJWNMNd1@mail.gmail.com
обсуждение исходный текст
Ответ на Re: changing MyDatabaseId  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Wed, Nov 17, 2010 at 6:33 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> I think you're missing the point.  If we switch databases, all cached
> relations and plans have to be flushed anyway.  We're talking about
> what might NOT need to be flushed on switching databases.

Oh sorry, yes, I missed that point.

I will mention that your point about TCP connection establishment
latency is real. TCP connection establishment adds several
milliseconds of latency (for low latency connections -- obviously it's
much much worse for long-haul connections) and then the congestion
control slow start adds more if there's a significant amount of data
to transfer.

--
greg


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running
Следующее
От: Tom Lane
Дата:
Сообщение: Re: unlogged tables