Re: [GENERAL] slow inserts and updates on large tables

Jim Mercer wrote:
>
> i'm developing a database for one of my clients.
>
> unfortunately, the combination of PostgreSQL 6.4 and FreeBSD 3.0 don't
> seem to be giving me the performance i would expect.
>
> i have a table which has some 60 fields, largely fixed length strings
> (of a variety of sizes) and indexed on a 20 character string field.
>
> currently i have some 5,866,667 records in the table and when i use
> a c program to insert records, i get a max of 102 inserts per second.
>
> updates average about 40/second, sometimes much slower.
>
> i intend to have a sliding group of about 10-15 million records in this
> table (deleting some each night, while constantly adding new records).
>
> 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 ?
Do you use BEGIN/END to run _many_ updates/inserts in
_single_ transaction ?

Vadim