Re: Running Postgresql with db on Netapp

From: 'Aditya ' (aditya@grot.org)
Date: Mon Sep 15 2003 - 19:04:11 EDT

  • Next message: Duncan Greenwood: "Re: Running Postgresql with db on Netapp"

    On Mon, Sep 15, 2003 at 03:41:28PM -0700, Maxwell Reid wrote:
    > Is it possible to install a Gigabit adapter in the *BSD box and filer?
    > That alone will probably give you a good performance boost... Switching to
    > udp probably won't improve things, but using Gbe and jumbo frames will do
    > wonders.

    I'd consider that, however I'm having a hard time believing that a PC a
    *stinkeen* plain-ol-IDE drive is doing better than my filer.

    I can blame (in order of cost of upgrade):

    - a configuration mistake
    - mount options
    - filer options
    - network hardware
    - nfs
    - pc hardware
    - postgresql

    and I'm slowly working my way down that list...(grin)

    I suspect that folks running Oracle/Informix with a filer aren't seeing more
    than a 10% performance reduction, otherwise very few would opt to do it, so I
    suspect that it works, it works well and I must be missing something...

    Thanks,
    Adi

    This archive was generated by hypermail 2b29 : Mon Sep 15 2003 - 19:10:33 EDT