Re: [HACKERS] Additional options for Sync Replication

On Tue, Mar 29, 2011 at 2:48 PM, Josh Berkus j...@agliodbs.com wrote: Writing such long emails seems to be just filibustering to me. I doubt anyone has read and considered every word, there are just too many. A form of disrespect. Simon, Robert has been nothing but respectful to you.  You

Re: [HACKERS] Triggers on system catalog

On Wed, Mar 30, 2011 at 9:59 AM, David Fetter da...@fetter.org wrote: On Tue, Mar 29, 2011 at 08:21:04PM -0400, Robert Haas wrote: On Mar 29, 2011, at 2:17 PM, Christopher Browne cbbro...@gmail.com wrote: A proposal to adding triggers to system catalog tables won't be terribly popular

Re: [HACKERS] Should psql support URI syntax?

An advantage to this uri form is that it allows applications to be configured uniformly - I do not need to ask is this using libpq, needing one sort of configuration, or Java, needing another? Rather, I may say, here is a uri I may use with any of my applications

Re: [HACKERS] Should psql support URI syntax?

On Fri, Apr 1, 2011 at 12:43 PM, Joshua D. Drake j...@commandprompt.com wrote: On Fri, 2011-04-01 at 08:13 -0400, Andrew Dunstan wrote: That said, I do support adding this in the future, if only to keep up with the Jones'. So are the ones out there *already* even compatible, before we

Re: [DOCS] [HACKERS] Uppercase SGML entity declarations

On Mon, Apr 4, 2011 at 1:26 PM, Susanne Ebrecht susa...@2ndquadrant.com wrote: Anyway, I figured out there is another argument for XML: My information is that DocBook 5.0 won't support SGML anymore. Which means - sooner or later a reaction is needed. Yes, indeed. I don't think that during

Re: [HACKERS] Global variables in plpgsql

On Mon, Apr 11, 2011 at 7:33 AM, Nick Raj nickrajj...@gmail.com wrote: Can anyone know how to define global variable in plpgsql? I expect you should consult the manual page on the command CREATE TABLE. That's what would be the nearest SQL equivalent to a global variable.

Re: [HACKERS] Formatting Curmudgeons WAS: MMAP Buffers

On Sat, Apr 16, 2011 at 3:19 PM, Greg Smith g...@2ndquadrant.com wrote: Joshua Berkus wrote: Then you can say that politely and firmly with direct reference to the problem, rather than making the submitter feel bad. That's exactly what happened.  And then you responded that it was possible

Re: [HACKERS] Formatting Curmudgeons WAS: MMAP Buffers

On Mon, Apr 18, 2011 at 11:15 PM, Alex Hunsaker bada...@gmail.com wrote: On Mon, Apr 18, 2011 at 19:50, Josh Berkus j...@agliodbs.com wrote: You'll notice that this has been a complaint of veteran contributors as well; WIP patches either get no review, or get reviewed as if they were expected

Re: [HACKERS] pgbench \for or similar loop

On Tue, Apr 19, 2011 at 12:22 PM, Robert Haas robertmh...@gmail.com wrote: Yeah.  I was wondering if anyone was gung-ho enough about this to implement some kind of library that both programs could draw on. It probably wouldn't be super-hard, if we could agree on a rough design. It seems to me

Re: [HACKERS] Formatting Curmudgeons WAS: MMAP Buffers

On Thu, Apr 21, 2011 at 11:48 AM, Andres Freund and...@anarazel.de wrote: One could argue that its causing bad PR for postgres. I have seen several parties planning to migrate away or not migrate to postgres because of performance evaluations they made. With 7.4, 8.0 and 8.2. In 2010. Well

Re: [HACKERS] Formatting Curmudgeons WAS: MMAP Buffers

On Thu, Apr 21, 2011 at 11:05 AM, Robert Haas robertmh...@gmail.com wrote: I agree.  I am in favor of a shorter release cycle.  But I think that a shorter release cycle won't work well if there is still four month long integration period at the end of each series of CommitFests.  The problem

