7,148 reputation
31640
bio website
location Berlin, Germany
age 39
visits member for 3 years
seen 10 hours ago

Jan
22
revised Lower() vs ilike on postgresql
edited body
Jan
19
revised Monitoring Amazon RDS with pgtop
try to turn the question into something more specific
Jan
7
revised Is there a way to “SELECT and TRUNCATE” without losing new data?
edited body
Jan
6
revised Should database be denormalized if I need an index across multiple tables
added 2 characters in body
Dec
15
revised create insertion rule on view returning id
added 37 characters in body
Dec
12
revised Translate psql meta-command to SQL
edited title
Nov
26
revised Postgresql - Streaming replication - STONITH
added 20 characters in body
Nov
11
revised Postgresql doesn't accept replication connection
added 82 characters in body
Nov
10
revised PostgreSQL roles versus users, grant permissions
added 266 characters in body
Nov
10
revised PostgreSQL: Creation date of a table
added 6 characters in body
Nov
7
revised why pg_restore ignores --create ? Error: failed: FATAL: database “new_db” does not exist
deleted 10 characters in body
Nov
7
revised PostgreSQL: Creation date of a table
formatting
Oct
30
revised Postgres: modify existing search_path (preserve current values)
adding the bonus answer
Oct
29
revised Why does 'plpgsql' not appear in the pg_extension table?
added 72 characters in body
Oct
27
revised Why does a select statement dirty cache bufferes in postgres
added the explanation from the comment plus cleaned up HTH
Sep
12
revised get row count of last select query
added 12 characters in body
Aug
29
revised PostgreSQL Sequential Scan instead of Index Scan Why?
edited body
Aug
17
revised Searching a big table for a few results without scanning the whole table
remove duplication remove duplication
Jul
25
revised Why is my composite index not used for this table?
fixed myself :)
Jul
25
revised Custom personal monitor sql by writing the .psqlrc file
added 1 character in body