From: | Brendan Duddridge <brendan(at)shoptoit(dot)ca> |
---|---|
To: | Jim C(dot) Nasby <jnasby(at)pervasive(dot)com> |
Cc: | PostgreSQL-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: can't reindex a couple of tables |
Date: | 2006-05-15 22:05:46 |
Message-ID: | 4C03A6DB-55D2-42BA-A9FC-B7E32B0FE77E@shoptoit.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Jim,
I must have had a corrupt index as vacuum analyze verbose came back
with an error and crapped out the postgres instance. Once I re-
indexed the problem went away. This issue hasn't returned since re-
indexing.
Thanks,
brendan duddridge | CTO | 403-520-5793 x24 | brendan(at)shoptoit(dot)ca
Shop To It Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G 0V9
Canada's Shopping Search Engine!
On May 15, 2006, at 2:27 PM, Jim C. Nasby wrote:
> On Fri, May 05, 2006 at 12:41:56PM -0600, Brendan Duddridge wrote:
>> They both have a click_count column that we update with "update
>> attribute set click_count = click_count + 1;" and the same for the
>> attribute_value table. Postgres is getting hung up on any transaction
>> that attempts to update the click_count. I've vacuum analyzed both
>> tables and that worked fine. Now I tried to reindex them and Postgres
>> is just locking up and never finishing. I had to cancel the reindex.
>
> I'm sure it would finish if you gave it enough time. Why are you
> reindexing?
>
>> The attribute table has only 3434 rows in it.
>> The attribute_value table has only 548735 in it.
>>
>> Either one I try to reindex causes that Postgres connection to hang
>> until I cancel the reindex command.
>
> Try looking in pg_locks. Reindex needs an exclusive lock IIRC, so
> anything else that's hitting the table will have to finish before the
> reindex can start.
> --
> Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2006-05-15 22:11:00 | Re: understanding explain data |
Previous Message | Jim C. Nasby | 2006-05-15 22:04:26 | Re: Concatenate WAL contents |