Re: postgre performance question

Ioannis <Ioannis(at)dante(dot)org(dot)uk> writes:

> Hello,
>
> I am using a PostgreSQL database and I recently ran to some
> problems.
> I have a table of around two hunded thousand entries (each entry is
> 78 bytes) and a simple (selct * from table) query takes a lot of
> time to
> complete). Moreover a (select * from table where column = (select
> oid from another_table)) takes several tens of minutes. An index is
> already used for `column'.
> The `another_table' has something like 200 entries, while column
> takes its values from the OIDs of `another_table'.

Sounds as if you're not running VACUUM.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863