User jjanes

65 votes

Database "frozen" on ALTER TABLE

answered Mar 22, 2016 at 19:53

36 votes

Accepted

Difference between fetched and returned tuples in postgresql

answered Oct 1, 2018 at 0:19

35 votes

Accepted

Trigram search gets much slower as search string gets longer

answered Aug 19, 2015 at 16:05

33 votes

Accepted

How to Install postgresql-client-11 on Ubuntu 18.04

answered Feb 16, 2020 at 14:35

25 votes

Accepted

How do I cleanup Postgres WAL?

answered Feb 9, 2019 at 15:58

24 votes

Accepted

Postgresql: What the default_statistics_target value really means?

answered Mar 14, 2018 at 4:00

22 votes

Accepted

Where column not like multiple values

answered Nov 17, 2015 at 17:26

19 votes

Accepted

Does cancelling an (AUTO)VACUUM process in PostgreSQL make all the work done useless?

answered Jan 7, 2017 at 4:42

17 votes

Accepted

Deleting many rows on a live table in chunks - without locking for too long (PostgreSQL 9.3)

answered Oct 3, 2015 at 15:38

17 votes

What is the Maintenance DB asked by pgAdmin?

answered Jun 11, 2014 at 22:39

16 votes

Accepted

How is it possible for Hash Index not to be faster than Btree for equality lookups?

answered Jul 19, 2018 at 19:39

15 votes

Accepted

Analyze memory usage of PostgreSQL – why is it growing constantly?

answered Sep 13, 2017 at 20:18

14 votes

Accepted

Why wouldn't VACUUM ANALYZE clear all dead tuples?

answered Sep 25, 2014 at 6:09

14 votes

Accepted

Array integer[]: how to get all distinct values in a table and count them?

answered Jan 15, 2016 at 23:13

12 votes

Accepted

What does "Heap Block" in "Bitmap Heap Scan" mean?

answered Jan 20, 2016 at 18:26

11 votes

Accepted

Why is LIMIT killing performance of this Postgres query?

answered May 28, 2018 at 21:56

11 votes

Accepted

Multi-row insert vs transactional single row inserts

answered Dec 14, 2018 at 14:28

11 votes

Accepted

UPDATE on big table in PostgreSQL randomly takes too long

answered Mar 10, 2021 at 15:15

10 votes

the cache hit rate using pg_statio_user_tables

answered Jun 7, 2015 at 17:32

10 votes

Accepted

Postgresql 10 create subscription hangs

answered Nov 27, 2017 at 13:51

10 votes

What does this error mean when doing a pg_restore on a Postgres 9.6.2 database?

answered May 30, 2017 at 19:34

10 votes

Accepted

Does PostgreSQL always sequentially scan pages in the same order?

answered Nov 27, 2020 at 22:48

10 votes

Accepted

Is there a performance or storage space advantage to lowering time/timestamp precision in PostgreSQL?

answered Sep 2, 2021 at 21:18

9 votes

Accepted

Postgres speed up index creation for large table

answered Jun 15, 2019 at 17:54

9 votes

Will autovacuum block DROP or TRUNCATE?

answered Feb 2, 2019 at 2:02

9 votes

How can I find the source of postgresql per-connection memory leaks?

answered Nov 18, 2018 at 14:59

9 votes

How to handle bad query plan caused by exact equality on range type?

answered Feb 2, 2016 at 20:51

9 votes

Accepted

Postgres: understanding amount of WAL files/size generated

answered Nov 6, 2016 at 21:12

9 votes

Handling performance problems with jit in postgres 12

answered Apr 14, 2020 at 15:29

9 votes

Accepted

When (or why even) use PLPython(3)u

answered Jul 23, 2020 at 11:48

Stack Exchange Network

1,443 Answers

Database "frozen" on ALTER TABLE

Difference between fetched and returned tuples in postgresql

Trigram search gets much slower as search string gets longer

How to Install postgresql-client-11 on Ubuntu 18.04

How do I cleanup Postgres WAL?

Postgresql: What the default_statistics_target value really means?

Where column not like multiple values

Does cancelling an (AUTO)VACUUM process in PostgreSQL make all the work done useless?

Deleting many rows on a live table in chunks - without locking for too long (PostgreSQL 9.3)

What is the Maintenance DB asked by pgAdmin?

How is it possible for Hash Index not to be faster than Btree for equality lookups?

Analyze memory usage of PostgreSQL – why is it growing constantly?

Why wouldn't VACUUM ANALYZE clear all dead tuples?

Array integer[]: how to get all distinct values in a table and count them?

What does "Heap Block" in "Bitmap Heap Scan" mean?

Why is LIMIT killing performance of this Postgres query?

Multi-row insert vs transactional single row inserts

UPDATE on big table in PostgreSQL randomly takes too long

the cache hit rate using pg_statio_user_tables

Postgresql 10 create subscription hangs

What does this error mean when doing a pg_restore on a Postgres 9.6.2 database?

Does PostgreSQL always sequentially scan pages in the same order?

Is there a performance or storage space advantage to lowering time/timestamp precision in PostgreSQL?

Postgres speed up index creation for large table

Will autovacuum block DROP or TRUNCATE?

How can I find the source of postgresql per-connection memory leaks?

How to handle bad query plan caused by exact equality on range type?

Postgres: understanding amount of WAL files/size generated

Handling performance problems with jit in postgres 12

When (or why even) use PLPython(3)u