Thank you Bill and David. I'll take a look at `pg_buffercache ` and explain
with buffers.
---
>>> What problem are you seeing?
---
I don't have a problem at the moment.
---
>>> What is your performance requirement, and what is the observed
performance?
---
On 15 August 2015 at 00:09, Deepak Balasubramanyam
wrote:
> Hi,
>
> I have a table (20 million rows) in Postgresql 9.4 that contains a bigint
> id as the primary key and another column that contains jsonb data. Queries
> run on this table look like so...
>
>
> ## Query
>
On Fri, 14 Aug 2015 17:39:49 +0530
Deepak Balasubramanyam wrote:
>
> I have a table (20 million rows) in Postgresql 9.4 that contains a bigint
> id as the primary key and another column that contains jsonb data. Queries
> run on this table look like so...
>
>
> ## Query
> --
Hi,
I have a table (20 million rows) in Postgresql 9.4 that contains a bigint
id as the primary key and another column that contains jsonb data. Queries
run on this table look like so...
## Query
select ... from table
WHERE table.column ->'item'->> 'name' = 'value'
-
Hi,
I am developing a postgres extension. The extension gets json data as a
string from external source and is supposed to be able to store this string
in a Jsonb type.
I am working with C API for postgres-9.4 installed from ubuntu trusty main
repo.
I would like to use a function that converts a
