Re: [GENERAL] DATA Integrity & Recovery

I just finished a point in time  recovery  from a rsync physical data file backup + wal archive.Of course it works!You can also achieve the same goal through pg_basebackup. By your descriptions, your vendor seems to use logical backup through pg_dump. Anyway you can only achieve no data loss

Re: [GENERAL] have trouble understanding xmin and xmax with update operations from two different sessions

this chapter introduces mvcc http://www.interdb.jp/pg/pgsql05.html 原始訊息 自： rajan 日期： 2017/7/1 14:32 (GMT+08:00) 至： pgsql-general@postgresql.org 主旨： [GENERAL] have trouble understanding xmin and xmax with update operations from two different sessions

Re: [GENERAL] Oracle database into PostgreSQL using Ora2PG tool.

tell me where this function add_job_history() is?Actually, I don't think you can count on ora2pg to transform your pl/sql code to plpgsql or other (un)trusted procedural language code. It's not that simple!you can type "\df   add_job_history"  in psql session to check it's existence if it

Re: [GENERAL] Current best practice for maximum shared_buffers settings on big hardware?

for ur reference  https://madusudanan.com/blog/understanding-postgres-caching-in-depth/ 從我的 Samsung Galaxy 智慧型手機傳送。 原始訊息 自： stevenchang1213 <stevenchang1...@gmail.com> 日期： 2017/5/24 23:48 (GMT+08:00) 至： Bill Moran <wmo...@potentialtech.com> 副本： pgsql-general@post

Re: [GENERAL] Current best practice for maximum shared_buffers settings on big hardware?

for postgre share buffer issue. you will find what you want. steven 從我的 Samsung Galaxy 智慧型手機傳送。 原始訊息 自： Bill Moran <wmo...@potentialtech.com> 日期： 2017/5/24 22:52 (GMT+08:00) 至： stevenchang1213 <stevenchang1...@gmail.com> 副本： pgsql-general@postgresql.org 主旨： Re: [GENE

Re: [GENERAL] Current best practice for maximum shared_buffers settings on big hardware?

hello, at most 40% total memory, official doc also says so.you can testify it using pg_prewarm and pgfincore . btw, numa supported? if so, extra care is necessary when starting db cluster. 從我的 Samsung Galaxy 智慧型手機傳送。 原始訊息 自： Bill Moran 日期： 2017/5/24