Question : While looking at several examples of pl/python and pl/pgsql, I have seen many – but not all – […]
Tag: optimization
How to get paged resultset from a table?
Question : I am trying to get paged resultset from a table (Notes). So, I am passing the last offset […]
How recording of every change of a row in a database is generaly stored?
Question : In a project I’m working on, every change to the rows in some tables of the database must […]
When SELECTing an expression that is an expression based index does the expression get processed? [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
improve MySQL text searches
Question : What MySQL settings improve text searches? Which resources (memory, cpus, disk: ssd) to add first to increase performance? […]
Is there a reliable way to determine how long it took the optimizer to generate a query plan?
Question : I’m not sure where I’d start, but is there a way to see how long it took the […]
Does postgres optimise repeated expressions?
Question : select column_1, (column_1 <-> cube(:input)) / (:input <-> cube(0)) difference from table_1 for this query, is calculation of […]
Speed up INSERTs
Question : I need to have a way to insert to a table, fast, synchronous, with minimal duration. What I’ve […]
Is “many database writes” an anti-pattern?
Question : I am designing a database api. I have two options: Have a complex aggregation that queries the data […]
Is LIMIT processed before or after retrieving data?
Question : MySQL. My heavy query crashed our MySQL server. If I add LIMIT 10 will it make my query […]