I have a (only vaguely) related question about NUMERICs. I'm using
someone else's schema to copy data from their DB into mine. They use
NUMERIC quite a bit, with scale 0, where I would use one of the integer
types. My question is whether joining and matching on NUMERIC is
likely to be slower than, say, INTEGER. Note that I'm never doing math
with these values, they are just IDs.
Thanks for any info provided!
- John D. Burger
MITRE
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
