Re: Desconexion o lentitud de Postgres ???

Bueno, basicamente dmesg te esta diciendo que el link (o sea la
actividad en la interfaz) fue y vino a su gusto durante un buen rato.

Revisa que el cable este correctamente enchufado en ambos extremos,
switch e interfaz de red del server. Revisa que el cable funcione
bien. Y comentale al administrador de red el problema con urgencia,
puede ser tranquilamente un problema en el switch o en el port del
mismo.

De nuevo, esto NO es un problema de postgres, sino de redes.

Con respecto a ulimit, la cantidad de file descriptors (flag -n en
1024) a mi entender es poca, pero no esta relacionado con el problema
en cuestión.

Saludos,
Guido

On Wed, Apr 7, 2010 at 3:56 PM, Edwin Quijada
<listas_quijada(at)hotmail(dot)com> wrote:
>
>
>  > Claramente un factor ajeno al servicio de Postgres.
>>
>> sudo dmesg y a ver que paso con la red
>>
>
> Esto fue lo que consegui con dmesg que la verdad no entiedno mucho la
> informacion
>
> diamante:/usr/local/pgsql/data# dmesg |grep eth0
> [    1.758938] eth0: Broadcom NetXtreme II BCM5709 1000Base-T (C0) PCI
> Express found at mem d6000000, IRQ 36, node addr 00:26:b9:3b:1b:c5
> [   56.153764] bnx2: eth0: using MSIX
> [   56.291201] ADDRCONF(NETDEV_UP): eth0: link is not ready
> [   57.761598] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [   57.761598] ADDRCONF(NETDEV_CHANGE): eth0: link becomes ready
> [   67.976423] eth0: no IPv6 routers present
> [  287.033502] bnx2: eth0 NIC Copper Link is Down
> [  311.706468] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [  352.087214] bnx2: eth0 NIC Copper Link is Down
> [  389.746738] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [47733.700698] bnx2: eth0 NIC Copper Link is Down
> [47830.642744] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [47830.843812] bnx2: eth0 NIC Copper Link is Down
> [47839.438783] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [285342.817391] bnx2: eth0 NIC Copper Link is Down
> [285344.438020] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [4001436.465577] bnx2: eth0 NIC Copper Link is Down
> [4001438.572582] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [4002061.215076] bnx2: eth0 NIC Copper Link is Down
> [4002063.044273] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [4002084.900365] bnx2: eth0 NIC Copper Link is Down
> [4002086.452943] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [4003379.332121] bnx2: eth0 NIC Copper Link is Down
> [4003383.829401] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [4003958.056174] bnx2: eth0 NIC Copper Link is Down
> [4003964.530612] bnx2: eth0 NIC Copper Link is Up, 100 Mbps full duplex
> [11481867.883010] bnx2: eth0 NIC Copper Link is Down
> [11484966.345353] bnx2: eth0 NIC Copper Link is Up, 1000 Mbps full duplex
> [11486137.815575] bnx2: eth0 NIC Copper Link is Down
> [11486155.082838] bnx2: eth0 NIC Copper Link is Up, 1000 Mbps full duplex
> [11489092.767044] bnx2: eth0 NIC Copper Link is Down
> [11489095.800636] bnx2: eth0 NIC Copper Link is Up, 1000 Mbps full duplex
> diamante:/usr/local/pgsql/data#
>
> ________________________________