Skip site navigation (1) Skip section navigation (2)

Re: Postgres Database slow

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Nirmal Kumar <nirmal1980(at)yahoo(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres Database slow
Date: 2005-11-24 15:47:18
Message-ID: c2d9e70e0511240747w24e8f921ne4294a1d53819570@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
always CC list

On 11/24/05, Nirmal Kumar <nirmal1980(at)yahoo(dot)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(at)gmail(dot)com> wrote:
>
> > On 11/21/05, Nirmal Kumar <nirmal1980(at)yahoo(dot)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 ;)

In response to

pgsql-admin by date

Next:From: Colton SmithDate: 2005-11-24 16:12:19
Subject: query planning and partitioned tables
Previous:From: Oliver ElphickDate: 2005-11-24 13:39:05
Subject: Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group