Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL is extremely slow on Windows

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Vig, Sandor (G/FI-2)" <Sandor(dot)Vig(at)audi(dot)hu>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: PostgreSQL is extremely slow on Windows
Date: 2005-02-22 18:15:13
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE476962@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-performance
>I've downloaded the latest release (PostgreSQL 8.0) for windows.
>Installation was OK, but I have tried to restore a database.
>It had more than ~100.000 records. Usually I use PostgreSQL
>under Linux, and it used to be done under 10 minutes.
>
>Under W2k und XP it took 3 hours(!) Why is it so slow????
>
>The commands I used:
>
>Under Linux: (duration: 1 minute)
>	pg_dump -D databasename > databasename.db
>
>Under Windows: (duration: 3 - 3.5 hours(!))
>	psql databasename < databasename.db >nul
>
>It seemed to me, that only 20-30 transactions/sec were
>writen to the database.

20-30 transactionsi s about what you'll get on a single disk on Windows
today.
We have a patch in testing that will bring this up to about 80.
You can *never* get above 80 without using write cache, regardless of
your OS, if you have a single disk. You might want to look into wether
write cacheing is enabled on your linux box, and disable it. (unless you
are using RAID) A lot points towards write cache enabled on your system.

If you need the performance that equals the one with write cache on, you
can set fsync=off. But then you will lose the guarantee that your
machine will survive an unclean shutdown or crash. I would strongly
advice against it on a production system - same goes for running with
write cache!

//Magnus

Responses

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2005-02-22 19:47:27
Subject: is pg_autovacuum so effective ?
Previous:From: Mitch PirtleDate: 2005-02-22 16:30:28
Subject: Re: PostgreSQL is extremely slow on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group