Horton

Re: Summary and Plan for Hot Standby

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Tatsuo Ishii <ishii@sraoss.co.jp>
Cc: simon@2ndQuadrant.com, ishii@postgresql.org, pgsql-hackers@postgresql.org
Date: 2009-11-19T08:59:33Z
Lists: pgsql-hackers 
Tatsuo Ishii wrote:
> Sorry for confusion. My example is under normal PostgreSQL, not under
> HS enabled.

You get the same result in standby:

postgres=# begin;
BEGIN
postgres=# prepare a(int) as insert into foo values($1);
PREPARE
postgres=# SELECT * FROM pg_locks;
  locktype  │ database │ relation │ page │ tuple │ virtualxid │
transactionid │
classid │ objid │ objsubid │ virtualtransaction │  pid  │       mode
   │ gra
nted
────────────┼──────────┼──────────┼──────┼───────┼────────────┼───────────────┼─
────────┼───────┼──────────┼────────────────────┼───────┼──────────────────┼────
─────
 relation   │    11564 │    10968 │      │       │            │
      │
        │       │          │ 2/4                │ 10449 │
AccessShareLock  │ t
 relation   │    11564 │    16384 │      │       │            │
      │
        │       │          │ 2/4                │ 10449 │
RowExclusiveLock │ t
 virtualxid │          │          │      │       │ 1/1        │
      │
        │       │          │ 1/0                │ 10419 │ ExclusiveLock
   │ t
 virtualxid │          │          │      │       │ 2/4        │
      │
        │       │          │ 2/4                │ 10449 │ ExclusiveLock
   │ t
(4 rows)

this is from a standby.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com