Dne 12.5.2011 16:23, Phoenix Kiula napsal(a):
> Hi
>
> Been reading some old threads (pre 9.x version) and it seems that the
> consensus is to avoid doing massive deletes from a table as it'll
> create so much unrecoverable space/gaps that vacuum full would be
> needed. Etc.
>
> Instead, we might
Dne 12.5.2011 17:37, Phoenix Kiula napsal(a):
> [mydomain] src > cd pg_reorg-1.1.5
>
> [mydomain] pg_reorg-1.1.5 > gmake
> Makefile:13: ../../src/Makefile.global: No such file or directory
> gmake: *** No rule to make target `../../src/Makefile.global'. Stop.
>
> [mydomain] pg_reorg-1.1.5 >
>
>
On Thu, May 12, 2011 at 8:23 AM, Phoenix Kiula wrote:
> Hi
>
> Been reading some old threads (pre 9.x version) and it seems that the
> consensus is to avoid doing massive deletes from a table as it'll
> create so much unrecoverable space/gaps that vacuum full would be
> needed. Etc.
> Any ideas o
[snip]
> You can easily install it as a contrib . Just read the installation guide or
> the man Page.
Thanks Eric. How though?
The instructions here --
http://reorg.projects.postgresql.org/pg_reorg.html -- are woefully
incomplete.
I have a standard PG install on WHM/Cpanel type server. I kn
On Thu, May 12, 2011 at 17:23, Phoenix Kiula wrote:
> Been reading some old threads (pre 9.x version) and it seems that the
> consensus is to avoid doing massive deletes from a table as it'll
> create so much unrecoverable space/gaps that vacuum full would be
> needed. Etc.
Just running DELETE wi
In response to Phoenix Kiula :
> Hi
>
> Been reading some old threads (pre 9.x version) and it seems that the
> consensus is to avoid doing massive deletes from a table as it'll
> create so much unrecoverable space/gaps that vacuum full would be
> needed. Etc.
>
> Instead, we might as well do a
Am 12.05.2011 16:38, schrieb Phoenix Kiula:
On Thu, May 12, 2011 at 10:33 PM, Eric Ndengang
wrote:
Am 12.05.2011 16:23, schrieb Phoenix Kiula:
Hi
Been reading some old threads (pre 9.x version) and it seems that the
consensus is to avoid doing massive deletes from a table as it'll
create so
Hi
Been reading some old threads (pre 9.x version) and it seems that the
consensus is to avoid doing massive deletes from a table as it'll
create so much unrecoverable space/gaps that vacuum full would be
needed. Etc.
Instead, we might as well do a dump/restore. Faster, cleaner.
This is all well
