pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres Database slow
6+ messages / 5 participants
[nested] [flat]

* Postgres Database slow
@ 2005-11-21 15:04 Nirmal Kumar <nirmal1980@yahoo.com>
  2005-11-21 16:45 ` Re: Postgres Database slow Jim C. Nasby <jnasby@pervasive.com>
  2005-11-21 16:51 ` Re: Postgres Database slow Jaime Casanova <systemguards@gmail.com>
  2005-11-21 18:22 ` Re: Postgres Database slow Jeff Frost <jeff@frostconsultingllc.com>
  2005-11-21 19:10 ` Re: Postgres Database slow Brad Nicholson <bnichols@ca.afilias.info>
  0 siblings, 4 replies; 6+ messages in thread

From: Nirmal Kumar @ 2005-11-21 15:04 UTC (permalink / raw)
  To: pgsql-admin

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



		
__________________________________ 
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres Database slow
  2005-11-21 15:04 Postgres Database slow Nirmal Kumar <nirmal1980@yahoo.com>
@ 2005-11-21 16:45 ` Jim C. Nasby <jnasby@pervasive.com>
  3 siblings, 0 replies; 6+ messages in thread

From: Jim C. Nasby @ 2005-11-21 16:45 UTC (permalink / raw)
  To: Nirmal Kumar <nirmal1980@yahoo.com>; +Cc: pgsql-admin

How about the output from explain analyze on one of the slow queries?

On Mon, Nov 21, 2005 at 07:04:29AM -0800, Nirmal Kumar 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
> 
> 
> 
> 		
> __________________________________ 
> Yahoo! FareChase: Search multiple travel sites in one click.
> http://farechase.yahoo.com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq
> 

-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres Database slow
  2005-11-21 15:04 Postgres Database slow Nirmal Kumar <nirmal1980@yahoo.com>
@ 2005-11-21 16:51 ` Jaime Casanova <systemguards@gmail.com>
  2005-11-24 15:47   ` Re: Postgres Database slow Jaime Casanova <systemguards@gmail.com>
  3 siblings, 1 reply; 6+ messages in thread

From: Jaime Casanova @ 2005-11-21 16:51 UTC (permalink / raw)
  To: Nirmal Kumar <nirmal1980@yahoo.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres Database slow
  2005-11-21 15:04 Postgres Database slow Nirmal Kumar <nirmal1980@yahoo.com>
  2005-11-21 16:51 ` Re: Postgres Database slow Jaime Casanova <systemguards@gmail.com>
@ 2005-11-24 15:47   ` Jaime Casanova <systemguards@gmail.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Jaime Casanova @ 2005-11-24 15:47 UTC (permalink / raw)
  To: Nirmal Kumar <nirmal1980@yahoo.com>; +Cc: 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 ;)



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres Database slow
  2005-11-21 15:04 Postgres Database slow Nirmal Kumar <nirmal1980@yahoo.com>
@ 2005-11-21 18:22 ` Jeff Frost <jeff@frostconsultingllc.com>
  3 siblings, 0 replies; 6+ messages in thread

From: Jeff Frost @ 2005-11-21 18:22 UTC (permalink / raw)
  To: Nirmal Kumar <nirmal1980@yahoo.com>; +Cc: pgsql-admin

What is the explain analyze output of the query which is slow?  What does your 
data look like?  What's your postgresql.conf look like?


On Mon, 21 Nov 2005, Nirmal Kumar 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
>
>
>
>
> __________________________________
> Yahoo! FareChase: Search multiple travel sites in one click.
> http://farechase.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>
>

-- 
Jeff Frost, Owner 	<jeff@frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 650-780-7908	FAX: 650-649-1954



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres Database slow
  2005-11-21 15:04 Postgres Database slow Nirmal Kumar <nirmal1980@yahoo.com>
@ 2005-11-21 19:10 ` Brad Nicholson <bnichols@ca.afilias.info>
  3 siblings, 0 replies; 6+ messages in thread

From: Brad Nicholson @ 2005-11-21 19:10 UTC (permalink / raw)
  To: pgsql-admin

Nirmal Kumar 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
>
>  
>
Nope,  because you haven't given anything for us to work with.

It could the database configuration.  It could be the hardware.  It 
could be poorly written queries.  It could be that you aren't vacuuming 
the database often enough, ect, ect.

A good place to start looking would be to use the explain command to 
look at the query plans for some of your queries.  Post some to the list 
if you need a hand.



-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.





^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2005-11-24 15:47 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-21 15:04 Postgres Database slow Nirmal Kumar <nirmal1980@yahoo.com>
2005-11-21 16:45 ` Jim C. Nasby <jnasby@pervasive.com>
2005-11-21 16:51 ` Jaime Casanova <systemguards@gmail.com>
2005-11-24 15:47   ` Jaime Casanova <systemguards@gmail.com>
2005-11-21 18:22 ` Jeff Frost <jeff@frostconsultingllc.com>
2005-11-21 19:10 ` Brad Nicholson <bnichols@ca.afilias.info>

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