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, 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 t
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
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 dbase.
Ok I know there will be somewhere a relation with a FK wi