On Tue, Jun 8, 2010 at 8:58 PM, Mark Rostron <mrostron@xxxxxxx> wrote: > I am looking for some specific information regarding optimizer behavior. > > We recently experienced a situation where a query that was previously using > a btree lookup (efficient) SWITCHED to using seqscan/hash lookup. OK, before we go any further, got any explain analyze output of the fast and slow queries? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
