Simple queries take forever to run

From: Michael Guerin <guerin(at)rentec(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Simple queries take forever to run
Date: 2003-08-27 21:40:05
Message-ID: 3F4D2535.8050103@rentec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I'm running into some performance problems trying to execute simple
queries.

postgresql version 7.3.3
.conf params changed from defaults.
shared_buffers = 64000
sort_mem = 64000
fsync = false
effective_cache_size = 400000

ex. query: select * from x where id in (select id from y);

There's an index on each table for id. SQL Server takes <1s to return,
postgresql doesn't return at all, neither does explain analyze.
x has 1200673 rows
y has 1282 rows

It seems like its ignoring the index and not using enough memory.. any
ideas?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2003-08-27 23:00:14 Re: Comparing postgresql7.4 CVS head on linux 2.4.20 and 2.6.0-test4
Previous Message Tom Lane 2003-08-27 19:38:19 Re: Replication Ideas