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 these

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

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.217content-type=text/x-cvsweb-markup nope. :( We recently had a very satisfactory contract

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 heavy

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:

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

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 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 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 to under 10