Re: [HACKERS] copy.c handling for RLS is insecure

2014-10-06 Thread David Fetter
? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] [RFC] Incremental backup v2: add backup profile to base backup

2014-10-06 Thread David Fetter
need it at all, but if we're going to have a profile file, it should always be included. +1 for fewer user decisions, especially with something light-weight in resource consumption like the profile. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] delta relations in AFTER triggers

2014-08-27 Thread David Fetter
why they can't create an index on it. :) Continuing with this digression, that request seems more likely with views and foreign tables, given that they persist across statements. I'm given to understand that other systems have at least the former. Cheers, David. -- David Fetter da...@fetter.org

Re: [HACKERS] WIP Patch for GROUPING SETS phase 1

2014-08-21 Thread David Fetter
this. Do we want to make some kind of generator for such things? It doesn't seem hard in principle, but I haven't tried coding it up yet. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Patch status: delta relations in AFTER triggers

2014-08-20 Thread David Fetter
manager, BTW.  It's a dirty job, but somebody's got to do it. Indeed, and thanks for wrangling this, Heikki. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal

Re: [HACKERS] Patch status: delta relations in AFTER triggers

2014-08-20 Thread David Fetter
On Wed, Aug 20, 2014 at 09:59:11AM -0700, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: On Wed, Aug 20, 2014 at 07:29:39AM -0700, Kevin Grittner wrote: The patch that David offered to use the tuplestores in C should probably be updated to show both direct use based on what

Re: [HACKERS] pg_dump bug in 9.4beta2 and HEAD

2014-08-15 Thread David Fetter
far) equivalents and use those. Not for 9.4, obviously. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [HACKERS] Behavior of OFFSET -1

2014-07-22 Thread David Fetter
this could be argued not to be is just casuistry, namely LIMIT m OFFSET -n might be argued to mean LIMIT m-n. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] Missing autocomplete for CREATE DATABASE

2014-07-10 Thread David Fetter
this bug. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating

Re: [HACKERS] [BUGS] LEFT JOINs not optimized away when not needed

2014-07-08 Thread David Fetter
JOINs seems orthogonal, at least in theory, to join_collapse_limit. What have I missed here, and how might they have dependencies? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

Re: [HACKERS] delta relations in AFTER triggers

2014-06-30 Thread David Fetter
On Mon, Jun 30, 2014 at 11:03:06AM -0400, Robert Haas wrote: On Sat, Jun 28, 2014 at 10:35 AM, Kevin Grittner kgri...@ymail.com wrote: David Fetter da...@fetter.org wrote: On Sat, Jun 21, 2014 at 11:06:26AM -0700, Kevin Grittner wrote: Here is v2. I've taken the liberty of making

Re: [HACKERS] delta relations in AFTER triggers

2014-06-29 Thread David Fetter
On Sat, Jun 28, 2014 at 07:35:10AM -0700, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: On Sat, Jun 21, 2014 at 11:06:26AM -0700, Kevin Grittner wrote: Here is v2. I've taken the liberty of making an extension that uses this. Preliminary tests indicate a 10x performance

Re: [HACKERS] delta relations in AFTER triggers

2014-06-27 Thread David Fetter
/davidfetter/postgresql_projects/tree/test_delta_v2 Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember

Re: [HACKERS] [PATCH 0/3] Tau support

2014-06-27 Thread David Fetter
of the world already. Might that be the cause? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [HACKERS] delta relations in AFTER triggers

2014-06-18 Thread David Fetter
. In summary, I'd like to propose that the tuplestores be generated separately in general and attached to callers. We can optimize this by not generating redundant tuplestores. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] delta relations in AFTER triggers

2014-06-18 Thread David Fetter
On Wed, Jun 18, 2014 at 03:30:34PM -0700, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: Robert Haas wrote: Kevin Grittner kgri...@ymail.com wrote: The good: - Generating the tuplestores.  Yay! Thanks for that.  ;-) Sorry, I just can't resist references to Spaghetti

Re: [HACKERS] delta relations in AFTER triggers

2014-06-15 Thread David Fetter
the old version for the case of UPDATE ... RETURNING? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [HACKERS] IMPORT FOREIGN SCHEMA statement

2014-05-28 Thread David Fetter
On Tue, May 27, 2014 at 09:41:06AM -0400, Stephen Frost wrote: * David Fetter (da...@fetter.org) wrote: - We make type mappings settable at the level of: - FDW - Instance (a.k.a. cluster) - Database - Schema - Table - Column While I like the general idea

Re: [HACKERS] Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?

2014-05-26 Thread David Fetter
, as anyone who's worked on that part of pg_dump can tell you. Any caveat Locking. Given that, you'd want this behavior only with CASCADE, per Stephen's response. that defeats the purpose of such feature? Probably not. I'd certainly like to have the feature :) Cheers, David. -- David Fetter

Re: [HACKERS] Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?

2014-05-26 Thread David Fetter
On Tue, May 27, 2014 at 12:37:32AM +0400, ash wrote: David Fetter da...@fetter.org writes: On Mon, May 26, 2014 at 06:25:09PM +0400, ash wrote: Hi Hackers, This came up recently on general list (and I've just hit the same issue today): http://www.postgresql.org/message-id

Re: [HACKERS] IMPORT FOREIGN SCHEMA statement

2014-05-25 Thread David Fetter
: IDENTITY, outbound: IDENTITY }') Each FDW would have some set of default mappings and some way to override them as above. What say? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] IMPORT FOREIGN SCHEMA statement

2014-05-25 Thread David Fetter
On Sun, May 25, 2014 at 11:23:41PM +0200, Ronan Dunklau wrote: Le dimanche 25 mai 2014 12:41:18 David Fetter a écrit : On Fri, May 23, 2014 at 10:08:06PM +0200, Ronan Dunklau wrote: Hello, Since my last proposal didn't get any strong rebuttal, please find attached a more complete

Re: [HACKERS] Congrats Andres Freund, the newest PostgreSQL Commiter!

2014-05-22 Thread David Fetter
, for the excellent work that has been doing for the community. Thank you and Congrats Andres! Congratulations, Andres! Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

Re: [HACKERS] New timezones used in regression tests

2014-05-15 Thread David Fetter
a good bit more extensible. Conversions among the different timestamptzs might be problematic, as we are currently assuming certain approximations about spacetime that don't actually hold when we have time zones in significantly different reference frames. Cheers, David. -- David Fetter da

Re: [HACKERS] Freezing without write I/O

2014-05-14 Thread David Fetter
improvements over what we have now, but if this revolutionary approach has a high chance of landing then any work on incremental improvements would be pointless. How much work do you anticipate for the description and PoC of whatever it is you've been pondering? Cheers, David. -- David Fetter da

Re: [HACKERS] Hashable custom types

2014-04-26 Thread David Fetter
many other things (total ordering, e.g.)? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember

Re: [HACKERS] Decrease MAX_BACKENDS to 2^16

2014-04-26 Thread David Fetter
references. Out of curiosity, where are you finding that a 32-bit integer is causing problems that a 16-bit one would solve? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

Re: [HACKERS] Decrease MAX_BACKENDS to 2^16

2014-04-26 Thread David Fetter
connections, but I've never found a win for 2x the number of cores in the box, which at least in my experience so far tops out in the 8-bit (in extreme cases unsigned 8-bit) range. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [HACKERS] UUIDs in core WAS: 9.4 Proposal: Initdb creates a single table

2014-04-25 Thread David Fetter
of not have an obvious predecessor or successor. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember

Re: [HACKERS] 9.4 Proposal: Initdb creates a single table

2014-04-24 Thread David Fetter
of some other popular implementation of that code. We pretty much bet on the wrong horse when we picked the OSSP library to depend on, but otherwise I think the principle of using an external library was good. So long as we can pick another horse later, sure. Cheers, David. -- David Fetter da

Re: [HACKERS] 9.4 Proposal: Initdb creates a single table

2014-04-23 Thread David Fetter
to build UUID functionality in, and I don't see this as a hard task. Should I draft it up as a self-contained extension? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

Re: [HACKERS] 9.4 Proposal: Initdb creates a single table

2014-04-23 Thread David Fetter
On Wed, Apr 23, 2014 at 12:24:21PM -0700, David Fetter wrote: On Wed, Apr 23, 2014 at 02:26:50PM -0300, Alvaro Herrera wrote: Josh Berkus wrote: On 04/23/2014 07:43 AM, Alexander Korotkov wrote: I can propose contrib PostgreNoSQL providing following: 1) Table postgres as you proposed

Re: [HACKERS] 9.4 Proposal: Initdb creates a single table

2014-04-23 Thread David Fetter
On Wed, Apr 23, 2014 at 08:27:52PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: Is there any good reason not to roll native UUID generation into our standard distribution? It's already there (as of 9.4) in pg_crypto. Sorry I wasn't clear enough. Since contrib/pgcrypto

Re: [HACKERS] PATCH: Allow empty targets in unaccent dictionary

2014-04-20 Thread David Fetter
, (unsigned char *) src, srclen, -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- David Fetter da...@fetter.org http://fetter.org

[HACKERS] test script, was Re: [COMMITTERS] pgsql: psql: conditionally display oids and replication identity

2014-04-15 Thread David Fetter
. Or maybe it could be a new make target... Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember

[HACKERS] Re: [COMMITTERS] pgsql: Fix EquivalenceClass processing for nested append relations.

2014-03-28 Thread David Fetter
On Fri, Mar 28, 2014 at 03:50:10PM +, Tom Lane wrote: Fix EquivalenceClass processing for nested append relations. If this is a bug fix, shouldn't it be back-patched? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] [pgsql-advocacy] GSoC 2014 - mentors, students and admins

2014-02-27 Thread David Fetter
prospective mentors? We'll want some folk to act as back-up mentors too to ensure projects can still be completed should any mentor become unavailable. For MADlib, no. Are you asking for mentors in general? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] Re: [COMMITTERS] pgsql: Add a GUC to report whether data page checksums are enabled.

2014-02-19 Thread David Fetter
On Tue, Feb 18, 2014 at 04:39:27PM -0300, Alvaro Herrera wrote: Heikki Linnakangas wrote: Add a GUC to report whether data page checksums are enabled. Is there are reason this wasn't back-patched to 9.3? I think it should be. +1 for back-patching. Cheers, David. -- David Fetter da

Re: [HACKERS] CREATE FOREIGN TABLE ( ... LIKE ... )

2014-02-16 Thread David Fetter
On Sat, Feb 15, 2014 at 03:14:03PM +0100, Andres Freund wrote: On 2014-01-31 18:16:18 +0100, Vik Fearing wrote: On 01/25/2014 06:25 AM, David Fetter wrote: Please find attached the next rev :) This version looks committable to me, so I am marking it as such. This doesn't contain

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2014-02-11 Thread David Fetter
On Sun, Feb 02, 2014 at 02:52:42PM -0800, David Fetter wrote: On Wed, Aug 21, 2013 at 08:52:25PM +0200, Karol Trzcionka wrote: W dniu 21.08.2013 19:17, Boszormenyi Zoltan pisze: With this fixed, a more complete review: Thanks. I've done some syntactic and white space cleanup, here

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2014-02-02 Thread David Fetter
that need same? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating

[HACKERS] FOREIGN KEY ... CONCURRENTLY

2014-01-29 Thread David Fetter
to understand. A couple of questions: 1) Would people like to have FOREIGN KEY ... CONCURRENTLY as described above? 2) Is there another way to solve the problem of adding a foreign key constraint that points at a busy table? Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] [pgsql-advocacy] GSoC 2014 - mentors, students and admins

2014-01-29 Thread David Fetter
for mentoring this year? And are there any project ideas folk would like to suggest? I'd be delighted to mentor. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] Changeset Extraction v7.3

2014-01-28 Thread David Fetter
? The existing replication mechanism is similar to block-based disk backups. It's the whole thing (not parts) and doesn't have any concept of database/directory. +1 for this terminology. It's descriptive. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] inherit support for foreign tables

2014-01-27 Thread David Fetter
solution will be satisfactory, as the PostgreSQL FDW could, at least in principle, support many more than the CSV FDW, as shown above. In my estimation, the outcome of discussion above is not a blocker for this patch. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415

Re: [HACKERS] Fix comment typo in /src/backend/command/cluster.c

2014-01-27 Thread David Fetter
times in the source tree. Should we have a glossary of such terms? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [HACKERS] CREATE FOREIGN TABLE ( ... LIKE ... )

2014-01-24 Thread David Fetter
On Sun, Nov 24, 2013 at 02:03:18AM +0100, Vik Fearing wrote: On 10/15/2013 07:50 AM, David Fetter wrote: On Mon, Oct 07, 2013 at 11:16:56PM -0700, David Fetter wrote: Folks, Please find attached a patch implementing and documenting, to some extent, $subject. I did this in aid of being

Re: [HACKERS] CREATE FOREIGN TABLE ( ... LIKE ... )

2014-01-15 Thread David Fetter
On Thu, Jan 16, 2014 at 01:07:50AM +0100, Vik Fearing wrote: On 11/24/2013 02:03 AM, Vik Fearing wrote: On 10/15/2013 07:50 AM, David Fetter wrote: On Mon, Oct 07, 2013 at 11:16:56PM -0700, David Fetter wrote: Folks, Please find attached a patch implementing and documenting, to some

Re: [HACKERS] Disallow arrays with non-standard lower bounds

2014-01-13 Thread David Fetter
. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS]

2014-01-12 Thread David Fetter
://commitfest.postgresql.org/action/commitfest_view?id=21 Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote

Re: [HACKERS] new json funcs

2014-01-10 Thread David Fetter
documentation :-( FDWs to the rescue! Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

Re: [HACKERS] Disallow arrays with non-standard lower bounds

2014-01-10 Thread David Fetter
). Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] Disallow arrays with non-standard lower bounds

2014-01-09 Thread David Fetter
mistakes than this. Anybody whose code has this kind of silliness in it will be in other kinds of trouble, too. Cheers, David (who is among that tiny minority who believe that arrays should be indexed from 0.5 as a compromise ;) -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] Time to do our Triage for 9.4

2014-01-08 Thread David Fetter
, there are unsent patches which don't fit into the categories below. Are you saying now that the cut-off is today, and not actually 1/15, as everyone understands it to be? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] RFC: Async query processing

2014-01-05 Thread David Fetter
). This is already doable using data-modifying WITH clauses. Whether ORMs are (or should be made) smart enough to take advantage of this is probably out of the scope of this discussion, though. For what it's worth, I'm not in favor of orthogonality in languages, so +1 from me. Cheers, David. -- David

Re: [HACKERS] [ANNOUNCE] IMCS: In Memory Columnar Store for PostgreSQL

2014-01-04 Thread David Fetter
imcs and removed drop extension imcs commands. If there are some violations of PostgreSQL extensions rules, please let me know, I will fix them. But I thought that I have done everything in legal way. On 01/04/2014 03:21 AM, David Fetter wrote: On Thu, Jan 02, 2014 at 08:48:24PM

Re: [HACKERS] [ANNOUNCE] IMCS: In Memory Columnar Store for PostgreSQL

2014-01-03 Thread David Fetter
as an EXTENSION, which would allow people to add it or remove it cleanly. Would you be so kind as to fix these? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] [PATCH] SQL assertions prototype

2013-12-27 Thread David Fetter
On Mon, Nov 25, 2013 at 12:10:22PM -0800, Kevin Grittner wrote: David Fetter da...@fetter.org wrote: On Mon, Nov 25, 2013 at 11:04:23AM -0800, Kevin Grittner wrote: As soon as we are out of this CF, I am planning to write code to capture deltas and fire functions to process them eagerly

Re: [HACKERS] CREATE TABLESPACE SET

2013-12-26 Thread David Fetter
TABLESPACE x LOCATION y SET (random_page_cost = z); That should probably be WITH instead of SET for consistency with other similar DDL. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] GiST support for inet datatypes

2013-12-22 Thread David Fetter
of the addresses. Except for the new operators and is contained within, contains; basic comparison operators are also supported. Please add this patch to the upcoming Commitfest at https://commitfest.postgresql.org/action/commitfest_view?id=21 Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] array_length(anyarray)

2013-12-19 Thread David Fetter
when used with the arrays people use 99% of the time. +1 for adding this. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical

Re: [HACKERS] planner missing a trick for foreign tables w/OR conditions

2013-12-16 Thread David Fetter
, and then run these quereis: +1 for fixing this bug :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [HACKERS] [PATCH] Negative Transition Aggregate Functions (WIP)

2013-12-15 Thread David Fetter
transition function. Would that make the CREATE AGGREGATE option be INVFUNC ? Any other ideas or +1's for any of the existing ones? +1 for inverse. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] Status of FDW pushdowns

2013-12-04 Thread David Fetter
On Wed, Dec 04, 2013 at 12:43:44PM -0600, Merlin Moncure wrote: On Mon, Dec 2, 2013 at 10:26 PM, David Fetter da...@fetter.org wrote: On Tue, Dec 03, 2013 at 11:15:36AM +0800, Craig Ringer wrote: On 11/28/2013 03:24 AM, David Fetter wrote: WITH, or SRF, or whatever, the point is that we

Re: [HACKERS] Status of FDW pushdowns

2013-12-04 Thread David Fetter
On Wed, Dec 04, 2013 at 03:04:31PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: The idea here is that such a happy situation will not obtain until much later, if ever, and meanwhile, we need a way to get things accomplished even if it's inelegant, inefficient, etc

Re: [HACKERS] Status of FDW pushdowns

2013-12-02 Thread David Fetter
On Tue, Dec 03, 2013 at 11:15:36AM +0800, Craig Ringer wrote: On 11/28/2013 03:24 AM, David Fetter wrote: WITH, or SRF, or whatever, the point is that we need to be able to specify what we're sending--probably single opaque strings delimited just as we do other strings--and what we might

Re: [HACKERS] Status of FDW pushdowns

2013-11-27 Thread David Fetter
, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] Status of FDW pushdowns

2013-11-27 Thread David Fetter
On Thu, Nov 28, 2013 at 01:29:46AM +0530, Atri Sharma wrote: On Thu, Nov 28, 2013 at 12:54 AM, David Fetter da...@fetter.org wrote: On Wed, Nov 27, 2013 at 10:29:34AM -0300, Alvaro Herrera wrote: Shigeru Hanada escribió: SQL/MED standard doesn't say much about PASS THROUGH mode

Re: [HACKERS] [PATCH] SQL assertions prototype

2013-11-25 Thread David Fetter
in Foundation section 11.49 and called REFERENCING in CREATE TRIGGER. Do you have any prototypes I could use for that purpose? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

Re: [HACKERS] Status of FDW pushdowns

2013-11-22 Thread David Fetter
to implement it. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2013-11-21 Thread David Fetter
plan to continue this work for the current commitfest? A lot of people really want the feature :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] Status of FDW pushdowns

2013-11-21 Thread David Fetter
, it's literally impossible to make what they suggest safe. Given those givens, we're free to do this in a way that's not barking-at-the-moon crazy. At least two inter-database communication links which work with PostgreSQL do this.. Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Changing pg_dump default file format

2013-11-07 Thread David Fetter
the choice to use -j (1 core) trivial. I'd also make sure that the directory format could handle the entirety of the backed-up database in some comprehensible way. Maybe a globals/ and a databases/ directory up top... Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] [PATCH] Use MAP_HUGETLB where supported (v3)

2013-10-30 Thread David Fetter
using PostgreSQL x.y.z or x.y.w? when it comes to features. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [HACKERS] [PATCH] Use MAP_HUGETLB where supported (v3)

2013-10-30 Thread David Fetter
say indivisible unit or smallest division or something) and failing with a message to that effect if someone tries to set it otherwise? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Commitfest II CLosed

2013-10-20 Thread David Fetter
On Sun, Oct 20, 2013 at 10:42:10AM +0200, Boszormenyi Zoltan wrote: Hi, 2013-10-19 17:20 keltezéssel, David Fetter írta: Thanks very much to Mike Blackwell and Craig Kerstiens for their persistence through what most people would consider a tedious and thankless task. Thanks also

Re: [HACKERS] FDW API / flow charts for the docs?

2013-10-20 Thread David Fetter
simpler. If we manage to keep Java out of our build toolchain, we will be much the better for it. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

[HACKERS] Commitfest II CLosed

2013-10-19 Thread David Fetter
reviewed or committed until November. What it does mean is that people will be setting patch review as a lower priority, frequently so they can live their lives, work on new stuff, do their day jobs... We got 20 patches, many quite significant, committed this time. Kudos! Cheers, David. -- David

Re: [HACKERS] logical changeset generation v6.2

2013-10-15 Thread David Fetter
as a series of JSON files. We have docs for this rev of the format and examples of consumers in Perl and Python you can use as-is or hack up to meet your needs. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] CREATE FOREIGN TABLE ( ... LIKE ... )

2013-10-14 Thread David Fetter
On Mon, Oct 07, 2013 at 11:16:56PM -0700, David Fetter wrote: Folks, Please find attached a patch implementing and documenting, to some extent, $subject. I did this in aid of being able to import SQL standard catalogs and other entities where a known example could provide a template

Re: [HACKERS] dynamic shared memory: wherein I am punished for good intentions

2013-10-10 Thread David Fetter
PostgreSQL, you've got to either make POSIX shared memory work on your machine, or change the GUC that selects the type of dynamic shared memory used. +1 for this. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-09 Thread David Fetter
component of which is ten years old. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote

Re: [HACKERS] Patch: FORCE_NULL option for copy COPY in CSV mode

2013-10-09 Thread David Fetter
the null for some other column(s)? Idea: NULL FOR (foo,bar,baz,blurf) AS '', NULL FOR (quux,fleeg) AS ..., Are we going to have multiple such clauses? It looks like a real mess. Is that not part of what parsers ordinarily do? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

[HACKERS] [Commitfest] Patches, please notify your reviewers when you update a patch.

2013-10-09 Thread David Fetter
Folks, When you update a patch, please make sure to let your reviewer(s) know you have in addition to putting it in the Commitfest application. This will help ensure that your patch moves along its track to a satisfactory outcome for all this Commitfest. Cheers, David. -- David Fetter da

[HACKERS] CREATE FOREIGN TABLE ( ... LIKE ... )

2013-10-08 Thread David Fetter
all such errors and mention them at the end rather than simply bailing on the first one? TBD: regression tests. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal

Re: [HACKERS] old warning in docs

2013-10-07 Thread David Fetter
. There are probably a lot of places in the docs that refer to versions of PostgreSQL a good bit older than 8.3. Will grep and patch as I get the time. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Minmax indexes

2013-09-30 Thread David Fetter
guess, first cut. I take it this also occurred to you and that you believe that this approach makes the more general case or at least further out than it would need to be. Am I close? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

[HACKERS] Please mark new patches on the next CF

2013-09-18 Thread David Fetter
If you've got something that's not already on the current commitfest, please put it on the next one. Thanks! Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal

Re: [HACKERS] [PATCH] Revive line type

2013-09-16 Thread David Fetter
? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

[HACKERS] Commitfest II, 9.4 edition

2013-09-15 Thread David Fetter
this one great! Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating

Re: [HACKERS] Hstore: Query speedups with Gin index

2013-09-15 Thread David Fetter
via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] Protocol forced to V2 in low-memory conditions?

2013-09-11 Thread David Fetter
, given how far behind they're lagging in that case... How could we care anyhow? It's not like we have the resources to maintain all our current released versions anyhow, e.g. current support for 8.4 is a good bit less solid than for 9.2. Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Next CFM?

2013-09-10 Thread David Fetter
On Tue, Sep 10, 2013 at 01:27:37PM -0400, Peter Eisentraut wrote: On 9/9/13 5:56 PM, David Fetter wrote: On Mon, Sep 02, 2013 at 12:13:56PM -0700, David Fetter wrote: On Mon, Sep 02, 2013 at 12:00:02PM -0500, Josh Berkus wrote: Hackers, We need a Commit Fest manager for the September CF

[HACKERS] 9.4 CommitFest 2 Starts Sunday 15 September 2013!

2013-09-10 Thread David Fetter
this tedious and unglamorous work, write back and explain why you think you'd do it well. Thanks in advance for everyone's help, and let's make this CommitFest awesome! Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] Next CFM?

2013-09-09 Thread David Fetter
On Mon, Sep 02, 2013 at 12:13:56PM -0700, David Fetter wrote: On Mon, Sep 02, 2013 at 12:00:02PM -0500, Josh Berkus wrote: Hackers, We need a Commit Fest manager for the September CF. I'm not going to do it; this month is a heavy travel month for me (3 conferences and a wedding

Re: [HACKERS] Custom Plan node

2013-09-07 Thread David Fetter
the graph of the cluster with edges weighted by network bandwidth and latency? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people

Re: [HACKERS] Custom Plan node

2013-09-07 Thread David Fetter
On Sat, Sep 07, 2013 at 05:21:31PM +0200, Kohei KaiGai wrote: 2013/9/7 David Fetter da...@fetter.org: The broad outlines look great. Do we have any way, at least conceptually, to consider the graph of the cluster with edges weighted by network bandwidth and latency? As postgres_fdw

Re: [HACKERS] Next CFM?

2013-09-02 Thread David Fetter
: https://wiki.postgresql.org/wiki/CommitFest_Checklist Mind you, Peter E. seems to be getting patches organized ... are you CFM for this one, Peter? If Peter won't, I will. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [HACKERS] Extension Templates S03E11

2013-09-02 Thread David Fetter
it needs by itself. Is there some standard set of checks you run on new patches, and are the results showing up on, say, the buildfarm or some other CI dashboard? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] [v9.4] row level security

2013-08-29 Thread David Fetter
(disabling EXPLAIN, e.g.). Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

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