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
>>
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
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
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
>
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
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
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
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:
> >>
> >>>
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
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
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
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
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
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
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
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
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
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)
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
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.
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,
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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:
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
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
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.
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
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
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
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
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
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
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
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
On Mon, May 27, 2013 at 1:42 AM, Gurjeet Singh gurj...@singh.im wrote:
Joking about 640K aside, it doesn't seem reasonable to expect a truly
enormous query as is generated by the broken forms of this logic to turn
out happily. I'd rather fix Slony (as done in the above patch).
Yes, by
This situation falls from a problem that we noticed a mighty long time ago
in Slony, where the set of XIDs outstanding gets very large, and, attendant
to that, the set of action id values by which tuples are being filtered,
gets correspondingly large.
It happens when there is a long pause in
The assumption that we ought to plan expressly for an incompatibility that
essentially discards pg_upgrade seems premature, particularly in advance of
would-be solutions that, in some cases, mightn't actually work.
If pg_upgrade doesn't work, then, at present, the plausible solutions are
to
There hasn't been general agreement on the merits of particular .gitignore
rules of this sort.
You could hide your own favorite patterns by putting this into your
~/.gitignore that isn't part of the repo, configuring this globally, thus:
git config --global core.excludesfile '~/.gitignore'
That
On Fri, May 10, 2013 at 9:50 AM, Peter Eisentraut pete...@gmx.net wrote:
On 8/9/12 9:08 AM, Robert Haas wrote:
On Wed, Aug 8, 2012 at 6:50 PM, David Fetter da...@fetter.org wrote:
I'm wondering if perhaps -- in addition to what you've done here -- we
should make psql -1 error out if
On Mon, Apr 29, 2013 at 10:50 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Apr 29, 2013 at 9:25 AM, Atri Sharma atri.j...@gmail.com wrote:
This is an interesting idea. Historically I've always decomposed
graphs into relational structures because that's the only practical
way to
I would expect the strategy you have in mind to be more useful to apply at
the filesystem level, so that it's not in Postgres altogether. (Ala
Stacker, remember DR-DOS?)
But, to speak arguable heresy, the demerits of this sort of thing are
described nicely in Another Database's Documentation:
On Thu, Feb 28, 2013 at 3:20 PM, Tom Lane t...@sss.pgh.pa.us wrote:
I think it's fairly obvious that
(1) dealing with a DROP only after it's happened is pretty limiting;
(2) allowing user-defined code to run mid-command is dangerous.
What's at issue is the tradeoff we make between these
On Wed, Feb 6, 2013 at 12:05 PM, Robert Haas robertmh...@gmail.com wrote:
On Wed, Feb 6, 2013 at 9:44 AM, Dimitri Fontaine dimi...@2ndquadrant.fr
wrote:
Robert Haas robertmh...@gmail.com writes:
I disagree with that. I don't see why the enclosing event trigger
shouldn't be aware of all the
On Sat, Feb 2, 2013 at 2:54 PM, Robert Haas robertmh...@gmail.com wrote:
On Sat, Feb 2, 2013 at 1:49 PM, Andres Freund and...@2ndquadrant.com wrote:
You're right, this doesn't work superbly well, especially for
insert-only tables... But imo the place to fix it is not the
priorization logic but
On Fri, Feb 1, 2013 at 4:59 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Jan 31, 2013 at 3:18 PM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
My intention was to apply a Nasby correction to Browne Strength and call
the resulting function Browne' (Browne prime). Does that sound
On Thu, Jan 31, 2013 at 5:06 AM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Tom Lane t...@sss.pgh.pa.us writes:
Also, it's far from obvious to me that largest first is the best rule
anyhow; it's likely to be more complicated than that.
But anyway, the right place to add this sort of
(apparently named for Christopher Browne) and
yet you haven't even bothered to add a comment explaining the meaning
of the term, let along justifying the choice of that formula rather
than any other. I don't want to dog this proposal to death, because
surely we can do better than the status quo here
On Wed, Jan 30, 2013 at 4:05 PM, Jim Nasby j...@nasby.net wrote:
On 1/25/13 11:56 AM, Christopher Browne wrote:
With a little bit of noodling around, here's a thought for a joint
function
that I*think* has reasonably common scales:
f(deadtuples, relpages, age) =
deadtuples/relpages
On Mon, Jan 28, 2013 at 6:19 PM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Christopher Browne cbbro...@gmail.com writes:
I'm poking at event triggers a bit; would like to set up some examples
(and see if they
work, or break down badly; both are interesting results) to do some
validation
I'm poking at event triggers a bit; would like to set up some examples
(and see if they
work, or break down badly; both are interesting results) to do some
validation of schema
for Slony.
What I'm basically thinking about is to set up some event triggers that run on
DROP TABLE / DROP SEQUENCE,
On Fri, Jan 25, 2013 at 11:58 AM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Robert Haas robertmh...@gmail.com writes:
OK, but can we lay the issue of a *normalized* command string to the
side for just one minute, and talk about exposing the *raw* command
string? It seems to me that this
On Thu, Jan 24, 2013 at 5:22 PM, Heikki Linnakangas
hlinnakan...@vmware.com wrote:
Backpatching sounds a bit scary. It's not a clear-cut bug, it's just that
autovacuum could be smarter about its priorities. There are other ways you
can still bump into the xid-wraparound issue, even with this
On Wed, Jan 16, 2013 at 5:15 PM, Robert Haas robertmh...@gmail.com wrote:
On Tue, Jan 15, 2013 at 3:37 PM, Christopher Browne cbbro...@gmail.com
wrote:
That points towards a fix that involves having a set of non-arbitrary
commands
that we allow plain users to use.
Hmm. There's
On Tue, Jan 15, 2013 at 2:53 PM, Stephen Frost sfr...@snowman.net wrote:
The popen patch doesn't support the '|compression-binary' option through
the FE protocol. Even if it did, it would only be available for
superusers as we can't allow regular users to run arbitrary commands on
the
On Thu, Jan 3, 2013 at 12:27 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Jan 3, 2013 at 11:15 AM, Hannu Krosing ha...@2ndquadrant.com wrote:
This is what I did with my sample pl/python function ;)
Yeah, except that the c in ctime does not stand for create, and
therefore the function
On Fri, Dec 21, 2012 at 10:39 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Marko Tiikkaja pgm...@joh.to writes:
Courtesy of me, Christmas comes a bit early this year. I wrote a patch
which allows you to add STRICT into PERFORM and INSERT/UPDATE/DELETE
without specifying an INTO clause.
What
On Fri, Dec 21, 2012 at 11:25 AM, Charles Gomes charle...@outlook.com
wrote:
Hello guys,
I've been finding performance issues when using a trigger to modify
inserts on a partitioned table.
If using the trigger the total time goes from 1 Hour to 4 hours.
The trigger is pretty simple:
On Thu, Nov 15, 2012 at 2:53 PM, Darren Duncan dar...@darrenduncan.net
wrote:
I still think the syntax of TRUNCATE FOR EACH ROW would be useful, but if
no one agrees...
I'm compelled to disagree.
What was useful about TRUNCATE in the first place was that it quickly
operated against the entire
Preface: I think there's some great commentary here, and find myself
agreeing
pretty whole-heartedly.
On Tue, Nov 13, 2012 at 2:45 PM, Simon Riggs si...@2ndquadrant.com wrote:
On 13 November 2012 17:38, Tom Lane t...@sss.pgh.pa.us wrote:
Simon Riggs si...@2ndquadrant.com writes:
The most
On Mon, Nov 5, 2012 at 12:19 PM, Robert Haas robertmh...@gmail.com wrote:
On Mon, Oct 29, 2012 at 4:31 PM, Jim Nasby j...@nasby.net wrote:
For whatever it's worth... we (and presumably others) still use londiste
(or
Slony) as our upgrade path, so we could tolerate a cluster-wide setting.
It seems not unusual for Linux distributions to supply libpq as part of a
separate package (whether via dpkg, which I think uses ar as the
archiver, or RPM, which uses cpio).
Possibly this is already provided on your system via some means akin to
those.
If, instead, you are keen on getting the
On Tue, Oct 30, 2012 at 5:25 PM, Josh Berkus j...@agliodbs.com wrote:
On 10/29/12 6:40 AM, Chris Corbyn wrote:
What's the use case of this? It sounds like it will just create a
maintenance nightmare where some stuff you expect to lookup in in
postgresql.conf is actually hiding in the .auto
On Tue, Oct 23, 2012 at 6:12 PM, Peter Eisentraut pete...@gmx.net wrote:
On 10/22/12 11:47 AM, Phil Sorber wrote:
Also, it seems that about 75% of the patch is connection options processing.
How about
we get rid of all that and just have them specify a connection string? It
would be a
I agree that it seems inappropriate to preserve order. That seems an
inappropriate imposition, inconsistent with what SQL does elsewhere.
If there is a natural sequence (e.g. - a value assigned by nextval()), that
offers a natural place to apply the usual order-imposing ORDER BY that we
are
On Thu, Oct 18, 2012 at 9:49 AM, Peter Geoghegan pe...@2ndquadrant.com wrote:
On 16 October 2012 15:26, Jan Wieck janwi...@yahoo.com wrote:
This means that the transition time from the existing, trigger based
approach to the new WAL based mechanism will see both technologies in
parallel, which
On Thu, Oct 18, 2012 at 2:56 PM, Hannu Krosing ha...@2ndquadrant.com wrote:
* works as table on INSERTS up to inserting logical WAL record describing
the
insert but no data is inserted locally.
with all things that follow from the local table having no data
- unique constraints don't make
Well, replication is arguably a relevant case.
For Slony, the origin/master node never cares about logged changes - that
data is only processed on replicas. Now, that's certainly a little
weaselly - the log data (sl_log_*) has got to get read to get to the
replica.
This suggests, nonetheless, a
On Wed, Oct 17, 2012 at 4:25 PM, Josh Berkus j...@agliodbs.com wrote:
It is not meant to be a full implementation of application level queuing
system though but just the capture, persisting and distribution parts
Using this as an application level queue needs a set of interface
functions to
On Wed, Oct 17, 2012 at 5:45 PM, Daniel Farina dan...@heroku.com wrote:
retort -- which is true, Heroku's user base is not provably
representative of all users. But what else is there to go on, besides
experiences of others, such as yours and Andrew's, or others?
Well, Heroku doesn't support
On Mon, Oct 15, 2012 at 11:57 AM, Robert Haas robertmh...@gmail.com wrote:
On Mon, Oct 15, 2012 at 10:34 AM, Greg Stark st...@mit.edu wrote:
I'm a bit lost. I would think pl/pgsql is precisely the same as
Oracle's pl/sql and MS's T-SQL. I see the complaint you have as a
purely implementation
On Sat, Oct 13, 2012 at 3:49 PM, Joshua Berkus j...@agliodbs.com wrote:
So, problem #1 is coming up with a mathematical formula. My initial target
values are in terms of # of rows in the table vs. # of writes before analyze
is triggered:
1 : 3
10 : 5
100 : 10
1000 : 100
10 : 2000
On Mon, Oct 15, 2012 at 3:14 PM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Robert Haas robertmh...@gmail.com writes:
if (select 1 from pg_class where relname = 'foo' and
pg_table_is_visible(oid)) then
truncate table foo;
end if;
Yeah, I think the
On Mon, Oct 15, 2012 at 3:18 PM, Peter Geoghegan pe...@2ndquadrant.com wrote:
On 15 October 2012 19:19, Bruce Momjian br...@momjian.us wrote:
I think Robert is right that if Slony can't use the API, it is unlikely
any other replication system could use it.
I don't accept that. Clearly there
On Mon, Oct 15, 2012 at 4:51 PM, Andres Freund and...@2ndquadrant.com wrote:
On Monday, October 15, 2012 10:08:28 PM Christopher Browne wrote:
On Mon, Oct 15, 2012 at 3:18 PM, Peter Geoghegan pe...@2ndquadrant.com
wrote:
On 15 October 2012 19:19, Bruce Momjian br...@momjian.us wrote:
I
On Mon, Oct 15, 2012 at 5:33 PM, Simon Riggs si...@2ndquadrant.com wrote:
Sequences, as defined by SQL Standard, provide a series of unique
values. The current implementation on PostgreSQL isolates the
generation mechanism to only a single node, as is common on many
RDBMS.
I remember
On Fri, Oct 12, 2012 at 3:04 PM, Robert Haas robertmh...@gmail.com wrote:
On Thu, Oct 11, 2012 at 3:22 PM, Simon Riggs si...@2ndquadrant.com wrote:
So we just need a function called pg_if_table_exists(table, SQL) which
wraps a test in a subtransaction.
And you write
SELECT
On Fri, Oct 12, 2012 at 5:52 PM, Dimitri Fontaine
dimi...@2ndquadrant.fr wrote:
Christopher Browne cbbro...@gmail.com writes:
I suggest the though of embracing statement modifiers in DDL, with
some options possible:
a) { DDL STATEMENT } IF CONDITION;
b) { DDL STATEMENT } UNLESS CONDITION
On Thu, Oct 11, 2012 at 6:25 PM, Simon Riggs si...@2ndquadrant.com wrote:
Anyway, lets start with a discussion of what rules give us that SQL
standard features do not?
The somewhat broader question that this elicits is How would we go
about deprecating a feature that seems to be troublesome? I
On Wed, Oct 10, 2012 at 10:26 PM, Bruce Momjian br...@momjian.us wrote:
How does Slony write its changes without causing serialization replay
conflicts?
It uses a sequence to break any ordering conflicts at the time that
data is inserted into its log tables.
If there are two transactions, A
On Wed, Oct 10, 2012 at 3:32 AM, Simon Riggs si...@2ndquadrant.com wrote:
On 10 October 2012 02:10, Robert Haas robertmh...@gmail.com wrote:
On Tue, Oct 9, 2012 at 4:18 PM, Josh Berkus j...@agliodbs.com wrote:
The second is for making deployment scripts idempotent. For example,
say you have
On Mon, Oct 8, 2012 at 11:54 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Heikki Linnakangas hlinnakan...@vmware.com writes:
On 08.10.2012 18:26, Tom Lane wrote:
The other thing that the abbreviation list files are doing for us is
providing a user-configurable way to resolve conflicting
On Wed, Sep 26, 2012 at 10:02 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Daniel Farina dan...@heroku.com writes:
On Tue, Sep 25, 2012 at 10:55 PM, Jaime Casanova ja...@2ndquadrant.com
wrote:
The definition of information_schema.triggers contains this:
-- TRIGGER_TYPE_UPDATE; we intentionally
On Mon, Sep 24, 2012 at 10:17 AM, Alvaro Herrera
alvhe...@2ndquadrant.com wrote:
Excerpts from Daniele Varrazzo's message of dom sep 23 22:02:51 -0300 2012:
On Mon, Sep 24, 2012 at 12:23 AM, Michael Paquier
michael.paqu...@gmail.com wrote:
As proposed by Masahiko, a single organization
We historically have connection pooling as an external thing; with the high
degree to which people keep implementing and reimplementing this, I think
*something* more than we have ought to be built in.
This, with perhaps better implementation, might be an apropos start.
Parallel with LDAP: it
On Sat, Sep 22, 2012 at 7:45 PM, Peter Eisentraut pete...@gmx.net wrote:
On Sat, 2012-09-22 at 16:25 +0900, Satoshi Nagayasu wrote:
I think it's time to consider some *umbrella project* for maintaining
several small projects outside the core.
Well, that was pgfoundry, and it didn't work out.
If the present project is having a tough time doing enhancements, I should
think it mighty questionable to try to draw it into core, that presses it
towards a group of already very busy developers.
On the other hand, if the present development efforts can be made more
public, by having them take
1 - 100 of 477 matches
Mail list logo