From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adriaan van Os <postgres@microbizz.nl>
Cc: pgsql-performance@postgresql.org
Subject: Re: TRUNCATE TABLE
Date: Fri, 13 Jul 2007 12:30:46 -0400
Message-ID: <23092.1184344246@sss.pgh.pa.us> (raw)
In-Reply-To: <4697A58E.8060904@microbizz.nl>
References: <46953949.3030201@microbizz.nl>
<87ps2ypox3.fsf@oxford.xeocode.com>
<46972DFA.9000900@microbizz.nl>
<20070713124435.GL31358@mathom.us>
<21495.1184337630@sss.pgh.pa.us>
<4697A58E.8060904@microbizz.nl>
Adriaan van Os <postgres@microbizz.nl> writes:
> I started another test. I copied an existing database (not very large,
> 35 tables, typically a few hundred up to a few thousand records) with
> CREATE DATABASE testdb TEMPLATE mydb and started to remove random
> tables from testdb with DROP TABLE and TRUNCATE TABLE. I did this with
> the query tool of pgAdmin III, to exclude any doubts about my own
> software (that uses pqlib).
Can you try it with plain psql? pgAdmin is a variable that wasn't
accounted for in my tests.
> The hardware is an Intel dual-core 17-inch
> MacBook Pro running Mac OS X 10.4.
Hmm. I thought you said Fedora before. However, I'd done a few tests
yesterday on my own Mac laptop (Al G4) and not gotten results that were
out of line with HPUX or Fedora.
Does anyone else want to try replicating these tests?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, postgres@microbizz.nl
Subject: Re: TRUNCATE TABLE
In-Reply-To: <23092.1184344246@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox