| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | "Scott Muir" <wsmuir(at)islandnet(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Vacuuming - how often? |
| Date: | 2001-11-14 15:55:57 |
| Message-ID: | 3.0.5.32.20011114235557.019fc790@192.228.128.13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 06:32 PM 11/13/01 -0700, Scott Muir wrote:
>I'm using 7.1 on redhat 7.1...
>
>I had a query result which startled me a bit... it was a simple join and
>the result was like a cartesian product like I hadn't bothered with a when
>clause.
>
>I ran vacuum from inside pgaccess and the results of the query changed to
>what I was expecting in the first place...
AFAIK in most typical cases results should not change because of a vacuum -
performance may change, but the results shouldn't.
If the results change then something is wrong - corrupted/buggy index perhaps.
Cheerio,
Link.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoffrey J. Gowey | 2001-11-14 15:58:40 | Re: transitioning from MS SQL Server to Postgres |
| Previous Message | Tom Lane | 2001-11-14 15:37:21 | Re: Memory exhausted in AllocSetReAlloc |