Re: speed on Postgresql compared to Mysql

On Tue, 3 Apr 2001, Livio Righetti wrote:

> Hi,
>
> Talking about insert, I know Mysql is fast than Postgresql.
>
> I've made the following test :
>
> 40'000 insert (accouting context) using Perl and dbd :
>
> Postgresql :
>   text       :  4 min 53 s
>   varchar :  4 min 49 s
>   char      :  4 min 49 s
>
> Mysql :
>   text       : 0 min 29 s
>   varchar : 0 min 29 s
>   char      : 0 min 29 s
>
> So we can see Mysql is about 10 times fast.
>
> Also we used Postgresql for Radius (authentication) et we have to make 3
> vacuum per day otherwise the first server is overload and the user go to the
> backup server.
>
> Is it normal or my Postgresql is not well configured ?

Err, yes.

Did you just do 40,000 inserts in a row, one after another? Realistic
speed tests often have many requests coming in together, to simulate
application- and web-usage.

In addition, did you wrap this in a transaction? Otherwise, you're
performing one transaction for *every single* insert, which is much slower
than in a a transaction.

(Generally speaking, if you want to just add 40,000 rows to a table, I'd
use COPY, not INSERT ;-) )

HTH,

--
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington