From: | HK <harikrishnan(at)midascomm(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | accessing primary key slower than accessing non primary key??? |
Date: | 2003-02-13 13:59:25 |
Message-ID: | Pine.LNX.4.33.0302131922060.5940-100000@mallard.midascomm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice pgsql-odbc |
hi,
I am using postgresql 7.1.3 under RH linux 7.2
For sake of comparison of speeds i am doing a small experiment.
I am having a table with 20 columns (1 col with bigint as primary key)
the size of a record is 300 bytes.
On retrieving records with select query with where clause accessing a
primary key and a non primary key the times are as follows
time in ms per query retrieval
py key non py key
------ -----------
2000 15.8 15.7
10000 71.2 70.7
25000 174 173.5
100000 4319 3417
As u see the non primary key retrieval is faster. AFAIK accessing primary
key should be faster. Can anybody throw light on why is this anamoly.
I use libpq with blocking execution of queries.
I ran this test with there being no other load in the system.
TIA.
--------
regards,
hari
__
/ / __ _ _ _ _ __ __ -o)
/ /__ / / / \\// //_// \\ \\/ / /\\\\ Making things happen
/____/ /_/ /_/\\/ /___/ /_/\\_\\ _\\_v-
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-13 15:45:37 | Re: accessing primary key slower than accessing non primary key??? |
Previous Message | Alan Clucas | 2003-02-13 12:27:36 | Cygwin and C triggers |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-13 15:45:37 | Re: accessing primary key slower than accessing non primary key??? |
Previous Message | Benjamin Scherrey | 2003-02-12 22:28:38 | Re: FW: Multiple databases question |