<div class="WordSection1"><p class="MsoNormal"> <p class="MsoNormal">This message was posted in the pgsql-general and
novicelists, and I was cirected here . . . sorry for those of you receiving multiple posts.<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">We have 36,000+ rows returned by " SELECT oid, format_type(oid, typtypmod) AS
typnameFROM pg_type".<p class="MsoNormal"> <p class="MsoNormal">My manager says this is only a small number compared to
whatis expected by next summer.<p class="MsoNormal"> <p class="MsoNormal">When I run this select statement on the
databaseserver it returns in under 1 second but it takes a minute to open some tabs using pgAmin III (1.16.1).<p
class="MsoNormal"> <pclass="MsoNormal">Is there a workaround for this - most of the rows returned are from one schema.
Ifwe could elimiate it from the listed schemas it would help. Is this possible in pgAdmin III?<p class="MsoNormal"> <p
class="MsoNormal">Ourdatabase server is at 8.4<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"><b><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#17365D">Robert</span></b><p
class="MsoNormal"><b><spanstyle="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#17365D">Nexgen Wireless,
Inc.</span></b><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">1701
EastWoodfield Road, Suite 430</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Schaumburg,IL 60173</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Office: </span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">(847)944-8003</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif""> </span><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">ext121</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Mobile:(847) 721-6477</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Fax: (847)
874-7050</span><pclass="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><a
href="http://www.nexgenwireless.com/"><spanstyle="color:blue">www.nexgenwireless.com</span></a></span><p
class="MsoNormal"> </div>