Skip to main content
Hans-Jürgen Schönig's user avatar
Hans-Jürgen Schönig's user avatar
Hans-Jürgen Schönig's user avatar
Hans-Jürgen Schönig
  • Member for 9 years, 8 months
  • Last seen more than 2 years ago
18 votes
Accepted

Transactions within a Transaction

13 votes
Accepted

Why does a SELECT statement dirty cache buffers in Postgres?

8 votes
Accepted

How to manipulate join order of PostgreSQL optimizer?

6 votes
Accepted

Prevent Primary Key increment when an INSERT statement fails in PostgreSQL

5 votes

PostgreSQL procedural languages overhead (plpython / plsql / pllua...)

4 votes

SELECT all substrings (n-grams) of length n?

4 votes

Copying database to different hard disk

3 votes

Postgresql - Streaming replication - STONITH

3 votes

Memory usage of PostgreSQL

3 votes

Partial db dump/restore

2 votes

Can i have one foreign key to both parent and it's childs in postgresql?

2 votes

postgresql - a local replication entry doesn't work

2 votes

Postgresql function to create table

2 votes

Optimizing for data that does not fit in memory

2 votes

MongoDB Benchmark with write-intensive on geo-indexed DB

2 votes

Postgres inherit indexes for partitioned tables

2 votes

Indexes vs Collation vs Pattern Ops

2 votes

Which tool to compare an Oracle database with a Postgresql database?

2 votes

pg_stat_activity - is it possible to decompose a stored procedure further?

2 votes
Accepted

Does PGStrom calculate relational comparisons?

1 vote

How can I simplify this UNION?

1 vote

pgbench-tools failed authentication

1 vote
Accepted

When to break large delete queries up?

1 vote

How to restore postgreSQL schema dump to schema with different name

1 vote

Size of Postgres database growing

1 vote

Postgresql single base on multiple HDD partitions

1 vote

1 million strings and exact match search

1 vote
Accepted

How to create a citation/quote from a Postgres text field?

1 vote

Speed of WAL send/receive when replicating

0 votes

Get min and max row from table