Skip to content

Instantly share code, notes, and snippets.

WITH temp_dirs AS (
SELECT s1.dir || s1.version || '/pgsql_tmp' AS dir_name
FROM
(
SELECT
'pg_tblspc/' || spc.oid::text || '/' AS dir,
l.version
FROM
(
SELECT spc1.oid
<AirShoppingRQ xsi:schemaLocation="http://www.iata.org/IATA/EDIST ../AirShoppingRQ.xsd" Version="16.2"
xmlns="http://www.iata.org/IATA/EDIST"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<PointOfSale>
<Location>
<CountryCode>RU</CountryCode>
<CityCode>MOW</CityCode>
</Location>
<RequestTime Zone="EST">2017-03-16T07:38:00</RequestTime>
<TouchPoint>
@tanks
tanks / ASRS.xml
Last active October 13, 2017 09:05
<PricedOffer>
<OfferPrice OfferItemID="1">
<RequestedDate>
<PriceDetail>
<TotalAmount>
<SimpleCurrencyPrice>27110</SimpleCurrencyPrice>
</TotalAmount>
<BaseAmount>24000</BaseAmount>
<Taxes>
<Total Code="RUB">3110</Total>
@tanks
tanks / Distillery release optimization
Created August 29, 2017 14:11 — forked from maierru/OTP
Phoenix (elixir) highload optimization
# https://github.com/bitwalker/distillery/blob/master/docs/Walkthrough.md
$ MIX_ENV=prod mix release --erl="+K true +stbt db" --env=prod --verbose