Re: [PERFORM] https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server

On Tue, 19 Sep 2017 00:49:14 +, wrote: For an academic experiment I need to *restrict the total amount of memory that is available for a pgSQL server* to compute a given set of queries. I know that I can do this through postgressql.conffile, where I can adjust

Re: [PERFORM] printing results of query to file in different times

Hi Mariel, On 9/7/2017 7:02 AM, Mariel Cherkassky wrote: I'm pretty sure that the source tables are changing during the loop. I have no problem showing the query :        SELECT AREA,                PHONE,                TERM_CODE,                LINE_NO,                PAYMENT_START_DATE,    

Re: [PERFORM] printing results of query to file in different times

Hi Mariel, On 9/6/2017 4:38 AM, Mariel Cherkassky wrote: I'm sure that those tables arent involved in any other transaction when the loop is running. Anything else that I can check ? I think that mybe its connected to some fetching properties but Im not familiar with what settings.. That's

Re: [PERFORM] printing results of query to file in different times

Geez ... I just saw how my last message got mangled. Trying again. On 9/5/2017 7:28 AM, Mariel Cherkassky wrote: I didn't understand what do you mean by REPEATABLE_READ. I was referring to transaction isolation levels.  When multiple transactions are running concurrently, the DBMS can (or

Re: [PERFORM] printing results of query to file in different times

Hi Mariel, Please don't top post in the Postgresql groups. On 9/5/2017 7:28 AM, Mariel Cherkassky wrote: 2017-08-31 16:24 GMT+03:00 George Neuner <gneun...@comcast.net > <mailto:gneun...@comcast.net>>: > >> One thing you might look at is the isolation level of the qu

Re: [PERFORM] printing results of query to file in different times

On Thu, 24 Aug 2017 16:15:19 +0300, Mariel Cherkassky wrote: >I'm trying to understand what postgresql doing in an issue that I'm having. >Our app team wrote a function that runs with a cursor over the results of a >query and via the utl_file func they write

Re: [PERFORM] Unlogged tables

On 8/10/2017 1:29 AM, l...@laurent-hasson.com wrote: Finally, my true question was whether Postgres would support something like worm with the performance benefits of UNLOGGED, but not the inconveniences of auto truncates. If you can live with the limitations, one other thing you might

Re: [PERFORM] Unlogged tables

On 8/10/2017 1:29 AM, l...@laurent-hasson.com wrote: Hello George... I know about not doing top posting but was emailing from my phone, and just recently moved to Android. I think I am still not configured right. Somewhat orthogonal, but any particular reason why top posts == bad, or just

Re: [PERFORM] Unlogged tables

Please don't top post. On 8/9/2017 2:30 PM, l...@laurent-hasson.com wrote: > On 8/9/2017 2:17 PM, gneun...@comcast.net wrote: >> On Wed, 9 Aug 2017 09:14:48 -0700, Jeff Janes wrote: >> Why doesn't the Windows scheduled shutdown signal postgres to shutdown >> cleanly and

Re: [PERFORM] Unlogged tables

On Wed, 9 Aug 2017 09:14:48 -0700, Jeff Janes wrote: >Why doesn't the Windows scheduled shutdown signal postgres to shutdown >cleanly and wait for it to do so? That is what is supposed to happen. Windows *does* signal shutdown (and sleep and hibernate and wakeup).

[PERFORM] testing - ignore

testing -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] testing - please ignore

-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance

[PERFORM] help: function failing

Hi, I am using Postgresql 9.3.5 on Ubuntu and I have a sudden, unexplained failure in a function that has been working for a long time. --- code CREATE OR REPLACE FUNCTION gen_random() RETURNS double precision AS $BODY$ DECLARE num float8 := 0; den