User Hassan Baig

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

34 votes

1 answer

35k views

DELETE rows which are not referenced in other table

asked Apr 3, 2016 at 14:15

11 votes

2 answers

28k views

Deleting old postgresql log files (Ubuntu)

asked Mar 26, 2016 at 12:22

17 votes

1 answer

23k views

Disk space unreleased after cleaning up rows from PG table

asked Sep 27, 2017 at 12:36

6 votes

1 answer

16k views

Optimizing slow performance of simple SELECT query

asked Oct 7, 2017 at 13:02

6 votes

1 answer

15k views

Releasing disk space by using DELETE or TRUNCATE?

asked Jan 11, 2017 at 17:45

4 votes

3 answers

14k views

Setting location of temp files for Postgresql backend (9.3.10)

asked Mar 19, 2017 at 8:49

1 vote

1 answer

8k views

Deleting aged postgresql rows with foreignkey constraints

asked Feb 29, 2016 at 20:48

4 votes

1 answer

8k views

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

asked Apr 20, 2016 at 7:18

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

1 vote

1 answer

7k views

PgBouncer log management

asked Dec 12, 2016 at 9:51

6 votes

1 answer

7k views

Deleting records from tables containing FK pointing to each other

asked Feb 19, 2017 at 11:19

1 vote

1 answer

4k views

Postgresql maintainenace queries fail with foreignkey violation

asked May 9, 2016 at 21:42

2 votes

1 answer

4k views

Time taken by VACUUM FULL to reclaim space

asked Sep 28, 2017 at 15:24

1 vote

2 answers

4k views

Routinely deleting aged postgresql rows via cron

asked Jun 24, 2016 at 9:39

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

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

1 vote

1 answer

3k views

Speeding up very slow UPDATE query (Postgresql 9.6)

asked Nov 11, 2019 at 12:02

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

2k views

Postgresql log rotation

asked Jul 1, 2016 at 11:38

4 votes

2 answers

2k views

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

asked Oct 25, 2016 at 0:01

0 votes

1 answer

2k views

How to configure port for listening to traffic meant for PostgreSQL

asked Oct 19, 2017 at 7:57

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

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

0 votes

1 answer

802 views

controlling postgresql log generation

asked Nov 18, 2016 at 22:48

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

2 votes

0 answers

740 views

Amount by which to increase checkpoint_segments (postgresql)

asked Nov 30, 2016 at 4:04

0 votes

0 answers

726 views

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

asked Jul 9, 2019 at 8:54

Stack Exchange Network

43 Questions

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

Dealing with disk space full in postgresql

DELETE rows which are not referenced in other table

Deleting old postgresql log files (Ubuntu)

Disk space unreleased after cleaning up rows from PG table

Optimizing slow performance of simple SELECT query

Releasing disk space by using DELETE or TRUNCATE?

Setting location of temp files for Postgresql backend (9.3.10)

Deleting aged postgresql rows with foreignkey constraints

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

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

PgBouncer log management

Deleting records from tables containing FK pointing to each other

Postgresql maintainenace queries fail with foreignkey violation

Time taken by VACUUM FULL to reclaim space

Routinely deleting aged postgresql rows via cron

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

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

Speeding up very slow UPDATE query (Postgresql 9.6)

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

Postgresql log rotation

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

How to configure port for listening to traffic meant for PostgreSQL

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]

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

controlling postgresql log generation

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

Amount by which to increase checkpoint_segments (postgresql)

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