| From: | Clemens Schwaighofer <clemens(dot)schwaighofer(at)tequila(dot)jp> |
|---|---|
| To: | tv(at)fuzzy(dot)cz |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres 8.3 only uses seq scan |
| Date: | 2008-11-26 09:46:49 |
| Message-ID: | 492D1B09.4060006@tequila.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/26/2008 06:44 PM, tv(at)fuzzy(dot)cz 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 ]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Együd | 2008-11-26 10:17:34 | Re: Separate Sessions?? (View data <-> Query tool) |
| Previous Message | tv | 2008-11-26 09:44:30 | Re: Postgres 8.3 only uses seq scan |