Re: psql problem

On 07/27/2010 10:20 PM, Tom Lane wrote:
> Gary Fu<gary.fu@sigmaspace.com>  writes:
>> Below is an example that I created.  It works okay, but when I add any
>> character in the comment or in the table definition, it fails (hangs).
>> I checked the server process (with ps command), and I can see that
>> connection is 'idle'.  By the way, the size 1484 may not mean anything,
>> since I tried another case (with different comment and table) and the
>> problem still happens but the size 1484 is not the break point.
>
>> I think this may be CentOS(64 bits)/ssh related, since I don't have the
>> problem with CentOS(32 bits) and we have the same application to install
>> the tables with the same command on mandriva.
>
> FWIW, I cannot reproduce this problem using 8.4.latest on Fedora 13 64bit.
> So it might indeed be something specific to the openssl version you're
> using.  I assume you tested that the problem goes away if you use a
> non-SSL connection?
>
> The openssl installation I'm testing with is
> openssl-1.0.0a-1.fc13.x86_64
> I don't know offhand what RHEL/CentOS 5.x are using but it's probably
> quite a lot older.
>
>             regards, tom lane
>

Thanks for your response.  Our SA said that there was a network
configuration set up incorrectly. After the 'Jumbo Frames' was enabled
on the network between the 10G and 1G hosts, the problem was gone.
Sorry, I don't know the detail about the network configuration.

Thanks,
Gary