Re: [PERFORM] Prepared statements vs. Stored Procedures

ood rule of thumb is this: change data, several related operations, very simple processing involved -> stored procedure. Read data as in a reporting scenario -> prepared statements. Obviously if you're reading data in several steps and then aggregate it in the application then perhaps you nee

Re: [PERFORM] Performance Tuning Article

There have been problems with Xeon processors. Can you elaborate on that please ? Thanks, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 smime.p7s Description: S/MIME Cryptographic Signature

Re: [PERFORM] Performance Tuning Article

that ? The only information I have is a message from Tom Lane saying the buffer manager (or something like that) locking has been redone for 8.0. Any pointers ? Dave Thanks, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 smime.p7s Description: S/MIME Cryptographic Signature

Re: [PERFORM] Performance - moving from oracle to postgresql

oogle search, as you move forward through a very large (millions) search result. Regards, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PERFORM] Speed with offset clause

re's better ways of doing this. Regards, -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail comman

Re: [PERFORM] postgresql amd-64

tware/rhel/features/ you can also get a EM64T release. If anyone has opinions about that, I'd be happy to hear. -- Radu-Adrian Popescu CSA, DBA, Developer Aldrapay MD Aldratech Ltd. +40213212243 smime.p7s Description: S/MIME Cryptographic Signature