Posts

Showing posts from March 3, 2019

Pfister & Vogel

Image
Pfister & Vogel ( P&V ) was an American tannery business in Milwaukee, Wisconsin. Frederick Vogel emigrated from Wurtemberg, Germany to Milwaukee. In 1848, he founded a tannery on Milwaukee's Menominee River. Having also emigrated from Wurtemberg in 1845, Vogel's cousin Guido Pfister opened a shoe store on nearby West Water Street. They joined forces as the Pfister & Vogel Leather Company in 1853, and their company thrived, becoming one of the largest leather producers in the country. [1] August H. Vogel was vice-president of the company until his death. The company changed hands several times. Its last owners, U.S. Leather Company, shut it down in 2000. [2] Their buildings have been readapted for residential use. [3] See also Charles F. Pfister A.L. Gebhardt & Co. Vogel State Park Fred R. Zimmerman Menomonee Valley References ^ Woods, Clif F. "How Two German Boys Started Milwaukee's Tanneries" Milwaukee Telegram , Novemb

Menominee River

Image
river in Wisconsin and Michigan This article is about the river in Wisconsin and Michigan. For the Illinois river, see Menominee River (Illinois). For the river in southeastern Wisconsin, see Menomonee River. Menominee River Menominee River Location Physical characteristics Source    - location Brule and Michigamme rivers  - coordinates 45°57′12″N 88°11′46″W  /  45.95328°N 88.19624°W  / 45.95328; -88.19624 [2] Mouth    - location Green Bay, Lake Michigan  - coordinates 45°05′41″N 87°35′28″W  /  45.0947°N 87.59121°W  / 45.0947; -87.59121 Coordinates: 45°05′41″N 87°35′28″W  /  45.0947°N 87.59121°W  / 45.0947; -87.59121 Length 116 mi (187 km) Basin size 4,070 sq mi (10,500 km 2 ) [1] Menominee River watershed White Rapids Hydroelectric dam The Menominee River is a river in northwestern Michigan and northeastern Wisconsin in the United States. It is approximately 116 miles (187 km) long, [3] draining a rural fore

What would happen if I run two SQL commands using the same DB connection?

Image
1 I'm writing a program to run mass calculation and output results into PostgreSQL. My platform is Windows Sever 2008, PostgreSQL 10. My program is written in C. The results would be produced group by group, finishing of each group will create an extra thread to write the output. Now since the output threads are created one by one, it is possible that two or more SQL input commands will be created simultaneously, or the previous one is under process when new ones call the function. So my questions are: (1) What would happen if one thread is in SQL processing and another thread called PQexec(PGconn *conn, const char *query) , would they effect each other? (2) What if I apply different PGconn ? Would it speed up? postgresql