depesz.com
select * from depesz; » Blog Archive » How to remove backups?
https://www.depesz.com/2010/04/04/how-to-remove-backups
How to remove backups? April 4th, 2010 by depesz Tags: backup. If yes - maybe you can help me. Question from title sounds weird to you? It's just a ‘rm backup filename'? Well I really wish it was so simple in some cases. One of the servers I'm looking into, there is interesting situation:. Quite busy database server (2k tps is the low point of the day). Daily backups, each sized at about 100GB. Backups stored on ext3 filesystem with default options. Create 15 1GB files with irrelevant content. Done & /tm...
depesz.com
select * from depesz; » Blog Archive » my thoughts on getting random row
https://www.depesz.com/index.php/2007/09/16/my-thoughts-on-getting-random-row
My thoughts on getting random row. September 16th, 2007 by depesz Tags: postgresql. If yes - maybe you can help me. This topic has been written about by many smart people – from the recent past, by greg sabino mullane. They show 4 different approaches:. All these approaches have their benefits and drawbacks, but i'd like to show another one (polish readers saw the approach already in january 2007, but this time i will make the code more robust). First, let's discuss existing methods:. Basically – g...
depesz.com
select * from depesz; » Blog Archive » Explaining the unexplainable
https://www.depesz.com/2013/04/16/explaining-the-unexplainable
April 16th, 2013 by depesz Tags: explain. If yes - maybe you can help me. One of the first things new DBA hears is “Use the EXPLAIN". And upon first try he/she is greeted with incomprehensible:. QUERY PLAN - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -. Pg get function arguments (. Sort Method: quicksort Memory: 43kB -. Hash Cond: (. Pg proc p (. Pg function is visible (. Memory Usage: 1kB -. Pg namespace n (. Sequential scan me...
explain.solr.pl
Solr Explain
http://explain.solr.pl/explains
A tool for finding out why the documents are where they are in the results list. Visit us at solr.pl. An idea and layout borrowed from explain.depesz.com.
explain.solr.pl
Solr Explain
http://explain.solr.pl/help
A tool for finding out why the documents are where they are in the results list. Supported versions of Apache Solr. Explain.solr.pl supports the following versions of Apache Solr search server:. We plan to support Apache Solr 3.6 and newer, but support for versions older than 3.0 is not planned. Adding a new query - 10 seconds tutorial. In order to add Your query explain information and visualise it, please add the following to your query. And paste the raw Solr response. So if your query looks like.
depesz.com
select * from depesz; » Blog Archive » Partitioning – what? why? how?
https://www.depesz.com/2015/06/07/partitioning-what-why-how
Partitioning – what? June 7th, 2015 by depesz Tags: partitioning. If yes - maybe you can help me. Recently I noticed that more and more cases that I deal with could use some partitioning. And while theoretically most people know about it, it's definitely not a very well-understood feature, and sometimes people are scared of it. So, I'll try to explain, to my best knowledge, what it is, why one would want to use it, and how to actually make it happen. Relational database. And the. Let's see what it is.
depesz.com
select * from depesz; » irc
https://www.depesz.com/tag/irc
Getting list of unique elements in table, per group. July 12th, 2016 by depesz Tags: aggregate. Today, on irc, someone asked interesting question. Basically she ran a query like: select a, b, c, d, e, f from table order by a then, she processed the query to get, for each a array of unique values of b, c, d, . Incrementing counters in database. June 14th, 2016 by depesz Tags: counter. About it, but figured, I can as well write a blogpost, so others can use it too. February 8th, 2016 by depesz Tags: check.
depesz.com
select * from depesz; » window
https://www.depesz.com/tag/window
Grouping data by timestamp and interval. December 8th, 2015 by depesz Tags: grouping. Someone asked today on irc about grouping data, that contains timestamps, into "partitions". Usually when someone wants something like this, you can do grouping by date trunc(), but this time, this person, wanted to group data that all timestamps are within given . Filling in the blanks. June 6th, 2015 by depesz Tags: aggregate. Waiting for 9.4 – Provide moving-aggregate support for a bunch of aggregates. And maybe not ...
depesz.com
select * from depesz; » jsonb
https://www.depesz.com/tag/jsonb
Waiting for 9.5 – Rename jsonb replace to jsonb set and allow it to add new values. June 4th, 2015 by depesz Tags: json. On 1st of June, Andrew Dunstan committed patch: Rename jsonb replace to jsonb set and allow it to add new values The function is given a fourth parameter, which defaults to true. When this parameter is true, if the last element of the path is . Waiting for 9.5 – Additional functions and operators for jsonb. May 20th, 2015 by depesz Tags: json. March 25th, 2014 by depesz Tags: gin.