Re: zheap: a new storage format for PostgreSQL - Mailing list pgsql-hackers

From Daniel Westermann
Subject Re: zheap: a new storage format for PostgreSQL
Date
Msg-id AM4PR0901MB1346FE25AB44195995860734D2D80@AM4PR0901MB1346.eurprd09.prod.outlook.com
Whole thread Raw
In response to Re: zheap: a new storage format for PostgreSQL  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: zheap: a new storage format for PostgreSQL  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers

> Thanks, it makes difference and keep us motivated for making progress.
+1

Is it intended behavior that a database can not be dropped when undo apply is running in the background?

zheap=# update pgbench_accounts set filler = 'bbb' where mod(aid,10) = 0;
UPDATE 1000000
zheap=# rollback;
ROLLBACK
zheap=# drop database zheap;
ERROR:  cannot drop the currently open database
zheap=# \c postgres
You are now connected to database "postgres" as user "postgres".
postgres=# drop database zheap;
ERROR:  database "zheap" is being accessed by other users
DETAIL:  There is 1 other session using the database.
postgres=# drop database zheap;
ERROR:  database "zheap" is being accessed by other users
DETAIL:  There is 1 other session using the database.
postgres=#

Regards
Daniel

pgsql-hackers by date:

Previous
From: Amit Khandekar
Date:
Subject: Re: TupleTableSlot abstraction
Next
From: Tomas Vondra
Date:
Subject: Re: logical decoding vs. VACUUM FULL / CLUSTER on table with TOAST-eddata