Hassan Baig's user avatar
Hassan Baig's user avatar
Hassan Baig's user avatar
Hassan Baig
  • Member for 8 years
  • Last seen more than a month ago
33 votes
1 answer
37k views

DELETE rows which are not referenced in other table

32 votes
4 answers
122k views

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

21 votes
2 answers
38k views

Dealing with disk space full in postgresql

18 votes
1 answer
24k views

Disk space unreleased after cleaning up rows from PG table

11 votes
2 answers
30k views

Deleting old postgresql log files (Ubuntu)

8 votes
2 answers
7k views

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

6 votes
1 answer
15k views

Releasing disk space by using DELETE or TRUNCATE?

6 votes
1 answer
7k views

Deleting records from tables containing FK pointing to each other

6 votes
1 answer
17k views

Optimizing slow performance of simple SELECT query

4 votes
3 answers
15k views

Setting location of temp files for Postgresql backend (9.3.10)

4 votes
2 answers
2k views

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

4 votes
1 answer
8k views

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

3 votes
0 answers
654 views

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

2 votes
1 answer
4k views

Time taken by VACUUM FULL to reclaim space

2 votes
2 answers
3k views

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

2 votes
0 answers
675 views

Manual postgres migration for Django (python) app

2 votes
0 answers
761 views

Amount by which to increase checkpoint_segments (postgresql)

1 vote
1 answer
7k views

PgBouncer log management

1 vote
2 answers
787 views

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

1 vote
1 answer
992 views

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

1 vote
1 answer
8k views

Deleting aged postgresql rows with foreignkey constraints

1 vote
1 answer
199 views

Deleting aged postgresql rows with tricky condition

1 vote
1 answer
158 views

Tricky condition for PostgreSQL UPDATE query

1 vote
1 answer
4k views

Postgresql maintainenace queries fail with foreignkey violation

1 vote
2 answers
4k views

Routinely deleting aged postgresql rows via cron

1 vote
1 answer
2k views

Postgresql log rotation

1 vote
1 answer
1k views

Slow query performance of simple SELECT query (Postgresql 9.6)

1 vote
1 answer
51 views

Optimizing SELECT query consistently showing up in slow-log

1 vote
1 answer
3k views

Speeding up very slow UPDATE query (Postgresql 9.6)

1 vote
2 answers
786 views

Explaining recurring crash in postgresql deployment