On 11/26/2008 06:44 PM, tv@xxxxxxxx wrote: > Try running EXPLAIN ANALYZE - that gives much more information. For > example it may show differences in number of rows between the two > machines, that the statistics are not up to date, etc. Thanks a lot for this tip -- [ Clemens Schwaighofer -----=====:::::~ ] [ IT Engineer/Manager ] [ E-Graphics Communications, TEQUILA\ Japan IT Group ] [ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ] [ Tel: +81-(0)3-3545-7706 Fax: +81-(0)3-3545-7343 ] [ http://www.tequila.jp ]
Attachment:
signature.asc
Description: OpenPGP digital signature