| From: | konstantin knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru> |
|---|---|
| To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Unlogged tables cleanup |
| Date: | 2016-11-10 07:23:49 |
| Message-ID: | A6B2E714-F3B9-4462-B047-0EEE28AE8F83@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Nov 10, 2016, at 10:17 AM, Michael Paquier wrote:
>
> Hm.. I cannot reproduce what you see on Linux or macos. Perhaps you
> have locally a standby pointing as well to this tablespace?
No, it is latest sources from Postgres repository.
Please notice that you should create new database and tablespace to reproduce this issue.
So actually the whole sequence is
mkdir fs
initdb -D pgsql
pg_ctl -D pgsql -l logfile start
psql postgres
# create tablespace fs location '/home/knizhnik/dtm-data/fs';
# set default_tablespace=fs;
# create unlogged table foo(x integer);
# insert into foo values(generate_series(1,100000));
# ^D
pkill -9 postgres
pg_ctl -D pgsql -l logfile start
# select * from foo;
> --
> Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-11-10 07:33:12 | Re: Unlogged tables cleanup |
| Previous Message | Stefan Scheid | 2016-11-10 07:17:58 | Re: Fwd: Re: [CORE] temporal tables (SQL2011) |