Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2001-01-24 Thread Denis Perchine
On Wednesday 24 January 2001 20:37, Bruce Momjian wrote: > Here is another open item. What are we doing with LAZY vacuum? Sorry for inserting in the middle. I would like to say that when I tried LAZY vacuum on 7.0.3, I had a lockup on one of the table which disappeared after I did usual vacuum

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2001-01-24 Thread Bruce Momjian
Here is another open item. What are we doing with LAZY vacuum? > We recently had a very satisfactory contract completed by > Vadim. > > Basically Vadim has been able to reduce the amount of time > taken by a vacuum from 10-15 minutes down to under 10 seconds. > > We've been running with the

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2001-01-23 Thread Alfred Perlstein
* Bruce Momjian <[EMAIL PROTECTED]> [010122 19:55] wrote: > > Vadim, did these patches ever make it into 7.1? According to: http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/parser/gram.y?rev=2.217&content-type=text/x-cvsweb-markup nope. :( > > > We recently had a very satisfactory c

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2001-01-22 Thread Bruce Momjian
Vadim, did these patches ever make it into 7.1? > We recently had a very satisfactory contract completed by > Vadim. > > Basically Vadim has been able to reduce the amount of time > taken by a vacuum from 10-15 minutes down to under 10 seconds. > > We've been running with these patches under h

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2001-01-02 Thread Alfred Perlstein
* Peter Schmidt <[EMAIL PROTECTED]> [010102 12:53] wrote: > Will these patchsets be available to the public? > I get: > "You don't have permission to access /~alfred/vacfix/vlazy.tgz on this > server" > > Thanks. > Peter > > > There's three patchsets and they are available at: > > http://peopl

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2000-12-07 Thread Alfred Perlstein
* Tom Samplonius <[EMAIL PROTECTED]> [001207 18:55] wrote: > > On Thu, 7 Dec 2000, Alfred Perlstein wrote: > > > We recently had a very satisfactory contract completed by > > Vadim. > > > > Basically Vadim has been able to reduce the amount of time > > taken by a vacuum from 10-15 minutes down

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2000-12-07 Thread Tom Samplonius
On Thu, 7 Dec 2000, Alfred Perlstein wrote: > We recently had a very satisfactory contract completed by > Vadim. > > Basically Vadim has been able to reduce the amount of time > taken by a vacuum from 10-15 minutes down to under 10 seconds. ... What size database was that on? I looking at

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2000-12-07 Thread Alfred Perlstein
* Tom Lane <[EMAIL PROTECTED]> [001207 17:10] wrote: > Alfred Perlstein <[EMAIL PROTECTED]> writes: > > Basically Vadim has been able to reduce the amount of time > > taken by a vacuum from 10-15 minutes down to under 10 seconds. > > Cool. What's it do, exactly?

Re: [HACKERS] Patches with vacuum fixes available for 7.0.x

2000-12-07 Thread Tom Lane
Alfred Perlstein <[EMAIL PROTECTED]> writes: > Basically Vadim has been able to reduce the amount of time > taken by a vacuum from 10-15 minutes down to under 10 seconds. Cool. What's it do, exactly? regards, tom lane

[HACKERS] Patches with vacuum fixes available for 7.0.x

2000-12-07 Thread Alfred Perlstein
We recently had a very satisfactory contract completed by Vadim. Basically Vadim has been able to reduce the amount of time taken by a vacuum from 10-15 minutes down to under 10 seconds. We've been running with these patches under heavy load for about a week now without any problems except one: