Re: [ADMIN] Vacuum Question

2003-03-01 Thread Daniel Schuchardt
Do a VACUUM FULL on your database. This should be the solution. Daniel ""Pascal PEYRE"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Hi, > > I use postgresql 7.2.x on Linux 2.4.18-6mdksmp #1 SMP i686 > > I have some big postgreSQL databases (4/5 GB at start) on this server

[ADMIN] compress the data sended via network???

2003-02-10 Thread Daniel Schuchardt
Hi @ all, I have some trouble with speed of our online-server. The problem is that we have to much traffic in some cases. Particulary BLOB or Memo -Fields slow down everything. So i look for some possibilities to compress the data sended via network. I expect a large incresement of speed exspecial

Re: [ADMIN] Large objects - SOS

2003-02-06 Thread Daniel Schuchardt
Hi, in 7.3 this changed. type : CREATE DOMAIN lo AS oid; And everything works well. Daniel <[EMAIL PROTECTED]> schrieb im Newsbeitrag OF0B8A93EA.20F6C498-ON65256CC3.0043C73A@LocalDomain">news:OF0B8A93EA.20F6C498-ON65256CC3.0043C73A@LocalDomain... > Hi, > I need to create a large object - a p