Yeah, I forgot about the RULE on that table. Ignore my previous email.
-Scott
At 01:26 PM 1/15/2007, you wrote:
Hey all!
I'm having some trouble with a simple update on a table that only
has about 250,000 rows in it. The table itself looks something like:
CREATE TABLE price_details (
pric
Hey all!
I'm having some trouble with a simple update on a table that only has
about 250,000 rows in it. The table itself looks something like:
CREATE TABLE price_details (
price_detail_id int PRIMARY KEY,
private bool
) ;
There is one table that references price_details, but isn't affected
On Mon, Jan 15, 2007 at 02:44:15PM +, Ezequiel Luis Pellettieri wrote:
> Hi Andrew,
>
> Why don't you try droping all indexes exept but the constraints ones for
> each table.
I don't have the problem, so I don't know whether that will help.
> then you'll free aprox half of DB size. then re-c
Hi Andrew,
Why don't you try droping all indexes exept but the constraints ones for
each table.
then you'll free aprox half of DB size. then re-create indexes, one by one.
and finally you can perform a full vacuum.
that worked for me. :)
cheers
pelle.-
2007/1/15, Andrew Sullivan <[EMAIL PROT
On Mon, Jan 15, 2007 at 06:23:23AM -0800, Mario Behring wrote:
> Hi all,
>
> I've executed a VACUUM FULL on a database 33GB in size. The process
> was going fine until it reached a index (I guess it's an index) and
> there it stopped for more than 30 hours...the whole
> weekend..
It m
Hi all,
I've executed a VACUUM FULL on a database 33GB in size. The process was going
fine until it reached a index (I guess it's an index) and there it stopped for
more than 30 hours...the whole weekend..
I've canceled it but I desperately need to free some space at the server's
d
