Re: Suggestion on index creation for TEXT data field

2020-05-21 Thread Adrian Klaver
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

2020-05-21 Thread Adrian Klaver
stics"); 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. -- Adrian Klav

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

2020-05-07 Thread Adrian Klaver
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...@gmail.com>> wrote: On Thu, May 7, 2020 at 7:40 AM Adrian Klav

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

2020-05-07 Thread Adrian Klaver
es, 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.

2020-04-02 Thread Adrian Klaver
e find the attachment for reference. Thanks, Postgann. -- Adrian Klaver adrian.kla...@aklaver.com

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

2020-02-24 Thread Adrian Klaver
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 adrian.kla

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

2019-08-13 Thread Adrian Klaver
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

2018-06-12 Thread Adrian Klaver
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

2018-06-12 Thread Adrian Klaver
that there is a bug that is not finding it when it's at the end. -- Adrian Klaver adrian.kla...@aklaver.com

Re: pg_upgrade 10.2

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

Re: pg_upgrade 10.2

2018-06-12 Thread Adrian Klaver
ntrol. 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