Re: Vacuum problems

----- "Scot Kreienkamp" <SKreien(at)la-z-boy(dot)com> wrote:

> Thanks for the advice Scott. I've taken out the vacuum fulls
> entirely.
> I've now got a nightly vacuum analyze as well as reindex. I'll
> probably
> drop both to every other night.
>
> BTW, the database shrunk by 2 gigs just from reindexing last night.
> I
> expect I'll see a performance gain from actually doing reindexing
> since
> this database has never been reindexed since it was put in production
> 6
> months ago.
>
> I've got about 12 tables that get caught by the autoanalyze and about
> 6
> that get caught by autovacuum on a daily basis. I'm not sure how
> often
> the autovacuum and autoanalyze runs on those tables. I probably need
> to
> up the logging to find out. I'm not worried about making it more
> aggressive yet.
>
> One other problem though... my database has a "-" in the name... when
> I
> try to run:
>
> psql -U postgres -d rms-prod -c "REINDEX SYSTEM rms-prod"

You need to quote the db name:
psql -U postgres -d rms-prod -c 'REINDEX SYSTEM "rms-prod"'

>
> I get this:
>
> ERROR: syntax error at or near "-"
> LINE 1: REINDEX SYSTEM rms-prod
>
> The user tables run fine. Should I reindex the system tables also?
> If
> so, how do I get around the dash in the db name?
>
> Thanks,
>
> Scot Kreienkamp
> La-Z-Boy Inc.
> skreien(at)la-z-boy(dot)com
> 734-242-1444 ext 6379
>

Adrian Klaver
aklaver(at)comcast(dot)net