| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | Ron Arts <ron(dot)arts(at)neonova(dot)nl> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Strange query plan difference between two machines |
| Date: | 2011-06-19 18:10:21 |
| Message-ID: | BANLkTikUNpnvbz48r_o6K6jeE=sJHYA_kQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 19 June 2011 18:42, Ron Arts <ron(dot)arts(at)neonova(dot)nl> wrote:
> Hi,
>
> I have two machines that have the same database with the same table
> and indexes (definitions are exactly the same). I compared the
> postgresql.conf
> and they are the same.
>
> Still the SQL query plan differs greatly for the same query. VACUUM ANALYZE
> does not make a difference, neither does recreating the indexes.
>
> Any hints on what could cause this? What can I check? How can I
> debug it?
Are the 2 versions of PostgreSQL between the 2 servers identical too?
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | java4dev | 2011-06-19 20:21:14 | Re: PL/pgSQL editor/debugger |
| Previous Message | Ron Arts | 2011-06-19 17:42:12 | Strange query plan difference between two machines |