Re: [HACKERS] [PROTOCOL TODO] Permit streaming of unknown-length lob/clob (bytea,text,etc)

2014-12-01 Thread David Fetter
ou thinking of a one or more use cases where it's both large and unknown? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http:

Re: [HACKERS] double counting of lines in psql

2014-11-18 Thread David Fetter
oked on > output that is way too short (by about half a screen's height, I think). +1 It's a bug fix that changes behavior no reasonable script could count on. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype:

Re: [HACKERS] Final Patch for GROUPING SETS

2014-11-11 Thread David Fetter
n > renaming contrib/cube or unreserving keywords > gsp-u.patch- proposed method to unreserve CUBE and ROLLUP > > (the contrib patch is not necessary if the -u patch is used; the > contrib/pg_stat_statements fixes are in the phase1 patch) > > -- >

Re: [HACKERS] Let's drop two obsolete features which are bear-traps for novices

2014-11-04 Thread David Fetter
On Tue, Nov 04, 2014 at 08:30:21AM +, Laurenz Albe wrote: > David Fetter wrote: > > On Tue, Nov 04, 2014 at 07:51:06AM +0900, Tatsuo Ishii wrote: > >> Just out of curiosity, why is Oracle's NUMBER (I assume you are > >> talking about this) so fast? > > &

Re: [HACKERS] Let's drop two obsolete features which are bear-traps for novices

2014-11-03 Thread David Fetter
ces) at a 128-bit internal representation as the maximum. I don't know what happens when you get past what 128 bits can represent. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmai

Re: [HACKERS] Let's drop two obsolete features which are bear-traps for novices

2014-11-03 Thread David Fetter
publishing numbers they don't authorize, but they might have pushed some authorized numbers if those numbers make them look good. Also, just a general three-state comparison, "we beat them handily," "we're somewhere near them" or "we're not even close"

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2014-10-07 Thread David Fetter
tion about what > > reloptions have been set. > > > > Maybe into "information_schema" ?? Not there. The information schema is defined pretty precisely in the SQL standard and contains only some of this kind of information. pg_catalog seems like a much more appropriate sp

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

2014-10-06 Thread David Fetter
(by default disabled). > > I don't see the point of making the profile optional. Why burden the user > with that decision? I'm not convinced we need it at all, but if we're going > to have a profile file, it should always be included. +1 for fewer user decisions, esp

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

2014-10-06 Thread David Fetter
hanges, even though they might be bugs, categorically couldn't violate an access control? Cheers, David. -- David Fetter 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/pe

Re: [HACKERS] delta relations in AFTER triggers

2014-08-27 Thread David Fetter
EW/OLD as tables. I suspect that it won't be long after release > before someone asks 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 underst

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

2014-08-21 Thread David Fetter
ey have the extension installed and to do some magic > before the actual upgrade to handle the rename..? +1 for doing 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 Fe

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

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

2014-08-20 Thread David Fetter
should I wait to start until those patch sets are submitted to -hackers? > Thanks for picking up the job of CF 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 http://fetter.

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

2014-08-15 Thread David Fetter
)". There is no DROP there. The lo_* functions are probably too entrenched to be deprecated, but maybe we could come up with DML (or DDL, although that seems like a bridge too far) equivalents and use those. Not for 9.4, obviously. Cheers, David. -- David Fetter http://fetter.org/ Phone:

Re: [HACKERS] Behavior of "OFFSET -1"

2014-07-22 Thread David Fetter
magine where 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://ww

Re: [HACKERS] Missing autocomplete for CREATE DATABASE

2014-07-10 Thread David Fetter
it could hurt to fix this bug. Cheers, David. -- David Fetter 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
_collapse_limit relations to worry about. Eliminating 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Sky

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 wrote: > > David Fetter wrote: > >> On Sat, Jun 21, 2014 at 11:06:26AM -0700, Kevin Grittner wrote: > > > >>> Here is v2. > > > >>

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

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

2014-06-27 Thread David Fetter
value. It's Tau day (6.28) in some parts of the world already. Might that be the cause? Cheers, David. -- David Fetter 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] delta relations in AFTER triggers

2014-06-27 Thread David Fetter
r-space hack I did that's similar in functionality. Please find attached the extension, etc., which I've published to https://github.com/davidfetter/postgresql_projects/tree/test_delta_v2 Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

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 wrote: > > Robert Haas wrote: > >> Kevin Grittner wrote: > > > The good: > > - Generating the tuplestores.  Yay! > > Thanks for that.  ;-) Sorry, I just can't re

Re: [HACKERS] delta relations in AFTER triggers

2014-06-18 Thread David Fetter
x27;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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] delta relations in AFTER triggers

2014-06-15 Thread David Fetter
e able to surface the old version for the case of UPDATE ... RETURNING? Cheers, David. -- David Fetter 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

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 > > - T

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

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

2014-05-26 Thread David Fetter
t; that defeats the purpose of such feature? Probably not. I'd certainly like to have the feature :) Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/fe

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 stro

Re: [HACKERS] IMPORT FOREIGN SCHEMA statement

2014-05-25 Thread David Fetter
TO TEXT WITH ( INBOUND TRANSFORMATION IDENTITY, OUTBOUND TRANSFORMATION IDENTITY ) /* Ugh!!! */ vs. ALTER FOREIGN TABLE foo ADD (mapping '{ "datetime": "text", "inbound": "IDENTITY", outbound: &quo

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

2014-05-22 Thread David Fetter
s very much > this confidence, for the excellent work that has been doing for the > community. > > Thank you and Congrats Andres! Congratulations, Andres! Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] New timezones used in regression tests

2014-05-15 Thread David Fetter
n we have time zones in significantly different reference frames. Cheers, David. -- David Fetter 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 Remembe

Re: [HACKERS] Freezing without write I/O

2014-05-14 Thread David Fetter
ight do that would be more important. > > > Can anyone guess how likely this approach is to make it into 9.5? > I've been pondering some incremental improvements over what we have > now, but if this revolutionary approach has a high chance of landing > then any work on incremental

Re: [HACKERS] Decrease MAX_BACKENDS to 2^16

2014-04-26 Thread David Fetter
e do something clever with bit-stuffing, or would that tank performance in some terrible ways? I know we allow for gigantic numbers of backend 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

Re: [HACKERS] Decrease MAX_BACKENDS to 2^16

2014-04-26 Thread David Fetter
full integer to store 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.

Re: [HACKERS] Hashable custom types

2014-04-26 Thread David Fetter
of tree, perhaps, or does that require too many other things (total ordering, e.g.)? Cheers, David. -- David Fetter 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/david7

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

2014-04-25 Thread David Fetter
e this > easier (for example, a useful unique database ID), but I suspect that > acutal implementation will always remain application-specific. > > You may say "oh, that's not the job of the identifer", but if it's not, > WTF is the identifer for, then? Frequently

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

2014-04-24 Thread David Fetter
herwise 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://

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

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 follow

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

2014-04-23 Thread David Fetter
ng like it, certainly. One thing SQL Server does right is to have an opaque identity column, for which UUID would do an admirable job. We would need 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.

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

2014-04-20 Thread David Fetter
e, > > (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 --

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

2014-04-15 Thread David Fetter
py to go through and perl-ify it, document it, etc. Or maybe it could be a new make target... Cheers, David. -- David Fetter 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/ica

[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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfett

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

2014-02-27 Thread David Fetter
Are there any more 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 http://fetter.o

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,

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

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 som

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2014-02-02 Thread David Fetter
ting the sections that need same? Cheers, David. -- David Fetter 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] [pgsql-advocacy] GSoC 2014 - mentors, students and admins

2014-01-29 Thread David Fetter
his on in light of that experience :) > Who would be up 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter S

[HACKERS] FOREIGN KEY ... CONCURRENTLY

2014-01-29 Thread David Fetter
er or easier 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 http://fe

