Ferron H ferronrsmith

Our biggest table contains raw image data in form of a bytea column.

When we did a simple COPY from psql on this table to stdout, it was quite fast (1 or 2 minutes), but it was very slow with the pg_dump. It took ~60 minutes.

So investigating this I stumbled across this discussion. It seems that the pg_dump compression is rather slow if data is already compressed as it is with image data in a bytea format. And it is better to compress outside of pg_dump (-Z0).

Additionally we found that we can make use of our multi-core cpu (-j 10 and pigz -p 10 to use 10 cores. you might select a different number of cores).

So now we are doing it like this:

QuerySet API reference (stock portfolio example)

An in-depth guide to Django QuerySet (Django 3.0, updated June 2020).

When QuerySets are evaluated

Internally, a QuerySet can be constructed, filtered, sliced, and generally passed around without actually hitting the database. No database activity actually occurs until you do something to evaluate the queryset. Examples of that "something" that cause a QuerySet to evaluate:

Iteration: QuerySet executes its database query the first time you iterate over it
```
for q in Quote.objects.all():
    print(q.symbol)
```

Ramblings for Relevant Search. Primary and Secondary ranking factors in relevance. Problem: you want to rank with two factors. Simply multiplying scores ignores the relative significance of the primary/secondary scores. For example, in the tables below, if the first column is much more important to ranking than the second factor. The second factor is more of a tie breaker for ties in the primary criteria. Additive boosting seems to do a better job at this:

Additive Boosting

Primary	Secondary	Sum
10	0.9	10.9
10.1	0.7	10.8
10	0.8	10.8

	#!/bin/bash
	set -xeuo pipefail
	echo "Crack Navicat15, works on Arch based Distro....."

	echo "安装破解的一切后果请自行承担"
	echo "由于版权原因本脚本不再维护，推荐使用DBeaver等开源替代或使用mycli、pgcli等终端工具，或使用教育邮箱或开源贡献认证申请Jetbrains家的DataGrip"

	source /etc/os-release
	case $ID in
	arch)

	#!/usr/bin/env python

	import glob
	import os.path
	import socket
	import subprocess
	import sys

	# manage.py must be made executable in order for this to work

	DO WHAT THE FUCK YOU WANT TO PUBLIC LICENSE
	Version 2, December 2004

	Copyright (C) 2011 Haochi Chen <http://ihaochi.com>

	Everyone is permitted to copy and distribute verbatim or modified
	copies of this license document, and changing it is allowed as long
	as the name is changed.

	DO WHAT THE FUCK YOU WANT TO PUBLIC LICENSE

	#!/bin/sh
	#
	# PHP 5.6 and older require OpenSSL 1.0.2, which is too old for most modern
	# operating systems. This script downloads, builds and installs OpenSSL 1.0.2
	# for use in PHP builds.
	#

	set -ex

	BUILD_DIR=/tmp/openssl-1.1.1-build

	#!/bin/sh/env python
	#
	# Simple script for comparing the various ways of "boosting" queries in Solr,
	# combined with the three main query parsers (lucene, dismax, and edismax).
	# The idea is to generate md5sums of the search results, so I can quickly
	# figure out which boost methods work the same as the other ones.
	#

	import re, urllib2, urllib, md5, json

	// Refrence http://stackoverflow.com/questions/18817336/golang-encrypting-a-string-with-aes-and-base64
	package main

	import (
	"crypto/aes"
	"crypto/cipher"
	"crypto/rand"
	"encoding/base64"
	"errors"
	"fmt"