Postgres NOSQL Benchmarking

2021-02-06 Thread Rushikesh socha
Hi, Any suggestion on how to do PostgreSQL benchmarking for Document Store database(Nosql/jsonb). I found this https://github.com/EnterpriseDB/pg_nosql_benchmark while searching google. Please advise if there anything latest available. Thanks.

Copy json from couchbase to postgres

2020-10-26 Thread Rushikesh socha
Any suggestions on copying .json which is exported from couchbase using cbexport json. I used copy command but most of them are throwing error. pgdocstore=# copy schaname.tablename from 'path/filename.json'; ERROR: invalid input syntax for type json DETAIL: Token "H" is invalid.

Re: pg_stat_statements extension

2020-01-13 Thread Rushikesh socha
. Rushikesh Socha Edison,NJ,USA Cell : +1 860 794 4643 On Mon, Jan 13, 2020 at 2:24 PM Adrian Klaver wrote: > On 1/13/20 11:15 AM, Rushikesh socha wrote: > > HI, Is there any good link that shows how to install pg_stat_statements > > extension > > Postgres version? > > H

pg_stat_statements extension

2020-01-13 Thread Rushikesh socha
HI, Is there any good link that shows how to install pg_stat_statements extension I am getting below error postgres=# CREATE EXTENSION pg_stat_statements; ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pg_stat_statements.control": No such file or directory Thanks.