Re: [HACKERS] stored procedures

On Thu, Apr 21, 2011 at 3:51 PM, Merlin Moncure mmonc...@gmail.com wrote: On Thu, Apr 21, 2011 at 2:37 PM, Robert Haas robertmh...@gmail.com wrote: On Thu, Apr 21, 2011 at 2:13 PM, Tom Lane t...@sss.pgh.pa.us wrote: Kevin Grittner kevin.gritt...@wicourts.gov writes: Josh Berkus

Re: [HACKERS] Unlogged tables, persistent kind

On Sun, Apr 24, 2011 at 6:15 PM, Simon Riggs si...@2ndquadrant.com wrote: For large sets of low value data, it makes sense. Deleting all data, just simply because some of it might be damaged, is not the only option. IMHO deleting all the data is a surprising option that will cause many people

Re: [HACKERS] branching for 9.2devel

On Mon, Apr 25, 2011 at 11:03 AM, Greg Stark gsst...@mit.edu wrote: If the tools become easy to run is it possible we cold get to the point where we do an indent run on every commit? This wold require a stable list of system symbols plus the tool would need to add any new symbols added by the

Re: [HACKERS] Unlogged tables, persistent kind

On Mon, Apr 25, 2011 at 2:03 PM, Jesper Krogh jes...@krogh.cc wrote: On 2011-04-25 20:00, Leonardo Francalanci wrote: The amount of data loss on a big table will be 1% of the data loss caused by truncating the whole table. If that 1% is random (not time/transaction related), usually you'd

Re: [HACKERS] Proposal - asynchronous functions

On Tue, Apr 26, 2011 at 1:15 PM, Sim Zacks s...@compulab.co.il wrote: We have tried a similar approach, using plpythonu, by calling import pg and then creating a new connection to the database. This does give you an autonomous transaction, but not an asynchronous function. My use cases are

Re: [HACKERS] Changing the continuation-line prompt in psql?

On Fri, Apr 29, 2011 at 12:17 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from David E. Wheeler's message of vie abr 29 13:04:35 -0300 2011: On Apr 29, 2011, at 8:22 AM, Tom Lane wrote: AFAICT the initial prompt is always mysql , so they don't have to think hard about how

Re: [HACKERS] Unlogged tables, persistent kind

On Tue, May 3, 2011 at 4:54 PM, Tom Lane t...@sss.pgh.pa.us wrote: Simon Riggs si...@2ndquadrant.com writes: You're assuming that there are referential links *from* other tables to the table with damage. In which case you would be correct. But of course, if you needed that data for integrity

Re: [HACKERS] Compiling a PostgreSQL 7.3.2 project with Eclipse

2011/5/6 Krešimir Križanović kresimir.krizano...@fer.hr: I don't know what to do with this backend interface. I would like to get a postmaster running and to connect to a data base with psql. However, when i try to start psql, it says that there is no postmaster running. I would not assume

Re: [HACKERS] Why not install pgstattuple by default?

On Fri, May 6, 2011 at 1:32 PM, Magnus Hagander mag...@hagander.net wrote: On Fri, May 6, 2011 at 18:22, Euler Taveira de Oliveira eu...@timbira.com wrote: Em 06-05-2011 05:06, Magnus Hagander escreveu: On Fri, May 6, 2011 at 00:34, Josh Berkusjosh.ber...@pgexperts.com  wrote: Hackers,

Re: [HACKERS] Why not install pgstattuple by default?

On Fri, May 6, 2011 at 2:32 PM, Greg Smith g...@2ndquadrant.com wrote: Christopher Browne wrote: I'm getting paper cuts quite a bit these days over the differences between what different packaging systems decide to install.  The one *I* get notably bit on, of late, is that I have written code

