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:p

[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] 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/ - 50

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 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 can probably stay as > > it

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 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. Any

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 | http://identi.ca/command

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 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 on your

Re: [HACKERS] Debian readline/libedit breakage

2011-02-16 Thread Joshua D. Drake
On Wed, 2011-02-16 at 22:53 -0500, Bruce Momjian wrote: > Stephen Frost wrote: > -- Start of PGP signed section. > > * Greg Stark (gsst...@mit.edu) wrote: > > > Well for what it's worth we want to support both. At least the project > > > philosophy has been that commercial derivatives are expected

Re: [HACKERS] Debian readline/libedit breakage

2011-02-16 Thread Joshua D. Drake
On Wed, 2011-02-16 at 20:53 -0500, Stephen Frost wrote: > * Tom Lane (t...@sss.pgh.pa.us) wrote: > > In particular, getting rid of use of OpenSSL would not be sufficient > > to satisfy the most rabid GPL partisans that we were in compliance. > > I've never heard anyone argue that position, don't b

Re: [HACKERS] Debian readline/libedit breakage

2011-02-16 Thread Joshua D. Drake
On Thu, 2011-02-17 at 00:28 +, Greg Stark wrote: > On Thu, Feb 17, 2011 at 12:07 AM, Greg Smith wrote: > > > There appear to be two people working periodically on the upstream NetBSD > > libedit: http://cvsweb.netbsd.org/bsdweb.cgi/src/lib/libedit/?sortby=date > > > > And a third who period

Re: [HACKERS] Debian readline/libedit breakage

2011-02-16 Thread Joshua D. Drake
ur dollars 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 | ht

Re: [HACKERS] Debian readline/libedit breakage

2011-02-11 Thread Joshua D. Drake
On Fri, 2011-02-11 at 14:59 -0500, charles.mcdev...@emc.com wrote: > If psql uses libreadline and libgnutls, does that mean psql will be > distributed under the GPL in the future? Or Dual-licensed? libgnutls is libgpl, not GPL, so this is not a problem. JD -- PostgreSQL.org Major Contributor

Re: [HACKERS] Debian readline/libedit breakage

2011-02-11 Thread Joshua D. Drake
ng that raises my red-alert bells. As popular as Debian is, the "user" population is squarely in Ubuntu world and that has some serious public implications as a whole. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.c

[HACKERS] Debian readline/libedit breakage

2011-02-10 Thread Joshua D. Drake
Hello, Per: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=607109 It seems we may have a problem to consider. As far as I know, we are the only major platform that supports libedit but our default is readline. Unfortunately readline is not compatible with OpenSSL (apparently?) licensing. This

Re: [HACKERS] Sync Rep for 2011CF1

2011-02-08 Thread Joshua D. Drake
On Tue, 2011-02-08 at 13:53 -0500, Robert Haas wrote: > That having been said, there is at least one part of this patch which > looks to be in pretty good shape and seems independently useful > regardless of what happens to the rest of it, and that is the code > that sends replies from the standby

[HACKERS] PgEast 2011: 3 days until close of CFP

2011-02-07 Thread Joshua D. Drake
Hello hackers, Just FYI, the CFP for PgEast in NYC closes in three days. https://www.postgresqlconference.org/talk_types Sincerely, JD -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engine

Re: [HACKERS] Sync Rep for 2011CF1

2011-02-07 Thread Joshua D. Drake
On Mon, 2011-02-07 at 12:24 -0800, Josh Berkus wrote: > +1. > > I, for one, would vote against extending beta if Sync Rep isn't ready > yet. There's plenty of other "big features" in 9.1, and Sync Rep will > benefit from having additional development time given the number of > major spec points

Re: [HACKERS] Sync Rep for 2011CF1

2011-02-07 Thread Joshua D. Drake
On Mon, 2011-02-07 at 17:59 +, Simon Riggs wrote: > On Mon, 2011-02-07 at 12:39 -0500, Robert Haas wrote: > > > I just spoke to my manager at EnterpriseDB and he cleared my schedule > > for the next two days to work on this. So I'll go hack on this now. > > I haven't read the patch yet so I d

Re: [RRR] [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-26 Thread Joshua D. Drake
On Wed, 2011-01-26 at 17:39 -0500, Robert Haas wrote: > On Wed, Jan 26, 2011 at 5:30 PM, Richard Broersma > wrote: > >> I'm not sure what you mean by this. > > > > Now that I read it, I not sure what I meant either. :) How about this: the > > selection, management, and oversight of grants and men

Re: [RRR] [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-26 Thread Joshua D. Drake
ne who is going to make it through a grant process specifically for this purpose is going to have some intrinsic motivation beyond money. We aren't talking about shelling out 50k here. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandpromp

Re: [RRR] [HACKERS] Seeking Mentors for Funded Reviewers

2011-01-25 Thread Joshua D. Drake
that such grants are limited to members of PgUS. Although, I > > should mention that there's no restriction for residents of any country > > becoming a member of PgUS. > > OK. Correct. You will have to be a member of PgUS. However, we don't restrict who can be a memb

[HACKERS] PgEast: 2011, 2nd call for papers

2011-01-18 Thread Joshua D. Drake
Hey folks, PgEast is being held in NYC this year from 03/22-03-25. Get your papers in, the deadline is soon! http://www.postgresqlconference.org/ Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support

Re: [HACKERS] making an unlogged table logged

2011-01-04 Thread Joshua D. Drake
> > -- > > Robert Haas > > EnterpriseDB: http://www.enterprisedb.com > > The Enterprise PostgreSQL Company > > A couple thoughts: > 1. Could the making a table logged be a non-exclusive lock if the > ALTER is allowed to take a full checkpoint? If possible, that would certainly be better. If the

Re: [HACKERS] system views for walsender activity

2011-01-04 Thread Joshua D. Drake
newbies, which none of the other view names would ... hmmm I think "pg_stat_standby" might be more relevant but I definitely agree something more newbie appropriate is in order. Joshua D. Drake > > -- > -- Josh Berkus >

Re: [HACKERS] Sync Rep Design

2011-01-04 Thread Joshua D. Drake
> I'm not feeling well now, so I'm going to go to bed, not just to avoid > snapping at people. Even given that short interlude, I see no problem > about delivery. Cool! Thanks Simon. Feel better. Joshua D. Drake -- PostgreSQL.org Major Contributor Comman

Re: [HACKERS] WIP patch for parallel pg_dump

2010-12-24 Thread Joshua D. Drake
On Fri, 2010-12-24 at 18:26 -0500, Aidan Van Dyk wrote: > On Fri, Dec 24, 2010 at 2:48 PM, Joshua D. Drake > wrote: > > > I would have to agree here. The idea that we have to search email is bad > > enough (issue/bug/feature tracker anyone?) but to have someone say, &g

Re: [HACKERS] WIP patch for parallel pg_dump

2010-12-24 Thread Joshua D. Drake
e email > discussion is ideal --- if they can't find it, odds are the patch person > will not be able to find it either. I would have to agree here. The idea that we have to search email is bad enough (issue/bug/feature tracker anyone?) but to have someone say, search the archives? That i

Re: [HACKERS] Why don't we accept exponential format for integers?

2010-12-17 Thread Joshua D. Drake
p:~$ perl -e 'print int('1e+01')'; 10 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

Re: [HACKERS] Why don't we accept exponential format for integers?

2010-12-17 Thread Joshua D. Drake
an integer, which strikes me as a > seriously bad idea. > Python 2.6.6 (r266:84292, Sep 15 2010, 16:22:56) [GCC 4.4.5] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> print int(1e+01) 10 >>&g

[HACKERS] PgEast 2011: NYC CFP

2010-12-16 Thread Joshua D. Drake
December 16th, 2010: Celebrating 15 years of PostgreSQL, early. Following on the smashing success of PostgreSQL Conference West, PostgreSQL Conference West, The PostgreSQL Conference for Developers, End Users and Decision Makers, is being held at the Hotel Pennsylvania, in New York City from March

Re: [HACKERS] Anyone for SSDs?

2010-12-10 Thread Joshua D. Drake
as would all logging outside of the WAL itself. 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/command

Re: [HACKERS] ALTER EXTENSION ... UPGRADE;

2010-12-10 Thread Joshua D. Drake
On Fri, 2010-12-10 at 15:42 -0500, Andrew Dunstan wrote: > > On 12/10/2010 03:24 PM, Josh Berkus wrote: > > > > Also, once extensions and pgxn are operating full swing, I see contrib > > going away anyway ... > > We've heard this before, but I'm still quite skeptical about it. Quite > apart from

Re: [HACKERS] Final(?) proposal for wal_sync_method changes

2010-12-07 Thread Joshua D. Drake
On Tue, 2010-12-07 at 19:00 -0500, Chris Browne wrote: > x...@thebuild.com (Christophe Pettus) writes: > > On Dec 7, 2010, at 2:43 PM, Josh Berkus wrote: > >> Because nobody sane uses OSX on the server? > > > > The XServe running 10.5 server and 9.0.1 at the other end of the > > office takes your r

Re: [HACKERS] Final(?) proposal for wal_sync_method changes

2010-12-07 Thread Joshua D. Drake
On Tue, 2010-12-07 at 18:11 -0500, Tom Lane wrote: > Josh Berkus writes: > > On 12/7/10 2:28 PM, Tom Lane wrote: > >> Another point here is that it's not clear why we're selecting a > >> known-to-be-insecure default on OS X (where in fact all methods except > >> fsync_writethrough fail to push dat

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Joshua D. Drake
On Wed, 2010-12-01 at 12:46 -0800, Josh Berkus wrote: > >> I'd love to hear from someone at EDB: how are you dealing with synonym > >> name collisions right now? > > > > I think the way we deal with that is the way PostgreSQL deals with it. > > Unique names per search path. > > Have you had an em

Re: [HACKERS] Another proposal for table synonyms

2010-12-01 Thread Joshua D. Drake
On Wed, 2010-12-01 at 12:13 -0800, Josh Berkus wrote: > > Well, porting applications from other database systems that support synonyms > > (i.e. Oracle, DB2, SQL Server). > > SQL Server supports synonyms? If it's not Oracle-only, it's a more > powerful argument to have the feature. Oracle, DB2 a

Re: [HACKERS] s/LABEL/VALUE/ for ENUMs

2010-11-23 Thread Joshua D. Drake
On Tue, 2010-11-23 at 14:48 -0500, Robert Haas wrote: > On Tue, Nov 23, 2010 at 2:01 PM, David E. Wheeler > wrote: > > On Nov 22, 2010, at 6:03 PM, Josh Berkus wrote: > > > >> ... "original patch". Sorry. Let's not fiddle with the names. > > > > To be clear, as things stand now, the new command

Re: [HACKERS] SQL/MED estimated time of arrival?

2010-11-23 Thread Joshua D. Drake
On Tue, 2010-11-23 at 20:18 +0200, Heikki Linnakangas wrote: > On 23.11.2010 14:22, Shigeru HANADA wrote: > > OID is supported to get oid from the source table (yes, it works only > > for postgresql_fdw but it seems useful to support). > > I don't think that's worthwhile. Oids on user tables is a

Re: [HACKERS] We need to log aborted autovacuums

2010-11-17 Thread Joshua D. Drake
On Wed, 2010-11-17 at 13:46 -0800, Josh Berkus wrote: > Hackers, > > I've been trying to diagnose in a production database why certain tables > never get autovacuumed despite having a substantial % of updates. The > obvious reason is locks blocking autovacuum from vacuuming the table ... > but th

Re: [HACKERS] unlogged tables

2010-11-17 Thread Joshua D. Drake
> > >> I don't particularly care for the name UNSYNCED > > > > > > EVANESCENT? > > > > > >> I'm starting not to like UNLOGGED much either > > > > > > EPHEMERAL? > > > > > > Actually, the UNSYNCED and UNLOGGED seem fairly clear Uhhh yeah. Let's not break out the thesaurus for this. JD -- Pos

Re: [HACKERS] unlogged tables

2010-11-16 Thread Joshua D. Drake
On Wed, 2010-11-17 at 00:08 +0200, Peter Eisentraut wrote: > On tis, 2010-11-16 at 14:00 -0800, Josh Berkus wrote: > > It seems to me > > that most people using unlogged tables won't want to back them up ... > > especially since the share lock for pgdump will add overhead for the > > kinds of high-

Re: [HACKERS] unlogged tables

2010-11-16 Thread Joshua D. Drake
On Tue, 2010-11-16 at 14:00 -0800, Josh Berkus wrote: > > Yeah, you'd have to allow a flag to control the behavior. And in that > > case I'd rather the flag have a single default rather than different > > defaults depending on whether or not individual tables were selected. > > Something like --om

Re: [HACKERS] autovacuum maintenance_work_mem

2010-11-16 Thread Joshua D. Drake
On Tue, 2010-11-16 at 10:36 -0800, Josh Berkus wrote: > On 11/16/10 9:27 AM, Robert Haas wrote: > > I'm a little skeptical about creating more memory tunables. DBAs who > > are used to previous versions of PG will find that their vacuum is now > > really slow, because they adjusted maintenance_wor

Re: [HACKERS] WIP: extensible enums

2010-11-12 Thread Joshua D. Drake
On Fri, 2010-11-12 at 14:20 -0500, Tom Lane wrote: > Robert Haas writes: > > On Fri, Nov 12, 2010 at 1:55 PM, Tom Lane wrote: > >> Well, you can rename an item today if you don't mind doing a direct > >> UPDATE on pg_enum. I think that's probably sufficient if the demand > >> only amounts to one

Re: [HACKERS] max_wal_senders must die

2010-10-28 Thread Joshua D. Drake
On Thu, 2010-10-28 at 17:12 -0700, Josh Berkus wrote: > > Sorry, didn't know... I have 122 responses so far, which I think will be > > surprising (some of them certainly surprised me). I will keep it open > > until next week and then post the results. > > Well, for any community site poll, I hope

Re: [HACKERS] max_wal_senders must die

2010-10-28 Thread Joshua D. Drake
On Thu, 2010-10-28 at 16:25 -0700, Josh Berkus wrote: > > https://www.postgresqlconference.org/content/replication-poll > > > > You don't have to login to take it but of course it helps with validity > > of results. > > Oh, I'd already put something up on http://www.postgresql.org/community Sorr

Re: [HACKERS] max_wal_senders must die

2010-10-28 Thread Joshua D. Drake
On Thu, 2010-10-28 at 07:05 -0500, Kevin Grittner wrote: > "Joshua D. Drake" wrote: > > On Wed, 2010-10-27 at 19:52 -0400, Robert Haas wrote: > >> Josh Berkus wrote: > > > >>> *you don't know* how many .org users plan to implement >

Re: [HACKERS] max_wal_senders must die

2010-10-27 Thread Joshua D. Drake
On Wed, 2010-10-27 at 19:52 -0400, Robert Haas wrote: > On Wed, Oct 27, 2010 at 7:45 PM, Josh Berkus wrote: > >> I would also agree that the minority of our users will want replication. > >> The majority of CMD customers, PGX customers, EDB Customers will want > >> replication but that is by far N

Re: [HACKERS] max_wal_senders must die

2010-10-27 Thread Joshua D. Drake
diste, Slony, DRBD or Log Shipping. I would also agree that the minority of our users will want replication. The majority of CMD customers, PGX customers, EDB Customers will want replication but that is by far NOT the majority of our (.Org) users. Sincerely, Joshua D. Drake -- PostgreSQL.org Majo

Re: [HACKERS] max_wal_senders must die

2010-10-27 Thread Joshua D. Drake
On Wed, 2010-10-27 at 15:33 -0400, Tom Lane wrote: > Josh Berkus writes: > >>> Josh has completely failed to make a case that > >>> that should be the default. > >> > >> Agreed. > > > In what way have a failed to make a case? > > You're assuming that we should set up the default behavior to sup

Re: [HACKERS] default_statistics_target WAS: max_wal_senders must die

2010-10-20 Thread Joshua D. Drake
On Wed, 2010-10-20 at 15:15 -0700, Josh Berkus wrote: > >> Maybe what should be done about this is to have separate sizes for the > >> MCV list and the histogram, where the MCV list is automatically sized > >> during ANALYZE. > > It's been suggested multiple times that we should base our sample si

Re: [HACKERS] Floating-point timestamps versus Range Types

2010-10-17 Thread Joshua D. Drake
On Sun, 2010-10-17 at 15:52 -0700, Greg Stark wrote: > On Sun, Oct 17, 2010 at 12:03 PM, Joshua D. Drake > wrote: > > The only major distribution that I know of that ships the deprecated > > configuration is RedHat/Fedora. I don't know when that will change. > > &g

Re: [HACKERS] Floating-point timestamps versus Range Types

2010-10-17 Thread Joshua D. Drake
On Sun, 2010-10-17 at 16:27 -0400, Tom Lane wrote: > "Joshua D. Drake" writes: > > The only major distribution that I know of that ships the deprecated > > configuration is RedHat/Fedora. I don't know when that will change. > > Red Hat switched to integ

Re: [HACKERS] Fate of the old cvs repository

2010-10-17 Thread Joshua D. Drake
On Sun, 2010-10-17 at 17:54 +0200, Magnus Hagander wrote: > So, it seems we're pretty firmly on git now, and I doubt we're ever > going to shift back now :) > > That means I'd like to get the two CVS VMs shut down (that's > cvs.postgresql.org and anoncvs.postgresql.org), so we don't have to > atte

Re: [HACKERS] Floating-point timestamps versus Range Types

2010-10-17 Thread Joshua D. Drake
On Sun, 2010-10-17 at 10:00 -0700, David E. Wheeler wrote: > On Oct 17, 2010, at 9:56 AM, Jeff Davis wrote: > > > 3. Somehow deprecate floating point timestamps or make them unusable in > > conjunction with Range Types. I'm not sure if there is demand to keep > > them alive or not. > This seems

Re: [HACKERS] First patch proposal

2010-10-15 Thread Joshua D. Drake
(-f) exist and is it readable > - Do paths to the output files ( -o and -l) exist and are they writable > - Is the host/socket listening (-h) > I think these are pretty good. The last one might not be as easy as you think. Joshua D. Drake -- PostgreSQL.org Major Contributor

Re: [HACKERS] Issues with Quorum Commit

2010-10-07 Thread Joshua D. Drake
On Thu, 2010-10-07 at 19:44 -0400, Greg Smith wrote: > I don't see this as needing any implementation any more complicated than > the usual way such timeouts are handled. Note how long you've been > trying to reach the standby. Default to -1 for forever. And if you hit > the timeout, mark th

Re: [HACKERS] leaky views, yet again

2010-10-05 Thread Joshua D. Drake
On Tue, 2010-10-05 at 14:49 -0400, Robert Haas wrote: > On Tue, Oct 5, 2010 at 2:08 PM, Greg Stark wrote: > > Though I find it unlikely the sales people would have direct access to > > run arbitrary SQL -- let alone create custom functions. > > I have definitely seen shops where virtually everyon

Re: [HACKERS] leaky views, yet again

2010-10-05 Thread Joshua D. Drake
On Tue, 2010-10-05 at 12:27 -0400, Tom Lane wrote: > Robert Haas writes: > > On Tue, Oct 5, 2010 at 10:56 AM, Tom Lane wrote: > >> Personally I think this is a dead end that we shouldn't be wasting > >> any more time on. > > > But you haven't proposed a reasonable alternative. > > Tom: "This pr

Re: [HACKERS] git cherry-pick timestamping issue

2010-09-23 Thread Joshua D. Drake
On Thu, 2010-09-23 at 22:22 +0100, Thom Brown wrote: > On 23 September 2010 22:20, David E. Wheeler wrote: > > On Sep 23, 2010, at 1:02 PM, Robert Haas wrote: > > > >> On Thu, Sep 23, 2010 at 3:52 PM, Tom Lane wrote: > >>> Apparently somebody's confused between local and GMT time somewhere in > >

Re: pg_upgrade pain; was Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-23 Thread Joshua D. Drake
ich eventually is going to cause us > problems. "us" being -hackers yes, but it will only help the community. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Deve

Re: [HACKERS] Another Modest Proposal: Platforms

2010-09-22 Thread Joshua D. Drake
to require Perl 5.8. 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/commandprompt -- Sent via pgsql-hackers

Re: [HACKERS] Another Modest Proposal: Platforms

2010-09-22 Thread Joshua D. Drake
Perhaps you could suggest some more specific ideas of your proposal? I mean I am with you on the idea of reducing our supported platforms. I see no reason to support SCO Note: I am not actually advocating this as much as stating my own personal opinion. Joshua D. Drake -- PostgreSQL.org M

Re: [HACKERS] Another Modest Proposal: Platforms

2010-09-22 Thread Joshua D. Drake
On Wed, 2010-09-22 at 13:17 -0700, David Fetter wrote: > Folks, > > While it's interesting to note, in an historical sense, that a > platform most recently updated when 1999 was still in the future, I > think it's time we did a little pruning. > > We can start by supporting only platforms git run

Re: [HACKERS] Configuring synchronous bikeshedding

2010-09-22 Thread Joshua D. Drake
On Wed, 2010-09-22 at 21:05 +0100, Thom Brown wrote: > On 22 September 2010 19:50, Josh Berkus wrote: > > All: > > > > I feel compelled to point out that, to date, there have been three times > > as many comments on what format the configuration file should be as > > there have been on what option

Re: [HACKERS] Configuring synchronous replication

2010-09-22 Thread Joshua D. Drake
On Wed, 2010-09-22 at 13:26 -0400, Tom Lane wrote: > Robert Haas writes: > > On Wed, Sep 22, 2010 at 1:09 PM, Joshua D. Drake > > wrote: > >> On Wed, 2010-09-22 at 13:00 -0400, Robert Haas wrote: > >>> But it CAN'T be a system catalog, because, a

Re: [HACKERS] Configuring synchronous replication

2010-09-22 Thread Joshua D. Drake
kers don't even use the product. We are building it for our community, which are by far user space developers and dbas. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Dev

Re: [HACKERS] Configuring synchronous replication

2010-09-22 Thread Joshua D. Drake
a that we are shoving this all into the postgresql.conf is cumbersome. 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

Re: [HACKERS] Configuring synchronous replication

2010-09-21 Thread Joshua D. Drake
hen ALTER CLUSTER ENABLE REPLICATION FOR FOO; ALTER CLUSTER SET keep_connect ON FOO TO TRUE; Or some such thing. Sincerely, Joshua D. Drake > -- > Bruce Momjian http://momjian.us > EnterpriseDB http://enterprisedb.com > > + It'

Re: [HACKERS] Any reason why the default_with_oids GUC is still there?

2010-09-21 Thread Joshua D. Drake
em like an adequate reason for possibly breaking old apps. > > Mind you, it wouldn't take a *big* reason to persuade me to remove it. > But bigger than that. The uninformed still use OIDs. They shouldn't. Joshua D. Drake > > regards, tom lane >

Re: [HACKERS] Policy decisions and cosmetic issues remaining for the git conversion

2010-09-13 Thread Joshua D. Drake
est life, which would be git (or the conversion as it was) at this point (for at least another 15 years). Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering

[HACKERS] PgWest 2010 CFP extended (one week)

2010-09-07 Thread Joshua D. Drake
For one week guys... https://www.postgresqlconference.org/2010/west/cfp/ -- PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-

Re: [HACKERS] Performance Farm Release

2010-08-31 Thread Joshua D. Drake
On Tue, 2010-08-31 at 03:28 -0400, Greg Smith wrote: > 4) Merge the perfarm fork changes into the mainline buildfarm code. I > expect continued bitrot of this code as changes are made to the regular > buildfarm client, so it might be worth considering that sooner rather > than later. As Andre

Re: [HACKERS] Backups from the standby (Incrementally Updated Backups), open item

2010-08-24 Thread Joshua D. Drake
On Tue, 2010-08-24 at 13:44 -0700, Josh Berkus wrote: > On 8/24/10 12:42 PM, Tom Lane wrote: > > Marko Tiikkaja writes: > >> Is this method not reliable then? Can something go wrong even if the > >> user does exactly what the documentation says? > > > > It is not. This whole discussion started

Re: [HACKERS] Version Numbering

2010-08-21 Thread Joshua D. Drake
his one on my flaky keyboard this > time. Hahahahaha. Yeah I think we are spinning at this point. I posted a simple, problem we are trying to solve email. If we can do that, great. If not we are just wasting bandwidth. Sincerely, Joshua D. Drake > -- PostgreSQL.org Majo

Re: [HACKERS] Version Numbering

2010-08-21 Thread Joshua D. Drake
On Sat, 2010-08-21 at 18:24 +0100, Greg Stark wrote: > On Sat, Aug 21, 2010 at 5:51 PM, Joshua D. Drake > wrote: > > There was *NEVER* a Windows NT 4.0.x, there was Windows NT 4.0 SP2. > > > > I'm not sure what you're point is here. There was a NT 4.0 followed

Re: [HACKERS] Version Numbering

2010-08-21 Thread Joshua D. Drake
On Sat, 2010-08-21 at 13:12 -0400, Tom Lane wrote: > "Joshua D. Drake" writes: > > PostgreSQL is a user space project. Yes we have a solid core of -hackers > > but our wider use is a place where hackers don't exist. User space > > developers do. I.e; PHP

Re: [HACKERS] Version Numbering

2010-08-21 Thread Joshua D. Drake
x27;s description of what's new in 2.28 (over > 2.26, the previous public release): Gnome is a bad example. People barely know if at all they are running Gnome. They are running Ubuntu. Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.co

Re: [HACKERS] Version Numbering

2010-08-20 Thread Joshua D. Drake
On Sat, 2010-08-21 at 01:36 +, Greg Sabino Mullane wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: RIPEMD160 > > > > Look at other DBMSes: > > Oracle: 8i, 9i, 10g, 11g > > Informix 9, 10, 11 > > MS SQL Server 7, 2000, 2005, 2008 > > > is not only confusing but make people think we are so

Re: [HACKERS] Version Numbering

2010-08-20 Thread Joshua D. Drake
or example. Consider me a very weak -1 > and open to persuasion. :) Are we losing something by going to a notably simpler scheme of versioning? Is there a problem we are creating? Are we arguing for the sake of arguing? Sincerely, Joshua D. Drake -- PostgreSQL.org Major Contributor Comm

Re: [HACKERS] Version Numbering

2010-08-20 Thread Joshua D. Drake
On Fri, 2010-08-20 at 15:41 -0700, Josh Berkus wrote: > > Not really a comparable argument. I find it interesting that people are > > making logical arguments about something that is clearly not in the > > logical realm. This is marketing people. > > Then why are we discussing it on -hackers? Go

Re: [HACKERS] Version Numbering

2010-08-20 Thread Joshua D. Drake
On Fri, 2010-08-20 at 18:10 -0400, Robert Haas wrote: > > > > > > Maybe we can give marketing brand names to every new version so people > > is not confused by numbers... > > Ah, yes. Because it's so intuitive that Windows 7 comes after Windows 95... > :-) Not really a comparable argument. I f

Re: [HACKERS] Version Numbering

2010-08-20 Thread Joshua D. Drake
catering to > their inaccuracies. Depends on the goal. If our goal is to continue to add confusion to the masses of users we have, you are correct. If our goal is to simplify the ability for a user to accurately understand the version of PostgreSQL they are running, then you are wrong. Josh

Re: [HACKERS] git: uh-oh

2010-08-20 Thread Joshua D. Drake
On Fri, 2010-08-20 at 14:47 +0100, Dave Page wrote: > On Fri, Aug 20, 2010 at 2:36 PM, Robert Haas wrote: > > On Fri, Aug 20, 2010 at 9:28 AM, Magnus Hagander > > wrote: > >> I believe Robert had some comments/questions as well :-) > > > > What Magnus means is that I'm a grumpy old developer who

Re: [HACKERS] git: uh-oh

2010-08-20 Thread Joshua D. Drake
On Fri, 2010-08-20 at 09:36 -0400, Robert Haas wrote: > On Fri, Aug 20, 2010 at 9:28 AM, Magnus Hagander wrote: > > I believe Robert had some comments/questions as well :-) > > What Magnus means is that I'm a grumpy old developer who complains > about everything. +1 JD -- PostgreSQL.org Major

Re: [HACKERS] git: uh-oh

2010-08-18 Thread Joshua D. Drake
On Wed, 2010-08-18 at 12:26 -0400, Alvaro Herrera wrote: > Excerpts from Magnus Hagander's message of miƩ ago 18 11:52:58 -0400 2010: > > On Wed, Aug 18, 2010 at 17:33, Khee Chin wrote: > > > I previously proposed off-list an alternate solution to generate the git > > > repository which was turned

Re: [HACKERS] Git migration timeline

2010-08-16 Thread Joshua D. Drake
On Mon, 2010-08-16 at 16:19 +0200, Magnus Hagander wrote: > On Mon, Aug 16, 2010 at 16:15, Tom Lane wrote: > > Magnus Hagander writes: > >> On Mon, Aug 16, 2010 at 15:58, Tom Lane wrote: > >>> I can see the point of wanting to be dead certain the repository isn't > >>> changing under you during

Re: [HACKERS] JSON Patch for PostgreSQL - BSON Support?

2010-08-16 Thread Joshua D. Drake
Of course, until someone tests it, we're just > > speculating wildly. > > Yep, that was exactly what struck me. TOAST is quite likely to be a > good answer for this. Except: How much JSON data will actually be TOASTed? Joshua D. Drake -- PostgreSQL.org Major Contributo

Re: [HACKERS] including backend ID in relpath of temp rels - updated patch

2010-08-12 Thread Joshua D. Drake
atches automatically, > saving you some time and us some boredom :) I was under the impression that the project guideline was that we only accepted context diffs? Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Train

Re: [HACKERS] patch: Add JSON datatype to PostgreSQL (GSoC, WIP)

2010-08-11 Thread Joshua D. Drake
s up > > for discussion. Thoughts, anyone? > > +1 for putting it in core in 9.1 :) I would be curious to the benefit of putting it in core. I have no problem with the type but in core? Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.comma

Re: [HACKERS] patch for contrib/isn

2010-08-04 Thread Joshua D. Drake
anks. We will get it on the review list. 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/commandprompt -- Sen

Re: [HACKERS] Two problems when using Postgresql8.3.7, Please help me!

2010-08-03 Thread Joshua D. Drake
ot read block X of relation X/X/X: read only Xof X bytes". I > spent two days to figure out what happened, but it is too hard.Please > help me. What are you using to transfer the WAL? Did you read this chapter? http://www.postgresql.org/docs/8.3/static/continuous-

