Diff between Primary key and non primary key select

Поиск
Список
Период
Сортировка
От Deepa
Тема Diff between Primary key and non primary key select
Дата
Msg-id Pine.LNX.4.33.0302141757390.2054-100000@ws1154.midascomm.com
обсуждение исходный текст
Ответы Re: Diff between Primary key and non primary key select
Re: Diff between Primary key and non primary key select
Список pgsql-general
Hi,
        While testing select query with where condition for primary key
and non primary key value, I got the following results

        Base database size    Time taken to select one record using one
                                         query in milliseconds

                                With Primary key      With Non primary Key

             2000                    15.8                    15.7
             10000                   71.2                    70.7
             25000                   174                     173.5
             100000                  4319                    3417

        In the above result, I cannot able to see much difference between
the time consumed using primary key and non-primary key value. Even in
some cases, I can able to see that using non primary key value retrieves record faster
than  using primary key.

        I did the above test several times and I am getting the same
results. Can any one tell me, what could be the possible reason for this.

        I ran the above test in the following system configuration.

        SYSTEM CONFIGURATION
        ====================

        Hard Disk               :       4.3 GB
        RAM                     :       64  MB
        Processor               :       Celeron - 566 MHz
        Swap space              :       200 MB

        SOFTWARE CONFIGURATION
        ======================

Note : To avoid load in the PC, I ran only the above test and hence there
are no other loads in the PC.

--

Bye,
Deepa. K

--
Engineer,
Network Management System,
Midas Communication Technologies private Ltd,
Chennai.





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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: uppercase = lowercase
Следующее
От: Andreas Rust
Дата:
Сообщение: Re: db "hot switch"