Max_connections limit

Hello team, We have migrated our database from Oracle 12c to Postgres 11. I need your suggestions , we have sessions limit in Oracle = 3024 . Do we need to set the same connection limit in Postgres as well. How we can decide the max_connections limit for postgres. Are there any differences in

Re: Need a referential constraint to a non-unique record

On 6/25/19 2:58 PM, David Gauthier wrote: I need to create a constraint on a column of a table such that it's value is found in another table but may not be unique in that other table.  Example... Let's say the DB is about students and the grades they got for 4 subjects... Math, English, Scie

Re: Need a referential constraint to a non-unique record

On Tue, Jun 25, 2019 at 2:58 PM David Gauthier wrote: > I need to create a constraint on a column of a table such that it's value > is found in another table but may not be unique in that other table. > Example... > This requires a trigger > > Let's say the DB is about students and the grades t

Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR

On Tue, Jun 25, 2019 at 2:45 PM John Lumby wrote: > Background : For some workloads involving high volume of > INSERT/UPDATE/DELETE, It is sometimes beneficial > to schedule regular REINDEX of high-activity indexes, so as to improve > performance, or restore performance levels back to what

Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR

On Tue, Jun 25, 2019 at 2:56 PM Tom Lane wrote: > > This would avoid the saw-tooth effect on number of pages, and also reduce > > the number of index page-splits which occur during the period immediately > > following a REINDEX done with default FILLFACTOR of 90%. In effect, it > > lessens

Need a referential constraint to a non-unique record

I need to create a constraint on a column of a table such that it's value is found in another table but may not be unique in that other table. Example... Let's say the DB is about students and the grades they got for 4 subjects... Math, English, Science, History. But instead of creating 4 records

Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR

John Lumby writes: > Suggestion : it would be useful if REINDEX could ,   when some new parameter > is set , first determine current average leaf page density in the index to be > rebuilt,    (e.g. the value of pgstatindex().avg_leaf_density from the   > pgstattuple extension ),  and then adopt

REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR

Background :   For some workloads involving high volume of INSERT/UPDATE/DELETE,  It is sometimes beneficial to schedule regular REINDEX of high-activity indexes,   so as to improve performance,  or restore performance levels back to what it was earlier, by removing dead keys etc.  This ca

Re: Need a DB layout gui

All very good ideas. Thanks to all for the input. I think I'm leaning toward DBeaver. But they're all good. Thanks ! On Tue, Jun 25, 2019 at 5:02 PM Kevin Brannen wrote: > *From:* David Gauthier > > > I've been poking around > https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI

RE: Need a DB layout gui

From: David Gauthier > I've been poking around > https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to > see if there is anything that can read PG metadata in and display it > graphically in a gui. You know, the kind of picture that is 1 block per > table with 1->many a

Re: Connect is not available, request timeout after 30000ms.

Ya this is because of ANALYZE. now it's working fine. Thanks for your support. On Tue, Jun 25, 2019, 8:03 PM Adrian Klaver wrote: > On 6/25/19 7:24 AM, Pawan Sharma wrote: > > In PostgreSQL logs it's showing select queries are running with duration > > approx 37001.347ms > > > > Is this norma

Re: Connect is not available, request timeout after 30000ms.

On 6/25/19 7:24 AM, Pawan Sharma wrote: In PostgreSQL logs it's showing select queries are running with duration approx 37001.347ms Is this normal? Did you run ANALYZE on the database after you restored it to the new Postgres 11 cluster? If not do so. Then run the query in psql or someth

Re: Connect is not available, request timeout after 30000ms.

In PostgreSQL logs it's showing select queries are running with duration approx 37001.347ms On Tue, Jun 25, 2019, 7:44 PM Adrian Klaver wrote: > On 6/25/19 7:06 AM, Pawan Sharma wrote: > > Can the app connect at all? > > - yes connection between database and app B is successfully established. >

Re: Connect is not available, request timeout after 30000ms.

On 6/25/19 7:06 AM, Pawan Sharma wrote: Can the app connect at all? - yes connection between database and app B is successfully established. What is the app doing when it gets the error? - from the app B we trying to delete some records in database. Where is the error message appearing? - message

Re: Connect is not available, request timeout after 30000ms.

Can the app connect at all? - yes connection between database and app B is successfully established. What is the app doing when it gets the error? - from the app B we trying to delete some records in database. Where is the error message appearing? - messages are appearing in app server log. Are the

Re: Connect is not available, request timeout after 30000ms.

On 6/25/19 6:49 AM, Pawan Sharma wrote: Hi All, I have upgarded my PostgreSQL database from 10 to 11 version using pg_dump method. That database is used by two apps. 1. A   (most of the transaction are SELECT AND INSERT) 2. B   ( most of the transaction UPDATE AND DELETE) After the upgarde

Connect is not available, request timeout after 30000ms.

Hi All, I have upgarded my PostgreSQL database from 10 to 11 version using pg_dump method. That database is used by two apps. 1. A (most of the transaction are SELECT AND INSERT) 2. B ( most of the transaction UPDATE AND DELETE) After the upgarde I am facing *error:connection is not availa

Re: Need a DB layout gui

You also could try out DBVisualizer (https://www.dbvis.com/). It is available in a feature reduced free version. Feautre comaprison is at https://www.dbvis.com/features/feature-list/. I personally bought the pro to support development. I rarely use a pro feature. Quoting Zahir Lalani : Nav

RE: Need a DB layout gui

Navicat - its costs money but always found it very useful for managing various DBs Z -Original Message- From: Tim Clarke Sent: 24 June 2019 23:56 To: pgsql-general@lists.postgresql.org Subject: Re: Need a DB layout gui I've been enjoying dbeaver for this

Re: Need a DB layout gui

Hello! On 25/06/2019 00:25, David Gauthier wrote: > I've been poking > around  > https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to > see if there is anything that can read PG metadata in and display it > graphically in a gui.  You know, the kind of picture that is 1 block

Re: Need a DB layout gui

I use Valentina Studio these days... https://www.valentina-db.com/en/get-free-valentina-studio Brent Wood Programme leader: Environmental Information Delivery NIWA DDI: +64 (4) 3860529 [cid:image0a50e7.PNG@cb42a178.41b47e97] Brent Wood Principal Technician - GIS and