pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gurudutt <guru@indvalley.com>
To: pgsql-sql@postgresql.org
Subject: Resources
Date: Thu, 10 Jan 2002 19:03:29 +0530
Message-ID: <4423720517.20020110190329@indvalley.com> (raw)

Hi,

I have a pentium III server, running on RHL 7.1 with 256 MB RAM,

The following is output of the "top" command for query which involves
fetch from a table with about MAX of 10,000 rows.

-------------------------------------TOP------------------------------
  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND

 3174 postgres  19   0  3328 3328  2672 R    99.0  1.3   0:58 postmaster
 1199 nobody     9   0  3728 3728  2704 S     0.5  1.4   0:03 httpd
 3035 root      10   0  1048 1048   840 R     0.3  0.4   0:15 top
    1 root       8   0   544  544   472 S     0.0  0.2   0:04 init
    2 root       9   0     0    0     0 SW    0.0  0.0   0:00 keventd
    3 root


Now, my question is, it takes ages(2 mints) for the query to run (regularly
VACUUM ANALYZED Database) and if you look closely at the resources
consumed by the postgres, it is almost taking away 100% CPU time.

How can we make it faster and to consume less resources ??

Can anybody suggest the steps they are taking for time-critical
applications to run efficiently.

Thanks in advance

-- 
Best regards,
 Gurudutt                          mailto:guru@indvalley.com

Life is not fair - get used to it.
Bill Gates




view thread (18+ messages)  latest in thread

Message-ID: <4423720517.20020110190329@indvalley.com>
Permalink:  ../4423720517.20020110190329@indvalley.com/
Also on:    postgresql.org/message-id/4423720517.20020110190329@indvalley.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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: guru@indvalley.com
  Subject: Re: Resources
  In-Reply-To: <4423720517.20020110190329@indvalley.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