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