Re: [PERFORM] Filesystem Direct I/O and WAL sync option

2007-07-04 Thread Gregory Stark
"Dimitri" <[EMAIL PROTECTED]> writes: > Yes Gregory, that's why I'm asking, because from 1800 transactions/sec > I'm jumping to 2800 transactions/sec! and it's more than important > performance level increase :)) wow. That's kind of suspicious though. Does the new configuration take advantage o

Re: [PERFORM] Filesystem Direct I/O and WAL sync option

2007-07-04 Thread Dimitri
Yes Gregory, that's why I'm asking, because from 1800 transactions/sec I'm jumping to 2800 transactions/sec! and it's more than important performance level increase :)) Rgds, -Dimitri On 7/4/07, Gregory Stark <[EMAIL PROTECTED]> wrote: "Dimitri" <[EMAIL PROTECTED]> writes: > Yes, disk drives

Re: [PERFORM] Delete Cascade FK speed issue

2007-07-04 Thread Axel Rau
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