[HACKERS] What to do with my patch?
The 14 december I submitted a patch that implements named function arguments. So far no one have said anything about that. It would be nice if someone could look at it and either reject, accept, put on queue, or anything else. The patch is very big (400k), but most of that size comes from trival changes on the initial system tables. -- /Dennis ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [HACKERS] [GENERAL] Backwards index scan
Tom Lane wrote: I have committed a fix into 7.5devel to do this properly. I think this is the last case wherein btree is unnecessarily inefficient for large numbers of equal keys. Any chance to have it on 7.4.1 ? Regards Gaetano Mendola ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] What to do with my patch?
Dennis Bjorklund wrote: > The 14 december I submitted a patch that implements named function > arguments. So far no one have said anything about that. It would be nice > if someone could look at it and either reject, accept, put on queue, or > anything else. > > The patch is very big (400k), but most of that size comes from trival > changes on the initial system tables. Uh, I don't remember seeing your patch, and I don't have it in my mailbox? Which email list did you send it to? Perhaps the email is stuck waiting for Marc to accept it. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] What to do with my patch?
On Sun, 21 Dec 2003, Bruce Momjian wrote: > Uh, I don't remember seeing your patch, and I don't have it in my > mailbox? Which email list did you send it to? Perhaps the email is > stuck waiting for Marc to accept it. http://archives.postgresql.org/pgsql-patches/2003-12/msg00176.php -- /Dennis ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [GENERAL] Backwards index scan
Gaetano Mendola <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I have committed a fix into 7.5devel to do this properly. I think this >> is the last case wherein btree is unnecessarily inefficient for large >> numbers of equal keys. > Any chance to have it on 7.4.1 ? No. It's inadequately tested to go into a stable release, and anyway I'm not sure what the interactions are with previous 7.5-only changes for cross-datatype indexing. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] What to do with my patch?
Dennis Bjorklund <[EMAIL PROTECTED]> writes: > The 14 december I submitted a patch that implements named function > arguments. So far no one have said anything about that. I have it on my to-look-at list, but I've been too busy trying to get 7.4.1 ready to do anything with pending patches. regards, tom lane ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004
Would this be at all useful? Someone mentioned that the 'fees' were relatively high though ... that you lose a fair amount off the top *to* Sourceforge? If we were going to do this, I would suggest just going right through paypal. Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org
Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON 2004
On Sun, 21 Dec 2003, Joshua D. Drake wrote: > > >> > >>Would this be at all useful? > >> > >> > > > >Someone mentioned that the 'fees' were relatively high though ... that you > >lose a fair amount off the top *to* Sourceforge? > > > > > > > If we were going to do this, I would suggest just going right through > paypal. I'd rather pay the high fees and actually have access to the money ... Paypal I'm 110% *against* ... they have had *way* too many problems. In fact, there was a time when we ourselves setup the whole paypal account and were looking at moving to it, until our clients started telling us they wouldn't use it. We, as a business, have had something like 25 "new clients" sign up in the past month that its turning out are cards stolen from clients who made purchases through paypal in the recent past ... We (ie. Hub) just went through re-evaluating our online credit card services, and are currently in the middle of moving our accounts to a company called PaySystems (http://www.paysystems.com) that we've found to have some of the better fees, and have yet to any major complaints about their services ... we haven't found any major complaints about our current one, but we just find we're losing too much money in the way of fees ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] [pgsql-advocacy] PostgreSQL speakers needed for OSCON
Marc G. Fournier wrote: On Sun, 21 Dec 2003, Joshua D. Drake wrote: Would this be at all useful? Someone mentioned that the 'fees' were relatively high though ... that you lose a fair amount off the top *to* Sourceforge? If we were going to do this, I would suggest just going right through paypal. I'd rather pay the high fees and actually have access to the money ... Paypal I'm 110% *against* ... they have had *way* too many problems. In fact, there was a time when we ourselves setup the whole paypal account and were looking at moving to it, until our clients started telling us they wouldn't use it. We, as a business, have had something like 25 "new clients" sign up in the past month that its turning out are cards stolen from clients who made purchases through paypal in the recent past ... We (ie. Hub) just went through re-evaluating our online credit card services, and are currently in the middle of moving our accounts to a company called PaySystems (http://www.paysystems.com) that we've found to have some of the better fees, and have yet to any major complaints about their services ... we haven't found any major complaints about our current one, but we just find we're losing too much money in the way of fees ... Agreed. You might also look at http://www.2checkout.com/ - I have heard they are OK, and their fees don't look outrageous. I also have a friend who runs a web payment service, who might be able to help. I can ask him if people are interested. cheers andrew ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[HACKERS] 7.4.1 tag'd and bundled ...
will do a general announce Monday afternoon, but if someone can test and confirm that I haven't missed anything, that would be great... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [HACKERS] 7.4.1 tag'd and bundled ...
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > will do a general announce Monday afternoon, but if someone can test and > confirm that I haven't missed anything, that would be great... Looks solid from here ... regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [HACKERS] What to do with my patch?
Tom Lane wrote: > Dennis Bjorklund <[EMAIL PROTECTED]> writes: > > The 14 december I submitted a patch that implements named function > > arguments. So far no one have said anything about that. > > I have it on my to-look-at list, but I've been too busy trying to get > 7.4.1 ready to do anything with pending patches. OK, glad Tom has it. I have never seen the patch before, and I am a little confused how I could have missed it. It isn't in my mailbox either. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] cascading column drop to index predicates
Hey Tom, With regards to our previous conversation about dropping columns now properly dropping indexes that contain predicates that reference that column, I now find it a bit disconcerting that such indexes are automatically removed when the column is dropped, instead of requiring a CASCADE. The thing is, if you drop a column that is used in a normal index, yes the index is now useless - drop it. However, since you can have (and I have) indexes like this: CREATE INDEX asdf ON table (a, b, c) WHERE d IS NOT NULL; If I drop column d, there is no way I want that index to just disappear! This has already caught me out... Can we change it to requiring a CASCADE? Is that a good idea? Chris ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] cascading column drop to index predicates
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > The thing is, if you drop a column that is used in a normal index, yes > the index is now useless - drop it. > However, since you can have (and I have) indexes like this: > CREATE INDEX asdf ON table (a, b, c) WHERE d IS NOT NULL; > If I drop column d, there is no way I want that index to just disappear! Uh, why not? I don't quite see the argument why d stands in a different relationship to this index than a,b,c do. The index is equally meaningless without any of them. > Can we change it to requiring a CASCADE? It'd likely be a simple code change, but first let's have the argument why it's a good idea. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
