Thanks. Haven't VACUUMed ever. (Sloppy housekeeping:-)
Will do so and let you know if it helped.
There seems to have been some other problem too. I had to just now
forcefully shut down the postmaster and re-start it as it was
beginning to block on other requests as well.
If I Ctl-C the PSQL command for create index, it shouldn't cause a
problem, right?
On Jul 20, 2006, at 1:48 PM, Will Glynn wrote:
On Jul 20, 2006, at 4:11 PM, Claire McLister wrote:
Hi,
We have a couple of tables (40,000 and 600,000 rows each) that I
am trying to build an index on an integer column.
When I issue the "create index foo_index on foo(id);" command in
psql it just does not return. I've waited over half an hour for
the smaller table.
The same command worked with no problems on a test environment
with roughly the same data.
Any ideas what may be going on? When I use the "top" command, I
don't see postmaster as working during this time. So I suspect
that the create index has gone in some sort of a wait mode.
Will appreciate any suggestions.
Thanks
Claire
Have you VACUUMed recently? I've seen this happen when there's a
ridiculous number of dead rows in the table.
--Will Glynn
Freedom Health Systems
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