Re: [HACKERS] Re: [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

On Fri, May 6, 2011 at 3:01 PM, Gilberto Castillo Martínez gilberto.casti...@etecsa.cu wrote: Josh, This would imply improvement in the terms of the U.S. embargo on Cuba. What would be real beneficial to all regional communities. I wouldn't get overly optimistic about that - the purpose of

Re: [HACKERS] Re: [pgsql-advocacy] New Canadian nonprofit for trademark, postgresql.org domain, etc.

I quite agree with Peter's comments. Keeping this corporation as simple to manage as possible is a considerably valuable feature. If we find we need an activity corporation, it won't be all that difficult to found that, and it's worth noting that *that* organization would need to have a

Re: [HACKERS] Why not install pgstattuple by default?

My example is of doing self-discovery to see if all needful database components seem to be properly installed. E.g. - the app needs pgcrypto, intarray, and a custom data type. The install script can consequently inform the production folk either looks good, or, alternately, seems problematic!

Re: [HACKERS] stored procedures - use cases?

On Mon, May 9, 2011 at 9:21 PM, Andrew Dunstan and...@dunslane.net wrote: On 05/09/2011 08:20 PM, Bruce Momjian wrote: Tom Lane wrote: Peter Eisentrautpete...@gmx.net  writes: On mån, 2011-04-25 at 14:35 -0500, Kevin Grittner wrote: (1)  All the \d commands in psql should be implemented

Re: [HACKERS] deprecating contrib for PGXN

On Wed, May 18, 2011 at 12:15 PM, David E. Wheeler da...@kineticode.com wrote: On May 18, 2011, at 10:30 AM, Dimitri Fontaine wrote: The other problem is that the facility we need to provide the most is binary distributions (think apt-get).  Lots of site won't ever compile stuff on their

Re: [HACKERS] Adding an example for replication configuration to pg_hba.conf

On Wed, May 18, 2011 at 12:17 PM, Selena Deckelmann sel...@chesnok.com wrote: At the risk of starting an epic bikeshedding thread, I've attached a small patch that includes an example for both ipv4 and ipv6 localhost configuration. My bikeshedding would be to ensure that the sample pg_hba.conf

Re: [HACKERS] LOCK DATABASE

On Wed, May 18, 2011 at 1:02 AM, Jaime Casanova ja...@2ndquadrant.com wrote: So we the lock will be released at end of the session or when the UNLOCK DATABASE command is invoked, right? A question: why will we beign so rude by killing other sessions instead of avoid new connections and wait

Re: [HACKERS] LOCK DATABASE

On Thu, May 19, 2011 at 12:57 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Excerpts from Robert Haas's message of jue may 19 10:18:20 -0400 2011: On Wed, May 18, 2011 at 7:11 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: 1.  I suggested that this looks a lot like the controls

Re: [HACKERS] dynamic background workers

BTW, one of the ideas that popped up in the unConference session on replication was why couldn't we use a background worker as a replication agent? The main reason pointed out was 'because that means you have to restart the postmaster to add a replication agent.' (e.g. - like a Slony slon

Re: backend hangs at immediate shutdown (Re: [HACKERS] Back-branch update releases coming in a couple weeks)

The case where I wanted routine shutdown immediate (and I'm not sure I ever actually got it) was when we were using IBM HA/CMP, where I wanted a terminate with a fair bit of prejudice. If we know we want to switch right away now, immediate seemed pretty much right. I was fine with interrupting

Re: [HACKERS] Hash partitioning.

On Tue, Jun 25, 2013 at 12:08 PM, Yuri Levinsky yu...@celltick.com wrote: Guys, I am sorry for taking your time. The reason for my question is: As former Oracle DBA and now simple beginner PostgreSQL DBA I would like to say: the current partitioning mechanism might be improved. Sorry, it

Re: [HACKERS] Kudos for Reviewers -- straw poll

On Thu, Jun 27, 2013 at 10:37 AM, Robert Haas robertmh...@gmail.com wrote: On Tue, Jun 25, 2013 at 2:27 PM, Andrew Dunstan and...@dunslane.net wrote: I'd like to see prizes each release for best contribution and best reviewer - I've thought for years something like this would be worth

Re: [HACKERS] Min value for port

On Thu, Jun 27, 2013 at 9:22 AM, Andres Freund and...@2ndquadrant.comwrote: On 2013-06-27 15:11:26 +0200, Magnus Hagander wrote: On Thu, Jun 27, 2013 at 2:16 PM, Peter Eisentraut pete...@gmx.net wrote: On 6/27/13 6:34 AM, Magnus Hagander wrote: Is there a reason why we have set the min

Re: [HACKERS] [9.4 CF 1] The Commitfest Slacker List

On Wed, Jul 3, 2013 at 2:24 PM, Cédric Villemain ced...@2ndquadrant.comwrote: Clearly I ticked off a bunch of people by publishing the list. On the other hand, in the 5 days succeeding the post, more than a dozen additional people signed up to review patches, and we got some of the ready

Re: [HACKERS] Listen/notify across clusters

Shouldn't be possible. The act of requesting to LISTEN requires doing a sort of update to the database. In elder versions, it put tuple(s) into pg_catalog.pg_listener, and that's Right Well Disallowed on a WAL-based replica. I would think that if you're keen on building an event detection

Re: [HACKERS] killing pg_dump leaves backend process

On Sat, Aug 10, 2013 at 12:30 AM, Tom Lane t...@sss.pgh.pa.us wrote: Tatsuo Ishii is...@postgresql.org writes: I noticed pg_dump does not exit gracefully when killed. start pg_dump kill pg_dump by ctrl-c ps x 27246 ?Ds96:02 postgres: t-ishii dbt3 [local] COPY 29920 ?S

Re: [HACKERS] Personal note: taking some vacation time in Sep/Oct

On Tue, Aug 20, 2013 at 2:55 AM, Gavin Flower gavinflo...@archidevsys.co.nz wrote: On 20/08/13 15:26, Tom Lane wrote: I will be taking a long (and long-overdue) vacation from Sep 10 to Oct 20. I expect to have email access, but won't be doing much more than minimally keeping up with my inbox.

Re: [HACKERS] pg_system_identifier()

On Fri, Aug 23, 2013 at 3:10 AM, Fabien COELHO coe...@cri.ensmp.fr wrote: After someone in IRC asked if there was an equivalent to MySQL's server_id, it was noted that we do have a system identifier but it's not very accessible. The attached patch implements a pg_system_identifier() function

[HACKERS] Extra functionality to createuser

Sitting on my todo list for a while has been to consider the idea of adding a bit of additional functionality to createuser. One of the functions of CREATE ROLE is to associate the role with other roles, thus... create role my_new_user nosuperuser nocreatedb login IN ROLE

Re: [HACKERS] Extra functionality to createuser

Attached is a patch implementing the -g / --roles option for createuser. I'll be attaching it to the open CommitFest shortly. createuser.diff Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Auto-tuning work_mem and maintenance_work_mem

On Thu, Oct 10, 2013 at 12:28 PM, Bruce Momjian br...@momjian.us wrote: How do we handle the Python dependency, or is this all to be done in some other language? I certainly am not ready to take on that job. I should think it possible to reimplement it in C. It was considerably useful to

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

I would be more inclined to let GraphViz into the process than Dia; the former fits *much* better into a Make-based process. It is worth observing that there are schema diagramming systems (SchemaSpy is mighty likable) that build diagrams using GraphViz. We have integrated this into internal

Re: [HACKERS] Location for external scripts for Extensions?

On Wed, Oct 23, 2013 at 12:24 PM, Josh Berkus j...@agliodbs.com wrote: Dimitri, Josh Berkus josh(at)agliodbs(dot)com writes: pg_partman has several external (python) scripts which help the extension, located in /extras/ in its source. The problem currently is that if you install pg_partman

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

On Thu, Oct 31, 2013 at 2:44 PM, Garick Hamlin gham...@isc.upenn.edu wrote: On Thu, Oct 31, 2013 at 01:59:04PM -0400, Robert Haas wrote: On Thu, Oct 31, 2013 at 1:02 PM, Garick Hamlin gham...@isc.upenn.edu wrote: On Thu, Oct 31, 2013 at 09:54:14PM +0900, MauMau wrote: From: Robert Haas

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

On Thu, Oct 31, 2013 at 3:42 PM, Robert Haas robertmh...@gmail.com wrote: On Thu, Oct 31, 2013 at 2:44 PM, Garick Hamlin gham...@isc.upenn.edu wrote: I think using /dev/urandom directly would be surprising. At least it would have probably have taken me a while to figure out what was depleting

Re: [HACKERS] Extra functionality to createuser

On Thu, Nov 14, 2013 at 5:41 AM, Sameer Thakur samthaku...@gmail.com wrote: So i think -g option is failing Right you are. I was missing a g: in the getopt_long() call. Attached is a revised patch that handles that. And it behaves better: postgres@cbbrowne ~/p/s/b/scripts ./createuser -g

Re: [HACKERS] Extra functionality to createuser

On Fri, Nov 15, 2013 at 3:14 PM, Peter Eisentraut pete...@gmx.net wrote: On 11/14/13, 4:35 PM, Christopher Browne wrote: On Thu, Nov 14, 2013 at 5:41 AM, Sameer Thakur samthaku...@gmail.com wrote: So i think -g option is failing Right you are. I was missing a g: in the getopt_long() call

Re: [HACKERS] Extra functionality to createuser

On Mon, Nov 18, 2013 at 1:01 AM, Amit Kapila amit.kapil...@gmail.com wrote: On Sat, Nov 16, 2013 at 4:57 AM, Christopher Browne cbbro...@gmail.com wrote: Few comments: 1. + termoption-g//term + termoption--roles//term All other options which require argument are of form

Re: [HACKERS] Extra functionality to createuser

On Tue, Nov 19, 2013 at 11:54 PM, Amit Kapila amit.kapil...@gmail.com wrote: On further tests, I found inconsistency in behavior when some special characters are used in role names. 1. Test for role name containing quotes a. In psql, create a role containing quotes in role name.

Re: [HACKERS] Extra functionality to createuser

Wait, that doesn't work if more than one role is added, as they get merged together by the quoting. A somewhat ugly amount of quoting can be done at the shell level to induce double quotes. $ createuser -g \test_rol'e_3\ usequoted3 I note that similar (with not quite identical behaviour) issues

Re: [HACKERS] Add CREATE support to event triggers

On Fri, Nov 8, 2013 at 10:33 AM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: Hello, Attached you can find a very-much-WIP patch to add CREATE info support for event triggers (normalized commands). This patch builds mainly on two things: 1. Dimitri's DDL rewrite patch he submitted way

Re: [HACKERS] Extra functionality to createuser

On Wed, Dec 11, 2013 at 7:53 AM, Robert Haas robertmh...@gmail.com wrote: On Tue, Dec 10, 2013 at 9:55 AM, Amit Kapila amit.kapil...@gmail.com wrote: On Tue, Dec 10, 2013 at 12:20 AM, Robert Haas robertmh...@gmail.com wrote: On Sat, Dec 7, 2013 at 11:39 PM, Amit Kapila amit.kapil...@gmail.com

Re: [HACKERS] Storing the password in .pgpass file in an encrypted format

On Fri, Feb 21, 2014 at 7:49 AM, firoz e v firoz...@huawei.com wrote: Hi, Is there a way to store the password in .pgpass file in an encrypted format (for example, to be used by pg_dump). Even though, there are ways to set the permissions on .pgpass, to disallow any access to world or

Re: [HACKERS] Patch: iff - if

On Tue, Apr 15, 2014 at 6:19 PM, Andreas 'ads' Scherbaum adsm...@wars-nicht.de wrote: Hi, stumbled over a number of iff in the source where if is meant - not sure what the real story behind this is, but attached is a patch to fix the about 80 occurrences. IFF is a common idiom in

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

Last year, I built a pl/pgsql generator of version 1-ish UUIDs, which would combine timestamps with local information to construct data that kind of emulated the timestamp+MAC address that is version #1 of UUID. Note that there are several versions of UUIDs: 1. Combines MAC address, timestamp,

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

On Thu, Apr 24, 2014 at 8:43 PM, Marti Raudsepp ma...@juffo.org wrote: On Fri, Apr 25, 2014 at 3:36 AM, Tom Lane t...@sss.pgh.pa.us wrote: Of course, the weak spot in this analysis is the assumption that there are actually 122 independent bits in the value. It's not difficult to imagine

Re: [HACKERS] PL/pgSQL 2

On Tue, Sep 2, 2014 at 7:08 PM, Jan Wieck j...@wi3ck.info wrote: On 09/02/2014 06:56 PM, Andrew Dunstan wrote: People are free to do what they want, but to my mind that would be a massive waste of resources, and probably imposing a substantial extra maintenance burden on the core committers.

Re: [HACKERS] Add CREATE support to event triggers

On 8 November 2014 17:49, Robert Haas robertmh...@gmail.com wrote: We could just integrate those parts, and be done with it. But would that actually be a good thing for the community? Then slony needs to do it and potentially others as well? Then auditing can't use it? Then potential

Re: [HACKERS] Fix token exceeding NAMELEN

On 13 May 2015 at 17:55, Tom Lane t...@sss.pgh.pa.us wrote: Aaron W. Swenson titanof...@gentoo.org writes: Trying to build HEAD and ran into this issue building the docs: openjade:logicaldecoding.sgml:575:62:Q: length of name token must not exceed NAMELEN (44)

Re: [HACKERS] Patch: Implement failover on libpq connect level.

On 26 October 2015 at 16:25, Peter Eisentraut wrote: > On 10/14/15 6:41 AM, Victor Wagner wrote: > > 1. It is allowed to specify several hosts in the connect string, either > > in URL-style (separated by comma) or in param=value form (several host > > parameters). > > I'm not

Re: [HACKERS] quieting DEBUG3

On 27 October 2015 at 20:51, Tom Lane wrote: > > Craig Ringer writes: > > I think it'd be helpful to define some level of policy about what the > > debug levels are intended for, so there's some guidance on what level > > to emit messages on rather than

Re: [HACKERS] Patch: Implement failover on libpq connect level.

On 30 October 2015 at 09:26, Robert Haas wrote: > > On Thu, Oct 29, 2015 at 8:29 PM, Peter Eisentraut wrote: > > On 10/28/15 4:18 AM, Victor Wagner wrote: > >> On Mon, 26 Oct 2015 16:25:57 -0400 > >> Peter Eisentraut wrote: > >> > >>>

Re: [HACKERS] Can extension build own SGML document?

On 14 October 2015 at 13:04, Jim Nasby wrote: > On 9/15/15 10:13 AM, Tom Lane wrote: > >> Jim Nasby writes: >> >>> On 9/15/15 8:43 AM, Tom Lane wrote: >>> AFAICT from a quick look at its documentation, asciidoc can produce either

Re: [HACKERS] Database schema diff

On 13 October 2015 at 11:48, Michal Novotny wrote: > Hi guys, > > I would like to ask you whether is there any tool to be able to compare > database schemas ideally no matter what the column order is or to dump > database table with ascending order of all database

Re: [HACKERS] Proposal: Implement failover on libpq connect level.

On 3 September 2015 at 12:57, Shulgin, Oleksandr < oleksandr.shul...@zalando.de> wrote > > On Thu, Sep 3, 2015 at 6:02 PM, Robert Haas wrote: >> >> >> Maybe someday we should have all that, but I think for right now >> that's complicating things unnecessarily. I think the

Re: [HACKERS] No Issue Tracker - Say it Ain't So!

On 30 September 2015 at 14:31, Joshua D. Drake <j...@commandprompt.com> wrote: > > On 09/30/2015 11:23 AM, Christopher Browne wrote: > >> It's well and nice to think that an issue tracker resolves all of this, >> and, if we >> had tiny numbers of issues, we could

Re: [HACKERS] No Issue Tracker - Say it Ain't So!

On 30 September 2015 at 12:26, Joshua D. Drake wrote: > > On 09/30/2015 07:44 AM, Merlin Moncure wrote: > >> I'm not trolling in any way. I'm just challenging you to back up your >> blanket assertions with evidence. For example, you're assertion that >> mailing lists are

Re: [HACKERS] [COMMITTERS] pgsql: Use gender-neutral language in documentation

On 22 September 2015 at 15:11, Robert Haas wrote: > > On Tue, Sep 22, 2015 at 2:33 PM, Andrew Dunstan wrote: > > Good point. In the 18th and 19th centuries it was deemed by some grammarians > > to be incorrect for some reason, (and yet Thackeray still

Re: [HACKERS] WIP: About CMake v2

It's broadly interesting, but since it bakes in a build dependency on CMake, there is some risk that the dependencies become an insurmountable problem. (Does CMake run on a VAX 11/780?? :-)) It is probably worth a try, to see what improvements arise, albeit with the need to accept some risk of

Re: [HACKERS] psql - -dry-run option

On 17 December 2015 at 14:16, Pavel Stehule wrote: > or different idea - just enforce syntax check without execution. That seems pretty cool... I'd find "syntax check without execution" to be pretty useful to test SQL (and especially DDL). -- When confronted by a

Re: [HACKERS] Template for commit messages

On 30 January 2016 at 05:11, Robert Haas wrote: > > Well, this gets at one of the problems here, which is that you can't > fix a commit message once the commit has been pushed. So even if we > all agreed in principle to a standard format, it's not clear that you > could

Re: [HACKERS] Academic help for Postgres

On 11 May 2016 at 12:58, Josh berkus wrote: > Together with that, automated substitution of materialized views for > query clauses. > > Also: optimizing for new hardware, like persistent memory. I recently saw some material in ACM SIGOPS on tuning filesystems to play better

Re: [HACKERS] A Modest Upgrade Proposal

On 13 July 2016 at 15:06, Robert Haas wrote: > On Thu, Jul 7, 2016 at 9:25 PM, Simon Riggs wrote: > > I note also that replication slots aren't backed up by pg_dump; I see > > analogy here and think that at least some parts of logical replication >

Re: [HACKERS] [GENERAL] C++ port of Postgres

On 16 August 2016 at 17:08, Piotr Stefaniak wrote: > On 2016-08-16 18:33, Robert Haas wrote: >> It wouldn't be that much work to maintain, either: we'd >> just set up some buildfarm members that compiled using C++ and when >> they turned red, we'd go fix it. > > I

Re: [HACKERS] SAP Application deployment on PostgreSQL

On 8 September 2017 at 15:34, chiru r wrote: > We have multiple SAP applications running on Oracle as backend and looking > for an opportunity to migrate from Oracle to PostgreSQL. Has anyone ever > deployed SAP on PostgreSQL community edition? > > Is PostgreSQL community

Re: [HACKERS] Built-in plugin for logical decoding output

On Sep 25, 2017 1:39 PM, "Joshua D. Drake" wrote: > On 09/25/2017 10:32 AM, Petr Jelinek wrote: > >> On 25/09/17 19:26, Tom Lane wrote: >> >>> Alvaro Hernandez writes: >>> >> > >> There is already about 3 million output plugins out there so I think we >>

<    1   2   3   4   5