| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Kamil Srot <kamil(dot)srot(at)nlogy(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tables dissapearing |
| Date: | 2007-08-27 17:52:44 |
| Message-ID: | 20070827175244.GE20539@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Kamil Srot wrote:
>
> Martijn van Oosterhout wrote:
>> On Mon, Aug 27, 2007 at 06:57:54PM +0200, Kamil Srot wrote:
>>
>>> Correct...the script does echo "vacuum full;" | $PGDIR/bin/psql -U
>>> postgres $db for each database...
>>> Hope it's correct?
>>>
>>
>> Well, I'd drop the "full" part, it tends to bloat indexes. Also, did
>> you check it was actually completing (no errors)?
>>
> Yes, it completes w/o errors... just VACUUM as output...
> OK, I'll drop the full part and do it less often...
What user is doing it? Is it a superuser? If it's not, then there's
your problem.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"If it wasn't for my companion, I believe I'd be having
the time of my life" (John Dunbar)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kamil Srot | 2007-08-27 17:57:15 | Re: Tables dissapearing |
| Previous Message | Joseph S | 2007-08-27 17:34:43 | Re: [ANNOUNCE] == PostgreSQL Weekly News - August 26 2007 == |