March 2021

FreshPorts will disable user login/updates on March 31 as part of transition to git

Hello, The changeover from subversion to git for the FreeBSD project enters it’s final stage about three hours from now (as I type this). At 3:01 UTC on Mar 31 2021, the repository will become read-only. The full schedule for that process is in the FreeBSD wiki. The first git commit is not expected until […]

FreshPorts will disable user login/updates on March 31 as part of transition to git Read More »

to_tsquery gives ‘ERROR: syntax error in tsquery’ when it contains a space

I had noticed a problem with my full text search solution when I was testing. If the input query contained a quote, an error resulted on the query. At the time, I attributed that to a poor input/text handling. Later, I realized I was wrong. On the website, this PHP code is used: Where $this->Query

to_tsquery gives ‘ERROR: syntax error in tsquery’ when it contains a space Read More »

A PostgreSQL query runs in 1.7s – add a LIMIT 10, runs in 28.2 seconds

In yesterdays blog post, Replacing a column search with a full text search solution, I wanted to mention how adding a LIMIT 10 to a fast running query made it run slower. I didn’t remember that issue until this morning. Fortunately, the fix was low cost. The query This is the query I ran: The

A PostgreSQL query runs in 1.7s – add a LIMIT 10, runs in 28.2 seconds Read More »

Replacing a column search with a full text search solution

One of the many useful features on FreshPorts is: what port[s] install[s] this file? That’s the pkg-plist search option. pkg-plist is a file which “lists all the files installed by the port”. However not all ports have a pkg-plist file because the list is compiled automatically. That is why the configure_plist table was created to

Replacing a column search with a full text search solution Read More »

Scroll to Top