Naive question: would it be /possible/ to change configuration to accept
percentages, and have a percent mean "of existing RAM at startup time"?
I ask because most of the tuning guidelines I see suggest setting memory
parameters as a % of RAM available.
On Tue, Mar 3, 2015 at 1:29 PM, Heikki Linn
e to the Tom's suggestion that the changes in
> FETCH statement is defenitly ugly, especially the "overhead"
> argument is prohibitive even for me:(
>
> > Thanks to Kyotaro and Bruce Momjian for their help.
>
> Not at all.
>
> regardes,
>
>
> At Wed
I think it's confusing to use BETWEEN to mean [low,high) when it already
means [low,high] in WHERE clauses.
Why not leverage range notation instead?
CREATE TABLE parent_monthly_x_201401 PARTITION OF
parent_monthly_x FOR VALUES IN RANGE '[2014-04-01,2014-05-01)'
"IN RANGE" could easily be
Changes in this patch:
- added polymorphic versions of dblink_fetch()
- upped dblink version # to 1.2 because of new functions
- migration 1.1 -> 1.2
- DocBook changes for dblink(), dblink_get_result(), dblink_fetch()
On Sun, Feb 22, 2015 at 11:38 PM, Corey Huinker
wrote:
> "neverm
"nevermind". Found it.
On Sun, Feb 22, 2015 at 11:18 PM, Corey Huinker
wrote:
> Yes, that was it, I discovered it myself and should have posted a
> "nevermind".
>
> Now I'm slogging through figuring out where to find elog() messages from
> the tempor
n Mon, Feb 23, 2015 at 12:03 PM, Corey Huinker
> wrote:
> > + ERROR: could not stat file
> >
> "/home/ubuntu/src/postgres/contrib/dblink/tmp_check/install/usr/local/pgsql/share/extension/dblink--1.2.sql":
> > No such file or directory
>
> Didn't you forge
What needs to happen for new files to be seen by the regression test
harness?
On Fri, Feb 20, 2015 at 1:14 AM, Michael Paquier
wrote:
> On Fri, Feb 20, 2015 at 2:50 PM, Corey Huinker
> wrote:
> > Thanks - completely new to this process, so I'm going to need
> > walking-thr
that to Magnus already.
On Thu, Feb 19, 2015 at 11:00 PM, Michael Paquier wrote:
> On Fri, Feb 20, 2015 at 7:06 AM, Corey Huinker
> wrote:
> > Proposed patch attached.
>
> At quick glance, this patch lacks two things:
> - regression test coverage
> - documentation
>
In the course of writing a small side project which hopefully will make its
way onto pgxn soon, I was writing functions that had a polymorphic result
set.
create function foo( p_row_type anyelement, p_param1 ...) returns setof
anyelement
Inside that function would be multiple calls to dblink() in
What is required to get the New Patch superpower? I'm also in need of it.
On Mon, Feb 16, 2015 at 6:59 PM, Kouhei Kaigai wrote:
> > On Tue, Feb 17, 2015 at 8:50 AM, Kouhei Kaigai
> wrote:
> > >> > I couldn't find operation to add new entry on the current CF.
> > >>
> > >> Go to the bottom of th
It is far from central to this conversation, but I can confirm that
RedShift currently only supports user+pass combinations.
It's likely that each node has a pg_hba.conf, but the customer is not given
credentials to ssh to the individual nodes.
On Thu, Feb 5, 2015 at 10:48 AM, Stephen Frost wrot
I applied this patch to REL9_4_STABLE, and I was able to connect to a
foreign database (redshift, actually).
the basic outline of the test is below, names changed to protect my
employment.
create extension if not exists postgres_fdw;
create server redshift_server foreign data wrapper postgres_fd
Last year I was working on a patch to postgres_fdw where the fetch_size
could be set at the table level and the server level.
I was able to get the settings parsed and they would show up in
pg_foreign_table
and pg_foreign_servers. Unfortunately, I'm not very familiar with how
foreign data wrappers
301 - 313 of 313 matches
Mail list logo