User Hassan Baig

34 votes

1 answer

35k views

DELETE rows which are not referenced in other table

asked Apr 3, 2016 at 14:15

32 votes

4 answers

111k views

How to add a column with a foreign key constraint to a table that already exists?

asked Mar 12, 2016 at 1:53

20 votes

2 answers

36k views

Dealing with disk space full in postgresql

asked Mar 18, 2017 at 13:06

17 votes

1 answer

23k views

Disk space unreleased after cleaning up rows from PG table

asked Sep 27, 2017 at 12:36

11 votes

2 answers

28k views

Deleting old postgresql log files (Ubuntu)

asked Mar 26, 2016 at 12:22

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

6 votes

1 answer

15k views

Releasing disk space by using DELETE or TRUNCATE?

asked Jan 11, 2017 at 17:45

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

Optimizing slow performance of simple SELECT query

asked Oct 7, 2017 at 13:02

4 votes

3 answers

14k views

Setting location of temp files for Postgresql backend (9.3.10)

asked Mar 19, 2017 at 8:49

4 votes

2 answers

2k views

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

asked Oct 25, 2016 at 0:01

4 votes

1 answer

8k views

Postgresql error: failed to re-find parent key in index

asked Apr 20, 2016 at 7:18

3 votes

0 answers

606 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

2 votes

1 answer

4k views

Time taken by VACUUM FULL to reclaim space

asked Sep 28, 2017 at 15:24

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

2 votes

0 answers

668 views

Manual postgres migration for Django (python) app

asked Feb 28, 2016 at 14:16

2 votes

0 answers

740 views

Amount by which to increase checkpoint_segments (postgresql)

asked Nov 30, 2016 at 4:04

1 vote

1 answer

7k views

PgBouncer log management

asked Dec 12, 2016 at 9:51

1 vote

2 answers

784 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

986 views

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

asked Mar 21, 2017 at 11:59

1 vote

1 answer

8k views

Deleting aged postgresql rows with foreignkey constraints

asked Feb 29, 2016 at 20:48

1 vote

1 answer

195 views

Deleting aged postgresql rows with tricky condition

asked Mar 27, 2016 at 10:04

1 vote

1 answer

154 views

Tricky condition for PostgreSQL UPDATE query

asked May 1, 2016 at 9:06

1 vote

1 answer

4k views

Postgresql maintainenace queries fail with foreignkey violation

asked May 9, 2016 at 21:42

1 vote

2 answers

4k views

Routinely deleting aged postgresql rows via cron

asked Jun 24, 2016 at 9:39

1 vote

1 answer

2k views

Postgresql log rotation

asked Jul 1, 2016 at 11:38

1 vote

1 answer

1k views

Slow query performance of simple SELECT query (Postgresql 9.6)

asked Jan 27, 2019 at 21:01

1 vote

1 answer

49 views

Optimizing SELECT query consistently showing up in slow-log

asked Jan 30, 2019 at 20:26

1 vote

1 answer

3k views

Speeding up very slow UPDATE query (Postgresql 9.6)

asked Nov 11, 2019 at 12:02

1 vote

2 answers

635 views

Explaining recurring crash in postgresql deployment

asked May 15, 2020 at 2:32

Stack Exchange Network

43 Questions

DELETE rows which are not referenced in other table

How to add a column with a foreign key constraint to a table that already exists?

Dealing with disk space full in postgresql

Disk space unreleased after cleaning up rows from PG table

Deleting old postgresql log files (Ubuntu)

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

Releasing disk space by using DELETE or TRUNCATE?

Deleting records from tables containing FK pointing to each other

Optimizing slow performance of simple SELECT query

Setting location of temp files for Postgresql backend (9.3.10)

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

Postgresql error: failed to re-find parent key in index

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

Time taken by VACUUM FULL to reclaim space

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

Manual postgres migration for Django (python) app

Amount by which to increase checkpoint_segments (postgresql)

PgBouncer log management

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

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

Deleting aged postgresql rows with foreignkey constraints

Deleting aged postgresql rows with tricky condition

Tricky condition for PostgreSQL UPDATE query

Postgresql maintainenace queries fail with foreignkey violation

Routinely deleting aged postgresql rows via cron

Postgresql log rotation

Slow query performance of simple SELECT query (Postgresql 9.6)

Optimizing SELECT query consistently showing up in slow-log

Speeding up very slow UPDATE query (Postgresql 9.6)

Explaining recurring crash in postgresql deployment