Re: [HACKERS] Develop item from TODO list

2010-08-03 Thread Joshua D. Drake
ms of learning curve): Bluefish Anjuta Kate If you want a full environment with projects, SCM integration etc... I would suggest Eclipse. That said, if you can get a handle on VI/VIM or (joe :P) you will probably be pleased with the efficiency. Sincerely, Joshua D. Drake -- PostgreSQL.org

Re: [HACKERS] On Scalability

2010-07-29 Thread Joshua D. Drake
On Thu, 2010-07-29 at 19:52 +0200, Vincenzo Romano wrote: > 2010/7/29 Joshua D. Drake : > > On Thu, 2010-07-29 at 19:34 +0200, Vincenzo Romano wrote: > > > >> I expect that a more complex schema will imply higher workloads > >> on the query planner. What I don&

Re: [HACKERS] On Scalability

2010-07-29 Thread Joshua D. Drake
On Thu, 2010-07-29 at 19:34 +0200, Vincenzo Romano wrote: > I expect that a more complex schema will imply higher workloads > on the query planner. What I don't know is how the increase in the > workload will happen: linearly, sublinearly, polinomially or what? > > Significant testing would requi

Re: [HACKERS] On Scalability

2010-07-29 Thread Joshua D. Drake
in a multilevel hierarchy > (let's say, partitioning by year, month and company). Again, test it. Generally speaking the number of child tables directly correlates to planning time. Most experience that 60-100 tables is really the highest you can go. It all depends on actual implementation

Re: [HACKERS] Toward a column reorder solution

2010-07-28 Thread Joshua D. Drake
On Wed, 2010-07-28 at 09:30 -0700, David E. Wheeler wrote: > On Jul 28, 2010, at 7:57 AM, Joshua D. Drake wrote: > > > Hah! I gave you kudos :P (you are in the FAQ) > > Ah, thanks. The link is missing a "G": It's "PGXN," not "PXN". Yeah that

Re: [HACKERS] Toward a column reorder solution

2010-07-28 Thread Joshua D. Drake
On Tue, 27 Jul 2010 19:55:18 -0700, "David E. Wheeler" wrote: > On Jul 27, 2010, at 3:01 PM, Joshua D. Drake wrote: > >> Correct. We are also hoping to get some sponsorship for it. >> >> https://www.fossexperts.com/ > > Frigging copycat. Hah! I ga

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