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@xxxxxxxxxxx
Shop To It Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, AB T2G 0V9
http://www.shoptoit.ca
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@xxxxxxxxxxxxx
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
