Boissy-Maugis

Boissy-Maugis is a former commune in the Orne department in northwestern France. On 1 January 2016, it was merged into the new commune of Cour-Maugis-sur-Huisne.[2]

Boissy-Maugis
Location of Boissy-Maugis
Boissy-Maugis
Boissy-Maugis
Coordinates: 48°26′30″N 0°42′46″E
CountryFrance
RegionNormandy
DepartmentOrne
ArrondissementMortagne-au-Perche
CantonBretoncelles
CommuneCour-Maugis-sur-Huisne
Area
1
22.44 km2 (8.66 sq mi)
Population
 (2013)[1]
358
  Density16/km2 (41/sq mi)
Time zoneUTC+01:00 (CET)
  Summer (DST)UTC+02:00 (CEST)
Postal code
61110
Elevation122–249 m (400–817 ft)
(avg. 304 m or 997 ft)
1 French Land Register data, which excludes lakes, ponds, glaciers > 1 km2 (0.386 sq mi or 247 acres) and river estuaries.

Population

Historical population
YearPop.±%
1962471    
1968416−11.7%
1975387−7.0%
1982380−1.8%
1990351−7.6%
1999374+6.6%
2006416+11.2%
2008386−7.2%
gollark: What? Why does it say it's doing a sequential scan now? Æ all is bee.
gollark: Slower, even.
gollark: Oops, it turns out I'm accidentally sorting by it instead of the rank, but it's equally slow after fixing that.
gollark: ```nonlocality=# EXPLAIN ANALYZE SELECT url, ts_rank(fts, query), ts_headline(fts::text, query, 'MaxWords=60') AS rank FROM pages, websearch_to_tsquery('bee') query WHERE fts @@ query ORDER BY rank LIMIT 1; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=860.92..860.92 rows=1 width=96) (actual time=8506.425..8506.427 rows=1 loops=1) -> Sort (cost=860.92..861.05 rows=52 width=96) (actual time=8506.423..8506.425 rows=1 loops=1) Sort Key: (ts_headline((pages.fts)::text, query.query, 'MaxWords=60'::text)) Sort Method: top-N heapsort Memory: 25kB -> Nested Loop (cost=688.65..860.66 rows=52 width=96) (actual time=1.362..8505.403 rows=348 loops=1) -> Function Scan on websearch_to_tsquery query (cost=0.25..0.26 rows=1 width=32) (actual time=0.023..0.025 rows=1 loops=1) -> Bitmap Heap Scan on pages (cost=688.40..846.49 rows=52 width=142) (actual time=0.353..1.502 rows=348 loops=1) Recheck Cond: (fts @@ query.query) Heap Blocks: exact=231 -> Bitmap Index Scan on page_search_index (cost=0.00..688.39 rows=52 width=0) (actual time=0.320..0.320 rows=387 loops=1) Index Cond: (fts @@ query.query) Planning Time: 0.190 ms Execution Time: 8506.463 ms(13 rows)```
gollark: It's not a condition, it's an extra row on the output, and I can see exactly what it does via `EXPLAIN ANALYZE`.

See also

References



This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.