Re: [GENERAL] four template0 databases after vacuum

2016-02-14 Thread Kazuaki Fujikura
| C | =c/postgres + === >How are the databases created? We create database at createdb command. ex) createdb -O user -E UTF8 --lc-ctype ja_JP.UTF8 -T template0 Best regards, Kazuaki Fujikura 2016-02-11 4:41 GMT+09:00 Adrian

Re: [GENERAL] four template0 databases after vacuum

2016-02-10 Thread Kazuaki Fujikura
h we can try before scheduled maintenance, that is much appreciated. Best regards, Kazuaki Fujikura 2016-02-09 1:51 GMT+09:00 Adrian Klaver : > On 02/08/2016 04:16 AM, Kazuaki Fujikura wrote: > >> Thank you for your comments. >> >> First, I think I need to tell you our d

Re: [GENERAL] four template0 databases after vacuum

2016-02-08 Thread Kazuaki Fujikura
2 | (36,28) | template0 | 10 |6 | C | C| t | f| -1 | 12772 | 2264969019 | 1663 | {=c/pos tgres,postgres=CTc/postgres} (4 rows) === oid is same value. But ctid is different values.

[GENERAL] four template0 databases after vacuum

2016-02-06 Thread Kazuaki Fujikura
I think our production service will be down because it exceeds the limit of xid. I guess if I drop all template0 and create template0 again, then everything gets back normal. But I am not quite sure if my approach is right. I would appreciate any suggestion/comments. Best regards, Kazuaki Fujikura