diff options
| author | Tom Lane | 2000-10-24 01:38:44 +0000 |
|---|---|---|
| committer | Tom Lane | 2000-10-24 01:38:44 +0000 |
| commit | 4f44aa04b53f26d3abbf64beb0c1b3d10be324a3 (patch) | |
| tree | f32ad3b8c4819e87ac1fdcbe296b60880da55b56 /src/bin/pgtclsh | |
| parent | d7186cfa9b0807deb5c4f31975a4269efa0905cf (diff) | |
Major overhaul of large-object implementation, by Denis Perchine with
kibitzing from Tom Lane. Large objects are now all stored in a single
system relation "pg_largeobject" --- no more xinv or xinx files, no more
relkind 'l'. This should offer substantial performance improvement for
large numbers of LOs, since there won't be directory bloat anymore.
It'll also fix problems like running out of locktable space when you
access thousands of LOs in one transaction.
Also clean up cruft in read/write routines. LOs with "holes" in them
(never-written byte ranges) now work just like Unix files with holes do:
a hole reads as zeroes but doesn't occupy storage space.
INITDB forced!
Diffstat (limited to 'src/bin/pgtclsh')
| -rw-r--r-- | src/bin/pgtclsh/updateStats.tcl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/bin/pgtclsh/updateStats.tcl b/src/bin/pgtclsh/updateStats.tcl index d97c8a7b67..9cb8384dc2 100644 --- a/src/bin/pgtclsh/updateStats.tcl +++ b/src/bin/pgtclsh/updateStats.tcl @@ -59,7 +59,7 @@ proc update_attnvals {conn rel} { proc updateStats { dbName } { # datnames is the list to be result set conn [pg_connect $dbName] - set res [pg_exec $conn "SELECT relname FROM pg_class WHERE relkind = 'r' and relname !~ '^pg_' and relname !~ '^xinv'"] + set res [pg_exec $conn "SELECT relname FROM pg_class WHERE relkind = 'r' and relname !~ '^pg_'"] set ntups [pg_result $res -numTuples] for {set i 0} {$i < $ntups} {incr i} { set rel [pg_result $res -getTuple $i] |