User kgrittn

50 votes

Locking issue with concurrent DELETE / INSERT in PostgreSQL

answered Oct 27, 2012 at 15:26

32 votes

Accepted

Is the CPU performance relevant for a database server?

answered Apr 26, 2012 at 17:41

25 votes

Why is there a PostgreSQL Turtle?

answered May 10, 2012 at 18:42

18 votes

Set a column's default value to the concatenation of two other columns' values?

answered Aug 2, 2012 at 19:02

14 votes

Accepted

Altering table schema takes too much time

answered May 10, 2012 at 19:38

13 votes

PostgreSQL 9.1 Hot Backup Error: the database system is starting up

answered Apr 19, 2012 at 21:38

10 votes

Accepted

Performance degradation while updating tables having 10s of millions of records

answered May 9, 2012 at 18:23

9 votes

PostgreSQL procedural languages - differences between PL/pgSQL and SQL

answered Sep 6, 2012 at 11:49

8 votes

Concurrency with Select-conditional Insert/Update/Delete - PostgreSQL

answered Apr 15, 2012 at 15:46

7 votes

Accepted

Dropping indexes doesn't seem to release space to the OS. Can it?

answered Apr 23, 2012 at 20:31

6 votes

Problem with permissions for user

answered Sep 16, 2012 at 19:34

6 votes

Accepted

PostgreSQL PITR restore

answered Jun 30, 2012 at 18:31

6 votes

How to optimization database for heavy I/O from updates (software and hardware)

answered Sep 16, 2013 at 21:03

5 votes

Trouble recovering data from corrupted PostgreSQL tables

answered Jun 24, 2012 at 22:59

5 votes

Accepted

how to query for rows by specifying the range of row numbers in postgresql

answered Aug 23, 2012 at 12:05

5 votes

Optimizing ORDER BY in a full text search query

answered Apr 15, 2012 at 23:14

5 votes

Why is pg_dumpall throwing an "OID does not exist'' error?

answered May 7, 2012 at 21:36

5 votes

Optimizing ORDER BY in a full text search query

answered Apr 12, 2012 at 16:01

4 votes

Created user can access all databases in PostgreSQL without any grants

answered May 13, 2012 at 13:27

4 votes

Accepted

Syncing two (or more) PostgreSQL 9.1 clusters

answered Jun 24, 2012 at 15:11

4 votes

Accepted

Tune postgres 9.1 to speedup deletes

answered Aug 2, 2012 at 14:01

3 votes

Recover from Postgres FATAL: could not open file pg_tblspc/

answered May 6, 2012 at 13:28

3 votes

How can I write a proper query to JOIN all of these tables without duplicates?

answered Apr 11, 2012 at 22:18

3 votes

Improve sort performance in PostgreSQL?

answered Apr 29, 2012 at 16:44

2 votes

Postgresql - Segmentation fault (core dumped)

answered Feb 10, 2013 at 16:18

1 vote

Postgres table size doubles are transaction completes

answered May 4, 2012 at 18:50

1 vote

pg_restore: [archiver] unsupported version (1.11) in file header postgresql

answered Apr 11, 2012 at 17:33

1 vote

Accepted

Partial vacuum and whole table vacuum

answered May 13, 2012 at 13:10

0 votes

Postgresql 9.6 best settings for large admin work (min_wal and max_wal)

answered Nov 14, 2017 at 16:36

Stack Exchange Network

29 Answers

Locking issue with concurrent DELETE / INSERT in PostgreSQL

Is the CPU performance relevant for a database server?

Why is there a PostgreSQL Turtle?

Set a column's default value to the concatenation of two other columns' values?

Altering table schema takes too much time

PostgreSQL 9.1 Hot Backup Error: the database system is starting up

Performance degradation while updating tables having 10s of millions of records

PostgreSQL procedural languages - differences between PL/pgSQL and SQL

Concurrency with Select-conditional Insert/Update/Delete - PostgreSQL

Dropping indexes doesn't seem to release space to the OS. Can it?

Problem with permissions for user

PostgreSQL PITR restore

How to optimization database for heavy I/O from updates (software and hardware)

Trouble recovering data from corrupted PostgreSQL tables

how to query for rows by specifying the range of row numbers in postgresql

Optimizing ORDER BY in a full text search query

Why is pg_dumpall throwing an "OID does not exist'' error?

Optimizing ORDER BY in a full text search query

Created user can access all databases in PostgreSQL without any grants

Syncing two (or more) PostgreSQL 9.1 clusters

Tune postgres 9.1 to speedup deletes

Recover from Postgres FATAL: could not open file pg_tblspc/

How can I write a proper query to JOIN all of these tables without duplicates?

Improve sort performance in PostgreSQL?

Postgresql - Segmentation fault (core dumped)

Postgres table size doubles are transaction completes

pg_restore: [archiver] unsupported version (1.11) in file header postgresql

Partial vacuum and whole table vacuum

Postgresql 9.6 best settings for large admin work (min_wal and max_wal)