[PERFORM] Re: [GENERAL] Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!!

On 28 October 2011 09:02, Mohamed Hashim wrote: > EXPLAIN select * from stk_source ; > QUERY > PLAN > - >  Result  (cost=0.00..6575755.39 rows=163132513 width=42) >    ->  Appen

Re: [PERFORM] [GENERAL] How to improve: performance of query on postgresql 8.3 takes days

that though, you should at least declare these functions as STABLE instead of VOLATILE, see: http://www.postgresql.org/docs/8.4/interactive/xfunc-volatility.html Alban Hertroys -- Screwing up is an excellent way to attach something to the ceiling. !DSPAM:1144,4c52ae08286218152251173! -- Sent