Neil Tiffin-3 wrote
> Trying to wrap my head around postgresql 9.4 jsonb and would like some
> help figuring out how to do the following.
>
> Given the following example jsonb:
>
> ‘{“name1” : value1, “name2” : value2, “name3” : [int1, int2, int3]
> }’::jsonb AS table1.column1
>
> Zhan Li hat am 4. November 2014 um 03:01 geschrieben:
>
>
> Hi all,
>
> In PostgreSQL is there a timeout when the optimizer stops the optimization
> process and returns the least expensive plan it has found so far? Is it
> possible to change its value?
>
> Thanks,
> Zhan
Please read http://w
Hi all,
In PostgreSQL is there a timeout when the optimizer stops the optimization
process and returns the least expensive plan it has found so far? Is it
possible to change its value?
Thanks,
Zhan
Hello all,
I've come across Dynomite this evening.
http://techblog.netflix.com/2014/11/introducing-dynomite.html
It already has some interesting features and I'm sure there'll be some
momentum behind it.
It's too soon to say but I can definitely see something neat being build on
top of Postgres.
Trying to wrap my head around postgresql 9.4 jsonb and would like some help
figuring out how to do the following.
Given the following example jsonb:
‘{“name1” : value1, “name2” : value2, “name3” : [int1, int2, int3]
}’::jsonb AS table1.column1
Wanted: Return the “name3” array only,
Thank you John.
That perfectly answered by question.
Regards
Anil
On Sat, Nov 1, 2014 at 2:43 AM, John R Pierce wrote:
> On 10/31/2014 3:24 AM, Anil Menon wrote:
>
> I have a very basic question on inserts - I tried to get a good
> authoritative answer but could not really find one to my satis
>
> On Mon, 11/3/14, Igor Neyman wrote:
>
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org]
> On Behalf Of p...@cmicdo.com
> Sent: Monday, November 03, 2014 11:34 AM
> To: pgsql-general@postgresql.org
> Subjec
Moshe Jacobson writes:
> The function pulls a GUC value and that's all it does. Is it safe to mark
> it IMMUTABLE?
No; such a function is by definition mutable.
> I noticed that if I updated the GUC variable and ran the
> query again, it worked as I would hope, with the new value of the function
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of p...@cmicdo.com
Sent: Monday, November 03, 2014 11:34 AM
To: pgsql-general@postgresql.org
Subject: [SPAM] - [GENERAL] Performance of UPDATE SET = FROM vs UPDATE SET =
(SE
On 11/3/2014 10:27 AM, Devrim Gündüz wrote:
Hi,
On Mon, 2014-11-03 at 18:45 +0100, Georges Racinet wrote:
>Didn't find many ppc64 ou ppc64el binary packages online, though:
>yum.postgresql.org
For the archives: We will support Power 7 and Power 8 systems on RHEL 6
and RHEL 7 in the upcoming we
On 11/03/2014 07:27 PM, Devrim Gündüz wrote:
> On Mon, 2014-11-03 at 18:45 +0100, Georges Racinet wrote:
>> > Didn't find many ppc64 ou ppc64el binary packages online, though:
>> > yum.postgresql.org
> For the archives: We will support Power 7 and Power 8 systems on RHEL 6
> and RHEL 7 in the upcom
Hi,
On Mon, 2014-11-03 at 18:45 +0100, Georges Racinet wrote:
> Didn't find many ppc64 ou ppc64el binary packages online, though:
> yum.postgresql.org
For the archives: We will support Power 7 and Power 8 systems on RHEL 6
and RHEL 7 in the upcoming weeks.
Regards,
--
Devrim GÜNDÜZ
Principal S
On 11/3/2014 9:45 AM, Georges Racinet wrote:
I have an opportunity to test PostgreSQL and the applications I care
about on a IBM Power 8 system tomorrow afternoon (Nov 4th, CET time).
While my primary interest lies in the applications, I was wondering if
people here would have advice or interest
Hi,
I have an opportunity to test PostgreSQL and the applications I care
about on a IBM Power 8 system tomorrow afternoon (Nov 4th, CET time).
While my primary interest lies in the applications, I was wondering if
people here would have advice or interest about useful tests or
benchmarks to perfo
It seems Postgres 9.3 does not realize that it can collapse the result of a
STABLE function when attempting to match against an index for a single
query.
I am running into a problem with a full text index, where my filter
conditions include a function that returns the user's language code. If the
Hi all,
we experienced what seems to be a bug in the COPY TO implementation. When a
table is being rewritten by an ALTER TABLE statement, a parallel COPY TO
results in an empty result.
Consider the following table data:
CREATE TABLE test (id INTEGER NOT NULL, PRIMARY KEY (id));
INSERT INTO t
Why does the UPDATE SET = FROM choose a more poorly performing plan than
the UPDATE SET = (SELECT ...)? It seems to me that it is the same join.
I'm using 9.3.5.
CREATE TABLE orig
(
key1VARCHAR(11) PRIMARY KEY,
time1 TIME
);
INSERT INTO orig (key1, time1)
SELECT
17 matches
Mail list logo
