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 <[EMAIL PROTECTED]> Director of Information Systems, Support Center of Washington ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
