Re: vacuum and 24/7 uptime

Hi Mark, This is being worked on now. I believe the 7.2 release will have
enable you to run a vacuum with no downtime.

-r

At 03:39 PM 7/11/01 -0600, Mark wrote:

On Mi� 11 Jul 2001 13:46, Ryan Mahoney wrote:

Hi Mark, This is being worked on now. I believe the 7.2 release will have
enable you to run a vacuum with no downtime.

AFAIK, if UNDO is implemented, no vacuum will be needed to free space.

It would be great if UNDO would clean indexes.

Saludos.... :-)

--
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques | mmarques@unl.edu.ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------

Any thoughts as to when 7.2 is targeted for release?

The fall, 2001.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Greetings, Bruce!

At 12.07.2001, 03:49, you wrote:

Any thoughts as to when 7.2 is targeted for release?

BM> The fall, 2001.

Will you be even kinder and enlighten us, mere users, on the features
planned for this release? ;

--
Yours, Alexey V. Borzov, Webmaster of RDW.ru

On Thu, Jul 12, 2001 at 11:04:11AM +0400,
Alexey Borzov <borz_off@rdw.ru> wrote:

Will you be even kinder and enlighten us, mere users, on the features
planned for this release? ;

http://www.postgresql.org/docs/todo.html

The list looks fantastic. I'm now looking forward to this release. Sounds like
it's planned for just 6-9 months after the 7.1 release, or thereabouts? Good
agressive schedule.

I would like to request one more feature of course: support for ALTER TABLE
tablename MODIFY columnname [create clause] would make my life much easier.
When designing a new database from scratch, I often find myself having to change
column types during the very early stages of development.

That would also help users who need to convert their MONEY columns to
money-formatted decimal coluns once this release comes out and they upgrade.

Again, thanks for all the hard work.

Wes Sheldahl

Bruno Wolff III <bruno%wolff.to@interlock.lexmark.com> on 07/12/2001 09:24:31 AM

To: Alexey Borzov <borz_off%rdw.ru@interlock.lexmark.com>
cc: Bruce Momjian <pgman%candle.pha.pa.us@interlock.lexmark.com>, Tim Barnard
<tbarnard%povn.com@interlock.lexmark.com>,
pgsql-general%postgresql.org@interlock.lexmark.com (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: [GENERAL] Re: Pg7.2 (was: vacuum and 24/7 uptime)

On Thu, Jul 12, 2001 at 11:04:11AM +0400,
Alexey Borzov <borz_off@rdw.ru> wrote:

Will you be even kinder and enlighten us, mere users, on the features
planned for this release? ;

http://www.postgresql.org/docs/todo.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Greetings, Bruce!

At 12.07.2001, 03:49, you wrote:

Any thoughts as to when 7.2 is targeted for release?

BM> The fall, 2001.

Will you be even kinder and enlighten us, mere users, on the features
planned for this release? ;

Light-weight vacuum with light locking and statistics of queries.

All items marked with a dash on the TODO list will be in there.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Bruno Wolff III writes:

On Thu, Jul 12, 2001 at 11:04:11AM +0400,
Alexey Borzov <borz_off@rdw.ru> wrote:

Will you be even kinder and enlighten us, mere users, on the features
planned for this release? ;

http://www.postgresql.org/docs/todo.html

Those are not the features planned for this release.

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter

Alexey Borzov writes:

Will you be even kinder and enlighten us, mere users, on the features
planned for this release? ;

National language support, if I can get some people to do the translating.
(Hint, hint.)

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter

Peter Eisentraut wrote:

Alexey Borzov writes:

Will you be even kinder and enlighten us, mere users, on the features
planned for this release? ;

National language support, if I can get some people to do the translating.
(Hint, hint.)

Ill be happy to help with hebrew.

Bruno Wolff III writes:

On Thu, Jul 12, 2001 at 11:04:11AM +0400,
Alexey Borzov <borz_off@rdw.ru> wrote:

Will you be even kinder and enlighten us, mere users, on the features
planned for this release? ;

http://www.postgresql.org/docs/todo.html

Those are not the features planned for this release.

Yes, only the ones marked with dashes are done for 7.2 so far.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

On Thu, Jul 12, 2001 at 08:24:31AM -0500, Bruno Wolff III wrote:

Will you be even kinder and enlighten us, mere users, on the
features planned for this release? ;

http://www.postgresql.org/docs/todo.html

I notice the "urgent" item for point-in-time recovery doesn't have
the '-' indicating a 7.2 item.

When is that planned?

I hope for 7.2.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Bruce Momjian <pgman@candle.pha.pa.us> writes:

I notice the "urgent" item for point-in-time recovery doesn't have
the '-' indicating a 7.2 item.

When is that planned?

I hope for 7.2.

What grounds do you have for hoping that? If there's anyone working
on it, they're sure keeping a mighty low profile.

Given that we're hoping to go beta in another six weeks or so, anything
that's not got a commitment from someone now is unlikely to be finished
for 7.2. I don't believe that anything as large as PIT recovery is
going to magically appear out of the woodwork.

regards, tom lane

Bruce Momjian <pgman@candle.pha.pa.us> writes:

I notice the "urgent" item for point-in-time recovery doesn't have
the '-' indicating a 7.2 item.

When is that planned?

I hope for 7.2.

What grounds do you have for hoping that? If there's anyone working
on it, they're sure keeping a mighty low profile.

Given that we're hoping to go beta in another six weeks or so, anything
that's not got a commitment from someone now is unlikely to be finished
for 7.2. I don't believe that anything as large as PIT recovery is
going to magically appear out of the woodwork.

Someone told me they would do it. I will not disclose their name
because I don't think I have the right to do that.

I haven't heard from them in a while. Let's just assume the feature
will not be in 7.2 then.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Bruce Momjian <pgman@candle.pha.pa.us> writes:

... I don't believe that anything as large as PIT recovery is
going to magically appear out of the woodwork.

Someone told me they would do it. I will not disclose their name
because I don't think I have the right to do that.

And if "hacker X" delivers a patch that large a week or so before beta,
with no prior discussion of features or implementation techniques on
the mailing lists, we'd accept it? Hacker X needs to be told that
that's not how this project is run.

regards, tom lane

Bruce Momjian <pgman@candle.pha.pa.us> writes:

... I don't believe that anything as large as PIT recovery is
going to magically appear out of the woodwork.

Someone told me they would do it. I will not disclose their name
because I don't think I have the right to do that.

And if "hacker X" delivers a patch that large a week or so before beta,
with no prior discussion of features or implementation techniques on
the mailing lists, we'd accept it? Hacker X needs to be told that
that's not how this project is run.

I hope "hacker X" is listening. :-)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

I would like to request one more feature of course: support for ALTER
TABLE tablename MODIFY columnname [create clause] would make my life much

and ALTER TABLE DROP COLUMN! I see it's on the list, just not apparently for
7.2. Oh well I guess you can only do so much. Postgres really is great!
When ALL the features on that list are implemented, it will really kick some
serious MS arse! Am wondering how long that will take...

--
Like to travel? http://TravTalk.org
Micah Yoder Internet Development http://yoderdev.com