SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 05:31 AM
| ||||
| ||||
 Re: Postgres Database slow On 11/21/05, Nirmal Kumar <nirmal1980@yahoo.com> 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  ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org      |
|
04-10-2008, 05:31 AM
| ||||
| ||||
| Re: Postgres Database slow always CC list On 11/24/05, Nirmal Kumar <nirmal1980@yahoo.com> 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@gmail.com> wrote: > > > On 11/21/05, Nirmal Kumar <nirmal1980@yahoo.com> > > 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
Linear Mode
