User Hassan Baig

1 vote

2 answers

918 views

Explaining recurring crash in postgresql deployment

asked May 15, 2020 at 2:32

1 vote

1 answer

3k views

Speeding up very slow UPDATE query (Postgresql 9.6)

asked Nov 11, 2019 at 12:02

0 votes

0 answers

767 views

Possibility of using self-referential foreign key to create hierarchical comments

asked Jul 9, 2019 at 8:54

0 votes

0 answers

494 views

Running REINDEX in a live environment (POSTGRESQL 9.6.10)

asked Feb 13, 2019 at 6:55

1 vote

1 answer

51 views

Optimizing SELECT query consistently showing up in slow-log

asked Jan 30, 2019 at 20:26

0 votes

1 answer

64 views

Optimizing slow SELECT query (postgresql 9.6.5)

asked Jan 28, 2019 at 12:51

0 votes

1 answer

148 views

Speeding up slow SELECT query (Postgresql 9.6)

asked Jan 28, 2019 at 7:34

1 vote

1 answer

1k views

Slow query performance of simple SELECT query (Postgresql 9.6)

asked Jan 27, 2019 at 21:01

-2 votes

2 answers

1k views

Optimizing performance of basic select count (*) query on large postgresql 9.6.5 table [closed]

asked Sep 10, 2018 at 13:43

3 votes

0 answers

687 views

Spike in Disk I/O due to external process causing PostgreSQL commits to pile up in the slow log

asked Oct 22, 2017 at 4:44

0 votes

1 answer

2k views

How to configure port for listening to traffic meant for PostgreSQL

asked Oct 19, 2017 at 7:57

6 votes

1 answer

18k views

Optimizing slow performance of simple SELECT query

asked Oct 7, 2017 at 13:02

0 votes

1 answer

711 views

Getting pg_dump and pg_restore right for postgresl (9.3.10)

asked Sep 28, 2017 at 18:40

3 votes

1 answer

5k views

Time taken by VACUUM FULL to reclaim space

asked Sep 28, 2017 at 15:24

0 votes

1 answer

36 views

Optimizing postgresql maintenance statements on psql

asked Sep 27, 2017 at 14:15

18 votes

1 answer

27k views

Disk space unreleased after cleaning up rows from PG table

asked Sep 27, 2017 at 12:36

0 votes

1 answer

2k views

Slow performance of simple maintenance/deletion query on postgres 9.3.10 table [duplicate]

asked Sep 26, 2017 at 16:18

1 vote

1 answer

1k views

Deleting old files in /var/lib/postgresql/9.x/main after changing postgresql data_directory

asked Mar 21, 2017 at 11:59

5 votes

3 answers

16k views

Setting location of temp files for Postgresql backend (9.3.10)

asked Mar 19, 2017 at 8:49

8 votes

2 answers

7k views

Going out of disk space in the course of querying a postgres database

asked Mar 18, 2017 at 21:09

22 votes

2 answers

42k views

Dealing with disk space full in postgresql

asked Mar 18, 2017 at 13:06

2 votes

2 answers

3k views

External size of table still not released (as disk space) after issuing truncate command

asked Mar 16, 2017 at 6:05

6 votes

1 answer

7k views

Deleting records from tables containing FK pointing to each other

asked Feb 19, 2017 at 11:19

6 votes

1 answer

16k views

Releasing disk space by using DELETE or TRUNCATE?

asked Jan 11, 2017 at 17:45

1 vote

2 answers

799 views

Finding count of objects within a specified time window in SQL (Postgresql DB)

asked Dec 26, 2016 at 11:48

1 vote

1 answer

8k views

PgBouncer log management

asked Dec 12, 2016 at 9:51

2 votes

0 answers

775 views

Amount by which to increase checkpoint_segments (postgresql)

asked Nov 30, 2016 at 4:04

0 votes

1 answer

3k views

Measuring how long a query is IDLE IN TRANSACTION (postgresql + Django app)

asked Nov 27, 2016 at 11:02

0 votes

1 answer

1k views

controlling postgresql log generation

asked Nov 18, 2016 at 22:48

4 votes

2 answers

2k views

Should PgBouncer be installed on web application server or database server?

asked Oct 25, 2016 at 0:01

Stack Exchange Network

43 Questions

Explaining recurring crash in postgresql deployment

Speeding up very slow UPDATE query (Postgresql 9.6)

Possibility of using self-referential foreign key to create hierarchical comments

Running REINDEX in a live environment (POSTGRESQL 9.6.10)

Optimizing SELECT query consistently showing up in slow-log

Optimizing slow SELECT query (postgresql 9.6.5)

Speeding up slow SELECT query (Postgresql 9.6)

Slow query performance of simple SELECT query (Postgresql 9.6)

Optimizing performance of basic select count (*) query on large postgresql 9.6.5 table [closed]

Spike in Disk I/O due to external process causing PostgreSQL commits to pile up in the slow log

How to configure port for listening to traffic meant for PostgreSQL

Optimizing slow performance of simple SELECT query

Getting pg_dump and pg_restore right for postgresl (9.3.10)

Time taken by VACUUM FULL to reclaim space

Optimizing postgresql maintenance statements on psql

Disk space unreleased after cleaning up rows from PG table

Slow performance of simple maintenance/deletion query on postgres 9.3.10 table [duplicate]

Deleting old files in /var/lib/postgresql/9.x/main after changing postgresql data_directory

Setting location of temp files for Postgresql backend (9.3.10)

Going out of disk space in the course of querying a postgres database

Dealing with disk space full in postgresql

External size of table still not released (as disk space) after issuing truncate command

Deleting records from tables containing FK pointing to each other

Releasing disk space by using DELETE or TRUNCATE?

Finding count of objects within a specified time window in SQL (Postgresql DB)

PgBouncer log management

Amount by which to increase checkpoint_segments (postgresql)

Measuring how long a query is IDLE IN TRANSACTION (postgresql + Django app)

controlling postgresql log generation

Should PgBouncer be installed on web application server or database server?