| From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
|---|---|
| To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | Re: [HACKERS] Not enough memory for complex join |
| Date: | 1999-03-09 08:59:17 |
| Message-ID: | Pine.SOL2.3.96.SK.990309115639.18124B-100000@sun.med.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello!
On Fri, 5 Mar 1999, The Hermit Hacker wrote:
> > > vacuum...
> >
> > I didn't think it could be of any help. I have a copy of this database
> > on my local computer. I dump db on server and put it on local computer
> > every other day, so I thiink VACUUM is unneccessary here.
>
> Try 'vacuum analyze'...vacuum, rom my understanding, just cleans out the
> database of old records...reloading the db from scratch effectively has
> that already done. 'vacuum analyze' adjusts statistics that don't get
> changed on a load, that determins, to a large extet, how the optimizaer
> runs things...
Ha, then I stuck on another bug. VACUUM ANALYZE failed on glibc2 with
--enable-locale. I reported this in "VACUUM ANALYZE problem" thread. Look
into mail archive for February :(((
> Marc G. Fournier
> Systems Administrator @ hub.org
> primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 1999-03-09 09:23:44 | Re: [HACKERS] Developers globe |
| Previous Message | Horak Daniel | 1999-03-09 08:29:36 | dynamic loading on NT works! |