Reputation
11,829
Next tag badge:
686/1000 score
213/200 answers
Badges
7 32 55
Newest
 Revival
Impact
~590k people reached

Feb
3
revised Index has no gain vs normal query
added 19 characters in body; edited title
Feb
2
revised Trigger to create symmetrical rows
added 4 characters in body
Feb
2
revised How to create an index to be picked by query
added 160 characters in body
Feb
2
answered How to create an index to be picked by query
Feb
2
revised How to create an index to be picked by query
added 133 characters in body
Feb
2
comment Some delays in heavy inserts
Can you start logging about checkpoints? log_checkpoints has to be set to on in postgresql.conf and you need a restart. You might be interested in anarazel.de/talks/berlin-meetup-2016-01-26/io.pdf (see the throughput/latency graphs)
Feb
1
revised Why does time zone have such a crazy offset-from-UTC on year 0001 in Postgres?
added 51 characters in body
Feb
1
revised What's stored in data_dir/base of postgresql
added 6 characters in body
Feb
1
revised Some delays in heavy inserts
added 25 characters in body; edited title
Feb
1
comment Some delays in heavy inserts
Please show the non-default contents of your postgresql.conf. It can be related to the checkpoint settings, among others.
Feb
1
comment Postgres, promoting slave to master issue
Does the recovery advances through the WAL files (you can see this from the 0000000100000EF200000019 changing to something higher). If the slave is much behind the master at the time of promotion, it can take a while until it catches up. What you tell about the slave having different data than the master, this seems likely.
Feb
1
revised What does N'[Uncategorized (Local)] mean?
edited tags; edited title
Feb
1
comment Using HammerDB with unsupported databases
Well, HammerDB is an open source project, so in theory yes, you could - not sure if you have the time and means for that. I guess you'd better ask them if they plan to support GT.M
Feb
1
revised Using HammerDB with unsupported databases
added 99 characters in body; edited tags; edited title
Feb
1
revised Getting records for yesterday, but per hour
deleted 9 characters in body
Feb
1
revised Is it safe to use innodb_flush_log_at_trx_commit = 2
added 2 characters in body
Jan
31
revised Use specific array column in the where clause
added 22 characters in body; edited title
Jan
31
answered Use specific array column in the where clause
Jan
29
revised SQL Server Isnull Returning 1900-01-01 when field is null
added 1 character in body
Jan
29
comment Insert performance
Does it stay the same after adding an index on words (doc)?