Re: inserting, index and no index - speed

Поиск
Список
Период
Сортировка
От zilch@home.se
Тема Re: inserting, index and no index - speed
Дата
Msg-id 20010610225100.A29537@loony
обсуждение исходный текст
Ответ на Re: inserting, index and no index - speed  (zilch@home.se)
Список 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


В списке pgsql-general по дате отправления: