Re: TRUNCATE TABLE
| От | Adriaan van Os |
|---|---|
| Тема | Re: TRUNCATE TABLE |
| Дата | |
| Msg-id | 4697D339.2090204@microbizz.nl обсуждение исходный текст |
| Ответ на | Re: TRUNCATE TABLE (Tom Lane) |
| Список | pgsql-performance |
Дерево обсуждения
TRUNCATE TABLE
(Adriaan van Os,
)
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Gregory Stark, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Gregory Stark, )
Re: TRUNCATE TABLE (Jean-Max Reymond, )
Re: TRUNCATE TABLE ("Thomas Samson", )
Re: TRUNCATE TABLE (Michael Stone, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE ("Steinar H. Gunderson", )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE ("Jim C. Nasby", )
Re: TRUNCATE TABLE (Alvaro Herrera, )
Re: TRUNCATE TABLE ("Pavel Stehule", )
Re: TRUNCATE TABLE ("Jim C. Nasby", )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Alvaro Herrera, )
Re: TRUNCATE TABLE ("Kevin Grittner", )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Decibel!, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Gregory Stark, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Gregory Stark, )
Re: TRUNCATE TABLE (Jean-Max Reymond, )
Re: TRUNCATE TABLE ("Thomas Samson", )
Re: TRUNCATE TABLE (Michael Stone, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE ("Steinar H. Gunderson", )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE ("Jim C. Nasby", )
Re: TRUNCATE TABLE (Alvaro Herrera, )
Re: TRUNCATE TABLE ("Pavel Stehule", )
Re: TRUNCATE TABLE ("Jim C. Nasby", )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Alvaro Herrera, )
Re: TRUNCATE TABLE ("Kevin Grittner", )
Re: TRUNCATE TABLE (Adriaan van Os, )
Re: TRUNCATE TABLE (Decibel!, )
Re: TRUNCATE TABLE (Tom Lane, )
Re: TRUNCATE TABLE (Adriaan van Os, )
Tom Lane wrote: > Adriaan van Os <> 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 по дате отправления: