Re: [HACKERS] dynamic SQL - possible performance regression in 9.2

2013-01-04 Thread Joshua D. Drake
in that if we want them to upgrade to take advantage of features, we have to make it so the least amount of work possible is needed to make that upgrade happen. Rewriting many thousands of lines of dynamic sql to upgrade to 9.2 is certainly not doing that :). Sincerely, Joshua D. Drake

Re: [HACKERS] Re: Proposal: Store timestamptz of database creation on pg_database

2013-01-03 Thread Joshua D. Drake
On 01/03/2013 02:30 PM, Kevin Grittner wrote: Andrew Dunstan wrote: I don't especially have a horse in the race, but ISTM that if you want the information you want it to be able to persist across dump/restore, at least optionally. If you can happily lose it when you're forced to recover

Re: [HACKERS] Feature Request: pg_replication_master()

2012-12-21 Thread Joshua D. Drake
approach. What I am saying is that it should be THAT easy [1]. [2] Multi version rpms on the same box still need some help (lib issues) [3] Bruce, you rock... pg_ugrade is the bomb Joshua D. Drake 1. Obviously I am talking about the simplest of configuration and there are a whole slew of other

Re: [HACKERS] Cascading replication: should we detect/prevent cycles?

2012-12-19 Thread Joshua D. Drake
On 12/18/2012 11:57 PM, Simon Riggs wrote: On 19 December 2012 03:03, Josh Berkus j...@agliodbs.com wrote: So, my question is: 1. should we detect for replication cycles? *Can* we? 2. should we warn the user, or refuse to start up? Why not just monitor the config you just created?

Re: [HACKERS] Cascading replication: should we detect/prevent cycles?

2012-12-19 Thread Joshua D. Drake
On 12/19/2012 12:34 AM, Simon Riggs wrote: My logic is that if you make a 1 minute test you will notice your mistake, which is glaringly obvious. That is sufficient to prevent that mistake, IMHO. If you don't test your config and don't monitor either, good luck with HA. I am not arguing

Re: [HACKERS] PRIVATE columns

2012-12-12 Thread Joshua D. Drake
opportunity here is to make statistics non-user visible. I can't think of any reason that they need to be visible to the standard user? Even if when we set the statistics private, it makes just that column non-visible. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http

Re: [HACKERS] RFC: New log_destination 'fifo'

2012-11-08 Thread Joshua D. Drake
On 11/07/2012 02:46 PM, David Fetter wrote: On Wed, Nov 07, 2012 at 12:55:03PM -0800, Joshua D. Drake wrote: Hello, So it is possible to do this in other ways but I thought it might be interesting to allow people to define fifo or pipe as a log_desination. This would allow a person to tail

Re: [HACKERS] RFC: New log_destination 'fifo'

2012-11-08 Thread Joshua D. Drake
On 11/07/2012 10:22 PM, Peter Eisentraut wrote: On Wed, 2012-11-07 at 12:55 -0800, Joshua D. Drake wrote: So it is possible to do this in other ways but I thought it might be interesting to allow people to define fifo or pipe as a log_desination. You could do this with a logging hook

[HACKERS] RFC: New log_destination 'fifo'

2012-11-07 Thread Joshua D. Drake
Hello, So it is possible to do this in other ways but I thought it might be interesting to allow people to define fifo or pipe as a log_desination. This would allow a person to tail the fifo to receive the outputs of the log as it happens but would not take up precious IO or space from the

Re: [HACKERS] Deprecations in authentication

2012-10-18 Thread Joshua D. Drake
On 10/18/2012 04:43 AM, Simon Riggs wrote: On 18 October 2012 12:20, Magnus Hagander mag...@hagander.net wrote: Since Simon stirred up a hornets nest suggesting deprecation of a number of features, I figured I'd take it one step further and suggest removal of some previously deprecated

Re: [HACKERS] Deprecating RULES

2012-10-17 Thread Joshua D. Drake
should be deprecated and removed. My suggestion for docs is: Note: Do not use, use Triggers with Functions instead link Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development High Availability

Re: [HACKERS] Deprecating RULES

