Re: Large database

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/