Configuration parameter work_mem in PostgreSQL on Linux

I posted your query plan on explain.depesz.com, have a look. The query planner’s estimates are terribly wrong in some places. Have you run ANALYZE recently? Read the chapters in the manual on Statistics Used by the Planner and Planner Cost Constants. Pay special attention to the chapters on random_page_cost and default_statistics_target. You might try: ALTER … Read more

Make XAMPP / Apache serve file outside of htdocs folder [closed]

Ok, per pix0r‘s, Sparks‘ and Dave‘s answers it looks like there are three ways to do this: Virtual Hosts Open C:\xampp\apache\conf\extra\httpd-vhosts.conf. Un-comment ~line 19 (NameVirtualHost *:80). Add your virtual host (~line 36): <VirtualHost *:80> DocumentRoot C:\Projects\transitCalculator\trunk ServerName transitcalculator.localhost <Directory C:\Projects\transitCalculator\trunk> Order allow,deny Allow from all </Directory> </VirtualHost> Open your hosts file (C:\Windows\System32\drivers\etc\hosts). Add 127.0.0.1 transitcalculator.localhost … Read more