Re: Summary and Plan for Hot Standby

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