On Tue, May 23, 2006 at 09:27:41AM +0200, Petr Bouda wrote:
> Hi all
>
> I'am facing strang problem while using pgAdmin III to browse DB running on
> the same machine (localhost) - it is very very slow. Coonect is quite quict,
> but listing all schemas takes tens of seconds, listing tables in schema
> takes other tens of seconds, refresing table details takes other seocnds. If
> I connect to postresql running on onother machine in our network, the
> pgAdmin works fine. Also my local databse seems to work quickly if it deals
> with data. Just the pgAdmin is the one who prevents me from working.
How fast is \d in psql? Your catalog tables might be in serious need of
vacuuming. If that's not it you'll have better luck asking for help on
the pgAdmin lists.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461