On Wed, Nov 17, 2010 at 6:33 PM, Robert Haas <robertmh...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers