Alter table drop column and background vacuum?

[Stephen]

Any idea if alter table drop column and background vacuum will be
implemented by 7.3?
It's really critical for large applications that must run 24/7.

Stephen



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Scott Marlowe]

During the discussion of bools and hash index and partial indexes and
index growth and everything else, I tried to make a partial index on a
bool field and got the error that "data type bool has no default operator
for class hash..."

So, can I cast something to make this work, or is it possible to make
hash indexes work with bools. There are a few instances where a small
percentage of a table is marked false while the rest is true, or vice
versa, where a partial hash index would be nice to try, and may not have
the ever expanding index problem that brtees have.
--
"Force has no place where there is need of skill.", "Haste in every
business brings failures.", "This is the bitterest pain among men, to have
much knowledge but no power." -- Herodotus



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

Post by Scott Marlowe
During the discussion of bools and hash index and partial indexes and
index growth and everything else, I tried to make a partial index on a
bool field and got the error that "data type bool has no default operator
for class hash..."

Well, no. I can't see much point in hashing for a datatype with only
two values. (Of course, btree probably sucks too in this case.)

You could probably gin one up pretty quickly using the support routines
for char_ops, if you want one for testing.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org