PDA

View Full Version : problem with vacuum



lir5353
08-12-2009, 12:56 PM
i did a lot of searches and i dont know what to do and need some help
In the begining i tried to do the automatic vacuume and i didnt succed
after that i tried the manual one and when i push on the "OK" the computer think for a while and then stopped and every row i see CPU 00/00
what can i do ?
do you have an idea what to do ?
thank u very much
liron

netsrak
08-12-2009, 01:08 PM
You are talking about a vacuum via pgadmin?
Please post a screenshot.

lir5353
08-12-2009, 01:15 PM
i am talking about the pgadmin
this is the picture

netsrak
08-13-2009, 03:20 AM
My message window looks a little bit different but i think your vacuum completed successfully and you can click cancel to leave it.

There are a lot of messages where the vacuum has nothing to do. Thats where the 00/00 come from.

lir5353
08-13-2009, 03:51 AM
thank u about the answer but i dont think it's finish because it take something like 3 seconde and i have 4 million hands so its doesnt make sense...
do you have another idea what could be?

netsrak
08-13-2009, 04:30 AM
can you please post a screenshot of the options before you start the vacuum?

lir5353
08-13-2009, 04:41 AM
sure...

dqmien
08-15-2009, 09:18 AM
BUMP


I have the exact same problem. Any help please ?

netsrak
08-15-2009, 10:28 AM
The screenshot looks strange.

But i have no idea why the vacuum does not work. The options seem to be correct. You could try to download the latest pgadmin version from www.pgadmin.org or you can try a vacuum from the command line: http://www.faqs.org/docs/ppbook/x17549.htm

dqmien
08-15-2009, 10:57 AM
ok thanks, I'm gonna try this.