Re: More PostgreSQL stuff - Mailing list pgsql-general

From Oliver Elphick
Subject Re: More PostgreSQL stuff
Date
Msg-id 199810020720.IAA07924@linda.lfix.co.uk
Whole thread Raw
Responses Re: More PostgreSQL stuff
Re: [GENERAL] Re: More PostgreSQL stuff
List 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.Elphick@lfix.co.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



pgsql-general by date:

Previous
From: "Taral"
Date:
Subject: RE: [GENERAL] Long update query ? (also Re: [GENERAL] CNF vs. DNF)
Next
From: "Oliver Elphick"
Date:
Subject: Re: More PostgreSQL stuff