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
0 votes
1 answer
2k views

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

32 votes
4 answers
128k views

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

5 votes
3 answers
15k views

Setting location of temp files for Postgresql backend (9.3.10)

21 votes
2 answers
40k views

Dealing with disk space full in postgresql

1 vote
2 answers
852 views

Explaining recurring crash in postgresql deployment

1 vote
1 answer
3k views

Speeding up very slow UPDATE query (Postgresql 9.6)

35 votes
1 answer
39k views

DELETE rows which are not referenced in other table

0 votes
0 answers
762 views

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

0 votes
0 answers
476 views

Running REINDEX in a live environment (POSTGRESQL 9.6.10)

1 vote
1 answer
51 views

Optimizing SELECT query consistently showing up in slow-log

0 votes
1 answer
64 views

Optimizing slow SELECT query (postgresql 9.6.5)

0 votes
1 answer
147 views

Speeding up slow SELECT query (Postgresql 9.6)

1 vote
1 answer
993 views

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

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]

6 votes
1 answer
16k views

Releasing disk space by using DELETE or TRUNCATE?

4 votes
1 answer
8k views

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

3 votes
0 answers
671 views

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

0 votes
1 answer
2k views

How to configure port for listening to traffic meant for PostgreSQL

6 votes
1 answer
17k views

Optimizing slow performance of simple SELECT query

0 votes
1 answer
695 views

Getting pg_dump and pg_restore right for postgresl (9.3.10)

2 votes
1 answer
4k views

Time taken by VACUUM FULL to reclaim space

0 votes
1 answer
36 views

Optimizing postgresql maintenance statements on psql

18 votes
1 answer
26k views

Disk space unreleased after cleaning up rows from PG table

8 votes
2 answers
7k views

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

2 votes
2 answers
3k views

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

6 votes
1 answer
7k views

Deleting records from tables containing FK pointing to each other

1 vote
2 answers
790 views

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

1 vote
1 answer
8k views

PgBouncer log management

2 votes
0 answers
765 views

Amount by which to increase checkpoint_segments (postgresql)