2012-10-17 Thread Joshua D. Drake
On 10/17/2012 10:46 AM, Greg Stark wrote: I dislike both of the explanations above which don't actually explain why people shouldn't use rules (Josh does say they're tricky which is a start). Just telling people we hate parts of the system doesn't really come off well and leaves them wondering

Re: [HACKERS] Deprecating RULES

2012-10-17 Thread Joshua D. Drake
On 10/17/2012 11:32 AM, Josh Berkus wrote: I am not sure where to stick it but we should also include the fact that rules are almost always slower that a trigger/function comparative. That wouldn't be accurate, actually. Let me add: when used with partitioning. I should have been more

Re: [HACKERS] Deprecating RULES

2012-10-11 Thread Joshua D. Drake
On 10/11/2012 03:59 PM, Josh Berkus wrote: I'm also not real keen on the idea that someone could dump a 9.2 database and be unable to load it into 9.3 because of the DDL trigger, especially if they might not encounter it until halfway through a restore. That seems rather user-hostile to me.

Re: [HACKERS] sha1, sha2 functions into core?

2012-08-20 Thread Joshua D. Drake
On 08/20/2012 01:21 PM, Josh Berkus wrote: I don't think US export regulations are the only issue. Some other countries (mostly the usual suspects) forbid the use of crypto software. If we build more crypto functions into the core we make it harder to use Postgres legally in those places.

Re: [HACKERS] sha1, sha2 functions into core?

2012-08-20 Thread Joshua D. Drake
it makes absolute sense to keep them in contrib or pgxn but cryptography is pretty much a basic core feature set at this point. MySQL, MSSQL, Oracle (not sure if integrated or as a pack) and not to mention Java and Python all have them integrated. Sincerely, Joshua D. Drake -- Command Prompt

Re: [HACKERS] sha1, sha2 functions into core?

2012-08-20 Thread Joshua D. Drake
visibly, I don't know that this argument would ever come up. Sincerely, Joshua D. Drake cheers andrew -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC

Re: [HACKERS] Recent absence

2012-07-24 Thread Joshua D. Drake
On 07/24/2012 10:26 AM, Kevin Grittner wrote: I have recently been laid up with a MRSA infection, which left me suddenly unable to deal with even reading my email. (I took a shot at catching up a week ago, and it was too taxing, resulting in a relapse.) I'm trying to fight though the backlog

Re: [HACKERS] 2GB limit for temp_file_limit on 32bit platform

2012-07-19 Thread Joshua D. Drake
On 07/19/2012 01:04 PM, Pavel Stehule wrote: I did a backport of temp_file_limit feature to 9.1, but when we tested this patch, we found very restristrictive limit to 2GB. 2GB is nonsense, because this is session limit of temp files, and these files should be longer than 2GB. I haven't read

Re: [HACKERS] 2GB limit for temp_file_limit on 32bit platform

2012-07-19 Thread Joshua D. Drake
On 07/19/2012 01:48 PM, Christopher Browne wrote: On Thu, Jul 19, 2012 at 4:29 PM, Joshua D. Drake j...@commandprompt.com wrote: On 07/19/2012 01:04 PM, Pavel Stehule wrote: I did a backport of temp_file_limit feature to 9.1, but when we tested this patch, we found very restristrictive

Re: [HACKERS] Bug tracker tool we need

2012-07-09 Thread Joshua D. Drake
On 07/09/2012 12:02 PM, Josh Berkus wrote: Hackers, So I want to repeat this because I think we are conflating several uses for a bug tracker which aren't the same, and which really need to be dealt with seperately. -- Better CF App: to track feature submissions, discussion, revisions and

Re: [HACKERS] Future In-Core Replication

2012-04-27 Thread Joshua D. Drake
On 04/27/2012 11:33 AM, Simon Riggs wrote: Well, they all sound similar. My info was that Mammoth was not WAL-based. Mammoth was transaction log based but not WAL based. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

[HACKERS] PgNext: Cancelled (sorry for the offtopic)

2012-04-18 Thread Joshua D. Drake
://www.pgconf.eu Lastly, there is a Denver PgDay in October. PgDay's are a great way to meet locals and enjoy a smaller community setting but still maintain top notch content. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional

Re: [HACKERS] PgNext: Cancelled (sorry for the offtopic)

2012-04-18 Thread Joshua D. Drake
On 04/18/2012 11:56 AM, Josh Berkus wrote: On 4/18/12 11:53 AM, Joshua D. Drake wrote: Lastly, there is a Denver PgDay in October. PgDay's are a great way to meet locals and enjoy a smaller community setting but still maintain top notch content. Date? Hopefully not the same time as pg.EU

Re: [HACKERS] Bug tracker tool we need

2012-04-16 Thread Joshua D. Drake
On 04/16/2012 09:24 AM, Alex wrote: Jay, Alvaro, Dimitri (and whoever else wants to speak up) could you please describe your ideal tool for the task? Given that every other existing tool likely have pissed off someone already, I guess our best bet is writing one from scratch. Or maybe there

[HACKERS] PgNext CFP is still open

2012-04-10 Thread Joshua D. Drake
Hey, Just a reminder that the CFP for PgNext in Denver is still open. Let's get those talks in folks! https://www.postgresqlconference.org/ Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services

[HACKERS] Apology to the community

2012-03-23 Thread Joshua D. Drake
Hello, It has been brought to my attention a few times over the last year that I have been over the top in my presentation of myself and have in fact alienated and offended many of the community. To be honest I am unaware of everything I have done but I do take the opinion of those who have

[HACKERS] PgNext: CFP

2012-01-24 Thread Joshua D. Drake
Hello, The call for papers for PgNext (the old PgWest/PgEast) is now open: January 19th: Talk submission opens April 15th: Talk submission closes April 30th: Speaker notification Submit: https://www.postgresqlconference.org/talk_types Sincerely, JD -- Command Prompt, Inc. -

Re: [HACKERS] WIP: URI connection string support for libpq

2011-12-13 Thread Joshua D. Drake
, by far. That said, I am not really arguing against your other points except to answer your question. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http

Re: [HACKERS] 9.1.2 ?

2011-11-09 Thread Joshua D. Drake
On 11/09/2011 03:56 PM, Josh Berkus wrote: So that's my take on it. It's not a tomorrow severity release (we've been living with the workaround for months, even though it is blocking some things), but I would really appreciate an expedited release to enable unattended hot-standby operation

Re: [HACKERS] 9.1.2 ?

2011-11-09 Thread Joshua D. Drake
On 11/09/2011 06:15 PM, Robert Haas wrote: 2011/11/9 Devrim GÜNDÜZdev...@gunduz.org: On Wed, 2011-11-09 at 21:12 -0500, Robert Haas wrote: The point is that all the packaging will be done *before* people leave to go eat Turkey. Eating me? :-) No, just your country. I hear it is a

Re: [HACKERS] Thoughts on SELECT * EXCLUDING (...) FROM ...?

2011-10-29 Thread Joshua D. Drake
, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http://www.postgresqlconference.org/ @cmdpromptinc - @postgresconf - 509-416-6579 -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] So where are we on the open commitfest?

2011-10-28 Thread Joshua D. Drake
* unite recovery.conf and postgresql.conf This one also seems to be lacking consensus more than anything else. What do we do about that? AFAIR, the only person objecting is Simon. I'm not necessarily saying that means we should drive it in over his objections, but OTOH there were quite a

Re: [HACKERS] database file encryption.

2011-10-22 Thread Joshua D. Drake
On 10/21/2011 05:42 PM, nrdb wrote: Hi, I am new to this list. I haven't ever contributed code before, and have no idea on how to do this. I have made some changes to my copy of the 9.1.1 code that encrypts/decrypts the database files on the fly using AES256 cypher. Very cool. It passes

Re: [HACKERS] database file encryption.

2011-10-22 Thread Joshua D. Drake
On 10/22/2011 11:39 AM, nrdb wrote: Are you willing to submit a patch for people to review? I am not sure if the community would want this as backend code or not but it is definitely something to discuss. Yes! but I don't know what the procedure is to do that.

Re: [HACKERS] index-only scans

2011-10-07 Thread Joshua D. Drake
On 10/07/2011 11:40 AM, Tom Lane wrote: Robert Haasrobertmh...@gmail.com writes: Please find attached a patch implementing a basic version of index-only scans. I'm making some progress with this, but I notice what seems like a missing feature: there needs to be a way to turn it off.

Re: [HACKERS] unite recovery.conf and postgresql.conf

2011-09-23 Thread Joshua D. Drake
with adding an include to postgresql.conf manually. As Simon has already appropriately posted You would be incorrect. Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http

Re: [HACKERS] What Would You Like To Do?

2011-09-14 Thread Joshua D. Drake
On 09/14/2011 05:12 AM, Hannu Krosing wrote: On Tue, 2011-09-13 at 10:26 -0700, Joshua D. Drake wrote: Complete isolation at the user level, allowing an ISP to support multiple independent customers on a server without having to fiddle with multiple back ends each running on a separate port

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Joshua D. Drake
to reinvent the wheel. Why would we support that? Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http://www.postgresqlconference.org/ @cmdpromptinc - @postgresconf - 509

Re: [HACKERS] What Would You Like To Do?

2011-09-13 Thread Joshua D. Drake
that? There are other databases out there, too, why reinvent the wheel by working on PostgreSQL? :-) The question shoud be, would this be USEFUL? Personally, I don't think so but others may disagree. Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support

Re: [HACKERS] augmenting MultiXacts to improve foreign keys

2011-09-12 Thread Joshua D. Drake
Anyone on all of this? On 09/09/2011 02:31 PM, Alvaro Herrera wrote: Excerpts from Alvaro Herrera's message of mar ago 09 13:01:04 -0400 2011: To implement this, we need to augment MultiXact to store the lock type that each comprising Xid holds on the tuple. Two bits per Xid are needed.

[HACKERS] Final 48 for PgWest CFP

2011-08-11 Thread Joshua D. Drake
Hello, We are in the final 48 hours of the CFP for PgWest. Let's get those talks in. https://www.postgresqlconference.org/talk_types Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development

Re: [HACKERS] index-only scans

2011-08-11 Thread Joshua D. Drake
On 08/11/2011 01:57 PM, Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 1. The way that nodeIndexscan.c builds up the faux heap tuple is perhaps susceptible to improvement. I thought about building a virtual tuple, but then what do I do with an OID column, if I

[HACKERS] PgWest CFP extended for 12 days

2011-08-01 Thread Joshua D. Drake
Hello Hackers! The CFP for West has been extended until the 12th of August. Let's get those talks in! https://www.postgresqlconference.org/talk_types JD -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL

Re: [HACKERS] Policy on pulling in code from other projects?

2011-07-23 Thread Joshua D. Drake
On 07/22/2011 05:00 PM, Josh Berkus wrote: Arguments in favor of coding from scratch: 1) Does not introduce new dependencies into postgresql-client packages. (note how much of a problem Readline has been) Readline has license issues, this doesn't. 2) keeps psql as lightweight as possible

Re: [HACKERS] Policy on pulling in code from other projects?

2011-07-23 Thread Joshua D. Drake
On 07/23/2011 03:39 AM, Andrew Dunstan wrote: 1. I think the proposed use is of very marginal value at best, and certainly not worth importing an external library for. 2. Even if we have the feature, we do not need to parse URIs generally. A small amount of hand written C code should suffice.

Re: [HACKERS] Policy on pulling in code from other projects?

2011-07-22 Thread Joshua D. Drake
On 07/21/2011 11:13 AM, Tom Lane wrote: Joshua D. Drakej...@commandprompt.com writes: So I am looking intently on what it is going to take to get the URI patch done for psql [1] and was digging around the web and have a URI parser library. It is under the New BSD license and is strictly RFC

Re: [HACKERS] Policy on pulling in code from other projects?

2011-07-22 Thread Joshua D. Drake
/msg01144.php It is letting pgsql use URI syntax. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http://www.postgresqlconference.org/ @cmdpromptinc - @postgresconf - 509

Re: [HACKERS] Policy on pulling in code from other projects?

2011-07-22 Thread Joshua D. Drake
libssl or any other such thing. I would imagine that rolling our own code would likely be simpler but the code itself would be dumber (not bad, just not as capable) and we would be duplicating the effort of an already established project. Do we really want to do that? Sincerely, Joshua D

Re: [HACKERS] Policy on pulling in code from other projects?

2011-07-22 Thread Joshua D. Drake
not being sarcastic), if we don't let's just throw some simple code together, if we do, I think this library makes sense, whether in our tree or not. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services

[HACKERS] Policy on pulling in code from other projects?

2011-07-21 Thread Joshua D. Drake
/html/rfc3986 Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http://www.postgresqlconference.org/ @cmdpromptinc - @postgresconf - 509-416-6579 -- Sent via pgsql

Re: [HACKERS] Policy on pulling in code from other projects?

2011-07-21 Thread Joshua D. Drake
RFC 3986 [2] compliant . Surely we do not need a whole library to parse URIs. Shrug, standards compliant, already runs on windows Seems like a good idea to me? http://uriparser.sourceforge.net/ Sincerely, Joshua D. Drake regards, tom lane -- Command Prompt

Re: [HACKERS] Policy on pulling in code from other projects?

2011-07-21 Thread Joshua D. Drake
RFC 3986 [2] compliant . Surely we do not need a whole library to parse URIs. Also: http://uriparser.git.sourceforge.net/git/gitweb-index.cgi Sincerely, Joshua D. Drake regards, tom lane -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support

[HACKERS] PgWest CFP closes in two weeks

2011-07-19 Thread Joshua D. Drake
Hey folks, As a reminder, PgWest is in a few months and the CFP closes in two weeks. Get those talks in! https://www.postgresqlconference.org/talk_types Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services

Re: [HACKERS] Full GUID support

2011-07-12 Thread Joshua D. Drake
On 07/03/2011 11:54 AM, Peter Eisentraut wrote: On sön, 2011-07-03 at 13:42 -0500, Michael Gould wrote: I would like to request that full support for the UUID data type can added. I think that even though there is a contrib module, since this is a standard datatype that Postgres ought to be the

Re: [HACKERS] [COMMITTERS] pgsql: Enable CHECK constraints to be declared NOT VALID

2011-07-12 Thread Joshua D. Drake
On 07/12/2011 06:54 AM, Alvaro Herrera wrote: Excerpts from Magnus Hagander's message of mar jul 12 09:34:56 -0400 2011: Agreed. On one level I like the sponsor message, but on the other having Sponsored by RedHat on every Tom Lane item will get tiring. ;-) Create a macro ;) Can we add

Re: [HACKERS] Full GUID support

2011-07-12 Thread Joshua D. Drake
On 07/12/2011 11:56 AM, Josh Berkus wrote: Thom, The functions to produce UUIDs are in contrib, but the UUID data type itself is in core. You get the type uuid whether you install the contrib module or not. http://www.postgresql.org/docs/current/static/datatype-uuid.html Oh! I guess that

Re: [HACKERS] Full GUID support

2011-07-12 Thread Joshua D. Drake
On 07/12/2011 09:15 AM, Andrew Dunstan wrote: On 07/12/2011 12:03 PM, Joshua D. Drake wrote: On 07/03/2011 11:54 AM, Peter Eisentraut wrote: On sön, 2011-07-03 at 13:42 -0500, Michael Gould wrote: I would like to request that full support for the UUID data type can added. I think that even

Re: [HACKERS] Full GUID support

2011-07-12 Thread Joshua D. Drake
On 07/12/2011 01:29 PM, Andrew Dunstan wrote: On 07/12/2011 03:44 PM, Joshua D. Drake wrote: What about extensions makes them less usable? It is an extra step, that is less usable. Does it matter? Shrug, I know I hate having to type apt-get just to use xyz, does it mean it is a big deal

Re: [HACKERS] Full GUID support

2011-07-11 Thread Joshua D. Drake
On 07/10/2011 11:59 AM, Josh Berkus wrote: On 7/3/11 2:02 PM, Tom Lane wrote: Yeah. If there were One True Way to create a UUID, I would probably agree that we should push that functionality into core. But there are a lot of ways (and the reason for that is that they all suck in one fashion

[HACKERS] SYNONYMS (again)

2011-06-22 Thread Joshua D. Drake
Per: http://archives.postgresql.org/pgsql-hackers/2010-11/msg02043.php It seems we did come up with a use case in the procpid discussion. The ability to change the names of columns/databases etc, to handle the fixing of bad decision decisions during development over time. Thoughts? JD --

Re: [HACKERS] procpid?

2011-06-15 Thread Joshua D. Drake
. This isn't just about a few characters in a query, it is about consistency and providing an overall more sane user experience. Frankly I don't care if we use procpid or pid but it should be one or the other not both. Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com

Re: [HACKERS] procpid?

2011-06-11 Thread Joshua D. Drake
it for 9.2, we have 18 months to communicate the change. Joshua D. Drake -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] procpid?

2011-06-11 Thread Joshua D. Drake
On 6/11/2011 1:23 PM, Bruce Momjian wrote: There is a difference between a project name and something that directly affects usability. +1 on fixing this. IMO, we don't create a new pid column, we just fix the problem. If we do it for 9.2, we have 18 months to communicate the change. Uh, I am

Re: [HACKERS] reducing the overhead of frequent table locks - now, with WIP patch

2011-06-08 Thread Joshua D. Drake
unsuspecting in the wings. +1 for submitting for 9.2. +1 for not comitting to 9.1. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http://www.postgresqlconference.org

Re: [HACKERS] reducing the overhead of frequent table locks - now, with WIP patch

2011-06-07 Thread Joshua D. Drake
patches during beta if they suck. I think Alvaro's point isn't directed at you Robert but at the idea that this should be applied to 9.1. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development

Re: [HACKERS] Getting a bug tracker for the Postgres project

2011-05-31 Thread Joshua D. Drake
On 05/31/2011 01:12 AM, Peter Eisentraut wrote: On mån, 2011-05-30 at 21:52 -0400, Robert Haas wrote: I have used RT and I found that the web interface was both difficult to use and unwieldly for tickets containing large numbers of messages. Maybe those those things have been improved, but

Re: [HACKERS] Getting a bug tracker for the Postgres project

2011-05-31 Thread Joshua D. Drake
in workflow though. Nor am I, I was mainly bringing it up as a (better) alternative to bugzilla and rt. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http

Re: [HACKERS] How can I check the treatment of bug fixes?

2011-05-27 Thread Joshua D. Drake
allow it. Yes, it is a long standing argument. Yes, it is ridiculous. Yes, it is something that MySQL gets to make fun of us about (inside joke). You have done what you need to do to check the status. Someone who knows something about the bug should speak up at some point. Sincerely, Joshua D

[HACKERS] #PgWest 2011: CFP now open

2011-05-26 Thread Joshua D. Drake
Hello, The CFP for #PgWest is now open. We are holding it at the San Jose Convention Center from September 27th - 30th. We look forward to seeing your submissions. http://www.postgresqlconference.org/ Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support

Re: [HACKERS] deprecating contrib for PGXN

2011-05-17 Thread Joshua D. Drake
On 05/17/2011 01:31 PM, Darren Duncan wrote: I have missed it if this was discussed before but ... Would now be a good time to start deprecating the contrib/ directory as a way to distribute Pg add-ons, with favor given to PGXN and the like instead? If PGXN moves into .Org infrastructure

Re: [HACKERS] branching for 9.2devel

2011-04-25 Thread Joshua D. Drake
. It never hurts to consider an objective opinion. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Developement Organizers of the PostgreSQL Conference - http://www.postgresqlconference.org/ @cmdpromptinc

Re: [HACKERS] branching for 9.2devel

2011-04-25 Thread Joshua D. Drake
On 04/25/2011 01:55 PM, Andrew Dunstan wrote: Well, my solution would be to replace pgindent with a perl script (among other advantages, it would then run everywhere we build, including Windows), and filter the typedefs list so that we only use the ones that appear in each file with that

Re: [HACKERS] Formatting Curmudgeons WAS: MMAP Buffers

2011-04-20 Thread Joshua D. Drake
On 04/20/2011 12:05 PM, Josh Berkus wrote: On 4/20/11 12:00 PM, Robert Haas wrote: Please provide the evidence that this is a problem that exists now, as opposed to seven years ago. Since you're clearly already made up your mind that no problem exists, I don't have the energy to fight it out

Re: [HACKERS] Formatting Curmudgeons WAS: MMAP Buffers

2011-04-20 Thread Joshua D. Drake
On 04/20/2011 12:22 PM, Robert Haas wrote: Well, you aren't fighting alone. We have significant problems in this area. As you said, we always have. There is also a bizarre, almost insane objection to using tools that aren't invented here to solve problems. The problems you (Josh) present are

Re: [HACKERS] Formatting Curmudgeons WAS: MMAP Buffers

2011-04-18 Thread Joshua D. Drake
On 04/17/2011 11:07 PM, Tom Lane wrote: BTW, another thing that should be in the try-try-again category is seeing how close we could get to pgindent's results with GNU indent. It seems clear to me that a process based on GNU indent would be a lot easier for a lot of people. We tried that once

Re: [HACKERS] Formatting Curmudgeons WAS: MMAP Buffers

2011-04-18 Thread Joshua D. Drake
On 04/18/2011 06:38 PM, Robert Haas wrote: On Mon, Apr 18, 2011 at 3:17 PM, Josh Berkusj...@agliodbs.com wrote: In any case, I think the answer to this is constructive; better documentation and tools to let submitters get their code into good shape in the first place so that we don't have

Re: [HACKERS] Single client performance on trivial SELECTs

2011-04-15 Thread Joshua D. Drake
On 04/15/2011 09:59 AM, Joshua Berkus wrote: All, While it would be nice to improve our performance on this workload, let me point out that it's not a very important workload from the point of view of real performance challenges. Yes, there are folks out there with 100MB databases who only

Re: [HACKERS] using a lot of maintenance_work_mem

2011-04-09 Thread Joshua D. Drake
On Sun, 2011-04-10 at 03:05 +0100, Greg Stark wrote: On Sat, Apr 9, 2011 at 6:20 PM, Tom Lane t...@sss.pgh.pa.us wrote: BTW, it sounded like your argument had to do with whether it would use HashAgg or not -- that is *not* dependent on the per-palloc limit, and never has been. His

Re: [HACKERS] .ini support for .pgpass

2011-04-06 Thread Joshua D. Drake
On Wed, 2011-04-06 at 07:47 +0300, Peter Eisentraut wrote: On tis, 2011-04-05 at 16:04 -0700, Joshua D. Drake wrote: Well any libpq app but yes. I actually wonder as to the legitmacy of having both a pgpass and a pg_service. Why not just one of them? So you can keep passwords in a safer

Re: [HACKERS] .ini support for .pgpass

2011-04-06 Thread Joshua D. Drake
On Wed, 2011-04-06 at 09:10 +0200, Martijn van Oosterhout wrote: On Tue, Apr 05, 2011 at 11:55:04PM -0700, Joshua D. Drake wrote: I want to achieve two things: 1. More understandable .pgpass format. Yes, I understand our standard format, most people won't. Like JoshB said, hard to debug

Re: [HACKERS] Should psql support URI syntax?

2011-04-06 Thread Joshua D. Drake
/template1/?username=jdpassword=foobarssl=true But I don't know if we want to go there. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com

Re: [HACKERS] Should psql support URI syntax?

2011-04-06 Thread Joshua D. Drake
On Wed, 2011-04-06 at 13:35 -0500, Kevin Grittner wrote: Joshua D. Drake j...@commandprompt.com wrote: Many drivers support an extended syntax like: postgres:ssl://localhost:5432/template1/?username=jdpassword=foobarssl=true But I don't know if we want to go there. We've been

[HACKERS] .ini support for .pgpass

2011-04-05 Thread Joshua D. Drake
The current structure of .pgpass is: hostname:port:database:username:password Bare, useful, but not really friendly nor flexible. I would love to be able to do this: If no ini block: hostname:port:database:username:password else: [ecom] hostname= port= database= username= password=

Re: [HACKERS] .ini support for .pgpass

2011-04-05 Thread Joshua D. Drake
On Tue, 2011-04-05 at 15:38 -0700, David E. Wheeler wrote: On Apr 5, 2011, at 3:34 PM, Joshua D. Drake wrote: boom, I am in. Thoughts? boom, you have patch? I'll write it, if I am not going to be tied up for months arguing about it :P. Thus, I wanted to see if the community

Re: [HACKERS] .ini support for .pgpass

2011-04-05 Thread Joshua D. Drake
On Tue, 2011-04-05 at 18:52 -0400, Aidan Van Dyk wrote: On Tue, Apr 5, 2011 at 6:34 PM, Joshua D. Drake j...@commandprompt.com wrote: Bare, useful, but not really friendly nor flexible. I would love to be able to do this: [ecom] hostname= port= database= username= password

Re: [HACKERS] Transaction log

2011-04-05 Thread Joshua D. Drake
On Tue, 2011-04-05 at 18:25 -0700, aaronenabs wrote: Hi All, I was wondering if anyone can tell me how i can access the transaction log within postgresql 9.0.3. I have carried out some updated and deletions within the database and am hoping the transaction logs have records of this. You

Re: [HACKERS] Should psql support URI syntax?

2011-04-01 Thread Joshua D. Drake
On Fri, 2011-04-01 at 08:13 -0400, Andrew Dunstan wrote: That said, I do support adding this in the future, if only to keep up with the Jones'. So are the ones out there *already* even compatible, before we start adding our own? For example, for JDBC I beleive it has to be

Re: [HACKERS] Should psql support URI syntax?

2011-04-01 Thread Joshua D. Drake
On Fri, 2011-04-01 at 12:04 -0500, Kevin Grittner wrote: Joshua D. Drake j...@commandprompt.com wrote: Well I would argue that if compatibility (as opposed to familiarity) is our goal, we need to focus on one and only one syntax, JDBC. It doesn't matter our particular bent, JDBC

[HACKERS] Should psql support URI syntax?

2011-03-31 Thread Joshua D. Drake
Hello, Most database connectors/frameworks nowadays support a URI style connection string. Something like: pgsql://user:pass@host/database Do we think psql should support this style of connection string? Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http

Re: [HACKERS] Should psql support URI syntax?

2011-03-31 Thread Joshua D. Drake
On Thu, 2011-03-31 at 19:32 -0400, Andrew Dunstan wrote: On 03/31/2011 07:25 PM, Joshua D. Drake wrote: Hello, Most database connectors/frameworks nowadays support a URI style connection string. Something like: pgsql://user:pass@host/database Do we think psql should support

Re: [HACKERS] Should psql support URI syntax?

2011-03-31 Thread Joshua D. Drake
; I'm always looking up the conninfo for the options I don't use frequently. However, is there any standard for database URIs? There is an IETF RFC for generic URI: http://www.ietf.org/rfc/rfc2396.txt http://www.ietf.org/rfc/rfc3986.txt Sincerely, Joshua D. Drake -- PostgreSQL.org Major

Re: [HACKERS] Better estimates of index correlation

2011-03-13 Thread Joshua D. Drake
On Sun, 2011-03-13 at 19:40 -0400, Tom Lane wrote: I'm not planning to do anything about this idea right now, since I'm still hip-deep in collations, but I thought I'd throw it out to get it on the record. Comments? One question: Where is the overhead increase? JD

[HACKERS] #PgEast Schedule is up

2011-03-08 Thread Joshua D. Drake
Hey, The schedule for #PgEast is up. It can be found here: https://www.postgresqlconference.org/files/east_2011_schedule.html As usually we have a increasingly wide selection of content. Sincerely, JD -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ -

Re: [HACKERS] Sync Rep v17

2011-03-02 Thread Joshua D. Drake
On Wed, 2011-03-02 at 14:26 -0600, Kevin Grittner wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: All I'm saying is that if we end up shipping without that parameter (implying allow_standalone_primary=on), we need to call the feature something else. The GUCs and code

Re: wrapping up this CommitFest (was Re: [HACKERS] knngist - 0.8)

2011-03-01 Thread Joshua D. Drake
On Tue, 2011-03-01 at 14:26 -0500, Robert Haas wrote: On Tue, Mar 1, 2011 at 2:12 PM, Josh Berkus j...@agliodbs.com wrote: Since we appear to be still holding the commitfest open for Sync Rep, I guess this ought to get reviewed. Or else we should close the CommitFest and cut alpha4.

Re: [HACKERS] Why our counters need to be time-based WAS: WIP: cross column correlation ...

2011-02-28 Thread Joshua D. Drake
On Mon, 2011-02-28 at 11:39 -0800, Josh Berkus wrote: Spitballing here, but could sqlite be an intermediate, compromise solution? For a core PostgreSQL component ?!?!? Sure, why not? It is ACID compliant, has the right kind of license, has a standard API that we are all used to. It seems

[HACKERS] PgEast talks and trainings up

2011-02-22 Thread Joshua D. Drake
Hello, Per the customary URL: https://www.postgresqlconference.org/ JD -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc |

Re: [HACKERS] Debian readline/libedit breakage

2011-02-17 Thread Joshua D. Drake
On Thu, 2011-02-17 at 10:49 +, Dave Page wrote: On Thu, Feb 17, 2011 at 10:36 AM, Magnus Hagander mag...@hagander.net wrote: Probably readline but does it matter? We distribute the source to the click installers. Actually, we don't. We used to, but we don't at this point. Depends

Re: [HACKERS] Debian readline/libedit breakage

2011-02-16 Thread Joshua D. Drake
not working on PostgreSQL but instead working with it. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering http://twitter.com/cmdpromptinc | http://identi.ca

<    2   3   4   5   6   7   8   9   10   11   >