Home > mailing lists

inserting, index and no index - speed - Mailing list pgsql-general

From	zilch@home.se
Subject	inserting, index and no index - speed
Date	June 7, 2001 15:06:21
Msg-id	20010607175155.A26002@loony Whole thread Raw
Responses	Re: inserting, index and no index - speed (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Tree view

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.

pgsql-general by date:

From: "Tim Barnard"
Date: 07 June 2001, 14:39:39
Subject: Re: Re: [SQL] maximum number of rows in table - what about oid limits?

From: zilch@home.se
Date: 07 June 2001, 15:36:03
Subject: WAS: PostgreSQL Replication Server? IS: Zend comparison chart

inserting, index and no index - speed - Mailing list pgsql-general

Previous

Next