Re: ALTER TABLE DROP COLUMN

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER TABLE DROP COLUMN
Date: 2000-06-12 17:12:38
Message-ID: Pine.BSF.4.21.0006121410200.10507-100000@thelab.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 11 Jun 2000, Bruce Momjian wrote:

> > > -----Original Message-----
> > > From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> > >
> > > >> Seems we have 4 DROP COLUMN ideas:
> > > >> Method Advantage
> > > >> -----------------------------------------------------------------
> > > >> 1 invisible column marked by negative attnum fast
> > > >> 2 invisible column marked by is_dropped column fast
> > > >> 3 make copy of table without column col removed
> > > >> 4 make new tuples in existing table without column col removed
> > >
> >
> > Hmm,I've received no pg-ML mails for more than 1 day.
> > What's happened with pgsql ML ?
>
> Tom says there are tons of messages in the hub.org mail queue, but they
> are not being delivered.

I was out for the past 4 days taking a little girl camping for her b-day
... great weekend, but we had a process run rampant over the weekend that
caused the loadavg to skyrocket. For anyone that has ever used sendmail,
they will know that a high load will cause sendmail to essentially shut
itself down, queuing only up to a certain point, refusing connections
after that ... queuing is at a loadavg of 15, refusing connections at 20,
the machine was slightly higher then that ...

Just checked the queue, and now that the load is back down, the queue is
pretty much flushed out again ...

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-06-12 17:13:39 Re: pgsql (Makefile)
Previous Message Tom Lane 2000-06-12 17:10:00 Re: Adding time to DATE type