Re: [GENERAL] slow inserts and updates on large tables - Mailing list pgsql-general

From jim@reptiles.org (Jim Mercer)
Subject Re: [GENERAL] slow inserts and updates on large tables
Date
Msg-id m10CzFa-00080dC@mailbox.reptiles.org
Whole thread Raw
In response to Re: [GENERAL] slow inserts and updates on large tables  (Vadim Mikheev <vadim@krs.ru>)
List pgsql-general
> > if 100 inserts/second and 40 updates/second is all i can realistically
> > expect, then i will have to investigate alternate databases (likely
> > commercial ones like Progress on SCO, yech!).
> >
> > if anyone has any pointers as to why this is so slow, lemme know.
>
> What's -B ?

it is whatever the default is.

> Do you use BEGIN/END to run _many_ updates/inserts in
> _single_ transaction ?

i tried that and it didn't seem to make much difference.

--
[ Jim Mercer    Reptilian Research      jim@reptiles.org   +1 416 410-5633 ]
[ The telephone, for those of you who  have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail.            ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]

pgsql-general by date:

Previous
From: Vadim Mikheev
Date:
Subject: Re: [GENERAL] slow inserts and updates on large tables
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] slow inserts and updates on large tables