Обсуждение: memory problem with refresh materialized view

Enrico Pirozzi wrote:
> I have a new postgresql 9.5.0 installation on a new virtual server debian 8.3 x64 with 4gb RAM, I have
> compiled postgresql from source.
> 
> When I import a dump with materialized views I see that postgres process takes about all 4 Gb and then
> I have this error
> 
>  fork: Cannot allocate memory

What are the memory related settings of the database into which you restore?

Yours,
Laurenz Albe

Hi, We are looking into setting up a PostgreSQL environment for an
application that inputs JSON through via http rest calls.

Now that we havent been using Postgres for these kind of setups I was
wondering what the course of action is in setting this up.

The development team is coding this in srpingboot with an embedded
mongodb version. Do we have to configure pgrest for instance to enable
postgres for processing JSON rest calls via HTTP or is that not necessary ?
Again just puzzling in how to approach this...


thanks in advance.

Peter

On 02/12/2016 03:00 AM, Peter van Eck wrote:
>
>
> Hi, We are looking into setting up a PostgreSQL environment for an
> application that inputs JSON through via http rest calls.
>
> Now that we havent been using Postgres for these kind of setups I was
> wondering what the course of action is in setting this up.
>
> The development team is coding this in srpingboot with an embedded
> mongodb version. Do we have to configure pgrest for instance to enable
> postgres for processing JSON rest calls via HTTP or is that not necessary ?
> Again just puzzling in how to approach this...

The below looks like a good start:

http://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-sql.html

>
>
> thanks in advance.
>
> Peter
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 02/12/2016 07:43 AM, James Keener wrote:
> https://github.com/begriffs/postgrest also looks interesting!

I thought the purpose of Spring/Spring Boot was to provide the REST
services in front of your choice of data store. Not sure how putting
another server in the stack is going to help things.

>
> On Fri, Feb 12, 2016 at 10:24 AM, Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
>     On 02/12/2016 03:00 AM, Peter van Eck wrote:
>
>
>
>         Hi, We are looking into setting up a PostgreSQL environment for an
>         application that inputs JSON through via http rest calls.
>
>         Now that we havent been using Postgres for these kind of setups
>         I was
>         wondering what the course of action is in setting this up.
>
>         The development team is coding this in srpingboot with an embedded
>         mongodb version. Do we have to configure pgrest for instance to
>         enable
>         postgres for processing JSON rest calls via HTTP or is that not
>         necessary ?
>         Again just puzzling in how to approach this...
>
>
>     The below looks like a good start:
>
>     http://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-sql.html
>
>
>
>         thanks in advance.
>
>         Peter
>
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
>     --
>     Sent via pgsql-general mailing list (pgsql-general@postgresql.org
>     <mailto:pgsql-general@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-general
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

On 02/12/2016 08:06 AM, James Keener wrote:
>
>         https://github.com/begriffs/postgrest also looks interesting!
>
>
>     I thought the purpose of Spring/Spring Boot was to provide the REST
>     services in front of your choice of data store. Not sure how putting
>     another server in the stack is going to help things.
>
>
> I was simply responding to the original question about accessing the DB
> over HTTP.

Then I am not sure what the question is.

Do you want to know how to use Spring Boot with Postgres or do you want
suggestions for programs/frameworks/applications that provide REST
services over Postgres?

Or is something else that I am entirely missing:)?


--
Adrian Klaver
adrian.klaver@aklaver.com

On 12/02/16 17:34, Adrian Klaver wrote:
> On 02/12/2016 08:06 AM, James Keener wrote:
>>
>>         https://github.com/begriffs/postgrest also looks interesting!
>>
>>
>>     I thought the purpose of Spring/Spring Boot was to provide the REST
>>     services in front of your choice of data store. Not sure how putting
>>     another server in the stack is going to help things.
>>
>>
>> I was simply responding to the original question about accessing the DB
>> over HTTP.
>
> Then I am not sure what the question is.
>
> Do you want to know how to use Spring Boot with Postgres or do you
> want suggestions for programs/frameworks/applications that provide
> REST services over Postgres?
>
> Or is something else that I am entirely missing:)?
>
>
Hi Adrian, James,

Thanks for your replies sofar.

It is exactly my point that for us the request from the developers
wasn't clear to us as we don't have the knowledge to apparently fully
understand the question.
I think it is as you describe Adrian  "Do you want to know how to use
Spring Boot with Postgres"
So we'll go with that and see when the first release is pushed from the
developers.

thnaks again.


Peter

I'd like to extend (and complete) this thread by collecting
programs/frameworks/applications that provide REST services over
Postgres.

I see following categories and open source web frameworks and/or libs:
Those which
* attach Postgres directly, like PostgREST (Haskell) or jsgrest
(JavaScript serverside).
* connect to (m)any db inc. Postgres, like Spring Boot (Java EE) or
sandman2 (Python)

PostgREST looks promising.
But since Postgres 9.5 ff. has good JSON support (and given I like
Python) I'd prefer an even more lightweight solution.
Any suggestions?

:Stefan


2016-02-12 17:46 GMT+01:00 Peter van Eck <peter@vaneckzone.net>:
>
>
> On 12/02/16 17:34, Adrian Klaver wrote:
>>
>> On 02/12/2016 08:06 AM, James Keener wrote:
>>>
>>>
>>>         https://github.com/begriffs/postgrest also looks interesting!
>>>
>>>
>>>     I thought the purpose of Spring/Spring Boot was to provide the REST
>>>     services in front of your choice of data store. Not sure how putting
>>>     another server in the stack is going to help things.
>>>
>>>
>>> I was simply responding to the original question about accessing the DB
>>> over HTTP.
>>
>>
>> Then I am not sure what the question is.
>>
>> Do you want to know how to use Spring Boot with Postgres or do you want
>> suggestions for programs/frameworks/applications that provide REST services
>> over Postgres?
>>
>> Or is something else that I am entirely missing:)?
>>
>>
> Hi Adrian, James,
>
> Thanks for your replies sofar.
>
> It is exactly my point that for us the request from the developers wasn't
> clear to us as we don't have the knowledge to apparently fully understand
> the question.
> I think it is as you describe Adrian  "Do you want to know how to use Spring
> Boot with Postgres"
> So we'll go with that and see when the first release is pushed from the
> developers.
>
> thnaks again.
>
>
> Peter
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

On 03/05/2016 05:34 PM, Stefan Keller wrote:
> I'd like to extend (and complete) this thread by collecting
> programs/frameworks/applications that provide REST services over
> Postgres.
>
> I see following categories and open source web frameworks and/or libs:
> Those which
> * attach Postgres directly, like PostgREST (Haskell) or jsgrest
> (JavaScript serverside).
> * connect to (m)any db inc. Postgres, like Spring Boot (Java EE) or
> sandman2 (Python)
>
> PostgREST looks promising.
> But since Postgres 9.5 ff. has good JSON support (and given I like
> Python) I'd prefer an even more lightweight solution.
> Any suggestions?

Recently ran across the below, have not had time to actually try it out yet:

https://github.com/timothycrosley/hug

>
> :Stefan
>
>



--
Adrian Klaver
adrian.klaver@aklaver.com