On Thu, 2011-02-17 at 00:28 +, Greg Stark wrote:
On Thu, Feb 17, 2011 at 12:07 AM, Greg Smith g...@2ndquadrant.com 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
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 believe
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 and
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.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http
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
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.
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
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 don't
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 we only
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,
aren't talking about shelling out 50k here.
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
On Wed, 2011-01-26 at 17:39 -0500, Robert Haas wrote:
On Wed, Jan 26, 2011 at 5:30 PM, Richard Broersma
richard.broer...@gmail.com 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
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 member.
Sincerely,
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
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
Command Prompt, Inc: http
be more relevant but I definitely
agree something more newbie appropriate is in order.
Joshua D. Drake
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
--
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 bgwriter is
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 is just plain rude and anti-community.
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 j...@commandprompt.com
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,
search
: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
Sincerely,
Joshua D. Drake
regards, tom lane
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com
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.ca/commandprompt
--
Sent via pgsql
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
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 anything
.
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/commandprompt
--
Sent via pgsql-hackers mailing
On Tue, 2010-12-07 at 18:11 -0500, Tom Lane wrote:
Josh Berkus j...@agliodbs.com 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
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 remark
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 and
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 employment
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
On Tue, 2010-11-23 at 14:48 -0500, Robert Haas wrote:
On Tue, Nov 23, 2010 at 2:01 PM, David E. Wheeler da...@kineticode.com
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
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_work_mem
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
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-volume
On Fri, 2010-11-12 at 14:20 -0500, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
On Fri, Nov 12, 2010 at 1:55 PM, Tom Lane t...@sss.pgh.pa.us 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
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
replication, whether it's a minority or majority.
None of us know. What
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
Sorry, didn't
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 you
On Wed, 2010-10-27 at 15:33 -0400, Tom Lane wrote:
Josh Berkus j...@agliodbs.com 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
Customers will want
replication but that is by far NOT the majority of our (.Org) users.
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
On Wed, 2010-10-27 at 19:52 -0400, Robert Haas wrote:
On Wed, Oct 27, 2010 at 7:45 PM, Josh Berkus j...@agliodbs.com 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
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 size
on a %
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 the best
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
attempt
On Sun, 2010-10-17 at 16:27 -0400, Tom Lane wrote:
Joshua D. Drake j...@commandprompt.com 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 integer datetimes as of 8.4
On Sun, 2010-10-17 at 15:52 -0700, Greg Stark wrote:
On Sun, Oct 17, 2010 at 12:03 PM, Joshua D. Drake j...@commandprompt.com
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.
If only we knew
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
Command Prompt, Inc: http
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 the
On Tue, 2010-10-05 at 12:27 -0400, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
On Tue, Oct 5, 2010 at 10:56 AM, Tom Lane t...@sss.pgh.pa.us 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
On Tue, 2010-10-05 at 14:49 -0400, Robert Haas wrote:
On Tue, Oct 5, 2010 at 2:08 PM, Greg Stark gsst...@mit.edu 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
the community.
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/commandprompt
--
Sent via pgsql
On Thu, 2010-09-23 at 22:22 +0100, Thom Brown wrote:
On 23 September 2010 22:20, David E. Wheeler da...@kineticode.com wrote:
On Sep 23, 2010, at 1:02 PM, Robert Haas wrote:
On Thu, Sep 23, 2010 at 3:52 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Apparently somebody's confused between local
,
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 mailing list (pgsql
that my solution puts code in more places and that it may be
more of a burden for the hackers.
However, we aren't building this for hackers. Most hackers 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
On Wed, 2010-09-22 at 13:26 -0400, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
On Wed, Sep 22, 2010 at 1:09 PM, Joshua D. Drake j...@commandprompt.com
wrote:
On Wed, 2010-09-22 at 13:00 -0400, Robert Haas wrote:
But it CAN'T be a system catalog, because, among other
On Wed, 2010-09-22 at 21:05 +0100, Thom Brown wrote:
On 22 September 2010 19:50, Josh Berkus j...@agliodbs.com 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
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 runs on,
on the idea of reducing our supported platforms. I
see no reason to support
Solaris 9
NetBSD in any form
FreeBSD 6
Any Linux not supported by its own community (e.g; FC9)
Irix
SCO
Note: I am not actually advocating this as much as stating my own
personal opinion.
Joshua D. Drake
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 mailing list (pgsql-hackers
to remove it.
But bigger than that.
The uninformed still use OIDs. They shouldn't.
Joshua D. Drake
regards, tom lane
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development
REPLICATION FOR FOO;
ALTER CLUSTER SET keep_connect ON FOO TO TRUE;
Or some such thing.
Sincerely,
Joshua D. Drake
--
Bruce Momjian br...@momjian.ushttp://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true
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
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
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
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 Andrew
On Tue, 2010-08-24 at 13:44 -0700, Josh Berkus wrote:
On 8/24/10 12:42 PM, Tom Lane wrote:
Marko Tiikkaja marko.tiikk...@cs.helsinki.fi 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
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.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development
On Sat, 2010-08-21 at 13:12 -0400, Tom Lane wrote:
Joshua D. Drake j...@commandprompt.com 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 people.
This is utter
On Sat, 2010-08-21 at 18:24 +0100, Greg Stark wrote:
On Sat, Aug 21, 2010 at 5:51 PM, Joshua D. Drake j...@commandprompt.com
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 by
SP1 through SP6
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 Major Contributor
Command Prompt, Inc: http
On Fri, 2010-08-20 at 09:36 -0400, Robert Haas wrote:
On Fri, Aug 20, 2010 at 9:28 AM, Magnus Hagander mag...@hagander.net 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
--
On Fri, 2010-08-20 at 14:47 +0100, Dave Page wrote:
On Fri, Aug 20, 2010 at 2:36 PM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Aug 20, 2010 at 9:28 AM, Magnus Hagander mag...@hagander.net
wrote:
I believe Robert had some comments/questions as well :-)
What Magnus means is that
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.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http
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 find it
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?
Good
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
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http
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 somehow behind
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 kheec...@gmail.com wrote:
I previously proposed off-list an alternate solution to generate the git
repository which
. 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 Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http
On Mon, 2010-08-16 at 16:19 +0200, Magnus Hagander wrote:
On Mon, Aug 16, 2010 at 16:15, Tom Lane t...@sss.pgh.pa.us wrote:
Magnus Hagander mag...@hagander.net writes:
On Mon, Aug 16, 2010 at 15:58, Tom Lane t...@sss.pgh.pa.us wrote:
I can see the point of wanting to be dead certain the
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, Training, Support, Custom Development, Engineering
http://twitter.com
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.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http
with the new 979-prefix and additionally added all
missing ranges since year 2006 for isbn with 978-prefix.
patch against HEAD is attached and validated against a lot of previously
wrong and correct hyphenated isbn.
regards, jan
Great! Thanks. We will get it on the review list.
Joshua D
):
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 Major Contributor
Command
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-archiving.html
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major
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 and business requirements
however.
Sincerely,
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 require a
On Thu, 2010-07-29 at 19:52 +0200, Vincenzo Romano wrote:
2010/7/29 Joshua D. Drake j...@commandprompt.com:
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
On Tue, 27 Jul 2010 19:55:18 -0700, David E. Wheeler
da...@kineticode.com 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 gave you kudos :P (you are in the FAQ
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 is already fixed, just waiting for cache to clear (on the
server
On Tue, 2010-07-27 at 14:11 -0400, Tom Lane wrote:
Robert Haas robertmh...@gmail.com writes:
I think we should consider postponing beta4. I count eleven
non-documentation, 9.0-specific bug fix on REL9_0_STABLE, but there
are currently five items on the open 9.0 issues list, at least one of
-12/msg00983.php
Alvaro is planning to work on this for 9.1, I believe.
http://archives.postgresql.org/pgsql-hackers/2010-07/msg00188.php
Yay!
Correct. We are also hoping to get some sponsorship for it.
https://www.fossexperts.com/
Sincerely,
Joshua D. Drake
On Sat, 2010-07-24 at 13:48 -0400, Andrew Dunstan wrote:
Yeah. Also, please bear in mind that our explicit aim here is to make
this change with a minimal disruption to existing work flows. So to all
those people who want to say Look, you can now do all these cool
things my answer is
EXECUTE permissions I can still see the function
in pg_proc.
This seems like an inconsistency worth looking into, especially now that
we have per column perms.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting
On Fri, 2010-07-23 at 21:55 +0300, Peter Eisentraut wrote:
On fre, 2010-07-23 at 11:48 -0700, Joshua D. Drake wrote:
In particular, it must have read access to all tables that you want
to
back up, so in practice you almost always have to run it as a database
superuser.
Ignoring
On Mon, 2010-07-19 at 10:23 -0700, David Fetter wrote:
On Mon, Jul 19, 2010 at 02:12:19PM -, Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
1. \d isn't exactly the most intuitive thing ever
Seems fairly mnemomic to me (d=describe) and it
On Sat, 2010-07-17 at 09:02 -0500, Robert Haas wrote:
On Jul 16, 2010, at 11:02 PM, Stephen Frost sfr...@snowman.net wrote:
* Robert Haas (robertmh...@gmail.com) wrote:
Why must the backslash commands be more powerful than any alternative
we might come up with?
Because they encode alot
On Sat, 2010-07-17 at 23:30 +0200, Stefan Kaltenbrunner wrote:
On 07/17/2010 04:02 PM, Robert Haas wrote:
On Jul 16, 2010, at 11:02 PM, Stephen Frostsfr...@snowman.net wrote:
* Robert Haas (robertmh...@gmail.com) wrote:
Why must the backslash commands be more powerful than any alternative
a single, well described grammar for interacting
with objects in the database regardless of client. I should be able to
open ANY SQL terminal, and type SHOW ME THE MONEY and have Benjamins
fall out.
The discussions of \ commands and psql are irrelevant to this thread.
Joshua D. Drake
On Sat, 2010-07-17 at 07:36 +1000, Brendan Jurd wrote:
On 17 July 2010 07:26, Joshua D. Drake j...@commandprompt.com wrote:
Yes. We should provide a single, well described grammar for interacting
with objects in the database regardless of client. I should be able to
open ANY SQL terminal
.
SHOW TABLES, SHOW COLUMNS makes a lot of sense. Just has something like
DESCRIBE TABLE foo makes a lot more sense than \d.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom
On Thu, 2010-07-15 at 17:38 +0200, Magnus Hagander wrote:
Looks like the last time this was discussed, there wasn't any clear
conclusion. Someone created a patch and it's still on the TODO list:
http://archives.postgresql.org/pgsql-hackers/2010-01/msg01845.php
That one is about:
a)
701 - 800 of 2933 matches
Mail list logo
