Re: Increasing the length of pg_stat_activity.current_query...

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Increasing the length of pg_stat_activity.current_query...
Date: 2004-11-09 01:02:13
Message-ID: 41901715.9060702@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> It's really a
> performance issue: do you want to pay the penalty associated with
> reassembling messages that exceed the loopback MTU [...]

BTW, the loopback MTU here is quite large:

oliver(at)flood:~$ /sbin/ifconfig lo | grep MTU
UP LOOPBACK RUNNING MTU:16436 Metric:1
oliver(at)flood:~$ uname -a
Linux flood 2.6.8.1-flood #1 Wed Sep 29 21:58:09 NZST 2004 i686 GNU/Linux

so at least on Linux 2.6 it seems like the risk of fragmentation is minimal.

-O

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-11-09 01:16:15 Re: server auto-restarts and ipcs
Previous Message Ed L. 2004-11-09 00:47:44 server auto-restarts and ipcs