| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Alexander Antonakakis <alexis(at)maich(dot)gr> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Large database |
| Date: | 2004-11-14 05:01:47 |
| Message-ID: | 20041114050147.GA91453@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Nov 10, 2004 at 04:10:43PM +0200, Alexander Antonakakis wrote:
> I will have to make sql queries in the form "select value from
> product_actions where who='someone' and where='somewhere' and maybe make
> also some calculations on these results. I allready have made some
> indexes on these tables and a view that joins the two of them but I
> would like to ask you people if someone is using such a big db and how
> can I speed up things as much as it is possible on this
Can you give us an example of a query you'd like to speed up? Please
post the EXPLAIN ANALYZE output for the query as well so we can see
what the planner is doing.
Have you tuned any settings in postgresql.conf? The following page
has some tuning tips:
http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2004-11-14 05:29:27 | Re: Value of serial data type after insert. |
| Previous Message | Gary L. Burnore | 2004-11-14 02:39:12 | Re: I spoke with Marc from the postgresql mailing |