Re: [PERFORM] Trigger question

nted. http://www.postgresql.org/docs/current/interactive/sql-createtrigger.html "FOR EACH STATEMENT" probably this can help you a bit. Christoph Nelles -- Mit freundlichen Grüssen Evil Azraelmailto:[EMAIL PROTECTED] ---(end of broadca

Re: [PERFORM] 100 simultaneous connections, critical limit?

connections get very evenly used, no matter if there are 2 or 10. The CPU usage for them is very equally distributed. Christoph Nelles -- Mit freundlichen Grüssen Evil Azraelmailto:[EMAIL PROTECTED] ---(end of broadcast)-

Re: [PERFORM] "select max/count(id)" not using index

27;id' makes such a queries RL> many faster, but they still use a sequential scan. RL> Richard. -- Mit freundlichen Grüssen Evil Azraelmailto:[EMAIL PROTECTED] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[PERFORM] Various Questions

also seldom queried. Does the index slowdown noticable INSERTs? 4) Temporary tables will always be rather slow as they can´t gain from ANALYZE runs, correct? Thanx in advance for any answer Christoph Nelles -- Mit freundlichen Grüssen Evil Azrael mailto:[EMAIL

[PERFORM] Various Questions

also seldom queried. Does the index slowdown noticable INSERTs? 4) Temporary tables will always be rather slow as they can´t gain from ANALYZE runs, correct? Thanx in advance for any answer Christoph Nelles -- Mit freundlichen Grüssen Evil Azrael mailto:[EMAIL PROTECTED

Re: [PERFORM] Postgres 7.3.4 + Slackware 9.1

a BETA TEST versions. P> Any suggestion? P> THANKS ALL. P> ---(end of P> broadcast)--- P> TIP 5: Have you checked our extensive FAQ? P>http://www.postgresql.org/docs/faqs/FAQ.html -- Mit freundlichen Gr

Re: [PERFORM] Java Out-of-memory errors on attempts to read tables with millions of rows

of broadcast)--- RC> TIP 9: the planner will ignore your desire to choose an index scan if your RC> joining column's datatypes do not match -- Mit freundlichen Grüssen Evil Azraelmailto:[EMAIL PROTECTED]