Large number of rows in pg_type and slow gui (pgadmin) refresh
От | Robert Klaus |
---|---|
Тема | Large number of rows in pg_type and slow gui (pgadmin) refresh |
Дата | |
Msg-id | 00aa01cde9ea$a2bbd410$e8337c30$@com обсуждение исходный текст |
Ответы |
Re: Large number of rows in pg_type and slow gui
(pgadmin) refresh
|
Список | pgadmin-support |
<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>
В списке pgadmin-support по дате отправления: