Re: Postgres refusing to use >1 core

            NpgsqlConnection arrestsConnection = new NpgsqlConnection(Properties.Settings.Default.dbConnectionString);

            arrestsConnection.Open();

            /// First clear out the geocoding table

            NpgsqlCommand geocodingTableClear = new NpgsqlCommand("TRUNCATE raw.\"TxDPS geocoding\"", arrestsConnection);

            geocodingTableClear.ExecuteNonQuery();

            NpgsqlDataReader arrests = new NpgsqlCommand("SELECT * FROM \"raw\".\"TxDPS all arrests\"", arrestsConnection).ExecuteReader();

            /// Based on the pattern defined at

            /// http://social.msdn.microsoft.com/Forums/en-US/parallelextensions/thread/2f5ce226-c500-4899-a923-99285ace42ae.

            foreach(IDataRecord arrest in

                from row in arrests.AsParallel().Cast <IDataRecord>()

                select row)

            {

                Geocoder geocodeThis = new Geocoder(arrest);

                geocodeThis.Geocode();

            }

            arrestsConnection.Close();