Re: [GENERAL] string comparison problem

Behalf Of John R Pierce Sent: Monday, August 01, 2011 10:58 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] string comparison problem On 08/01/11 11:12 AM, Johnny Edge wrote: > I have a problem with identical versions of postgresql - 8.3.13 Config > files are identical. HostA is a

[GENERAL] string comparison problem

Hi folks, I have a problem with identical versions of postgresql - 8.3.13 Config files are identical. HostA is a 32 bit CentOS 5.3 install and the hostB is x86_64 CentOS 6. Difference in architecture should not be a problem - I have another 64 bit CentOS where both queries are executed displ

[GENERAL] string comparison problem

Hi folks, I have a problem with identical versions of postgresql - 8.3.13 Config files are identical. HostA is a 32 bit CentOS 5.3 install and the hostB is x86_64 CentOS 6. Difference in architecture should not be a problem - I have another 64 bit CentOS where both queries are executed displ

[GENERAL] string comparison problem

Hi folks, I have a problem with identical versions of postgresql - 8.3.13 Config files are identical. HostA is a 32 bit CentOS 5.3 install and the hostB is x86_64 CentOS 6. Difference in architecture should not be a problem - I have another 64 bit CentOS where both queries are executed displ

[GENERAL] pg query exec time, reports

Hello folks, I wish to log query execution time on all queries. Could you please advise re the same? Could you also suggest report generation tools? I.e. what queries take longest time to exec, duration of session, etc. Thanks, -JE