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
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)

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
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]

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

0 votes
1 answer
2k views

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

1 vote
1 answer
993 views

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

5 votes
3 answers
15k views

Setting location of temp files for Postgresql backend (9.3.10)

8 votes
2 answers
7k views

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

21 votes
2 answers
40k views

Dealing with disk space full in postgresql

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

6 votes
1 answer
16k views

Releasing disk space by using DELETE or TRUNCATE?

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)

0 votes
1 answer
3k views

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

0 votes
1 answer
1k views

controlling postgresql log generation

4 votes
2 answers
2k views

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