|
accessing primary key slower than accessing non primary key???: msg#00162db.postgresql.novice
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- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Cygwin and C triggers: 00162, Alan Clucas |
|---|---|
| Next by Date: | Re: accessing primary key slower than accessing non primary key???: 00162, Tom Lane |
| Previous by Thread: | Cygwin and C triggersi: 00162, Alan Clucas |
| Next by Thread: | Re: accessing primary key slower than accessing non primary key???: 00162, Tom Lane |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |