Re: [GENERAL] Question about plan difference between 9.3 and 9.3.2

2014-01-17 Thread Jeff Ross
On 1/17/14, 11:02 AM, Tom Lane wrote: Jeff Ross writes: I had to move our production database to a new server with virtually identical hardware. At the same time I went to 9.3.2 from 9.3. Queries on the old server (nirvana) run many magnitudes faster than on the new server (dukkha). The two ar

Re: [GENERAL] Question about plan difference between 9.3 and 9.3.2

2014-01-17 Thread Tom Lane
Jeff Ross writes: > I had to move our production database to a new server with virtually > identical hardware. At the same time I went to 9.3.2 from 9.3. > Queries on the old server (nirvana) run many magnitudes faster than on > the new server (dukkha). > The two are configured the same except

[GENERAL] Question about plan difference between 9.3 and 9.3.2

2014-01-17 Thread Jeff Ross
Hi all, I had to move our production database to a new server with virtually identical hardware. At the same time I went to 9.3.2 from 9.3. Queries on the old server (nirvana) run many magnitudes faster than on the new server (dukkha). The two are configured the same except for the IP addre