reindexing - Mailing list pgsql-general

From LARC/J.L.Shipman/jshipman
Subject reindexing
Date
Msg-id F2E8F26D-4369-48B9-BF17-D7F84430E27B@nasa.gov
Whole thread Raw
Responses Re: reindexing
List 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


pgsql-general by date:

Previous
From: "D. Dante Lorenso"
Date:
Subject: Cascading Trigger - changing row on delete does not delete row
Next
From: "D. Dante Lorenso"
Date:
Subject: Cascading Trigger - changing row on delete does not delete row