Re: Horrible PostgreSQL performance with NFS

On Sat, Jan 14, 2006 at 06:42:02AM -0800, Arne Woerner wrote:
> Did you do those "dd" tests with small block sizes (like 1byte:
> bs=1), like somebody on one of those lists suggests, too? Then we
> could see, if there is a high latency that ruins everything...

FYI, PostgreSQL does 8kB I/O by default. This can only be changed by
modifying a header file.
--
Jim C. Nasby, Database Architect decibel@xxxxxxxxxxx
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"
_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: Horrible PostgreSQL performance with NFS
    ... >> bs=1), like somebody on one of those lists suggests, too? ... if there is a high latency that ruins everything... ... size the first responder suggested), knowing that, you should ...
    (freebsd-performance)
  • Re: PostgreSQL
    ... There is a decent tool called PGAdmin III that would solve most of your ... Secondly you can always join the PostgreSQL list and seek help ... PG has a decent ODBC driver as well, ... > and I couldn't find any good web pages or mailing lists to get me over ...
    (Fedora)
  • Re: Kmail offline
    ... frustration of life with selinux and it took several days of questioning ... both the postgresql and selinux lists before I got it resolved and ended ... postgresql developers and rpm packager for Red Hat) to use. ...
    (Fedora)
  • RESULT: comp.databases.postgresql fails 74:14
    ... There were 88 valid YES/NO votes submitted during the voting period. ... To provide a Big-Eight usenet group for users of the PostgreSQL ... lists gated to the public pgsql.* hierarchy. ... Discussions pertaining to the administration, ...
    (comp.os.linux.misc)
  • RESULT: comp.databases.postgresql fails 74:14
    ... There were 88 valid YES/NO votes submitted during the voting period. ... To provide a Big-Eight usenet group for users of the PostgreSQL ... lists gated to the public pgsql.* hierarchy. ... Discussions pertaining to the administration, ...
    (comp.unix.bsd.freebsd.misc)