User Hassan Baig

33 votes

4 answers

134k views

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

asked Mar 12, 2016 at 1:53

22 votes

2 answers

42k views

Dealing with disk space full in postgresql

asked Mar 18, 2017 at 13:06

35 votes

1 answer

40k views

DELETE rows which are not referenced in other table

asked Apr 3, 2016 at 14:15

11 votes

2 answers

32k views

Deleting old postgresql log files (Ubuntu)

asked Mar 26, 2016 at 12:22

18 votes

1 answer

27k views

Disk space unreleased after cleaning up rows from PG table

asked Sep 27, 2017 at 12:36

6 votes

1 answer

18k views

Optimizing slow performance of simple SELECT query

asked Oct 7, 2017 at 13:02

6 votes

1 answer

16k views

Releasing disk space by using DELETE or TRUNCATE?

asked Jan 11, 2017 at 17:45

5 votes

3 answers

16k views

Setting location of temp files for Postgresql backend (9.3.10)

asked Mar 19, 2017 at 8:49

4 votes

1 answer

9k views

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

asked Apr 20, 2016 at 7:18

1 vote

1 answer

8k views

PgBouncer log management

asked Dec 12, 2016 at 9:51

1 vote

1 answer

8k views

Deleting aged postgresql rows with foreignkey constraints

asked Feb 29, 2016 at 20:48

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

7k views

Deleting records from tables containing FK pointing to each other

asked Feb 19, 2017 at 11:19

3 votes

1 answer

5k views

Time taken by VACUUM FULL to reclaim space

asked Sep 28, 2017 at 15:24

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

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

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

1 vote

1 answer

3k views

Speeding up very slow UPDATE query (Postgresql 9.6)

asked Nov 11, 2019 at 12:02

1 vote

1 answer

2k views

Postgresql log rotation

asked Jul 1, 2016 at 11:38

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

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

0 votes

1 answer

1k views

controlling postgresql log generation

asked Nov 18, 2016 at 22:48

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

1 vote

2 answers

920 views

Explaining recurring crash in postgresql deployment

asked May 15, 2020 at 2:32

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

2 votes

0 answers

775 views

Amount by which to increase checkpoint_segments (postgresql)

asked Nov 30, 2016 at 4:04

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)

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

PgBouncer log management

Deleting aged postgresql rows with foreignkey constraints

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

Deleting records from tables containing FK pointing to each other

Time taken by VACUUM FULL to reclaim space

Postgresql maintainenace queries fail with foreignkey violation

Routinely deleting aged postgresql rows via cron

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

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

Speeding up very slow UPDATE query (Postgresql 9.6)

Postgresql log rotation

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

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]

controlling postgresql log generation

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

Explaining recurring crash in postgresql deployment

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

Amount by which to increase checkpoint_segments (postgresql)