Am 03.07.2007 um 13:33 schrieb Michael Fuhr:
Something like
the following should work for single-column foreign keys:
Nice query. Found immediately 2 missing indexes. (-;)
Axel
-
Axel Rau, ☀Frankfurt , Germany
On Tue, Jul 03, 2007 at 08:05:27AM +0200, Patric de Waha wrote:
Is there a way I can find out what postgres does, and where it hangs
around, so I know where the FK might not be indexed. (The dbase is
to big to analyze it by hand).
You could query the system catalogs to look for foreign key
On Tue, 2007-07-03 at 08:05 +0200, Patric de Waha wrote:
Hi,
I've dbase with about 80 relations.
On deleting a user, this cascades through all the tables.
This is very slow, for 20 users it takes 4 hours, with exclusive
access to the dbase.
No other users connected to the