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

Re: Postgres Database slow

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Nirmal Kumar <nirmal1980(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres Database slow
Date: 2005-11-21 16:45:54
Message-ID: 20051121164554.GS19279@pervasive.com (view raw or flat)
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2005-11-21 16:46:43
Subject: Re: Server Hardware Configuration
Previous:From: Jim C. NasbyDate: 2005-11-21 16:43:42
Subject: Re: Batch Files

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