Re: changing MyDatabaseId - Mailing list pgsql-hackers

From Greg Stark
Subject Re: changing MyDatabaseId
Date
Msg-id AANLkTikx_Vj9O4d2iubO_wXso=-3vo87SyQ_bJWNMNd1@mail.gmail.com
Whole thread Raw
In response to Re: changing MyDatabaseId  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running
Next
From: Tom Lane
Date:
Subject: Re: unlogged tables