Re: postgre performance question

Ioannis <Ioannis@dante.org.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