Re: ALTER TABLE DROP COLUMN - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: ALTER TABLE DROP COLUMN
Date
Msg-id Pine.BSF.4.21.0006121410200.10507-100000@thelab.hub.org
Whole thread Raw
In response to Re: ALTER TABLE DROP COLUMN  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
On Sun, 11 Jun 2000, Bruce Momjian wrote:

> > > -----Original Message-----
> > > From: Tom Lane [mailto:tgl@sss.pgh.pa.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 ...




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Adding time to DATE type
Next
From: Denis Perchine
Date:
Subject: Caching number of blocks in relation to avoi lseek.