Re: [HACKERS] Changeset Extraction v7.3

2014-01-28 Thread David Fetter
sounds kind of funny to me. Anyone have another > > > > suggestion? > > > > > > Logical and Binary replication? > > > > Unfortunately changeset extraction output's can be binary data... > > > > Perhaps Logical and Block? > > The

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

2014-01-27 Thread David Fetter
viation in a first years Maths course > "Principles of Mathematics" in 1968 at the University of Auckland.. By my rough count (ack -l '\biff\b' |wc -l), it's used to mean equivalence 81 times in the source tree. Should we have a glossary of such terms? Che

Re: [HACKERS] inherit support for foreign tables

2014-01-27 Thread David Fetter
about what precisely foreign tables can and cannot inherit from local ones. I don't think that a generic 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

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 som

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, > >>> > >

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

2014-01-13 Thread David Fetter
the rest of our array implementation is a question for another thread. Cheers, David. -- David Fetter 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

Re: [HACKERS]

2014-01-12 Thread David Fetter
:) https://commitfest.postgresql.org/action/commitfest_view?id=21 Cheers, David. -- David Fetter 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] Disallow arrays with non-standard lower bounds

2014-01-10 Thread David Fetter
d I say that as a long-time Perl user (who has never seen this feature used in code worth not scrapping, by the way). Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://ww

Re: [HACKERS] new json funcs

2014-01-10 Thread David Fetter
t; pg_description comment against whether it has SGML documentation :-( FDWs to the rescue! Cheers, David. -- David Fetter 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] Disallow arrays with non-standard lower bounds

2014-01-09 Thread David Fetter
e have dropped support, as you put it, for bigger and harder-hitting 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 ;) -- Da

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

2014-01-08 Thread David Fetter
s: With utmost respect, 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Y

Re: [HACKERS] RFC: Async query processing

2014-01-05 Thread David Fetter
ck. Not even serial columns need feedback, since many ORMs > (SQLAlchemy, Hibernate) support allocation of ID sequences in batches > (by issuing a proper select nextval). This is already doable using data-modifying WITH clauses. Whether ORMs are (or should be made) smart enough to take

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

2014-01-04 Thread David Fetter
SQL extensions included in PostgreSQL distribution > (for example pg_stat_statements). It can be added using "create > extension imcs" and removed "drop extension imcs" commands. > > If there are some violations of PostgreSQL extensions rules, please > let me know,

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

2014-01-03 Thread David Fetter
ormatted 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 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 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 func

Re: [HACKERS] CREATE TABLESPACE SET

2013-12-26 Thread David Fetter
ly on the CREATE statement. > > CREATE 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype:

Re: [HACKERS] GiST support for inet datatypes

2013-12-22 Thread David Fetter
y > the network bits 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

Re: [HACKERS] array_length(anyarray)

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

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

2013-12-16 Thread David Fetter
ase. > > To see how this can torpedo performance, run the attached SQL file on > an empty database, and then run these quereis: +1 for fixing this bug :) Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

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

2013-12-15 Thread David Fetter
gt; I like both of these better than negative transition function and I agree > negative implies arithmetic rather than opposite. > Out of these 2 I do think inverse fits better than reverse, so I guess that > would make it "inverse aggregate transition function". > Would t

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 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 inelega

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

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

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 wrote: > > On Wed, Nov 27, 2013 at 10:29:34AM -0300, Alvaro Herrera wrote: > >> Shigeru Hanada escribió: > >> > >> > SQL/MED standard doesn't

Re: [HACKERS] Status of FDW pushdowns

2013-11-27 Thread David Fetter
k of offhand. What we can't do is assume that our parser needs to, or even could, in principle, understand these things in more detail than that. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet.

Re: [HACKERS] [PATCH] SQL assertions prototype

2013-11-25 Thread David Fetter
se does that sound to what > CREATE ASSERTION (as currently envisioned) would need? It sounds *extremely* close to what we'd need for row access in per-statement triggers, as in probably identical. The SQL syntax of this sub-feature is described in Foundation section 11.49 and called REFE

Re: [HACKERS] Status of FDW pushdowns

2013-11-22 Thread David Fetter
the standard is just ripe for un-patchable exploits *in its design*. Of all the misdesign-by-committee contained in the standard, this piece is far and away the stupidest I've encountered to date. We should not even vaguely attempt to implement it. Cheers, David. -- David Fet

Re: [HACKERS] Status of FDW pushdowns

2013-11-21 Thread David Fetter
st making a specification without a reference implementation. If I'm reading it correctly, 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 li

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2013-11-21 Thread David Fetter
or the new fields). I > think it might need to modify more places in code because of "comparing" > vars (maybe we'd need to include new fields while comparision). > Regards, > Karol Trzcionka Karol, Do you plan to continue this work for the current commitfest? A lot of people re

Re: [HACKERS] Changing pg_dump default file format

2013-11-07 Thread David Fetter
er than -Fc (custom), was the default for pg_backup, as it makes 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... Che

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

2013-10-30 Thread David Fetter
> a multiple of 2MB? How about documenting that 2MB is the quantum (OK, we'll 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 http://fetter.org

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

2013-10-30 Thread David Fetter
patch, that benefit is overwhelmed by the cost of having unstable releases. -infininty from me to any proposal that gets us into "are you using PostgreSQL x.y.z or x.y.w?" when it comes to features. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM:

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

2013-10-20 Thread David Fetter
to use and understand and is available on many > > platforms. > > I'd also take a look at ditaa, which might make this even simpler. If we manage to keep Java out of our build toolchain, we will be much the better for it. Cheers, David. -- David Fetter http://fetter.org/ Phone: +

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 > >t

[HACKERS] Commitfest II CLosed

2013-10-19 Thread David Fetter
t get 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. --

Re: [HACKERS] logical changeset generation v6.2

2013-10-15 Thread David Fetter
hack up to meet your needs. My version: Hacker: the output gets dumped 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 http://fetter.org/ Phone: +1 41

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 >

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

2013-10-10 Thread David Fetter
. > > (1) Define the issue as "not our problem". IOW, as of now, if you > want to use 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.

[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 http

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

2013-10-09 Thread David Fetter
or un-quoted empty strings we have a way to replace them with NULL. > > > >I think having 2 different syntax for replacing empty strings (one > >for quoted and another for un-quoted) as NULL's might not be best way > >to accomplish > >this feature. > > &

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

2013-10-09 Thread David Fetter
which assume an at least vaguely modern piece of hardware. By and large, people are not installing PostgreSQL for the very first time on a server the newest component of which is ten years old. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: df

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

2013-10-07 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [HACKERS] old warning in docs

2013-10-07 Thread David Fetter
t 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal:

Re: [HACKERS] Minmax indexes

2013-09-30 Thread David Fetter
uess, I'd 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfe

[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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iC

Re: [HACKERS] [PATCH] Revive line type

2013-09-16 Thread David Fetter
uld we start with whatever had been in the regression tests when the line type was dropped? Cheers, David. -- David Fetter 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] Hstore: Query speedups with Gin index

2013-09-15 Thread David Fetter
e taken into account here is Oleg and > >>> > > Teodor's in-progress work on extending hstore: > >>> > > https://www.pgcon.org/2013/schedule/events/518.en.html > >>> > > I'm not sure if this patch would conflict with that at all, but it > >>> > >

[HACKERS] Commitfest II, 9.4 edition

2013-09-15 Thread David Fetter
y or another. Let's make this one great! Cheers, David. -- David Fetter 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! Cons

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

2013-09-11 Thread David Fetter
speak v3. > > The possible thing to consider there is if there's a common pg fork > that uses v2 only, that would then no longer be compatible with the > standard libpq. I have no idea if such a thing exists, and I'm not > sure we even care if it does, given how

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

2013-09-10 Thread David Fetter
edious 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 http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfe

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