Re: [PERFORM] Speeding up JSON + TSQUERY + GIN

2017-02-27 Thread Jeff Janes
On Sun, Feb 26, 2017 at 5:28 AM, Sven R. Kunze wrote: > > > Using "select pg_prewarm('docs');" and on any of the indexes doesn't help > either. > After a "systemctl stop postgresql.service && sync && echo 3 > > /proc/sys/vm/drop_caches && systemctl start postgresql.service" the age=20, > 30 or na

Re: [PERFORM] Speeding up JSON + TSQUERY + GIN

2017-02-27 Thread Sven R. Kunze
Thanks Oleg for your reply. On 26.02.2017 21:13, Oleg Bartunov wrote: On Sun, Feb 26, 2017 at 4:28 PM, Sven R. Kunze >wrote: create index docs_meta_idx ON docs using gin (meta jsonb_path_ops); create index docs_name_idx ON docs using gin (to_tsvector('english

Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ?

2017-02-27 Thread Dinesh Chandra 12108
Hi, I run the below command [postgres@CPPMoma-DB05 bin]$ pg_dump -U postgres moma_ts_oce; echo $ Output was like this(Last few lines ) -- -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FR

Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ?

2017-02-27 Thread vinny
On 2017-02-27 14:29, John Gorman wrote: Even though it's not listed in any of the documentation or “pg_dump --help” you can check the return code of the process. A return code greater than 0 (zero) usually indicates a failure ./bin >pg_dump -U dummy_user dummy_database; echo $? 1 FROM: pgsql-

Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ?

2017-02-27 Thread John Gorman
Even though it's not listed in any of the documentation or “pg_dump --help” you can check the return code of the process. A return code greater than 0 (zero) usually indicates a failure ./bin >pg_dump -U dummy_user dummy_database; echo $? 1 From: pgsql-performance-ow...@postgresql.org [mailto

Re: [PERFORM] How Can I check PostgreSQL backup is successfully or not ?

2017-02-27 Thread Rick Otten
Although it doesn't really tell if the pg_dump was successful (you'll need to do a full restore to be sure), I generate an archive list. If that fails, the backup clearly wasn't successful, and if it succeeds, odds are pretty good that it worked: -- bash code snippet -- archiveList=`pg_restore -l

[PERFORM] How Can I check PostgreSQL backup is successfully or not ?

2017-02-27 Thread Dinesh Chandra 12108
Hi, We are taking daily full backup of PostgreSQL database using PG_DUMP which is automatic scheduled through Cronjobs. How can I check my yesterday backup is successfully or not? Is there any query or view by which I can check it? Regards, Dinesh Chandra |Database administrator (Oracle/Postgre