ほんとはLTLとFTL個別に部分インデックス作った方が速いけど、容量との兼ね合いもあるしどうなんだろ。FTLのクエリでさっきの部分インデックスが使われるのかどうか確認してない
ほんとはLTLとFTL個別に部分インデックス作った方が速いけど、容量との兼ね合いもあるしどうなんだろ。FTLのクエリでさっきの部分インデックスが使われるのかどうか確認してない
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
USB を題材にした同人音楽がかつて存在し,某所の人間がそれを無限に聞きながらデバイスドライバを完成させた激ヤバエピソードがあるのですが,その同人音楽がなにか忘れた
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
\ますたーに/ \ついずいしますたー/
とりいそぎ merged tootsuite/mastodon at 7fe1428cc4a099f12e95190b97880094bab9a807
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
/api/v1/timelines/public?limit=100&local=trueで40行に103秒。やっぱインデックス入れとくかw
SELECT "statuses"."id", "statuses"."updated_at" FROM "statuses" LEFT OUTER JOIN "accounts" ON "accounts"."id" = "statuses"."account_id" WHERE ("statuses"."local" = ? OR "statuses"."uri" IS NULL) AND "statuses"."visibility" = ? AND (statuses.reblog_of_id IS NULL) AND (statuses.reply = FALSE OR statuses.in_reply_to_account_id = statuses.account_id) AND "accounts"."silenced" = ? ORDER BY "statuses"."id" DESC LIMIT ?
ここまではすすむくん
$ telnet github.com 22
Trying 192.30.255.112...
Connected to github.com.
Escape character is '^]'.
SSH-2.0-libssh_0.7.0
^]
直接でぷろーい!
$ git push heroku-experiment zunda-ninja-master-on-heroku:master
あとで混乱するぜw
「GitHubのウェブで、Personal Access Tokenを取得して、これを使います」fmfm https://gist.github.com/ytsuboi/a5b292c35ae0250d99f6caa5c9e02225
public_repoのトークンをパスワードとして入力したところで停止。いあ微妙に進んでた
$ git push origin-https
Username for 'https://github.com': zunda
Password for 'https://zunda@github.com':
Counting objects: 5, done.
Delta compression using up to 4 threads.
Compressing objects: 100% (5/5), done.
Writing objects: 100% (5/5), 425 bytes | 425.00 KiB/s, done.
Total 5 (delta 4), reused 0 (delta 0)
fatal: The remote end hung up unexpectedly
fatal: The remote end hung up unexpectedly
Everything up-to-date
All systems reporting at 100%
https://status.github.com/messages
ふて寝る。w
放置した結果
$ git push
Connection to github.com closed by remote host.
fatal: Could not read from remote repository.
Please make sure you have the correct access rights
and the repository exists.
This account is not set to public on notestock.