| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | "Rose, Juergen" <Juergen(dot)Rose(at)sag-el(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SLOOOOOOOW |
| Date: | 2005-09-05 07:52:06 |
| Message-ID: | 200509050952.06605.peter_e@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am Montag, 5. September 2005 09:39 schrieb Rose, Juergen:
> I working now for a wile with postgres (7.4), and I have the impression
> that is one of the slowest dbms with which I've aver worked. Can please
> somebody explain to me, why this is the case?
I suggest you read the performance tips chapter of the documentation. For
slow-running specific queries, post the output of EXPLAIN ANALYZE. Also,
typical mistakes for a disproportionally slow database would be never having
run VACUUM or ANALYZE.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2005-09-05 07:54:51 | Re: SLOOOOOOOW |
| Previous Message | Rose, Juergen | 2005-09-05 07:39:47 | SLOOOOOOOW |