| From: | Alvar Freude <alvar(at)agi(dot)de> |
|---|---|
| To: | Arsalan Zaidi <azaidi(at)directi(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Turning off transactions completely. |
| Date: | 2002-01-08 10:14:11 |
| Message-ID: | 1789603.1010488451@[10.1.2.221] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
>> I would suggest to optimize your Application!
>
> First thing I did! :-)
OK, then sorry :)
I've a application where the tome consumption and amount of data is
similar, so this was my first idea.
> 1. VACUUM is dead slow. The CPU monitor shows long stretches when there's
> barely any activity at all while the vacuum is going on.
yes :-(
I hope for the 7.2, it seems that Vacuum is much more faster there (but I
didn't tested it yet).
> 2. I do vacuum analyze's to help the database figure out how to best run
> my queries. But it *still* doesnt use some of them...
I had the same problem; a simple (but dirty) solution was to disable
sequential scans in postgresql.conf:
enable_seqscan = false
Ciao
Alvar
--
AGI :: Hohnerstrasse 23, 70469 Stuttgart
Fon +49 (0)711.490 320-0, Fax +49 (0)711.490 320-150
AGI auf Platz 3 im neuen Multimedia-Kreativranking
http://www.agi.de/tagebuch/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Colm McCartan | 2002-01-08 11:09:46 | Re: JDO implementation? |
| Previous Message | steve boyle | 2002-01-08 09:57:23 | Re: Adding constraint to existing table. |