Re: [PERFORM] postgresql performance with multimedia

2004-08-23 Thread my ho
--- Jan Wieck <[EMAIL PROTECTED]> wrote: > On 8/17/2004 8:44 PM, my thi ho wrote: > > > Hi, > > I am working on a project which explore postgresql > to > > store multimedia data. > > In details, i am trying to work with the buffer > > management part of postgres source code. And try > to > > im

Re: [PERFORM] How do I see what triggers are called on cascade?

2004-08-23 Thread Tom Lane
[EMAIL PROTECTED] writes: > I'm still having trouble with slow cascading DELETEs. What commands can I issue to > see the sequence of events that occurs after I execute > DELETE FROM x WHERE p; > so that I can see if indexes being used correctly, or I have a constraint I don't > want, etc. I'd s

[PERFORM] How do I see what triggers are called on cascade?

2004-08-23 Thread andrew
I'm still having trouble with slow cascading DELETEs. What commands can I issue to see the sequence of events that occurs after I execute DELETE FROM x WHERE p; so that I can see if indexes being used correctly, or I have a constraint I don't want, etc. ---(end of broa

Re: [PERFORM] postgresql 8.0 beta - fail to collect statsistic

2004-08-23 Thread Tom Lane
Steve Bergman <[EMAIL PROTECTED]> writes: > If IPv6 doesn't work, shouldn't it fall back to IPv4, It does. That was all debugged in 7.4 --- we have not seen any cases since 7.4 beta in which failures of this kind did not mean a misconfigured networking setup. regards, tom

Re: [PERFORM] postgresql 8.0 beta - fail to collect statsistic

2004-08-23 Thread Steve Bergman
If IPv6 doesn't work, shouldn't it fall back to IPv4, or check IPv4 first, or something? Just wondering. -Steve Bergman ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAd

Re: [PERFORM] postgresql 8.0 beta - fail to collect statsistic

2004-08-23 Thread Tom Lane
my thi ho <[EMAIL PROTECTED]> writes: > I got this error message: > LOG: could not create IPv6 socket: Address family not > supported by protocol > LOG: could not bind socket for statistics collector: > Cannot assign requested address > LOG: disabling statistics collector for lack of > working

[PERFORM] postgresql 8.0 beta - fail to collect statsistic

2004-08-23 Thread my thi ho
Hi, I got this error message: LOG: could not create IPv6 socket: Address family not supported by protocol LOG: could not bind socket for statistics collector: Cannot assign requested address LOG: disabling statistics collector for lack of working socket LOG: database system was shut down at