Re: Re: Heaps of read() syscalls by the postmaster

On Fri, 19 May 2000, Matthias Urlichs wrote:

> This is postgreSQL 7.0, compiled with i686-pc-linux-gnu/2.95, using no
> special options to compile or setup, except that fsync was turned off,
> as verified by the above sytem call summary. Auto-commit was on during
> this test (what's the SQL command to turn it off, anyway? I couldn't
> find it).

In Perl, I do:

my $dbh = DBI->connect("dbi:Pg:dbname=$dbname;host=$dbhost;port=$dbport","$dbuser");
$dbh->{AutoCommit} = 0;

And then make sure you do a $dbh->commit(); whenever you want to end the
transaction ...

>
>
> NB: The same benchmark revealed that CREATE TABLE (or maybe it's CREATE
> INDEX) leaks about 2k of memory.
>
> --
> Matthias Urlichs | noris network GmbH | smurf(at)noris(dot)de | ICQ: 20193661
> The quote was selected randomly. Really. | http://smurf.noris.de/
> --
> Justice: A commodity which (in a more or less adulterated condition)
> the State sells to the citizen as a reward for his allegiance,
> taxes, and personal service.
> -- Ambrose Bierce, "The Devil's Dictionary"
>

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org