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