On 12/18/2013 01:03 AM, Robert Haas wrote:
> On Mon, Dec 16, 2013 at 3:12 PM, Gregory Smith
> wrote:
>> > On 12/16/13 9:36 AM, Craig Ringer wrote:
>>> >>
>>> >> - Finish and commit updatable security barrier views. I've still got a
>>> >> lot of straightening out to do there.
>> >
>> > I don't fo
On Wed, Dec 11, 2013 at 11:13 PM, Sergey Muraviov
wrote:
> Hi.
>
> I've improved the patch.
> It works in expanded mode when either format option is set to wrapped (\pset
> format wrapped), or we have no pager, or pager doesn't chop long lines (so
> you can still use the trick).
> Target output wi
On Wed, Dec 18, 2013 at 11:22 AM, Amit Kapila wrote:
> On Fri, Dec 13, 2013 at 7:57 PM, Heikki Linnakangas
> wrote:
>> Thanks, committed with some minor changes:
>
> Should this patch in CF app be moved to Committed Patches or is there
> something left for this patch?
Nothing has been forgotten f
On Tue, Dec 17, 2013 at 5:33 PM, MauMau wrote:
> From: "Amit Kapila"
>
>> Few minor things:
>
> event_source here is a global static char array, so it's automatically
> initialized with zeros and safe to access.
Right, I had missed that point.
>
>
>> 2. minor coding style issue
>
>
> Thanks.
On Fri, Dec 13, 2013 at 7:57 PM, Heikki Linnakangas
wrote:
> On 12/13/2013 07:55 AM, Sawada Masahiko wrote:
>>
>> On Fri, Dec 13, 2013 at 1:51 PM, Dilip kumar
>> wrote:
>>>
>>> On 04 December 2013, Sawada Masahiko Wrote
>>>
>> I have modified the patch base on your comment, and I attached the v7
(2013/12/17 21:29), Simon Riggs wrote:
These are interesting results. Good research.
Thanks!
They also show that the benefit of this is very specific to the exact
task being performed. I can't see any future for a setting that
applies to everything or nothing. We must be more selective.
This
(2013/12/18 5:33), Robert Haas wrote:
Sounds like it might be worth dusting the patch off again...
I'd like to request you to add all_index option and usage_count option.
When all_index option is selected, all index become rewarm nevertheless user
doesn't input relation name. And usage_count op
(now with patch--sorry about that)
diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml
index eb71581..5f03343 100644
--- a/doc/src/sgml/ref/vacuum.sgml
+++ b/doc/src/sgml/ref/vacuum.sgml
@@ -100,8 +100,9 @@ VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [
Select
VACUUM FREEZE sets both vacuum_freeze_min_age and vacuum_freeze_table_age
to 0, but only the former is documented. This patch notes that the other
setting is also affected.
On 12/17/2013 01:42 PM, Kevin Grittner wrote:
> Josh Berkus wrote:
>> Going back over this patch, I haven't seen any further discussion of the
>> point Heikki raises above, which seems like a bit of a showstopper.
>>
>> Heikki, did you have specific ideas on how to solve this? Right now my
>> min
On 17 December 2013 23:42, Tom Lane wrote:
>> We aim to have the simplest implementation that meets the stated need
>> and reasonable extrapolations of that. Text in a catalog table is the
>> simplest implementation. That is not a reason to reject it, especially
>> when we aren't suggesting a via
On 12/17/13, 10:19 AM, Tom Lane wrote:
> Perhaps we should just move all the Needs Review and RFC patches forward
> to the next fest, so we don't forget about them?
This was done the last few times, but it has caused some controversy.
One problem was that a number of patches arrived in this commit
Simon Riggs writes:
> On 17 December 2013 18:32, Stephen Frost wrote:
>> I have no idea where you're going with this, but I *do* object to
>> sticking an SQL script which defines a bunch of objects into a catalog
>> table *right next to where they are properly defined*. There's just no
>> sense
On 17 December 2013 18:32, Stephen Frost wrote:
> * Simon Riggs (si...@2ndquadrant.com) wrote:
>> I keep seeing people repeat "I don't like blobs" as if that were an
>> objection. There is no danger or damage from doing this. I can't see
>> any higher beauty that we're striving for by holding out.
On 17 December 2013 17:54, Tom Lane wrote:
>> So now, you don't need anymore to have file system write privileges into
>> a central place owned by root, it can be anywhere else,
>
> Modern OSes have security checks that can prevent loading libraries from
> random places. This is widely seen as n
On 18/12/13 10:48, Andrew Dunstan wrote:
On 12/17/2013 04:42 PM, Kevin Grittner wrote:
Josh Berkus wrote:
On 11/15/2013 05:41 AM, Heikki Linnakangas wrote:
A fundamental problem with this is that it needs to handle isolation
reliable, so that the assertion cannot be violated when two concurr
On 12/17/2013 04:42 PM, Kevin Grittner wrote:
Josh Berkus wrote:
On 11/15/2013 05:41 AM, Heikki Linnakangas wrote:
A fundamental problem with this is that it needs to handle isolation
reliable, so that the assertion cannot be violated when two concurrent
backends do things. Consider the examp
Josh Berkus wrote:
> On 11/15/2013 05:41 AM, Heikki Linnakangas wrote:
>> A fundamental problem with this is that it needs to handle isolation
>> reliable, so that the assertion cannot be violated when two concurrent
>> backends do things. Consider the example from the manual, which checks
>> that
On Fri, Dec 13, 2013 at 10:41:17PM +0900, MauMau wrote:
> [Cause]
> While the session is being established, the server cannot use the
> client encoding for message conversion yet, because it cannot access
> system catalogs to retrieve conversion functions. So, the server
> sends messages to the cl
Alvaro Herrera wrote:
> Well, it would help if those cases weren't dead code. Neither
> heap_update nor heap_delete are ever called in the "no wait" case at
> all. Only heap_lock_tuple is, and I can't see any misbehavior there
> either, even with HeapTupleBeingUpdated returned when there's a
> n
On 11/15/2013 05:41 AM, Heikki Linnakangas wrote:
> A fundamental problem with this is that it needs to handle isolation
> reliable, so that the assertion cannot be violated when two concurrent
> backends do things. Consider the example from the manual, which checks
> that a table has at least one
Simon Riggs writes:
> What surprises me is we don't have an API that allows an FDW to decide
> what it can accept or not. It seems strange to have a unilateral
> decision by our planner about what another planner is capable of.
Uh, what?
There's certainly missing features in our FDW APIs --- no
Robert Haas writes:
> On Tue, Dec 17, 2013 at 12:28 PM, Tom Lane wrote:
>> (I wonder if it'd be worth inserting a check that
>> there's not already a manually-generated equivalent clause, too ...)
> Sounds a little too clever IMHO.
The argument for doing it is that we might otherwise find ourse
On 17 December 2013 17:28, Tom Lane wrote:
> So at this point I'm pretty much talked into it. We could eliminate the
> dependence on indexes entirely, and replace this code with a step that
> simply tries to pull single-base-relation quals out of ORs wherever it can
> find one. You could argue
On Sun, Dec 15, 2013 at 05:10:38PM -0500, James Cloos wrote:
> > "MK" == Marko Kreen writes:
> > "PE" == Peter Eisentraut writes:
> PE> Any other opinions on this out there?
>
> For reference, see:
>
> https://wiki.mozilla.org/Security/Server_Side_TLS
>
> for the currently suggested
Hi,
Attached patch adds GiST support to the inet datatypes with two new
operators. Overlaps operator can be used with exclusion constraints.
Is adjacent to operator is just the negator of it. Index uses only
the network bits of the addresses. Except for the new operators and
is contained within, c
From: "Robert Haas"
On Tue, Dec 17, 2013 at 12:09 AM, Amit Kapila
wrote:
I have used pg_prewarm during some of work related to Buffer Management
and
other performance related work. It is quite useful utility.
+1 for reviving this patch for 9.4
Any other votes?
+1
Some customers requested:
On 12/17/2013 06:34 AM, Robert Haas wrote:
> On Tue, Dec 17, 2013 at 12:09 AM, Amit Kapila wrote:
>> I have used pg_prewarm during some of work related to Buffer Management and
>> other performance related work. It is quite useful utility.
>> +1 for reviving this patch for 9.4
>
> Any other votes
On 18/12/13 05:26, Bruce Momjian wrote:
On Tue, Dec 17, 2013 at 09:51:30AM -0500, Robert Haas wrote:
On Sun, Dec 15, 2013 at 5:10 PM, James Cloos wrote:
For reference, see:
https://wiki.mozilla.org/Security/Server_Side_TLS
for the currently suggested suite for TLS servers.
...
But for p
On Tue, Dec 17, 2013 at 11:26:13AM -0500, Bruce Momjian wrote:
> On Tue, Dec 17, 2013 at 09:51:30AM -0500, Robert Haas wrote:
> > I'm starting to think we should just leave this well enough alone. We
> > can't seem to find two people with the same idea of what would be
> > better than what we have
On Tue, Dec 17, 2013 at 3:31 PM, MauMau wrote:
>> Any other votes?
>
> +1
> Some customers requested:
>
> 1. fill the database cache with frequently accessed data before starting or
> resuming service for their users (for the first time or after maintenance
> work), so that they can provide steady
On 12/17/2013 08:26 AM, Bruce Momjian wrote:
On Tue, Dec 17, 2013 at 09:51:30AM -0500, Robert Haas wrote:
On Sun, Dec 15, 2013 at 5:10 PM, James Cloos wrote:
For reference, see:
https://wiki.mozilla.org/Security/Server_Side_TLS
for the currently suggested suite for TLS servers.
...
But
On 17 December 2013 17:03, Robert Haas wrote:
> On Mon, Dec 16, 2013 at 3:12 PM, Gregory Smith
> wrote:
>> On 12/16/13 9:36 AM, Craig Ringer wrote:
>>>
>>> - Finish and commit updatable security barrier views. I've still got a
>>> lot of straightening out to do there.
>>
>> I don't follow why yo
I had to write obscure code for processing time zone and using it for
timestamptz
Datum
make_timestamptz_at_timezone(PG_FUNCTION_ARGS)
{
Timestamp timestamp;
text *zone;
int tz;
chartzname[TZ_STRLEN_MAX + 1];
char *lowzone
On 12/17/2013 08:32 PM, Stephen Frost wrote:
* Simon Riggs (si...@2ndquadrant.com) wrote:
My only personal interest in this is to stimulate the writing of
further extensions, which is fairly clearly hampered by the overhead
required for packaging.
I'm not convinced of that but I agree that we
On Wed, Dec 11, 2013 at 5:25 PM, Alvaro Herrera
wrote:
> Andres Freund escribió:
>> What's your plan to commit this? I'd prefer to wait till Alvaro's
>> freezing changes get in, so his patch will look the same in HEAD and
>> 9.3. But I think he plans to commit soon.
>
> Yes, I do. I'm waiting on
* Simon Riggs (si...@2ndquadrant.com) wrote:
> I keep seeing people repeat "I don't like blobs" as if that were an
> objection. There is no danger or damage from doing this. I can't see
> any higher beauty that we're striving for by holding out. Why not
> allow the user to choose XML, JSON, YAML, o
On 16 December 2013 14:36, Craig Ringer wrote:
> - Decide on and implement a structure for row-security functionality its
> self. I'm persuaded by Robert's comments here, that whatever we expose
> must be significantly more usable than a DIY on top of views (with the
> fix for updatable security
On 13 December 2013 18:42, Stephen Frost wrote:
> * Jeff Davis (pg...@j-davis.com) wrote:
>> For what it's worth, I think the idea of extension templates has good
>> conceptual integrity. Extensions are external blobs. To make them work
>> more smoothly in several ways, we move them into the catal
On 12/16/2013 11:44 AM, Tom Lane wrote:> Right. I think a lot of the
tension comes from people being unconvinced
> that the existing extension feature is an ideal model for this sort of
> use-case. Extensions were mainly designed around the notion of a .so
> with some SQL datatype/function/etc de
On Tue, Dec 17, 2013 at 12:28 PM, Tom Lane wrote:
> I had been thinking it would fall down if there are several OR conditions
> affecting different collections of rels, but after going through the math
> again, I'm now thinking I was wrong and it does in fact work out. As you
> say, we do depend
Dimitri Fontaine writes:
> Stephen Frost writes:
>> That's only accurate if the new mechanism supports .so's, which seems
>> unlikely to be the case.
> Really?
Yes, really.
> So now, you don't need anymore to have file system write privileges into
> a central place owned by root, it can be any
On Fri, Dec 13, 2013 at 06:53:02PM +0900, Etsuro Fujita wrote:
> This is a small patch a bit improving a comment in
> src/backend/commands/copy.c.
Thanks, applied.
--
Bruce Momjian http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has t
There are also timezones off by 15 minutes (although only a few, mainly
Nepal).
The only integer representation I've ever seen is in 15 minutes units.
http://www.timeanddate.com/time/time-zones-interesting.html
On Tue, Dec 17, 2013 at 12:33 PM, Bruce Momjian wrote:
> On Tue, Dec 17, 2013 at 0
On 12/16/2013 07:53 PM, Robert Haas wrote:
> So, put a BEFORE trigger, and make it return NULL. Same effect,
> different notation.
NOT the same:
Master partition table with BEFORE trigger:
josh=# insert into a ( id, val ) values ( 23, 'test' ), ( 24, 'test'),
(25,'test');
INSERT 0 0
^^
* Dimitri Fontaine (dimi...@2ndquadrant.fr) wrote:
> Stephen Frost writes:
> >> My thinking is that if we invent a new mechanism for extensions that are
> >> not managed like contribs, we will find out that only contribs are going
> >> to be using extensions.
> >
> > That's only accurate if the ne
On Tue, Dec 17, 2013 at 8:02 AM, Jim Nasby wrote:
> On 12/17/13, 8:34 AM, Robert Haas wrote:
>
>> On Tue, Dec 17, 2013 at 12:09 AM, Amit Kapila
>> wrote:
>>
>>> I have used pg_prewarm during some of work related to Buffer Management
>>> and
>>> other performance related work. It is quite useful
On Tue, Dec 17, 2013 at 06:07:38PM +0100, Pavel Stehule wrote:
> Hello
>
>
> 2013/12/17 Pavel Stehule
>
>
>
>
> 2013/12/17 Tom Lane
>
> Alvaro Herrera writes:
> > Yeah, I think a constructor should allow a text timezone.
>
> Yes. I think a numeric timezone pa
Robert Haas writes:
> On Mon, Dec 16, 2013 at 6:59 PM, Tom Lane wrote:
>> The hard part is not extracting the partial qual. The hard part is
>> trying to make sure that adding this entirely-redundant scan qual doesn't
>> catastrophically degrade join size estimates.
> OK, I had a feeling that's
Stephen Frost writes:
>> My thinking is that if we invent a new mechanism for extensions that are
>> not managed like contribs, we will find out that only contribs are going
>> to be using extensions.
>
> That's only accurate if the new mechanism supports .so's, which seems
> unlikely to be the ca
On Tue, Dec 17, 2013 at 9:58 AM, Christian Kruse
wrote:
> Hi,
>
> attached you will find a patch for showing the current transaction id
> (xid) and the xmin of a backend in pg_stat_activty and the xmin in
> pg_stat_replication.
>
> This may be helpful when looking for the cause of bloat.
>
> I add
Hello
2013/12/17 Pavel Stehule
>
>
>
> 2013/12/17 Tom Lane
>
>> Alvaro Herrera writes:
>> > Yeah, I think a constructor should allow a text timezone.
>>
>> Yes. I think a numeric timezone parameter is about 99% useless,
>> and if you do happen to need that behavior you can just cast the
>> n
On Mon, Dec 16, 2013 at 3:12 PM, Gregory Smith wrote:
> On 12/16/13 9:36 AM, Craig Ringer wrote:
>>
>> - Finish and commit updatable security barrier views. I've still got a
>> lot of straightening out to do there.
>
> I don't follow why you've put this part first. It has a lot of new
> developme
2013/12/17 Alvaro Herrera
> Pavel Stehule escribió:
>
> > but AT TIME ZONE allows double (but decimal parts is ignored quietly)
> >
> > postgres=# select make_time(10,20,30) at time zone '+10.2';
> > timezone
> > -
> > 23:20:30-10
> >
> > so I propose (and I implemented) a variant
On 12/17/2013 12:06 AM, Jeff Janes wrote:
On Mon, Dec 9, 2013 at 3:14 PM, Heikki Linnakangas
wrote:
I took a stab at using posix_fadvise() in ANALYZE. It turned out to be
very easy, patch attached. Your mileage may vary, but I'm seeing a nice
gain from this on my laptop. Taking a 3 page s
2013/12/17 Tom Lane
> Alvaro Herrera writes:
> > Yeah, I think a constructor should allow a text timezone.
>
> Yes. I think a numeric timezone parameter is about 99% useless,
> and if you do happen to need that behavior you can just cast the
> numeric to text no?
yes, it is possible. Although
Alvaro Herrera writes:
> Yeah, I think a constructor should allow a text timezone.
Yes. I think a numeric timezone parameter is about 99% useless,
and if you do happen to need that behavior you can just cast the
numeric to text no?
regards, tom lane
--
Sent via pgsql-
On Tue, Dec 17, 2013 at 11:02 AM, Jim Nasby wrote:
> On 12/17/13, 8:34 AM, Robert Haas wrote:
>>
>> On Tue, Dec 17, 2013 at 12:09 AM, Amit Kapila
>> wrote:
>>>
>>> I have used pg_prewarm during some of work related to Buffer Management
>>> and
>>> other performance related work. It is quite usefu
On Tue, Dec 17, 2013 at 09:51:30AM -0500, Robert Haas wrote:
> On Sun, Dec 15, 2013 at 5:10 PM, James Cloos wrote:
> > For reference, see:
> >
> > https://wiki.mozilla.org/Security/Server_Side_TLS
> >
> > for the currently suggested suite for TLS servers.
> ...
> > But for pgsql, I'd leave off t
Robert Haas wrote:
> Amit Kapila wrote:
>> I have used pg_prewarm during some of work related to Buffer
>> Management and other performance related work. It is quite
>> useful utility.
>> +1 for reviving this patch for 9.4
>
> Any other votes?
Where I would have used a prewarm utility is followi
Pavel Stehule escribió:
> but AT TIME ZONE allows double (but decimal parts is ignored quietly)
>
> postgres=# select make_time(10,20,30) at time zone '+10.2';
> timezone
> -
> 23:20:30-10
>
> so I propose (and I implemented) a variant with int as time zone
>
> and we can (if we
2013/12/17 Jim Nasby
> On 12/15/13, 12:59 PM, Pavel Stehule wrote:
>
>> Why wouldn't we have a version that optionally accepts the timezone?
>> That mirrors what you can currently do with a cast from text, and having to
>> set the GUC if you need a different TZ would be a real PITA.
>>
>>
>>
Andres Freund wrote:
> On 2013-12-16 17:43:37 -0300, Alvaro Herrera wrote:
> > Alvaro Herrera wrote:
> >
> > > This POC patch changes the two places in HeapTupleSatisfiesUpdate that
> > > need to be touched for this to work. This is probably too simplistic,
> > > in that I make the involved cases
On 12/17/13, 8:34 AM, Robert Haas wrote:
On Tue, Dec 17, 2013 at 12:09 AM, Amit Kapila wrote:
I have used pg_prewarm during some of work related to Buffer Management and
other performance related work. It is quite useful utility.
+1 for reviving this patch for 9.4
Any other votes?
We've had
On 12/15/13, 12:59 PM, Pavel Stehule wrote:
Why wouldn't we have a version that optionally accepts the timezone? That
mirrors what you can currently do with a cast from text, and having to set the
GUC if you need a different TZ would be a real PITA.
It is not bad idea.
What will be forma
Peter Eisentraut writes:
> Committers should now try to get the Ready for Committer queue cleared.
I'm still hacking on the WITHIN GROUP patch, and will look at the planner
indexes thing after that's done.
> That leaves 8 patches that haven't been reviewed. If you take a look,
> you can imagine
Hello
updated patch
time zone type functions are overloaded now
postgres=# select '1973-07-15 08:15:55.33+02'::timestamptz;
timestamptz
---
1973-07-15 07:15:55.33+01
(1 row)
postgres=# SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33, 2);
make_timestampt
* Dimitri Fontaine (dimi...@2ndquadrant.fr) wrote:
> > OTOH, for a set of pure-SQL objects, it's not necessary that there be a
> > canonical text file somewhere, and we have in principle complete knowledge
> > of the objects' semantics as well as the ability to dump-and-restore into
> > newer PG ve
On Mon, Dec 16, 2013 at 6:46 AM, Tom Lane wrote:
> Andres Freund writes:
> > Hard to say, the issues fixed in the release are quite important as
> > well. I'd tend to say they are more important. I think we just need to
> > release 9.3.3 pretty soon.
>
> Yeah.
>
Has there been any talk about wh
On Mon, Dec 16, 2013 at 8:22 PM, Tatsuo Ishii wrote:
>>> static Datum regclass_gut(char *class_name_or_oid, bool raiseError);
>>> static List *stringToQualifiedNameList_gut(const char *string, bool
>>> raiseError);
>>
>> Please spell that as "guts" not "gut".
>
> Thanks. I see.
>
>>> regclass_gut
On Sun, Dec 15, 2013 at 5:10 PM, James Cloos wrote:
> For reference, see:
>
> https://wiki.mozilla.org/Security/Server_Side_TLS
>
> for the currently suggested suite for TLS servers.
...
> But for pgsql, I'd leave off the !PSK; pre-shared keys may prove useful
> for some. And RC4, perhaps, also
On Tue, Dec 17, 2013 at 4:31 AM, Andres Freund wrote:
> On 2013-12-16 23:01:16 -0500, Robert Haas wrote:
>> On Sat, Dec 14, 2013 at 12:37 PM, Andres Freund
>> wrote:
>> > On 2013-12-14 11:50:00 -0500, Robert Haas wrote:
>> >> Well, it still seems to me that the right way to think about this is
>
On Mon, Dec 16, 2013 at 7:25 AM, Andres Freund wrote:
> On 2013-12-14 17:43:36 +0100, Andres Freund wrote:
>> On 2013-12-14 11:27:53 -0500, Tom Lane wrote:
>> > In HEAD:
>> >
>> > regression=# \d pg_depend
>> >Table "pg_catalog.pg_depend"
>> >Column| Type | Modifiers
>> > --
On Tue, Dec 17, 2013 at 12:09 AM, Amit Kapila wrote:
> I have used pg_prewarm during some of work related to Buffer Management and
> other performance related work. It is quite useful utility.
> +1 for reviving this patch for 9.4
Any other votes?
--
Robert Haas
EnterpriseDB: http://www.enterpri
On Tue, Dec 17, 2013 at 3:27 AM, Marko Tiikkaja wrote:
> On 12/17/13, 4:53 AM, Robert Haas wrote:
>>>
>>> Well, I'm specifically thinking of master partition tables. In that
>>> case, we really want an INSTEAD OF trigger.
>>
>> /me scratches head.
>>
>> So, put a BEFORE trigger, and make it retur
On Tue, Dec 17, 2013 at 7:48 AM, Andres Freund wrote:
> On 2013-12-16 00:53:10 -0500, Robert Haas wrote:
>> > Yes, I think we could mostly reuse it, we'd probably want to add a field
>> > or two more (application_name, sync_prio?). I have been wondering
>> > whether some of the code in replication
On 2013-12-16 00:53:10 -0500, Robert Haas wrote:
> > Yes, I think we could mostly reuse it, we'd probably want to add a field
> > or two more (application_name, sync_prio?). I have been wondering
> > whether some of the code in replication/logical/logical.c shouldn't be
> > in replication/slot.c or
On 17 December 2013 11:50, KONDO Mitsumasa
wrote:
> Unpatched PG is faster than patched in A and B query. It was about 1.3 times
> faster. Result of A query as expected, because patched PG cannot execute
> readahead at all. So cache cold situation is bad for patched PG. However, it
> might good f
Hello,
I've found a small bug of ECPG and attached a patch. I tested the fix with
9.4. I'd like the fix to be back-ported.
[Problem]
The ECPG app runs the statement:
EXEC SQL CONNECT TO 'tcp:postgresql://?service=my_service';
I want this app to connect to any database based on the connect
From: "Amit Kapila"
Few minor things:
1.
evtHandle = RegisterEventSource(NULL,
*event_source? event_source: DEFAULT_EVENT_SOURCE);
In this code, you are trying to access the value (*event_source) and
incase it is not initialised,
it will not contain the value and could cause problem, why not
di
Hi,
I fixed the patch to improve followings.
- Can compile in MacOS.
- Change GUC name enable_kernel_readahead to readahead_strategy.
- Change POSIX_FADV_SEQUNENTIAL to POISX_FADV_NORMAL when we select sequential
access strategy, this reason is later...
I tested simple two access pate
Tom Lane writes:
> Right. I think a lot of the tension comes from people being unconvinced
> that the existing extension feature is an ideal model for this sort of
> use-case. Extensions were mainly designed around the notion of a .so
The effort here is all about extending the Extension Use Cas
On Mon, Dec 16, 2013 at 9:36 PM, Hannu Krosing wrote:
> On 12/16/2013 08:39 AM, David Rowley wrote:
>
>
> Any other ideas or +1's for any of the existing ones?
>
> +1, inverse good :)
>
>
In the attached patch I've renamed negative to inverse. I've also disabled
the inverse functions when an exp
On 2013-12-16 23:01:16 -0500, Robert Haas wrote:
> On Sat, Dec 14, 2013 at 12:37 PM, Andres Freund
> wrote:
> > On 2013-12-14 11:50:00 -0500, Robert Haas wrote:
> >> Well, it still seems to me that the right way to think about this is
> >> that the change stream begins at a certain point, and the
On 12/17/13, 4:53 AM, Robert Haas wrote:
Well, I'm specifically thinking of master partition tables. In that
case, we really want an INSTEAD OF trigger.
/me scratches head.
So, put a BEFORE trigger, and make it return NULL. Same effect,
different notation.
But it's not the same effect at a
Resolved.
Regression test outputs for name and enum can be replaced with generated out.
On Tue, Dec 17, 2013 at 12:17 AM, imagene...@gmail.com
wrote:
> This is resolved by running dpkg-buildpackage with postgres and
> dpkg-buildpackage -rsudo with the postgresql source folder in a
> directory ow
86 matches
Mail list logo
