An index can make all the difference

Before the last post was published, I forgot to add in the fix for the pathname problem. freshports.org=# select ElementPathnameUpdateChildren(453745); It run. A long time. I let it run. For hours. About 16 hours. Then I killed it. I checked the procedure. It made sense. Then I checked the update statement: freshports.org=# explain analyse UPDATE

An index can make all the difference Read More »

Creating the new repo base directories

I started looking at how to create these new directories as mentioned yesterday. This starts the process: $ psql freshports.org psql (9.0.8, server 9.0.9) Type “help” for help. freshports.org=# select Element_Add(‘/base/head’, ‘D’); element_add ————- 453742 (1 row) freshports.org=# select Element_Add(‘/doc/head’, ‘D’); element_add ————- 453743 (1 row) freshports.org=# select Element_Add(‘/ports/head’, ‘D’); element_add ————- 0 (1 row)

Creating the new repo base directories Read More »

Wrong path on src commits

Wesley Shields (wxs@) wrote in to point out that the commits for Mk/bsd.sites.mk where not showing up correctly. Not sure if you know about this or not but it appears that (at least) Mk/bsd.sites.mk is not being properly updated on freshports since August 5. I compared these two URLS: http://www.freshports.org/Mk/bsd.sites.mk http://dev.freshports.org/Mk/bsd.sites.mk Yep. The full commits

Wrong path on src commits Read More »

Scroll to Top