| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Andy Colson <andy(at)squeakycode(dot)net> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: unlogged tables |
| Date: | 2010-12-03 03:53:21 |
| Message-ID: | 1291348315-sup-1373@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Excerpts from Andy Colson's message of vie dic 03 00:37:17 -0300 2010:
> Ok, forget the time thing. Has nothing to do with it. (Which everyone already assumed I imagine).
>
> Its truncate.
>
> Create unloged table, fill it, truncate it, fill it again, restart pg, and the data will still be there.
Hmm, presumably the table rewrite thing in truncate is not preserving
the unlogged state (perhaps it's the swap-relfilenode business). Does
CLUSTER have a similar effect? What about VACUUM FULL? If so you know
where the bug is.
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2010-12-03 03:54:23 | Re: Author names in source files |
| Previous Message | Alvaro Herrera | 2010-12-03 03:38:44 | Re: Author names in source files |