always CC list On 11/24/05, Nirmal Kumar <nirmal1980@xxxxxxxxx> wrote: > Hi Jamie > > Thanks for the Reply. > > Memory allocated: 756MB. > We are not finding any problem on the Hardware. > > we tried to explain a normal query of same db load in > two different servers and postgres 7.4.2 seems to take > a lot of execution time comparatively higher than a > 7.3.8 version of postgres > > The servers are mandrake 9.1 for 7.3.8 and suse in > ppc has 7.4.2 > > We will try vaccum analise and get back to you. > if you found that the problem persist you can send info about the query, tables (and views) involved, indexes, explain analyze (from 7.3.8 if possible, and from 7.4.2)... > Regards > Nirmal > > > --- Jaime Casanova <systemguards@xxxxxxxxx> wrote: > > > On 11/21/05, Nirmal Kumar <nirmal1980@xxxxxxxxx> > > 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 > > > > > > > > > > > > > how many memory do you have? > > can you show an explain of some query that is slow? > > had you run VACUUM ANALYZE (or ANALYZE at least) > > recently? > > > > it's all the system that slow or just queries? > > (maybe it is a problem > > of lack of resources) > > > > > > -- > > regards, > > Jaime Casanova > > (DBA: DataBase Aniquilator ;) > > > > > > > __________________________________ > Yahoo! Music Unlimited > Access over 1 million songs. Try it free. > http://music.yahoo.com/unlimited/ > -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;)
