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
From: Peter Geoghegan [mailto:pe...@2ndquadrant.com]
Sent: Wednesday, August 01, 2012 8:49 PM
On 1 August 2012 15:14, Amit Kapila amit.kap...@huawei.com 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
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
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
Alvaro Herrera alvhe...@commandprompt.com 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
Kevin Grittner kevin.gritt...@wicourts.gov 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
On Thu, Aug 2, 2012 at 10:25 AM, Tom Lane t...@sss.pgh.pa.us 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
Robert Haas robertmh...@gmail.com writes:
On Thu, Aug 2, 2012 at 10:25 AM, Tom Lane t...@sss.pgh.pa.us 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.
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
Etsuro Fujita fujita.ets...@lab.ntt.co.jp 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
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
--
On 29 July 2012 16:39, Peter Geoghegan pe...@2ndquadrant.com 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
Noah Misch n...@leadboat.com 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
On Thu, Aug 2, 2012 at 8:19 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Marko Kreen mark...@gmail.com writes:
On Wed, Aug 1, 2012 at 6:18 PM, Tom Lane t...@sss.pgh.pa.us wrote:
So I'm working from the first set of patches in your message
20120721194907.ga28...@gmail.com.
Great!
Here's an
Marko Kreen mark...@gmail.com writes:
On Thu, Aug 2, 2012 at 8:19 AM, Tom Lane t...@sss.pgh.pa.us 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
On Fri, Aug 3, 2012 at 12:01 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Marko Kreen mark...@gmail.com writes:
On Thu, Aug 2, 2012 at 8:19 AM, Tom Lane t...@sss.pgh.pa.us wrote:
In principle I suppose we could hack PQconsumeInput enough that it
didn't damage the row buffer while still meeting its
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
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 version
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 created
19 matches
Mail list logo