On Mon, Feb 22, 2010 at 3:33 PM, Yang Zhang <yanghatespam@xxxxxxxxx> wrote: > On Mon, Feb 22, 2010 at 5:31 PM, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote: >> When in doubt - test. >> Why not remove index in MySQL (or create index in PostgreSQL) and see >> what happens. >> Why trying compare "apples and oranges"? > > Continue reading this thread -- I also tried using an index in Postgresql. And oh yeah, what was shared_buffers set to? I'm not sure we ever got an answer to that. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general