On Fri, Jan 16, 2009 at 4:37 PM, Oleg Bartunov o...@sai.msu.su wrote:
Just a quick question - why do you use quite old release 8.1 instead of
8.3.5 ?
I presume it's because it is the version that comes by default in
Debian Etch. So I'll take this opportunity to comment about
backports.org. If
Hi Francesco
most probabely this is due to the auto vacuum option on and if auto vacuum
is on then the in condition of high transaction on database it slows the
speed of the hole database.Set it off in postgres.conf and vacuum and
reindex transactional tables manualy with in every two million
On Montag, 19. Januar 2009, BRAHMA PRAKASH TIWARI wrote:
| most probabely this is due to the auto vacuum option on and if auto vacuum
| is on then the in condition of high transaction on database it slows the
| speed of the hole database.Set it off in postgres.conf and vacuum and
| reindex
On Mon, Jan 19, 2009 at 5:35 AM, BRAHMA PRAKASH TIWARI
prakashr...@gmail.com wrote:
Hi Francesco
most probabely this is due to the auto vacuum option on and if auto vacuum
is on then the in condition of high transaction on database it slows the
speed of the hole database.Set it off in
Hi all, i send this mesage because i just made a migration from my old
mysql db on a more robust postgres server.
I'm using version 8.1 on a linux debian 4.0
i have a dual core XEON 2.33GHz and 2Gb of ram ... 2 disk 15k mirrored
database works good but the performance are horrible! i hope is my
On Fri, Jan 16, 2009 at 04:18:02PM +0100, Francesco Andreozzi wrote:
Hi all, i send this mesage because i just made a migration from my old
mysql db on a more robust postgres server.
I'm using version 8.1 on a linux debian 4.0
i have a dual core XEON 2.33GHz and 2Gb of ram ... 2 disk 15k
Just a quick question - why do you use quite old release 8.1 instead of
8.3.5 ?
Post only changes in postgresql.conf and explain analyze of your slow
query.
Oleg
On Fri, 16 Jan 2009, Francesco Andreozzi wrote:
Hi all, i send this mesage because i just made a migration from my old mysql
db on