Re: postgres sql assistance

2024-01-16 Thread Raul Giucich
Hi Arun, can you share the sql used for this insert. Visually it seems some character are affecting the data. Best regards, Raul El mar, 16 ene 2024 a la(s) 9:35 a.m., arun chirappurath ( arunsnm...@gmail.com) escribió: > Dear all, > > I am an accidental postgres DBA and learning things every

Re: PostgreSQL Replication

2021-02-16 Thread Raul Giucich
This article will help you https://wiki.postgresql.org/wiki/Multimaster. El mar., 16 feb. 2021 10:56, Mutuku Ndeti escribió: > Hi, > > Need some advice here. I have an application using PostgreSQL. I need to > install it on 2 servers for redundancy purposes and have 2 databases. I > need the

Re: Optimize query

2020-12-15 Thread Raul Giucich
Hi Yambu, the btree index type is optimized for this kind of operators (>, >=, <, <=, =). For deep understanding on how to plan an query optimization I would recommend https://classroom.google.com/c/MTQ4MzczNDExMjM4 and https://use-the-index-luke.com. Another tip is use in the select clause only