Re: Inserts optimization? - Mailing list pgsql-performance

From Magnus Hagander
Subject Re: Inserts optimization?
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA352C3@algol.sollentuna.se
Whole thread Raw
In response to Inserts optimization?  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: Inserts optimization?
Re: Inserts optimization?
List pgsql-performance
> > Bacula already serializes access to the database (they have
> to support
> > mysql/myisam), so this shouldn't help.
>
> Ouch, that hurts.
>
> To support mysql, they break performance for _every other_
> database system?

Actually, it probably helps on SQLite as well. And considering they only
support postgresql, mysql and sqlite, there is some merit to it from
their perspective.

You can find a thread about it in the bacula archives from a month or
two back.

> <cynism>
> Now, I understand how the mysql people manage to spread the
> legend of mysql being fast. They convince software developers
> to thwart all others.
> </>

Yes, same as the fact that most (at least FOSS) web project-du-jour are
"dumbed down" to the mysql featureset. (And not just mysql, but
mysql-lowest-common-factors, which means myisam etc)


> > Actually, it might well hurt by introducing extra delays.
>
> Well, if you read the documentation, you will see that it
> will only wait if there are at least commit_siblings other
> transactions active. So when Bacula serializes access, there
> will be no delays, as there is only a single transaction alive.

Hm. Right. Well, it still won't help :-)

//Magnus

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Inserts optimization?
Next
From: Markus Schaber
Date:
Subject: Re: Inserts optimization?