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/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
