diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2012-05-25 14:35:37 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2012-05-25 14:35:37 -0400 |
| commit | 73cc7d3b240e1d46b1996382e5735a820f8bc3f7 (patch) | |
| tree | e9e075cc01cda2ea9403f8b477ceac512991fb30 /src/backend/utils/adt/varchar.c | |
| parent | 45ca31d6a7eaf91dc65fd5cf2b140320feb3fa3f (diff) | |
| download | postgresql-73cc7d3b240e1d46b1996382e5735a820f8bc3f7.tar.gz postgresql-73cc7d3b240e1d46b1996382e5735a820f8bc3f7.zip | |
Use binary search instead of brute-force scan in findNamespace().
The previous coding presented a significant bottleneck when dumping
databases containing many thousands of schemas, since the total time
spent searching would increase roughly as O(N^2) in the number of objects.
Noted by Jeff Janes, though I rewrote his proposed patch to use the
existing findObjectByOid infrastructure.
Since this is a longstanding performance bug, backpatch to all supported
versions.
Diffstat (limited to 'src/backend/utils/adt/varchar.c')
0 files changed, 0 insertions, 0 deletions