| From: | Claire McLister <mclister(at)zeesource(dot)net> |
|---|---|
| To: | Ian Harding <iharding(at)destinydata(dot)com> |
| Cc: | pgsql general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Create index hanging |
| Date: | 2006-07-20 21:28:46 |
| Message-ID: | EA924803-AB6E-45D9-83C1-FA9F026BFB41@zeesource.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
No, this is a brand new index, so no drops.
On Jul 20, 2006, at 2:03 PM, Ian Harding wrote:
> On 7/20/06, Claire McLister <mclister(at)zeesource(dot)net> 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?
>
> I thought maybe locks, but my brief experimentation shows that locks
> don't seem to block index creation, but they do seem to block dropping
> one. Hmmm. Are you trying to drop it first?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-07-20 22:13:37 | Re: Create index hanging |
| Previous Message | Claire McLister | 2006-07-20 21:28:02 | Re: Create index hanging |