preloader
軟體工程 Postgres WAL 概述

PostgreSQL version 10 WAL 設定概述 參數: checkpoint_timeout default is 5 minute max_wal_size default is 1GB archive_timeout full_page_writes checkpoint_warning checkpoint_completion_target default is 0.5 and only be fraction of checkpoint_timeout pg_test_fsync can measure average speed in microsecond of single WAL flush operation. Half of its value is effective for reporting average time setting that it flush single 8KB write operation to commit_delay. pg_test_fsync doesn’t care whether fsync

read more
心得 Deploy Notice for Ruby on Rails app beginner | 部署Ruby on Rails app應學習的事情

This article is written for Rails beginners when he/she want to deploy an app. From my experience, many things must be noticed and fixed, whose range from Ubuntu, RVM, Apache, Passenger, Postgres, Git, Capistrano and GitHub.com. The following are indexes for problems, solutions and resources I had faced. It might evolve with times change. Ubuntu List packages you have installed to a machine. Command: dpkg -l | grep {packageFullnameorPartname} Change

read more
軟體工程 Make Postgres support full text search in Mandarin/Chinese for Rails 讓Postgres 開始支援中文全文檢索

I use the gem pg_search in rails as a light-weight tool for full-text searching task of Postgres, but Postgres doesn’t support the function well in Mandarin/Chinese. After finding solutions, I take the combination of tools for full-text search in Postgres, which are pg_search gem, SCWS and zhparser. Doing it yourself according content in following links, you will setup successfully too. Remark at 20160131: This tutorial requires postgresql-server-devel-{VERSION} at Ubuntu and

read more

About

Howard Lee, Frontend-engineer with Angular 7+, Typescript, ReactJS, VueJS. Flutter, Dart, PHP, Ruby, JavaScript, HTML, SASS, CSS, Postgres, MySQL, Web Developer. Have a certificate of AWS Solution Architect Associate with verify number: 8FYNL55LCEEQ10W5. You can verify at AWS Certificate site or Credly site Tech lead role Lead 4 colleagues to build products and infrastructure Coordinate schedule of delivering products Senior web frontend developer role Products Form-filling, form-sharing, file-management, repair-managemnt and project-management for construction industry at Suiqui IoT management and EC platform for Liquid Petroleum Gas(LPG) at Wave-In Comm.

Know More

Tag

Social