Hassan Baig's user avatar
Hassan Baig's user avatar
Hassan Baig's user avatar
Hassan Baig
  • Member for 7 years, 7 months
  • Last seen more than a month 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
112k views

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

4 votes
3 answers
14k views

Setting location of temp files for Postgresql backend (9.3.10)

20 votes
2 answers
36k views

Dealing with disk space full in postgresql

1 vote
2 answers
635 views

Explaining recurring crash in postgresql deployment

1 vote
1 answer
3k views

Speeding up very slow UPDATE query (Postgresql 9.6)

34 votes
1 answer
35k views

DELETE rows which are not referenced in other table

0 votes
0 answers
726 views

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

0 votes
0 answers
448 views

Running REINDEX in a live environment (POSTGRESQL 9.6.10)

1 vote
1 answer
49 views

Optimizing SELECT query consistently showing up in slow-log

0 votes
1 answer
62 views

Optimizing slow SELECT query (postgresql 9.6.5)

0 votes
1 answer
144 views

Speeding up slow SELECT query (Postgresql 9.6)

1 vote
1 answer
986 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
15k 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
608 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
16k views

Optimizing slow performance of simple SELECT query

0 votes
1 answer
663 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
35 views

Optimizing postgresql maintenance statements on psql

17 votes
1 answer
23k 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
785 views

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

1 vote
1 answer
7k views

PgBouncer log management

2 votes
0 answers
740 views

Amount by which to increase checkpoint_segments (postgresql)