Version.
PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.5.2,
64-bit
Server.
Server: RX800 S2 (8 x Xeon 7040 3GHz dual-core processors, 32GB memory
O/S: SLES11 SP1 64-bit
Scenario.
Legacy application with bespoke but very efficient interface to its
I have two tables node and relationship. Each relationship record connects two
nodes and has an application keys (unfortunately named) that can be used by the
application to look-up a relationship and get from one node to the other.
My query uses a node id and a description of a relationship
