Re: How to debug authentication issues in Postgres

On Fri, 2020-11-27 at 12:44 +0530, Hemil Ruparel wrote: > I have a remote database which I can connect to using psql command line tool > as well as PgAdmin4. But I would really like to use DataGrip. But whenever I > try to connect, it gives me fatal: password > authentication failed and prompts m

How to debug authentication issues in Postgres

I have a remote database which I can connect to using psql command line tool as well as PgAdmin4. But I would really like to use DataGrip. But whenever I try to connect, it gives me fatal: password authentication failed and prompts me for another password. I raised an issue in DataGrip and I was to

Re: postgres_fdw insert extremely slow

On Thu, 2020-11-26 at 09:07 -0800, Adrian Klaver wrote: > So even if Mats where to break this query: > > INSERT INTO foreign.labels (address, labels) > SELECT address_id, ARRAY_AGG(name) AS labels > FROM labels > GROUP BY 1 > LIMIT 100; > > down into something like this: > > INSERT INTO foreign.

Re: Transaction isolation level Repeatable Read Read Only vs Serializable Read Only

On Thu, 2020-11-26 at 23:45 +0100, Jan Behrens wrote: > I understand that in a read+write scenario, two concurrent transactions may > still lead to > a result that could not have occurred if those two transactions were > executed one after the other. > However, in a read-only case, I do not see

Re: Transaction isolation level Repeatable Read Read Only vs Serializable Read Only

On Thu, 26 Nov 2020 19:13:53 -0500 Mohamed Wael Khobalatte wrote: > > > > Thus, what does SERIALIZABLE READ ONLY achieve that REPEATABLE READ READ > > ONLY does not? And what is SERIALIZABLE READ ONLY DEFERRABLE for? > > > > There is a nice walkthrough of the "control" and "batches/details" scen

Re: Transaction isolation level Repeatable Read Read Only vs Serializable Read Only

> > Thus, what does SERIALIZABLE READ ONLY achieve that REPEATABLE READ READ > ONLY does not? And what is SERIALIZABLE READ ONLY DEFERRABLE for? > There is a nice walkthrough of the "control" and "batches/details" scenario mentioned in the docs, you can find it in the wiki,

Transaction isolation level Repeatable Read Read Only vs Serializable Read Only

Dear all, I have some questions regarding the transaction isolation level REPEATABLE READ and it's documentation at [1] https://www.postgresql.org/docs/13/transaction-iso.html and [2] https://www.postgresql.org/docs/13/sql-set-transaction.html As far as I understood, a read-only transaction wit

Re: Potential BRIN Index Corruption

> > Thanks Alvaro for pointing me to pageinspect. I will give it a try and > report back. It might take a few days. I knew this module but have never > tried it before. >

Re: postgres_fdw insert extremely slow

On 11/25/20 11:18 AM, Tom Lane wrote: Mats Julian Olsen writes: I've got some more numbers here: ... To me this does indicate some sort of networking issue, but I'm wondering if INSERTs are treated differently than SELECTs in postgres_fdw? The only feasibly explanation I have is that postgres_f