Skip to main content
The 2024 Developer Survey results are live! See the results
Arkhena's user avatar
Arkhena's user avatar
Arkhena's user avatar
Arkhena
  • Member for 7 years, 3 months
  • Last seen more than 1 year ago
  • France
14 votes
Accepted

differences between hot standby vs warm standby postgresql?

12 votes
Accepted

Postgres seems to ignore listen_addresses setting

7 votes
Accepted

What happens if I interrupt or cancel `pg_upgradecluster`?

7 votes

Postresql replication pg_basebackup no pg_hbaconf entry for replication connection

5 votes
Accepted

If a user is created in a primary postgres database, will the user be copied to a follower?

4 votes

Why is PostgreSQL choosing the more expensive join order?

4 votes

Is there any way to determine how many rows a transaction has modified (before the transaction ends)?

4 votes
Accepted

Run PSQL command from bash script

3 votes

Given a large table (say "users") that receives many writes, which of the following SQL statements will not lock the table against writes for others

3 votes

In postgresql.conf, does the order of the listed parameters matter?

3 votes

How to speed up query with anti-joins

3 votes

Materialized views Performance

3 votes

Best practice for creating tablespaces in Postgresql

3 votes
Accepted

What is the fate of VODKA Indexing, is it dead?

3 votes
Accepted

PostgreSQL service start failed on CentOS 7

3 votes

How to install Postgresql on Ubuntu from PPA with data-checksums enabled?

3 votes
Accepted

Go back in time from a PostgreSQL backup using xlog

3 votes

How to verify that postgres 9.3 db has no corruption?

2 votes

Post Mortem Analysis: PostgreSQL replication failed

2 votes
Accepted

How to do PostgreSQL replication on CentOS 7?

2 votes

Setting locale for Chinese characters in Postgresql

2 votes
Accepted

Ensuring unique value for group of rows in table with trigger and concurrent transactions

2 votes

Postgresql Deadlock - what does "while rechecking updated tuple" mean?

2 votes

Need the name value of the enterprise to be the same as it was when it was registered and not the value it currently has

2 votes

Find friends of friends (recursively) efficiently using Postgresql

2 votes

PostgreSQL: need to routinely rotate a big table that is mentioned in a view

1 vote
Accepted

Postgresql 11 - service doesn't start

1 vote

index for ILIKE on postgresql, inconsistent performance

1 vote

Where does Postgres store all statistics?

1 vote

Postgres LIKE query using a GiST index is just as slow as a full scan