Re: ALTER TABLE name RENAME TO new_name; does not work immediately - Mailing list pgsql-bugs

<megous@gmail.com> writes:

> ALTER TABLE name RENAME TO new_name;
> ALTER TABLE new_name
>   RENAME COLUMN x TO y;
>
...
> I think the issue might be reproducible by creating table with a lot
> of rows, setting high work_mem and issuing the commands, but I did not
> try to reproduce it this way.

The commands you described should take the same length of time regardless of
the size of table and the memory settings are not relevant. I suspect you're
actually running some different commands?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning