Re: Suggestion on index creation for TEXT data field

indexing.^^ Hint supplies answer to 1) and 2) below. Could you please suggest on below queries. 1. How to solve the issue?. 2. What type of index is the best suited for this type of data?. Thanks for your support. Regards, PostgAnn. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Suggestion on table analyze

pute statistics"); stats->stats_valid = false; return; } You might find more information from here: https://postgis.net/support/ Though FYI PostGIS 2.2.7 is past EOL: https://postgis.net/source/ Thanks for your support. Regards, PostgAnn. -- A

Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )

'137074931866340'::bigint)                      Filter: (pi.app_id = '126502930200650'::bigint)                      Buffers: shared hit=4  Planning time: 0.297 ms  Execution time: 891.686 ms (20 rows) On Thu, May 7, 2020 at 9:17 PM David G. Johnston mailto:david.g.johns...@gma

Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query )

Can someone explain * Why It is fetching more columns and more rows, incase of inner query ? * Is there any option to really limit values with INNER JOIN, INNER query ? If yes, can you please share information on this ? Thanks in advance for your time and suggestions. Regards, Amar -- Adrian Klaver adrian.kla...@aklaver.com

Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues.

nd the attachment for reference. Thanks, Postgann. -- Adrian Klaver adrian.kla...@aklaver.com

Re: LDAP with TLS is taking more time in Postgresql 11.5

ion change with the upgrade? 2) How was the server installed from packages(if so from where?) or from source? 3) The configuration for LDAP in pg_hba.conf. 4) Pertinent information from the Postgres log. 5) Pertinent information from the system log. Regards, Mani. -- Adrian Klaver

Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg

have a char(n) column that could be enlarged before the migration. <https://support.oracle.com/knowledge/Siebel/476591_1.html> Hope this helps. And please report the version of ora2pg when asking for help. Luca -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade 10.2

at attempt. Is that possible? I don't so because it exited before it got the upgrading part. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade 10.2

bug that is not finding it when it's at the end. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade 10.2

see the actual command you ran? -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade 10.2

l. To reuse the old cluster, possibly remove the .old suffix from $PGDATA/global/pg_control; you can then restart the old cluster. " -- Adrian Klaver adrian.kla...@aklaver.com