From: | Lennert Buytenhek <buytenh(at)gnu(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Selects on tables with cidr type primary keys are broken |
Date: | 2000-10-15 14:56:34 |
Message-ID: | Pine.LNX.4.21.0010151654310.2130-100000@mara.math.leidenuniv.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Lennert Buytenhek
Your email address : buytenh(at)gnu(dot)org
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium II
Operating System (example: Linux 2.0.26 ELF) : Red Hat Linux 6.2 (custom 2.2.16 kernel)
PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.2
Compiler used (example: gcc 2.8.0) : Binary RPM distribution for Red Hat
Please enter a FULL description of your problem:
------------------------------------------------
Selects on tables with cidr type primary keys are broken.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Behold:
<quote>
test=# \d jobschedule
Table "jobschedule"
Attribute | Type | Modifier
-----------+---------+----------
prefix | cidr | not null
interval | integer |
Index: jobschedule_pkey
test=# select * from jobschedule;
prefix | interval
----------------+----------
132.229.230/24 | 2592000
132.229.231/24 | 2592000
132.229.232/24 | 2592000
132.229.12/24 | 2592000
132.229.50/24 | 2592000
132.229.52/24 | 2592000
132.229.93/24 | 2592000
132.229.95/24 | 2592000
(8 rows)
test=# explain select * from jobschedule where prefix='132.229.230/24';
NOTICE: QUERY PLAN:
Index Scan using jobschedule_pkey on jobschedule (cost=0.00..8.14 rows=10 width=16)
EXPLAIN
test=# select * from jobschedule where prefix='132.229.230/24';
prefix | interval
--------+----------
(0 rows)
</quote>
If I recreate the table without prefix being a primary key, the selects
are planned as sequential scans and magically start working again.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Eeeh.. not really. I haven't really had time yet to delve into the
PostgreSQL codebase.... :(
From | Date | Subject | |
---|---|---|---|
Next Message | Palle Girgensohn | 2000-10-15 16:25:26 | reproducable command sequence to get "mdopen: Couldn't open..." |
Previous Message | Philip Warner | 2000-10-15 08:25:40 | Re: PostgreSQL BugTool Submission |