Re: Creating many tables gets logical replication stuck

Hi All, There was a similar problem in this discussion: Logical decoding CPU-bound w/ large number of tables https://www.postgresql.org/message-id/flat/CAHoiPjzea6N0zuCi%3D%2Bf9v_j94nfsy6y8SU7-%3Dbp4%3D7qw6_i%3DRg%40mail.gmail.com > RelfilenodeMapHash from 1024 entries to 64. The above chang

Re: Row estimates for empty tables

On Fri, Jul 24, 2020 at 09:14:04PM +0200, Pavel Stehule wrote: > pá 24. 7. 2020 v 16:38 odesílatel Christophe Pettus > napsal: > > Since we already special-case parent tables for partition sets, would a > > storage parameter that lets you either tell the planner "no, really, zero > > is reasonabl

Re: Query plan prefers hash join when nested loop is much faster

On Sat, 22 Aug 2020 at 00:35, iulian dragos wrote: > I am trying to understand why the query planner insists on using a hash join, > and how to make it choose the better option, which in this case would be a > nested loop. > | -> Index Scan using > test_result_module

Most effective and fast way to load few Tbyte of data from flat files into postgresql

Hi, what would be the fastest or most effective way to load few (5-10) TB of data from flat files into a postgresql database, including some 1TB tables and blobs? There is the copy command but there is no way for native parallelism, right? I have found pg_bulkload but haven't tested it yet. As

Re: Migration of DB2 java stored procedures to PostgreSQL

On 24/08/2020 18:31, Laurenz Albe wrote: > On Mon, 2020-08-24 at 16:32 +, Dirk Krautschick wrote: >> for a potential migration from DB2 on DB2/z to PostgreSQL I have to take >> care of a whole >> bunch of java stored procedures. Would that be a show stopper here or is a >> migration >> someho

Re: Migration of DB2 java stored procedures to PostgreSQL

On Mon, 2020-08-24 at 16:32 +, Dirk Krautschick wrote: > for a potential migration from DB2 on DB2/z to PostgreSQL I have to take care > of a whole > bunch of java stored procedures. Would that be a show stopper here or is a > migration > somehow possible or is it anyway the same because Java

Migration of DB2 java stored procedures to PostgreSQL

Hi, for a potential migration from DB2 on DB2/z to PostgreSQL I have to take care of a whole bunch of java stored procedures. Would that be a show stopper here or is a migration somehow possible or is it anyway the same because Java = Java? Any experiences/recommendations or helpful ressources

Re: BUG? Slave don't reconnect to the master

> 21 авг. 2020 г., в 17:26, Jehan-Guillaume de Rorthais > написал(а): > > On Thu, 20 Aug 2020 15:16:10 +0300 > Based on setup per node, you can probably add > 'synchronous_commit=remote_write' in the common conf. Nope. I set 'synchronous_commit=remote_write' only for 3 and 4 node clusters.

Re: Query plan prefers hash join when nested loop is much faster

On Mon, Aug 24, 2020 at 4:21 PM iulian dragos wrote: > Hi Michael, > > Thanks for the answer. It's an RDS instance using SSD storage and the > default `random_page_cost` set to 4.0. I don't expect a lot of repetitive > queries here, so I think caching may not be extremely useful. I wonder if > th

Re: Substitute Variable in select query

thanks for the reply David. In case of Colon I need to set the variable first, my requirement is my select query should prompt for the input. On Mon, 24 Aug 2020 at 10:15 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, August 24, 2020, harish supare wrote: > >> Hi Team,

Re: Substitute Variable in select query

On Mon, Aug 24, 2020 at 7:21 AM harish supare wrote: > thanks for the reply David. > > In case of Colon I need to set the variable first, my requirement is my > select query should prompt for the input. > > Please don't top-post. psql does not have a feature that will prompt users during the exe

Re: Getting away from Oracle APEX, recommendations for PostgreSQL?

perl, is the most common. but you can use C, SQL, python or any other can be activate, check: https://www.postgresql.org/docs/current/xplang.html https://www.postgresql.org/docs/current/xfunc-c.html On 2020-08-22 19:32, Dirk Krautschick wrote: Hi all, if someone wants to get away from deve

Re: Query plan prefers hash join when nested loop is much faster

Hi Michael, Thanks for the answer. It's an RDS instance using SSD storage and the default `random_page_cost` set to 4.0. I don't expect a lot of repetitive queries here, so I think caching may not be extremely useful. I wonder if the selectivity of the query is wrongly estimated (out of 500 millio

Re: Substitute Variable in select query

On Monday, August 24, 2020, harish supare wrote: > Hi Team, > > Would like to know what the substitute/input variable available in psql. > > > Oracle we use & - select a, b , c from table where a like &a; > > Is there an alternative in psql? > > > Colon - read the documentation, psql section, fo

SSL between Primary and Seconday PostgreSQL DBs

I have setup a Primary and Secondary PostgreSQL DBs.  They were setup up with basic replication then I went back and modified them to use SSL.  I am just not sure if I did it correctly.  Everything is working but I want to make sure I have the settings correctly.  I am using PostgreSQL 11.2. 

Substitute Variable in select query

Hi Team, Would like to know what the substitute/input variable available in psql. Oracle we use & - select a, b , c from table where a like &a; Is there an alternative in psql? -- Best Regards Harish.