3 ms·
> Also the transition table might be an actual SQL table as well instead of switch-cases in a function. That would likely add an unnecessary read and slow thi
by mozumder 9y ago
> Also the transition table might be an actual SQL table as well instead of switch-cases in a function.
That would likely add an unnecessary read and slow things down just a little bit.
- ysleepy 9y agoIt depends. The table will reside in memory and it will just be a scan over a few bytes. Possibly cheaper than firing up the PL/pgSQL interpreter.