Re: Does pg_stat_get_live_tuples() matter?

Sherrylyn Branchaw writes: > If a table has 1.8M rows in reality, yet pg_stat_get_live_tuples() returns > 1.8K, does it matter to the performance of the database, as long as > pg_class.reltuples is the right order of magnitude? Hmmm ... what was in reltuples again? Looking at the current code,

Re: Unable to Vacuum Large Defragmented Table

Pavel, On Mon, Apr 8, 2019 at 8:29 AM Pavel Stehule wrote: > > > po 8. 4. 2019 v 17:22 odesílatel Igal Sapir napsal: > >> Pavel, >> >> On Sun, Apr 7, 2019 at 11:22 PM Pavel Stehule >> wrote: >> >>> >>> po 8. 4. 2019 v 7:57 odesílatel Igal Sapir napsal: >>> David, On Sun, Apr

Re: Does pg_stat_get_live_tuples() matter?

What version of Postgres? Sorry, can't believe I forgot to include that! Postgres 9.6.9. How are you getting at the 1.8M number? SELECT COUNT(*)

Re: Does pg_stat_get_live_tuples() matter?

On 4/9/19 9:45 AM, Sherrylyn Branchaw wrote: If a table has 1.8M rows in reality, yet pg_stat_get_live_tuples() returns 1.8K, does it matter to the performance of the database, as long as pg_class.reltuples is the right order of magnitude? What version of Postgres? How are you getting at the

Does pg_stat_get_live_tuples() matter?

If a table has 1.8M rows in reality, yet pg_stat_get_live_tuples() returns 1.8K, does it matter to the performance of the database, as long as pg_class.reltuples is the right order of magnitude? The query planner seems to use the accurate estimate, but what about the autovacuum daemon? Or

Re: Transactions

In addition to what Andreas has suggested, you should also verify user claims by A. Have them show you the query they executed, B. Verify they have appropriate SELECT, INSERT, UPDATE ad/or DELETE permissions on the tables involved. On Tue, Apr 9, 2019 at 6:10 AM Achilleas Mantzios <

Re: Fwd: Postgresql with nextcloud in Windows Server

On 4/8/19 6:51 PM, 김준형 wrote: Thanks for your answers. 1) First time, I set that value to 200. I think it is connection issue, so increase max_connection = 1200. Connections consume resources, that can come back to hurt you. After I show this email, I search max connection is associated to

Re: Logical replication failed recovery

On 4/9/19 6:08 AM, Lou Tseng wrote: Please reply to list also. Ccing list. Hi adrian, You are right.  Increasing the wal_kept_segments didn't solve the problem. However, I didn't find any scenario in the documentation applied to my case. Is there a way to get the databases resynced? It

Re: 9.6.11- could not truncate directory "pg_serial": apparent wraparound

> > On Sun, Apr 7, 2019 at 2:31 AM Pavel Suderevsky > wrote: > > Probably if you advise me what could cause "pg_serial": apparent > wraparound messages I would have more chances to handle all the performance > issues. > > Did you see that warning at some point before the later error? > Thomas,

Re: Transactions

On 9/4/19 12:26 μ.μ., Karl Martin Skoldebrand wrote: Hi, Is there a way to track “transactions” by default (i.e. without anyone having set up anything specific). The problem I am facing is that users are claiming that settings are disappearing with them doing anything to affect them. It would

Sv: RE: Transactions

På tirsdag 09. april 2019 kl. 11:56:28, skrev Karl Martin Skoldebrand < ks0c77...@techmahindra.com >: How much impact on performance and disk space would this or set log_min_duration_statement=0 have? I have no idea as to how common this is, or when it

RE: Transactions

How much impact on performance and disk space would this or set log_min_duration_statement=0 have? I have no idea as to how common this is, or when it happens, so it would need to run until this reported again (or some reasonable time if it doesn’t happen). /M. From: Andreas Joseph Krogh

Re: Transactions

Hi Karl Martin, you could set log_min_duration_statement=0 at the global level (in the config file) or at session level too. regards, fabio pardi On 09/04/2019 11:26, Karl Martin Skoldebrand wrote: > Hi, > >   > > Is there a way to track “transactions” by default (i.e. without anyone

Sv: Transactions

På tirsdag 09. april 2019 kl. 11:26:29, skrev Karl Martin Skoldebrand < ks0c77...@techmahindra.com >: Hi, Is there a way to track “transactions” by default (i.e. without anyone having set up anything specific). The problem I am facing is that users are

Transactions

Hi, Is there a way to track "transactions" by default (i.e. without anyone having set up anything specific). The problem I am facing is that users are claiming that settings are disappearing with them doing anything to affect them. It would be good to be able to see what postgresql thinks is