Re: Postgres Database slow - Mailing list pgsql-admin

From Jaime Casanova
Subject Re: Postgres Database slow
Date
Msg-id c2d9e70e0511240747w24e8f921ne4294a1d53819570@mail.gmail.com
Whole thread Raw
In response to Re: Postgres Database slow  (Jaime Casanova <systemguards@gmail.com>)
List pgsql-admin
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 ;)

pgsql-admin by date:

Previous
From: Oliver Elphick
Date:
Subject: Re:
Next
From: "Goulet, Dick"
Date:
Subject: Re: