easy resetting - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread
2023-08-31 16:52:31 | Re: Queries containing ORDER BY and LIMIT started to work slowly (Jeff Janes)
easier to optimize the current query while ignoring the past. But you seem to be interested in a root-cause analysis, and I don't see any other way to do one of those. What
Mailing lists >> pgsql-performance >> Thread
2023-07-10 14:28:51 | Performance implications of 8K pread()s (Dimitrios Apostolou)
setting max_parallel_workers_per_gather to 0. Strace'ing the postgresql process shows that all reads happen in offset'ed 8KB blocks using pread(): pread64(172, ..., 8192, 437370880) = 8192 The read rate
Mailing lists >> pgsql-performance >> Thread
2022-11-29 03:39:47 | Re: Catching up with performance & PostgreSQL 15 (Mladen Gogala)
easy to enable. All you need is to set max_parallel_workers_per_gather to an integer > 0 and PgSQL 15 will automatically use parallel plan if the planner decides that it's the best
Mailing lists >> pgsql-performance >> Thread
2022-07-21 19:33:27 | Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries (Justin Pryzby)
settings, in an easier to read format than posting pieces of your postgresql.conf file
Mailing lists >> pgsql-performance >> Thread
2021-05-07 21:28:33 | Re: Very slow Query compared to Oracle / SQL - Server (Peter Geoghegan)
setting the LP_DEAD bit of known-dead index tuples in passing more often (bitmap index scans won't do the kill_prior_tuple optimization). There could even be a virtuous circle over time. (Note
Mailing lists >> pgsql-performance >> Thread
2020-10-15 05:21:50 | Poor Performance running Django unit tests after upgrading from 10.6 (Roger Hunwicks)
setting anything and performance was fine using just the defaults, given the tiny data volumes. However, even though we have similar performance for 12.4 for most test runs, it remains very variable. About
Mailing lists >> pgsql-performance >> Thread
2020-07-14 00:05:07 | Re: Sudden insert performance degradation (Jeff Janes)
settings for dirty_background_ratio, dirty_expire_centisecs, and probably other things, and is not easy
Mailing lists >> pgsql-performance >> Thread
2019-11-24 20:50:20 | Re: performance degredation after upgrade from 9.6 to 12 (Jeff Janes)
setting it to 0 actually slows things down, as at that size parallelization is useful and disabling it hurts. Of course parallel query might be hurting some of the other queries
Mailing lists >> pgsql-performance >> Thread
2019-09-11 15:54:01 | Re: select distinct runs slow on pg 10.6 (Merlin Moncure)
settings there) *) Experiment with pg11/pg12 to see if upcoming versions can handle this strategy better. pg12 is in beta obviously, but an upgrade strategy would be the easiest
Mailing lists >> pgsql-performance >> Thread
2019-04-15 13:32:09 | Re: Out of Memory errors are frustrating as heck! (Jeff Janes)
setting a breakpoint for any memory allocation is probably going to fire too often to be useful. Yes, the verbose option didn't help (but the gdb backtrace made up for it--kind
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2019-03-01 07:54:12 | RE: How to get the content of Bind variables (ROS Didier)
setting of log_error_verbosity ? https:///docs/current/runtime-config-logging.html#GUC-LOG-ERROR-VERBOSITY Also, I recommend using CSV logs, since they're easier
Mailing lists >> pgsql-performance >> Thread
2019-01-23 19:16:06 | Benchmarking: How to identify bottleneck (limiting factor) andachieve "linear scalability"? (Saurabh Nanda)
easy way to identify the limiting factor? Is it network connectivity? Disk IOPS? CPU load? Some config parameter? ## SECONDARY QUESTION *At what level of concurrent connections should settings
Mailing lists >> pgsql-performance >> Thread
2019-01-22 21:13:48 | ANALYZE accuracy problems for n_distinct, and a solution (Jim Finnerty)
setting pg_statistic requires superuser privs, you run the aux_stats.analyze function, and then you run ANALYZE. Before running ANALYZE, you can view the stats as currently reflected in pg_statistic, and what
Mailing lists >> pgsql-performance >> Thread
2018-12-08 19:03:27 | Fwd: amazon aroura config - seriously overcommited defaults? (May beOff Topic) (Square Bob)
easy, some settings are in pages, some are in kb, some are who knows what
Mailing lists >> pgsql-performance >> Thread
2018-04-17 17:23:15 | Re: Unexplainable execution time difference between two testfunctions...one using IF (SELECT COUNT(*) FROM...) and (Tomas Vondra)
setting up parallel workers etc. So it does not do that. Which means that there are actually no matching rows for 'Test5000001'. So the database will scan the whole table anyway, in order to answer