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 [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
