Reputation
8,941
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 23 48
Impact
~451k people reached

Aug
5
reviewed Reviewed Checksum mis-match found on a table while restoring data using mysqlbackup
Aug
5
revised Checksum mis-match found on a table while restoring data using mysqlbackup
deleted 6 characters in body; edited tags
Aug
5
reviewed No Action Needed What is the best way to find out the sum of a field from a table?
Aug
5
reviewed Reviewed Efficiently computing aggregate functions over subqueries with incremental data
Aug
5
reviewed Reviewed Recursive BOM (Bill Of Material) type query
Aug
4
revised Why seq-scan can be much faster than index-scan and index-only-scan in this simple query?
added 202 characters in body
Aug
4
comment Why seq-scan can be much faster than index-scan and index-only-scan in this simple query?
Hm, now I found an excellent post from Robert Haas, where he describes these in detail. I have to admit you are right - index-only scans are not always index-only, but they try as long as it is possible. At the same time, an index-only scan with additional heap fetches is possible when a sufficient portion of the table pages remains unchanged since the last vacuum.
Aug
4
reviewed Close Dynamic Filters in SQL server
Aug
4
reviewed Close Inserting emoji - smartphones in MySQL database with PHP?
Aug
4
revised How do I list all tables in all schemas owned by the current user in Postgresql?
added 5 characters in body
Aug
4
revised Aggressive Autovacuum on PostgreSQL
added 8 characters in body
Aug
4
reviewed No Action Needed How to import a varbinary(max) column with bulk import?
Aug
4
reviewed Reviewed How To Manage Random Data Without Repitition?
Aug
4
comment How To Manage Random Data Without Repitition?
Please format your tables properly, it's not very easy to follow this way.
Aug
4
reviewed Reviewed Real-world scenarios for table with DENY SELECT and GRANT [INSERT/UPDATE/DELETE]
Aug
4
reviewed No Action Needed How can I call a remote User Defined Function?
Aug
3
awarded  Constituent
Aug
3
comment Postgres query plan has high rowcount, slow execution
Could you show the definition of those composite indexes?
Aug
3
reviewed Reject Mysql transaction READ REPEATABLE and READ COMMITTED read view
Aug
3
comment Select Between Date Range Mysql
Could you show some of those many? Or put some of your data in this fiddle to reproduce your issue (after it, post the new SQLFiddle link here)?