On 10/25/05, Michael Fuhr <mike@fuhr.org> wrote:
> Are there indexes on the foreign key columns? That is, given
> the following example,
>
> CREATE TABLE foo (id integer PRIMARY KEY);
> CREATE TABLE bar (fooid integer NOT NULL REFERENCES foo ON DELETE CASCADE);
>
> do you have an index on bar.fooid?
There are no indexes on the referring fields in any tables. Would this
make a huge difference?
> Also, do you regularly vacuum and analyze the database?
Yes.