Re: zheap: a new storage format for PostgreSQL
| От | Daniel Westermann |
|---|---|
| Тема | Re: zheap: a new storage format for PostgreSQL |
| Дата | |
| Msg-id | AM4PR0901MB1346FE25AB44195995860734D2D80@AM4PR0901MB1346.eurprd09.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: zheap: a new storage format for PostgreSQL (Amit Kapila <amit.kapila16@gmail.com>) |
| Ответы |
Re: zheap: a new storage format for PostgreSQL
|
| Список | 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=#
RegardsUPDATE 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=#
Daniel
В списке pgsql-hackers по дате отправления: