Re: inserting, index and no index - speed

From: zilch(at)home(dot)se
To: pgsql-general(at)postgresql(dot)org
Subject: Re: inserting, index and no index - speed
Date: 2001-06-10 20:51:00
Message-ID: 20010610225100.A29537@loony
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Could it be that the 10000 rows in the table makes it so much slower so that
> the next 10000 in the same database but different table get so much slower?
>
> Daniel Akerud

It wasn't.
Now the database is cleared and VACUUMed and VACUUMED ANALYZEd before both
tests (table WITH and WITHOUT and index). Still same results. 195/194 seconds.

Daniel Akerud

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fred J 2001-06-10 21:06:23 postgres runaway process
Previous Message Stephan Szabo 2001-06-10 20:49:47 Re: foreign keys constraints, depending on each other