Postgres Pro
Downloads
Home   >   mailing lists

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

From zilch@home.se
Subject Re: inserting, index and no index - speed
Date
Msg-id 20010610225100.A29537@loony
Whole thread Raw
In response to Re: inserting, index and no index - speed  (zilch@home.se)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: zilch@home.se
Date:
Subject: Re: inserting, index and no index - speed
Next
From: Stephan Szabo
Date:
Subject: Re: foreign keys constraints, depending on each other