[GENERAL] query locks up when run concurrently

Greetings! I'm using postgres version 9.5.5 on a ubuntu 16.04.1 server installation which was installed through apt-get. I have a query which if run alone usually completes in about 300ms. When run in my application this query constantly locks up and bogs down all connections of the connection

Re: [GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

Yes making the file is the problem. If you read my topic again, then you may know about what is the exact question -- View this message in context: http://postgresql.nabble.com/How-to-open-PGStrom-an-extension-of-PostgreSQL-in-Netbeans-tp5931425p5931594.html Sent from the PostgreSQL - general

Re: [GENERAL] Wal files - Question | Postgres 9.2

On Wed, Nov 23, 2016 at 1:59 PM, Patrick B wrote: > > > 2016-11-23 15:55 GMT+13:00 Venkata B Nagothi : > >> >> >> On Wed, Nov 23, 2016 at 1:03 PM, Patrick B >> wrote: >> >>> Hi guys, >>> >>> I currently have a slave02 server

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-23 15:55 GMT+13:00 Venkata B Nagothi : > > > On Wed, Nov 23, 2016 at 1:03 PM, Patrick B > wrote: > >> Hi guys, >> >> I currently have a slave02 server that is replicating from another >> slave01 via Cascading replication. The master01 server

Re: [GENERAL] Wal files - Question | Postgres 9.2

On Wed, Nov 23, 2016 at 1:03 PM, Patrick B wrote: > Hi guys, > > I currently have a slave02 server that is replicating from another slave01 > via Cascading replication. The master01 server is shipping wal_files (via > ssh) to both slaves. > > > I'm doing some tests on

[GENERAL] Wal files - Question | Postgres 9.2

Hi guys, I currently have a slave02 server that is replicating from another slave01 via Cascading replication. The master01 server is shipping wal_files (via ssh) to both slaves. I'm doing some tests on slave02 to test the recovery via wal_files... The goal here is to stop postgres, wait few

Re: [GENERAL] max_connections limit violation not showing in pg_stat_activity

On Tue, Nov 22, 2016 at 12:48 PM, Charles Clavadetscher wrote: > We are using PostgreSQL 9.3.10 on RedHat (probably 6.x). Is it possible to upgrade? You are missing over a year's worth of fixes for serious bugs and security vulnerabilities.

Re: [GENERAL] min/max_wal_size

On 11/22/2016 12:51 PM, Torsten Förtsch wrote: Hi, I am a bit confused about min_wal_size and max_wal_size. Previously, there was this formula to estimate the max number of WAL segment files in pg_xlog/ (https://www.postgresql.org/docs/9.4/static/wal-configuration.html): (2 +

[GENERAL] min/max_wal_size

Hi, I am a bit confused about min_wal_size and max_wal_size. Previously, there was this formula to estimate the max number of WAL segment files in pg_xlog/ (https://www.postgresql.org/docs/9.4/static/wal-configuration.html ): (2 + checkpoint_completion_target) * checkpoint_segments + 1 or

[GENERAL] max_connections limit violation not showing in pg_stat_activity

Hello We are using PostgreSQL 9.3.10 on RedHat (probably 6.x). The database is hosted by an internal service provider and we have superuser access to it over a PG client, e.g. psql, but not to the OS. For that reason we only have access to the log files indirectly using some of the built in

Re: [GENERAL] pg_basebackup on slave running for a long time

Thanks John, Well that clarifies about archive a lot! On 22 Nov 2016 22:22, "John R Pierce" wrote: On 11/22/2016 3:41 AM, Subhankar Chattopadhyay wrote: > John, > > Can you explain the Wal Archive procedure, how it can be setup so that > the slave never goes out of sync,

Re: [GENERAL] Streaming replication failover/failback

On Nov 18, 2016, at 5:48 AM, Jehan-Guillaume de Rorthais wrote: > > On Thu, 17 Nov 2016 08:26:59 -0900 > Israel Brewster > wrote: > >>> On Nov 16, 2016, at 4:24 PM, Adrian Klaver >>> wrote: >>> >>>

Re: [GENERAL] pg_basebackup on slave running for a long time

On 11/22/2016 3:41 AM, Subhankar Chattopadhyay wrote: John, Can you explain the Wal Archive procedure, how it can be setup so that the slave never goes out of sync, even if master deletes the WAL files? The WAL archive will typically be a separate file server that both the master and slave

Re: [GENERAL] pg_basebackup on slave running for a long time

On 11/22/2016 2:34 AM, Subhankar Chattopadhyay wrote: So, the question here is while I apply update on Slave, how do I know if if it will be able to catch up or I need Wal archive? Is there a way I can determine this? In my case, while applying update on slave, the db process will be stopped, so

Re: [GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

On 11/22/2016 12:29 AM, Mark Anns wrote: Nope. I am not asking about installation instructions. I have installed it. And I know how to run it from command line. I just wanted to compile it in netbeans. netbeans is a java-centric tool. if you can get it to run the make files, it should

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

On Tue, Nov 22, 2016 at 8:22 AM, Poul Kristensen wrote: > I think I understand. > When I use this in my code I get > "undefined reference to `PQexecParms' > ​The correct name is PQexecParams (note the last "a"). Sorry I missed that when first looking.​ Also, just to be sure,

Re: [GENERAL] Database migration to RDS issues permissions

On 11/21/2016 03:34 PM, Fran ... wrote: Hi Adrian, I followed you link and I had again errors: What was the command you used? /pg_restore: [archiver (db)] Error from TOC entry 4368; 2606 151317 FK CONSTRAINT type_id_3940becf ownersuser/ /pg_restore: [archiver (db)] could not execute

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

Poul Kristensen writes: > When I use this in my code I get > "undefined reference to `PQexecParms' > when compiling. IIRC, it's PQexecParams not PQexecParms regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

I think I understand. When I use this in my code I get "undefined reference to `PQexecParms' when compiling. references in main is const char *conninfo; /* connection string to the database */ PGconn *conn; /* connection to the database */ PGresult *res; /* result of sql query */ int nFields;

Re: [GENERAL] pg_rewind and WAL size...

On Tue, Nov 22, 2016 at 9:40 PM, wrote: > Am I doing something wrong? Would tweaking some checkpoint parameters help > reduce the WAL volume? The answer to this question is likely yes. wal_log_hints enforces a FPW for the first modification of a page even if that's for some hint

[GENERAL] pg_rewind and WAL size...

Hi, I did a series of test to see the WAL size impact of enabling data checksums/wal_log_hints on our databases (so that we can use pg_rewind to fix split brain situations). Having a set of servers available the last few days I did a few tests. Here are the results: No data checksums and

Re: [GENERAL] pg_basebackup on slave running for a long time

John, Can you explain the Wal Archive procedure, how it can be setup so that the slave never goes out of sync, even if master deletes the WAL files? On Tue, Nov 22, 2016 at 4:04 PM, Subhankar Chattopadhyay wrote: > So, the question here is while I apply update on Slave, how

Re: [GENERAL] pg_basebackup on slave running for a long time

So, the question here is while I apply update on Slave, how do I know if if it will be able to catch up or I need Wal archive? Is there a way I can determine this? In my case, while applying update on slave, the db process will be stopped, so the query, even if it gives correct value, won't help.

[GENERAL] Replication of a database or schemas from a database

We would like to have a master(read/write) version of a database (or a schema or two) on one server and a readonly version of of the same database. The only changed on the second one may be to duplicate changes to views, materialized_views and indexes that also happened on the first one. We

Re: [GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

Nope. I am not asking about installation instructions. I have installed it. And I know how to run it from command line. I just wanted to compile it in netbeans. -- View this message in context:

Re: [GENERAL] How to open PGStrom (an extension of PostgreSQL) in Netbeans?

On 11/21/2016 11:28 PM, Mark Anns wrote: Where I am missing? How can I do it? It needs CUDA also I think. did you read the installation instructions? it says nothing about netbeans, it says to use make and gcc etc. http://strom.kaigai.gr.jp/install.html#install-os don't ask me any