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

reindexing

From: "LARC/J(dot)L(dot)Shipman/jshipman" <Jeffery(dot)L(dot)Shipman(at)nasa(dot)gov>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: reindexing
Date: 2008-02-22 18:24:53
Message-ID: F2E8F26D-4369-48B9-BF17-D7F84430E27B@nasa.gov (view raw or flat)
Thread:
Lists: pgsql-general
Hi,
	I am reindexing my 7.1.4 postgres database.  The postmaster seems to  
create processes for each reindex request.  Is there any way to find  
out more about the processes.

ps -aef | grep postgres

yields the following, but does not tell me which table is being  
reindexed or anything meaningful
about the process.


postgres   605   604   0   Feb 18 ?           0:00 /usr/local/pgsql/ 
bin/postmaster
postgres  5599   579   0   Feb 21 ?          39:12 /usr/local/pgsql/ 
bin/postmaster
postgres 20101   579   0 10:56:52 ?           0:58 /usr/local/pgsql/ 
bin/postmaster
postgres   579     1   0   Feb 18 ?           0:02 /usr/local/pgsql/ 
bin/postmaster
postgres   604   579   0   Feb 18 ?           0:00 /usr/local/pgsql/ 
bin/postmaster
   dspace 21563 21391   0 13:27:00 pts/3       0:00 grep postgres
postgres  5645   579   0   Feb 21 ?          35:29 /usr/local/pgsql/ 
bin/postmaster
postgres 19695   579   0 10:13:22 ?           2:51 /usr/local/pgsql/ 
bin/postmaster
postgres 19713   579   0 10:15:02 ?           2:43 /usr/local/pgsql/ 
bin/postmaster
postgres  7441   579   0   Feb 21 ?          33:49 /usr/local/pgsql/ 
bin/postmaster
postgres 19963   579   0 10:42:25 ?           1:43 /usr/local/pgsql/ 
bin/postmaster
postgres 19658   579   0 10:09:56 ?           2:52 /usr/local/pgsql/ 
bin/postmaster
postgres 19981   579   0 10:44:43 ?           2:20 /usr/local/pgsql/ 
bin/postmaster
postgres  6276   579   0   Feb 21 ?          39:12 /usr/local/pgsql/ 
bin/postmaster
postgres 19667   579   0 10:10:56 ?           2:25 /usr/local/pgsql/ 
bin/postmaster
postgres  5654   579   0   Feb 21 ?          36:36 /usr/local/pgsql/ 
bin/postmaster
postgres  5657   579  20   Feb 21 ?          33:06 /usr/local/pgsql/ 
bin/postmaster
postgres  5656   579   0   Feb 21 ?          39:17 /usr/local/pgsql/ 
bin/postmaster
postgres  6216   579   0   Feb 21 ?          31:02 /usr/local/pgsql/ 
bin/postmaster
postgres  7508   579   0   Feb 21 ?          29:03 /usr/local/pgsql/ 
bin/postmaster
postgres 20159   579   0 11:03:25 ?           2:22 /usr/local/pgsql/ 
bin/postmaster
postgres  6275   579   0   Feb 21 ?          35:12 /usr/local/pgsql/ 
bin/postmaster
postgres  7474   579   0   Feb 21 ?          32:07 /usr/local/pgsql/ 
bin/postmaster
postgres 19884   579   0 10:33:52 ?           1:38 /usr/local/pgsql/ 
bin/postmaster
postgres  5655   579   0   Feb 21 ?          35:42 /usr/local/pgsql/ 
bin/postmaster
postgres 20100   579   0 10:56:43 ?           2:04 /usr/local/pgsql/ 
bin/postmaster
postgres  5598   579   0   Feb 21 ?          40:22 /usr/local/pgsql/ 
bin/postmaster
postgres 20259   579   0 11:15:33 ?           2:04 /usr/local/pgsql/ 
bin/postmaster
postgres 19696   579  19 10:13:57 ?           2:07 /usr/local/pgsql/ 
bin/postmaster
postgres  7509   579   0   Feb 21 ?          34:43 /usr/local/pgsql/ 
bin/postmaster
postgres 19946   579   0 10:40:11 ?           1:12 /usr/local/pgsql/ 
bin/postmaster
postgres 20006   579   0 10:47:06 ?           2:17 /usr/local/pgsql/ 
bin/postmaster
postgres  6258   579   0   Feb 21 ?          40:08 /usr/local/pgsql/ 
bin/postmaster


Responses

pgsql-general by date

Next:From: Tomasz OstrowskiDate: 2008-02-22 19:59:08
Subject: Re: Selecting large objects stored as bytea
Previous:From: EnricoDate: 2008-02-22 17:19:08
Subject: Re: Function problem

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