- Original Message -
From: Tom Lane
To: Midge Brown
Cc: pgsql-performance@postgresql.org
Sent: Friday, August 03, 2012 11:26 PM
Subject: Re: [PERFORM] slow query, different plans
"Midge Brown" writes:
> I'm having a problem with a query on our prod
riday, August 03, 2012 6:30 PM
Subject: Re: [PERFORM] slow query, different plans
Midge --
Sorry for top-quoting -- challenged mail.
Perhaps a difference in the stats estimates -- default_statistics_target ?
Can you show us a diff between the postgres config files for each instance ?
Maybe some
"Midge Brown" writes:
> I'm having a problem with a query on our production server, but not on a
> laptop running a similar postgres version with a recent backup copy of the
> same table. I tried reindexing the table on the production server, but it
> didn't make any difference. Other queries o
Midge --
Sorry for top-quoting -- challenged mail.
Perhaps a difference in the stats estimates -- default_statistics_target ?
Can you show us a diff between the postgres config files for each instance ?
Maybe something there ...
Greg Williamson
>
> From: Midg
