From:
Gregory Stark <stark(at)enterprisedb(dot)com>
To:
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"Hannes Dorbath" <light(at)theendofthetunnel(dot)de>, <pgsql-general(at)postgresql(dot)org>
Subject:
Re: Index trouble with 8.3b4
Date:
2008-01-07 15:18:46
Message-ID:
873at97jft.fsf@oxford.xeocode.com (view raw or flat )
Thread:
2008-01-06 19:42:00 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-07 02:22:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-07 14:46:19 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-07 15:18:46 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-07 16:15:35 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-07 16:43:50 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-13 18:50:51 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 19:02:34 from "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
2008-01-13 19:39:27 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 19:48:29 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 19:55:59 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 20:54:50 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-13 21:01:49 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-13 22:14:34 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-14 00:15:21 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-14 00:31:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-13 23:52:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-14 01:43:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-14 10:44:42 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-14 15:36:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-14 17:59:45 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
2008-01-14 11:36:18 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-14 21:29:18 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-01-14 21:53:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-15 02:51:42 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-15 03:10:54 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-15 13:33:43 from Kenneth Marshall <ktm(at)rice(dot)edu>
2008-01-15 17:27:15 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-01-15 19:01:32 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-15 19:22:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-08 23:21:27 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-08 23:47:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-09 02:03:26 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-01-09 02:33:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-01-09 03:18:22 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2008-01-07 19:46:01 from Hannes Dorbath <light(at)theendofthetunnel(dot)de>
Lists:
pgsql-general pgsql-hackers
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> I didn't have any luck reproducing either of these behaviors --- maybe
> it's data-dependent. Can you extract a test case?
I haven't been able to reproduce this either but I produced an entirely
different problem:
postgres=# create index concurrently dg5 on doc using gin (to_tsvector('english',d));
ERROR: deadlock detected
DETAIL: Process 7076 waits for ShareLock on unrecognized locktag type 5; blocked by process 10497.
Process 10497 waits for ShareUpdateExclusiveLock on relation 24656 of database 11511; blocked by process 7076.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!
In response to
Responses
pgsql-hackers by date
Next :From: Andrew SullivanDate: 2008-01-07 15:41:46Subject : Re: Dynamic Partitioning using Segment Visibility MapsPrevious :From : Kevin GrittnerDate : 2008-01-07 15:01:50Subject : Re: OUTER JOIN performance regression remains in8.3beta4
pgsql-general by date
Next :From: mljvDate: 2008-01-07 15:31:40Subject : File system level backup from 32bit to 64bitPrevious :From : Dennis BrakhaneDate : 2008-01-07 15:01:21Subject : Can a stored procedure that creates a temp table be declared STABLE?
