From: | "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Martin Schulze <joey(at)infodrom(dot)north(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: More PostgreSQL stuff |
Date: | 1998-10-02 07:20:36 |
Message-ID: | 199810020720.IAA07924@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Copied to PostgreSQL lists, in the hope of comments from the experts...
Martin Schulze wrote:
>Is there a way to speed up postgres? I'm converting one of my
>major apps from mSQL to PostgreSQL and PostgreSQL is at least three
>times slower. That's horrible. With this slowlyness I cannot
>install PostgreSQL in the office but only at home.
>
>So, is there a way to speed it up? I have turned off debugging
>since I hoped that it was the reason for the slowliness but
>apparently it isn't.
It depends what you are doing: every update or insert is a separate
transaction, unless you declare transactions yourself. So use
BEGIN TRANSACTION ... COMMIT ... END TRANSACTION to enclose related
updates and you should get a speed improvement.
If you are loading a lot of items, COPY is much faster than
successive INSERTs.
Consider whether to disable fsync; balance the speed improvement against the
slightly increased risk of corrupting your database in the event of a
system crash.
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Set your affection on things above, not on things on
the earth." Colossians 3:2
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 1998-10-02 07:20:38 | Re: More PostgreSQL stuff |
Previous Message | Bruce Momjian | 1998-10-02 06:02:48 | Re: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF) |