FreshPorts News

News and announcements regarding FreshPorts, The Place For Ports.

Full text search

  • to_tsquery gives ‘ERROR: syntax error in tsquery’ when it contains a space
  • A PostgreSQL query runs in 1.7s – add a LIMIT 10, runs in 28.2 seconds
  • Replacing a column search with a full text search solution

Like what we do?

As an Amazon Associate I earn from qualifying purchases.

Want a good read? Please try:
FreeBSD Mastery: Jails (IT Mastery Book 15)

BSD

  • BSDCan

FreeBSD

  • FreshPorts
  • FreshSource
  • The FreeBSD Diary

Other websites

  • DVL Software Limited
  • langille.org
  • PGCon
  • The Racing System
  • unixathome.org

Categories

Advocacy Announcements Apache Bacula bookmarks Branches Bug fixes Caching case insensitive CONFLICTS Cracking daemontools Dependencies Development Deveoper Tools Forensics FreeBSD Full pathnames Full text search Functions git Hardware Help Wanted! jail Master/Slave New ideas packages PEAR Periodics Perl pkg-plist Ports tree bugs PostgreSQL Procedures Python Reports Sanity Tests Server Stored procedures Trigger Uncategorized vuxml Watch Lists XML

Recent Comments

  • Dan Langille on If packages and ports are cached separately, how is one included in the middle of the other?
  • Dan Langille on If packages and ports are cached separately, how is one included in the middle of the other?
  • Dan Langille on Mail sending failures
  • Dan Langille on Things you didn’t know FreshPorts can do
  • grahamperrin on Things you didn’t know FreshPorts can do

Archives

Follow Me

Twitter
© 2019 Dan Langille This is where I write about my work on FreshPorts. Suffusion theme by Sayontan Sinha