Re: TRUNCATE TABLE
От | Adriaan van Os |
---|---|
Тема | Re: TRUNCATE TABLE |
Дата | |
Msg-id | 4697D339.2090204@microbizz.nl обсуждение исходный текст |
Ответ на | Re: TRUNCATE TABLE (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-performance |
Tom Lane wrote: > 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. Will do that and report the results. >> The hardware is an Intel dual-core 17-inch >> MacBook Pro running Mac OS X 10.4. > > Hmm. I thought you said Fedora before. Yes, the test that I mentioned yesterday was on Fedora, but as you were "of the opinion that there's something broken about Adriaan's infrastructure" I tried the new test on a completely different system today. 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? Thanks, Adriaan van Os
В списке pgsql-performance по дате отправления: