On Thu, Oct 27, 2016 at 7:38 AM, Andreas Kretschmer <
akretsch...@spamfence.net> wrote:
> Tomas Vondra wrote:
>
> >
> > Perhaps the table is organized / sorted differently, or something like
> > that. How did you do the upgrade?
>
>
Nothing special, dump + reload. The table in question is tiny -
This is a weird problem. A "limit 5" query runs quicky as expected, but a
"limit 1" query never finishes -- it just blasts along at 100% CPU until I
give up. And this is a join between two small tables (262K rows and 109K
rows). Both tables were recently analyzed.
This is Postgres 9.3.5 (yes, we'l
