Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Hassan Baig's user avatar
Hassan Baig's user avatar
Hassan Baig's user avatar
Hassan Baig
  • Member for 8 years, 3 months
  • Last seen more than 1 year ago
32 votes
4 answers
128k views

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

21 votes
2 answers
40k views

Dealing with disk space full in postgresql

35 votes
1 answer
39k views

DELETE rows which are not referenced in other table

11 votes
2 answers
31k views

Deleting old postgresql log files (Ubuntu)

18 votes
1 answer
26k views

Disk space unreleased after cleaning up rows from PG table

6 votes
1 answer
17k views

Optimizing slow performance of simple SELECT query

6 votes
1 answer
16k views

Releasing disk space by using DELETE or TRUNCATE?

5 votes
3 answers
15k views

Setting location of temp files for Postgresql backend (9.3.10)

4 votes
1 answer
8k views

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

1 vote
1 answer
8k views

Deleting aged postgresql rows with foreignkey constraints

1 vote
1 answer
8k views

PgBouncer log management

8 votes
2 answers
7k views

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

6 votes
1 answer
7k views

Deleting records from tables containing FK pointing to each other

2 votes
1 answer
4k views

Time taken by VACUUM FULL to reclaim space

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

2 votes
2 answers
3k views

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

0 votes
1 answer
3k views

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

1 vote
1 answer
3k views

Speeding up very slow UPDATE query (Postgresql 9.6)

0 votes
1 answer
2k views

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

1 vote
1 answer
2k views

Postgresql log rotation

4 votes
2 answers
2k views

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

0 votes
1 answer
2k views

How to configure port for listening to traffic meant for PostgreSQL

1 vote
1 answer
1k views

Slow query performance of simple SELECT query (Postgresql 9.6)

-2 votes
2 answers
1k views

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

0 votes
1 answer
1k views

controlling postgresql log generation

1 vote
1 answer
993 views

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

1 vote
2 answers
852 views

Explaining recurring crash in postgresql deployment

1 vote
2 answers
790 views

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

2 votes
0 answers
765 views

Amount by which to increase checkpoint_segments (postgresql)