User Arkhena

14 votes

Accepted

differences between hot standby vs warm standby postgresql？

answered Jan 25, 2019 at 9:09

11 votes

Accepted

Postgres seems to ignore listen_addresses setting

answered Jul 19, 2017 at 14:52

7 votes

Accepted

What happens if I interrupt or cancel `pg_upgradecluster`?

answered May 12, 2017 at 7:34

7 votes

Postresql replication pg_basebackup no pg_hbaconf entry for replication connection

answered May 10, 2017 at 10:44

4 votes

Accepted

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

answered Apr 18, 2017 at 17:45

4 votes

Why is PostgreSQL choosing the more expensive join order?

answered Jan 18, 2019 at 10:07

4 votes

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

answered Feb 12, 2019 at 10:12

4 votes

Accepted

Run PSQL command from bash script

answered Nov 21, 2022 at 13:14

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

answered Mar 20, 2021 at 9:43

3 votes

How to speed up query with anti-joins

answered Jan 30, 2019 at 7:29

3 votes

Materialized views Performance

answered Feb 25, 2019 at 13:52

3 votes

Accepted

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

answered Jul 5, 2018 at 15:32

3 votes

Accepted

PostgreSQL service start failed on CentOS 7

answered Jul 19, 2017 at 9:33

3 votes

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

answered Apr 18, 2017 at 7:15

3 votes

Accepted

Go back in time from a PostgreSQL backup using xlog

answered May 15, 2017 at 6:17

3 votes

How to verify that postgres 9.3 db has no corruption?

answered May 15, 2017 at 8:04

2 votes

Post Mortem Analysis: PostgreSQL replication failed

answered Jul 18, 2017 at 12:35

2 votes

Accepted

How to do PostgreSQL replication on CentOS 7?

answered Jul 19, 2017 at 14:20

2 votes

Setting locale for Chinese characters in Postgresql

answered Jul 21, 2017 at 14:04

2 votes

Accepted

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

answered Jan 17, 2019 at 10:47

2 votes

Best practice for creating tablespaces in Postgresql

answered Feb 25, 2019 at 14:03

2 votes

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

answered Feb 21, 2019 at 10:28

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

answered Jan 24, 2019 at 17:49

2 votes

Find friends of friends (recursively) efficiently using Postgresql

answered Mar 19, 2021 at 9:56

2 votes

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

answered Mar 24, 2021 at 14:01

2 votes

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

answered Sep 6, 2022 at 5:06

1 vote

Accepted

Postgresql 11 - service doesn't start

answered Mar 21, 2021 at 10:12

1 vote

index for ILIKE on postgresql, inconsistent performance

answered Jun 14, 2019 at 10:07

1 vote

Where does Postgres store all statistics?

answered Feb 21, 2019 at 15:36

1 vote

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

answered Jan 30, 2019 at 7:36

Stack Exchange Network

69 Answers

differences between hot standby vs warm standby postgresql？

Postgres seems to ignore listen_addresses setting

What happens if I interrupt or cancel `pg_upgradecluster`?

Postresql replication pg_basebackup no pg_hbaconf entry for replication connection

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

Why is PostgreSQL choosing the more expensive join order?

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

Run PSQL command from bash script

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

How to speed up query with anti-joins

Materialized views Performance

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

PostgreSQL service start failed on CentOS 7

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

Go back in time from a PostgreSQL backup using xlog

How to verify that postgres 9.3 db has no corruption?

Post Mortem Analysis: PostgreSQL replication failed

How to do PostgreSQL replication on CentOS 7?

Setting locale for Chinese characters in Postgresql

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

Best practice for creating tablespaces in Postgresql

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

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

Find friends of friends (recursively) efficiently using Postgresql

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

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

Postgresql 11 - service doesn't start

index for ILIKE on postgresql, inconsistent performance

Where does Postgres store all statistics?

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