From: [EMAIL PROTECTED] (Jim Mercer)
Subject:Re: [GENERAL] ld.so failed
To: [EMAIL PROTECTED] (Carsten Huettl)
Date sent: Fri, 15 Oct 1999 09:59:09 -0400 (EDT)
Copies to: [EMAIL PROTECTED], [EMAIL PROTECTED]
> you can
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.
Try turning off Autocommit: MySQL doesn't support transactions, so that
might be what's causing the speed boost. Just change the connect line from:
$pg_con=DBI->connect("DBI:Pg:
to
$pg_con=DBI->connect("DBI:Pg(AutoCommit=>0):
and add
$pg_con->commit
before you disconnect. I may have
Hello,
I have compiled postgres 6.5.2 on a Solaris 2.6 machine. pltcl and
plpgsql compiles without warnings. But whenever I try to execute a
function, the response is:
ERROR: Load of file /metuser/lib/plpgsql.so failed: ld.so.1: postmaster:
fatal: relocation error: file /metuse
Thanks.
It's now a lot faster. Now only about 5 or so times slower. Cool.
But it wasn't unexpected that I got the following after a while ;).
NOTICE: BufferAlloc: cannot write block 990 for joblist/central
NOTICE: BufferAlloc: cannot write block 991 for joblist/centra
