Re: [GENERAL] Postgres INSERTs much slower than MySQL?

Hi everyone,

Should inserts be so slow?

I've written a perl script to insert 10 million records for testing
purposes and it looks like it's going to take a LONG time with postgres.
MySQL is about 150 times faster! I don't have any indexes on either. I am
using the DBI and relevant DBD for both.

For Postgres 6.5.2 it's slow with either of the following table structures.
create table central ( counter serial, number varchar (12), name text,
address text );
create table central ( counter serial, number varchar (12), name
varchar(80), address varchar(80));

For MySQL I used:
create table central (counter int not null auto_increment primary key,
number varchar(12), name varchar(80), address varchar(80));

The relevant perl portion is (same for both):
		$SQL=<<"EOT";
insert into central (number,name,address) values (?,?,?)
EOT
		$cursor=$dbh->prepare($SQL);

	while ($c<10000000) {
		$number=$c;
		$name="John Doe the number ".$c;
		$address="$c, Jalan SS$c/$c, Petaling Jaya";
		$rv=$cursor->execute($number,$name,$address) or die("Error executing
insert!",$DBI::errstr);
		if ($rv==0) {
			die("Error inserting a record with database!",$DBI::errstr);
		};
		$c++;
		$d++;
		if ($d>1000) {
			print "$c\n";
			$d=1;
		}
	}