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
>
>