Re: [HACKERS] OT moving from MS SQL to PostgreSQL

2004-10-10 Thread Greg Stark
Christopher Browne <[EMAIL PROTECTED]> writes: > - The alternative _I_ would most like would be to deploy web apps > in Lisp, but I never have the "round tuits" to get into that > very far... If you find any tuits sometime you might want to check out Per Bothner's Kawa. It's a scheme impleme

Re: [HACKERS] Speeding up DELETEs on table with FKs ...

2004-10-10 Thread Marc G. Fournier
On Mon, 11 Oct 2004, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: 'k, now that I've seen the error of my ways *groan* I've gone back through, and checked for what is referencing that table, and there is only one place that is, and it does have an INDEX: explain analyze select *

Re: [HACKERS] cvs tip broken build for plpython

2004-10-10 Thread Andrew Dunstan
Tom Lane said: > Andrew Dunstan <[EMAIL PROTECTED]> writes: >> The last REL7_4_STABLE build the machine did had this: > >> ccache gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes >> -Wmissing-declarations -fpic -shared -Wl,-soname,libplpython.so.0 >> plpython.o -L../../../src/port -L/usr

Re: [HACKERS] cvs tip broken build for plpython

2004-10-10 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > The last REL7_4_STABLE build the machine did had this: > ccache gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes > -Wmissing-declarations -fpic -shared -Wl,-soname,libplpython.so.0 > plpython.o -L../../../src/port -L/usr/lib/python2.2/confi

Re: [HACKERS] Speeding up DELETEs on table with FKs ...

2004-10-10 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > 'k, now that I've seen the error of my ways *groan* I've gone back > through, and checked for what is referencing that table, and there is only > one place that is, and it does have an INDEX: >> explain analyze select * from table where raw_id =

[HACKERS] CVS fixed ...

2004-10-10 Thread Marc G. Fournier
pgsql-server renamed to pgsql contrib/earthdistance moved back into pgsql/contrib/earthdistance modules file updated for changes checkout seems to work fine for me ... let me know if there are any problems ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email:

Re: [HACKERS] Speeding up DELETEs on table with FKs ...

2004-10-10 Thread Marc G. Fournier
On Sun, 10 Oct 2004, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: I posted to -sql the other day about an atrociously slow DELETE on a table that has two FKs to a 'parent' table ... if the # of records in the table that match the condition is 1, its fast ... in the sample I'm work

Re: [HACKERS] Speeding up DELETEs on table with FKs ...

2004-10-10 Thread Marc G. Fournier
Not anymore I'm not :( Have I been looking at this backwards? I was looking at what the table being deleted from REFERENCES,but its what is REFERENCing that table I should be looking at, isn't? :( On Sun, 10 Oct 2004, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: I posted to -s

Re: [HACKERS] cvs tip broken build for plpython

2004-10-10 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: A couple of hours ago things started breaking thus, I assume related to the Makefile changes made around then: ccache gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -shared -Wl,-soname,l

Re: [HACKERS] Speeding up DELETEs on table with FKs ...

2004-10-10 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > I posted to -sql the other day about an atrociously slow DELETE on a table > that has two FKs to a 'parent' table ... if the # of records in the table > that match the condition is 1, its fast ... in the sample I'm working > with, there are 1639 r

Re: [HACKERS] cvs tip broken build for plpython

2004-10-10 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > A couple of hours ago things started breaking thus, I assume related to > the Makefile changes made around then: > ccache gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes > -Wmissing-declarations -fpic -shared -Wl,-soname,libplpython.so.0 pl

[HACKERS] cvs tip broken build for plpython

2004-10-10 Thread Andrew Dunstan
A couple of hours ago things started breaking thus, I assume related to the Makefile changes made around then: ccache gcc -O2 -fno-strict-aliasing -g -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -shared -Wl,-soname,libplpython.so.0 plpython.o -L../../../src/port -lpython2.2 -ldl -l

[HACKERS] Speeding up DELETEs on table with FKs ...

2004-10-10 Thread Marc G. Fournier
I posted to -sql the other day about an atrociously slow DELETE on a table that has two FKs to a 'parent' table ... if the # of records in the table that match the condition is 1, its fast ... in the sample I'm working with, there are 1639 records in the table ... Now, I'm making a guess that f

Re: [HACKERS] Status ofTrigger Firing Order and 'FOR EACH STATEMENT'?

2004-10-10 Thread Tom Lane
Dan Libby <[EMAIL PROTECTED]> writes: > Hi, I am running into a problem with changes in INSERT not showing up in > outer level triggers (that call the INSERT, which has its own trigger). I think 8.0 will behave the way you want, but with so little detail it's hard to be sure.

Re: [HACKERS] [pgsql-hackers-win32] build error in initdb on win32

2004-10-10 Thread Tom Lane
"Magnus Hagander" <[EMAIL PROTECTED]> writes: > The underlying problem is still there, though. initdb is pulling all > these symbols in from libpq.dll, which is clearly the wrong place to get > them... Or are they supposed to be available? If so, they should be > added to the official API, no? "Us