pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jaime Casanova <systemguards@gmail.com>
To: Nirmal Kumar <nirmal1980@yahoo.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgres Database slow
Date: Thu, 24 Nov 2005 10:47:18 -0500
Message-ID: <c2d9e70e0511240747w24e8f921ne4294a1d53819570@mail.gmail.com> (raw)
In-Reply-To: <20051124154020.60269.qmail@web53505.mail.yahoo.com>
References: <c2d9e70e0511210851m372366b2nf83d81d1ff48d65d@mail.gmail.com>
	<20051124154020.60269.qmail@web53505.mail.yahoo.com>

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 ;)



view thread (6+ messages)

Message-ID: <c2d9e70e0511240747w24e8f921ne4294a1d53819570@mail.gmail.com>
Permalink:  ../c2d9e70e0511240747w24e8f921ne4294a1d53819570@mail.gmail.com/
Also on:    postgresql.org/message-id/c2d9e70e0511240747w24e8f921ne4294a1d53819570@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: systemguards@gmail.com, nirmal1980@yahoo.com
  Subject: Re: Postgres Database slow
  In-Reply-To: <c2d9e70e0511240747w24e8f921ne4294a1d53819570@mail.gmail.com>
  References: <c2d9e70e0511210851m372366b2nf83d81d1ff48d65d@mail.gmail.com> <20051124154020.60269.qmail@web53505.mail.yahoo.com> <c2d9e70e0511240747w24e8f921ne4294a1d53819570@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox