On Tue, Jun 8, 2010 at 8:58 PM, Mark Rostron <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
