Hi, hackersI was exporting my project to a patch file. As the patch review
requires, the patch needs to be in context diff format
(http://wiki.postgresql.org/wiki/Reviewing_a_Patch). But the git diff exports
in a format similar to unified format. What is everyone doing with patching
curr
On Wed, Nov 30, 2011 at 09:47:40PM -0800, Greg Smith wrote:
> On 11/30/2011 10:20 AM, Greg Stark wrote:
> >Given your confusion it's clear that we have to explain that it will
> >wait one by one for each transaction that was started before the index
> >was created to finish.
>
> When the index was
Hi Kevin,
> > I would like to propose single-column sortedness options and
> > insert appropriate pathkeys into the ForeignPath node based on
> > these information:
> For character-based columns, don't we need to know the collation?
I forgot to add the collate option. I'll add it at the next ve
On Tue, Jun 21, 2011 at 08:27:45PM -0400, Andrew Dunstan wrote:
>
> Attached is a WIP possible replacement for pgindent. Instead of a
> shell script invoking a mishmash of awk and sed, some of which is
> pretty impenetrable, it uses a single engine (perl) to do all the
> pre and post indent proces
On Fri, Aug 3, 2012 at 12:01 AM, Tom Lane wrote:
> Marko Kreen writes:
>> On Thu, Aug 2, 2012 at 8:19 AM, Tom Lane wrote:
>>> In principle I suppose we could hack PQconsumeInput enough that it
>>> didn't damage the row buffer while still meeting its API contract of
>>> clearing the read-ready co
Marko Kreen writes:
> On Thu, Aug 2, 2012 at 8:19 AM, Tom Lane wrote:
>> In principle I suppose we could hack PQconsumeInput enough that it
>> didn't damage the row buffer while still meeting its API contract of
>> clearing the read-ready condition on the socket; but it wouldn't be
>> simple or c
On Thu, Aug 2, 2012 at 8:19 AM, Tom Lane wrote:
> Marko Kreen writes:
>> On Wed, Aug 1, 2012 at 6:18 PM, Tom Lane wrote:
>>> So I'm working from the first set of patches in your message
>>> <20120721194907.ga28...@gmail.com>.
>
>> Great!
>
> Here's an updated draft patch. I've not looked at the
Noah Misch writes:
> On Mon, Mar 12, 2012 at 10:50:36PM -0400, Tom Lane wrote:
>> There is one more (known) stop-ship problem in SPGiST, which I'd kind of
>> like to get out of the way now before I let my knowledge of that code
>> get swapped out again. This is that SPGiST is unsafe for use by ho
On 29 July 2012 16:39, Peter Geoghegan wrote:
> Many of you will be aware that the behaviour of commit_delay was
> recently changed. Now, the delay only occurs within the group commit
> leader backend, and not within each and every backend committing a
> transaction:
I've moved this to the pgsql-
Peter,
For some reason I didn't receive the beginning of this thread. Can you
resend it to me, or (better) post it to the pgsql-performance mailing list?
I have a linux system where I can test both on regular disk and on SSD.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sen
"Etsuro Fujita" wrote:
> I would like to propose single-column sortedness options and
> insert appropriate pathkeys into the ForeignPath node based on
> these information:
>
> sorted: Boolean option to specify whether data file is sorted by
> a column.
> key: Specifies the name of a colu
Hi,
In HEAD and 9.2, the following scenario happens in archive recovery.
1. The archived WAL file is restored onto the temporary file name
"RECOVERYXLOG".
2. The restored WAL file is renamed to the correct file name like
00010002.
3. The startup process tries to open the temporary
Robert Haas writes:
> On Thu, Aug 2, 2012 at 10:25 AM, Tom Lane wrote:
>> Per recent discussion, today is the tarball wrap day for beta3.
> Was this discussion on some closed mailing list? I don't remember seeing it.
http://archives.postgresql.org/pgsql-hackers/2012-07/msg00897.php
On Thu, Aug 2, 2012 at 10:25 AM, Tom Lane wrote:
> Per recent discussion, today is the tarball wrap day for beta3.
Was this discussion on some closed mailing list? I don't remember seeing it.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent v
"Kevin Grittner" wrote:
> Don't forget the peculiarities of columns with record types.
I forgot to include the type creation in the example:
test=# create type a as (a1 int, a2 int);
CREATE TYPE
-Kevin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
Alvaro Herrera wrote:
> Just over a year ago, I posted a patch (based on a previous patch
> by Bernd Helmle) that attempted to add pg_constraint rows for NOT
> NULL
> constraints.
>
http://archives.postgresql.org/message-id/20110707213401.ga27...@alvh.no-ip.org
> That patch was rather long and
Per recent discussion, today is the tarball wrap day for beta3.
I plan to wrap the tarballs around 2200 UTC. I will have the
libpq single-row mode patch in before then, and if time permits
I'll see if I understand how to fix SPGiST now. It'd be nice if
relevant people could review and commit the
select (interval '56:48' minute to second);
result:00:56:48
select (interval '-56:48' minute to second);
result:-56:48:00
select (interval '+56:48' minute to second);
result:56:48:00
When user uses ‘+’ or ‘-‘ symbol, then minute to second range is getting
ignored.
I have checked the code a
> From: Peter Geoghegan [mailto:pe...@2ndquadrant.com]
> Sent: Wednesday, August 01, 2012 8:49 PM
On 1 August 2012 15:14, Amit Kapila wrote:
>> I shall look into this aspect also(setting commit_delay based on raw
sync).
>> You also suggest if you want to run the test with different
configuration
The following is a comment at fileGetForeignPaths() in contrib/file_fdw.c:
/*
* If data file was sorted, and we knew it somehow, we could insert
* appropriate pathkeys into the ForeignPath node to tell the planner
* that.
*/
To do this, I would like to propose new generic
20 matches
Mail list logo