| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, "Eugene M(dot) Zheganin" <emz(at)norma(dot)perm(dot)ru> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Full vacuuming of BIG tables takes too long |
| Date: | 2003-05-22 15:11:59 |
| Message-ID: | 200305220811.59291.scrawford@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
You are likely to run into unhappy situations if you use views, rules, etc.
Depending on the version of PG it will either refuse to drop the table if
there are dependencies or it will drop it but the views won't be "connected"
to the new version of t1 after you run your opreation.
Cheers,
Steve
On Thursday 22 May 2003 07:01, Robert Treat wrote:
> Is it possible for you do Begin; Create Table t2 As Select * From t1;
> Drop Table t1 ; Alter table t2 Rename To t1; Commit;
>
> Note you might want to lock t1 from writers, but people could still
> select from it while you making the switch.
>
> Robert Treat
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Boes | 2003-05-22 15:21:08 | Backend exited with signal 14? |
| Previous Message | Tom Lane | 2003-05-22 14:08:03 | Re: Full vacuuming of BIG tables takes too long |