Tuning threshold for BAS_BULKREAD (large tables)

Hi, I have a source code-related question on BufferAccessStrategyType BAS_BULKREAD. Currently, this access method is set internally to cache tables larger than 1/4 of shared_buffers. src/backend/access/heap/heapam.c:initscan() if (!RelationUsesLocalBuffers(scan->rs_rd) && scan->rs_n

Re: Manage PostgreSQL Database for GITLAB Application?

On January 21, 2019 7:23:51 PM UTC, "Hilbert, Karin" wrote: >Thanks Stephen, > > >I'm under the gun to get this database restored & then tested with the >application. > >I'll try changing the schema back from public to the original schema >(the same as the application user account name). If that

Re: Manage PostgreSQL Database for GITLAB Application?

Greetings, * Hilbert, Karin (i...@psu.edu) wrote: > The other year, we had to restore the prod database backup to dev & that > changed the schema name. I was thinking that it would be better have the > same names used for dev & prod so that restores from one environment to > another would be e

Re: Manage PostgreSQL Database for GITLAB Application?

Adrian Klaver writes: > On 1/21/19 1:07 PM, Hilbert, Karin wrote: > Please reply to list also. > Ccing list. > >> Adrian, >> >> >> You said: >> >> Would it not be easier to ask the application developer what his >> permissions model is. I can see a game of Whack-a-Mole ahead otherwise. >> >> >>

Re: commit within a procedure loop - cannot commite with subtransaction

Thanks Andrew, The database is currently chewing through the load (without commits) as i'm doing a batch of rows at a time. I'm calling the procedure in pgadmin (4-4.2) as i was testing some bits from there but i'll also try a psql run Appreciate the pointers, Andy -- Sent from: http://www.po

Re: commit within a procedure loop - cannot commite with subtransaction

Thanks Adrian, It is PostgreSQL 11. The procedure listed is calling one postgres function which is in turn calling another postgres function but no additional procedure, just functions. It's a bit lengthy to explain what the functions are doing so i'll try testing with a less complex task i think

Re: Manage PostgreSQL Database for GITLAB Application?

On 1/21/19 1:07 PM, Hilbert, Karin wrote: Please reply to list also. Ccing list. Adrian, You said: Would it not be easier to ask the application developer what his permissions model is. I can see a game of Whack-a-Mole ahead otherwise. I'm sorry, what do you mean by permissions model? Wha

Re: Manage PostgreSQL Database for GITLAB Application?

On 1/21/19 11:23 AM, Hilbert, Karin wrote: Thanks Stephen, I'm under the gun to get this database restored & then tested with the application. I'll try changing the schema back from public to the original schema (the same as the application user account name).  If that doesn't work for the

Re: Manage PostgreSQL Database for GITLAB Application?

Thanks Stephen, I'm under the gun to get this database restored & then tested with the application. I'll try changing the schema back from public to the original schema (the same as the application user account name). If that doesn't work for the application, then I'll try leaving the schema

Re: Manage PostgreSQL Database for GITLAB Application?

Greetings, * Hilbert, Karin (i...@psu.edu) wrote: > Does anyone manage a PostgreSQL database for a GITLAB application? Yes. > I have PostgreSQL v9.6 installed on my server & we are trying to migrate a > GITLAB database there. > > The developer says that we need to use the public schema instead

Re: Manage PostgreSQL Database for GITLAB Application?

On 1/21/19 9:26 AM, Hilbert, Karin wrote: Does anyone manage a PostgreSQL database for a GITLAB application? Could you be more specific about the above?: 1) Are talking about installing GitLab as a self-managed server? 2) Or an application that is running over top of GitLab? I have Postgre

Re: Memory and hard ware calculation :

On Mon, Jan 21, 2019 at 5:35 PM Rangaraj G wrote: > Hi, > > > > Memory and hard ware calculation : > > > > > > How much memory required to achieve performance with the 6GB RAM, 8 Core, > Max connection 1100 concurrent connection and O/p memory from procedure 1GB > ? > > > https://pgtune.leopard.i

Memory and hard ware calculation :

Hi, Memory and hard ware calculation : How much memory required to achieve performance with the 6GB RAM, 8 Core, Max connection 1100 concurrent connection and O/p memory from procedure 1GB ? Is there any changes required in hardware and work memory expansion ? Regards RANGARAJ G

Manage PostgreSQL Database for GITLAB Application?

Does anyone manage a PostgreSQL database for a GITLAB application? I have PostgreSQL v9.6 installed on my server & we are trying to migrate a GITLAB database there. The developer says that we need to use the public schema instead of the schema of the same name as the application user. The sche

Re: commit within a procedure loop - cannot commite with subtransaction

> "andyterry" == andyterry writes: andyterry> Hi, andyterry> Using a procedure for the first time to run some processing andyterry> for each row in a table, generating output to a target andyterry> table. The following works without COMMIT the example below andyterry> gives: andyterr

Re: commit within a procedure loop - cannot commite with subtransaction

On 1/21/19 4:43 AM, andyterry wrote: Hi, Using a procedure for the first time to run some processing for each row in a table, generating output to a target table. The following works without COMMIT the example below gives: INFO: Error Name:cannot commit while a subtransaction is active INFO: Er

commit within a procedure loop - cannot commite with subtransaction

Hi, Using a procedure for the first time to run some processing for each row in a table, generating output to a target table. The following works without COMMIT the example below gives: INFO: Error Name:cannot commit while a subtransaction is active INFO: Error State:2D000 Could someone point me