Postgres Pro
Downloads
Home   >   mailing lists

Re: Delete Cascade FK speed issue - Mailing list pgsql-performance

From Axel Rau
Subject Re: Delete Cascade FK speed issue
Date
Msg-id ECC71DAB-3DEC-43FD-9D8B-0D348C2D2E67@Chaos1.DE
Whole thread Raw
In response to Re: Delete Cascade FK speed issue  (Michael Fuhr <mike@fuhr.org>)
List pgsql-performance
Tree view

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                       +49 69 9514 18 0


pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Filesystem Direct I/O and WAL sync option
Next
From: Dimitri
Date:
Subject: Re: Filesystem Direct I/O and WAL sync option