vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Those of you with long memories may recall a discussion back in January about reference-counting TupleDescs retrieved by lookup_rowtype_tupdesc(). I didn't like the patch Neil Conway developed for this, so I'm on the hook to find a better answer before 8.2 comes out. I haven't forgotten .... but I was reminded of it while looking at the performance issue pointed out by Marc Orgassa here: http://archives.postgresql.org/pgsql...5/msg00153.php If oprofile is to be trusted, Marc's second example spends something close to forty percent of its runtime in CreateTupleDescCopy() operations (including the subsidiary memcpy() calls). Yikes. A reference-counting mechanism would have to be cheaper than that. So I'll try to bubble this issue up to the top of the to-do queue again... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
| Thread Tools | |
| Display Modes | |
|
|