How about the output from explain analyze on one of the slow queries? On Mon, Nov 21, 2005 at 07:04:29AM -0800, Nirmal Kumar wrote: > Hi > > We are facing a slowness problem in posgres Database. > Whenver we query a data it is very very slow.It is > running on the IBM ISERIES I5 Server. > > HARDWARE: IBM Iseries I5 PPC Server > OS: SUSE LINUX ENTERPRISE SERVER 9.0 > POSTGRESSQL: 7.4.2 > WEB SERVER: APACHE2 > > Using the command line also it is taking long time to > query a database. > > Any Cluses > > Regards > Nirmal > > > > > __________________________________ > Yahoo! FareChase: Search multiple travel sites in one click. > http://farechase.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx 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
