Reputation
5,814
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 10 28
Newest
 Guru
Impact
~256k people reached

May
19
comment Postgresql indexing for IS NULL
query#1 is expected to update 110 rows and query#2 almost 4 million. They are not similar at all.
May
15
comment Memory usage on select for large number of rows
Yes, the effect of column alignment is more pronounced when the result includes wide text columns of varying lengths. But the point is to remember to turn alignment off to extract the raw contents rather than look at the space-padded version of them on a terminal.
May
14
answered Memory usage on select for large number of rows
May
10
answered unable to run postgres with pg_ctl
May
10
reviewed Approve The transaction log for database 'database_name' is full due to 'XTP_CHECKPOINT'
May
10
reviewed Approve Docker Mongodb replication on different hosts is not working
May
5
answered pg_dump does not honor -n
May
4
awarded  Guru
Apr
28
answered Postgres Slow Queries - Autovacuum frequency
Apr
27
answered Minimal grants for readonly single-table access on PostgreSQL
Apr
24
awarded  Enlightened
Apr
24
awarded  Nice Answer
Apr
24
comment missing WAL file on standby server following a backup
Yes, the restore_command is needed and the live server must not copy directly into $PGDATA/pg_xlog on the standby. It must copy into the archive directory. Only restore_command is allowed to copy into pg_xlog and only on demand (when postgres calls it).
Apr
24
answered missing WAL file on standby server following a backup
Apr
24
reviewed Approve How to move a specific Postgres database to different harddrive?
Apr
24
reviewed Approve how to disable and enable SSIS package using commandline?
Apr
21
answered pg_ctl status responds with “available” during failed startup
Apr
15
answered Insertion Rule on a view
Apr
11
answered Last occurance of time relative to now()
Apr
10
awarded  Nice Answer