inserting, index and no index - speed

From: zilch(at)home(dot)se
To: pgsql-general(at)postgresql(dot)org
Subject: inserting, index and no index - speed
Date: 2001-06-07 15:51:55
Message-ID: 20010607175155.A26002@loony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I just noticed that inserting 10000 tuples in an indexed table took exactly
the same amount of time as inserting 10000 tuples in a non-indexed table
(194 seconds). Why is this? The difference in MySQL is about 50% longer in
an indexed table.

Thanks

Daniel Akerud.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lehmeier, Michael 2001-06-07 16:05:47 Format of BOOLEAN
Previous Message Tim Barnard 2001-06-07 15:08:09 Re: Re: [SQL] maximum number of rows in table - what about oid limits?