Sometimes it doesn’t listen to the command pg_ctl stop, the following option can be used:
pg_ctl stop -m fast
or
pg_ctl stop -m immediate
Sometimes it doesn’t listen to the command pg_ctl stop, the following option can be used:
pg_ctl stop -m fast
or
pg_ctl stop -m immediate
To improve the performance of pg_sql database, it is necessary to vacuum regularly. Here is the command
vacuum full analyze sys_quest_list
update the file
app/design/frontend/default/megastore2/template/catalog/product/list/toolbar.phtml
change the “asc” to “desc”
done
http://www.magentocommerce.com/boards/viewthread/1176/P75/#t203693