| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomasz Ostrowski | 2008-02-22 19:59:08 | Re: Selecting large objects stored as bytea |
| Previous Message | Enrico | 2008-02-22 17:19:08 | Re: Function problem |