Re: [ADMIN] My server is oddly very slow

2011-05-06 Thread adrien ducos
Kevin Grittner a écrit : adrien ducos adu...@hbs-research.com wrote: Kevin Grittner a écrit : What does this show?: free -m total used free shared buffers cached Mem: 3042 3000 4104 2896 -/+

Re: [ADMIN] My server is oddly very slow

2011-05-05 Thread adrien ducos
Kevin Grittner a écrit : adrien ducos adu...@hbs-research.com wrote: [rearranged somewhat] The version of both databases is postgres 8.4.1 [sigh] You really should upgrade. http://www.postgresql.org/support/versioning http://www.postgresql.org/docs/8.4/static/release.html

Re: [ADMIN] My server is oddly very slow

2011-05-05 Thread Kevin Grittner
adrien ducos adu...@hbs-research.com wrote: Kevin Grittner a écrit : What does this show?: free -m total used free shared buffers cached Mem: 3042 3000 4104 2896 -/+ buffers/cache: 99 2942 Swap: 1983

[ADMIN] My server is oddly very slow

2011-05-04 Thread adrien ducos
I have 2 servers 1 for development (called dev) 1 for production (called prod). The server for development is very basic (a dual core 2.1ghtz on a basic 300MB hard drive with 2GB of memory (this server is not dedicated to postgres, it also uses php, mapserver and so on). I assigned the

Re: [ADMIN] My server is oddly very slow

2011-05-04 Thread Kevin Grittner
adrien ducos adu...@hbs-research.com wrote: [rearranged somewhat] The version of both databases is postgres 8.4.1 [sigh] You really should upgrade. http://www.postgresql.org/support/versioning http://www.postgresql.org/docs/8.4/static/release.html So I checked the memory on prod