grants gives - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread
2022-08-02 19:14:39 | Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries (Tom Lane)
gives. However, even if we grant that mean_query_len is that big, overflow here
Mailing lists >> pgsql-performance >> Thread
2017-02-27 17:10:52 | Re: [PERFORM] How Can I check PostgreSQL backup is successfully ornot ? (Dinesh Chandra 12108)
GRANT ALL ON SCHEMA public TO PUBLIC; -- -- PostgreSQL database dump complete -- $ Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida. ------------------------------------------------------------------ Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road
Mailing lists >> pgsql-performance >> Thread
2016-07-21 21:42:16 | Re: Seeing execution plan of foreign key constraint check? (Jim Nasby)
Granted, that doesn't give you plan info, just timing...) As for function plans, ISTM
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2015-08-24 15:08:35 | Re: query not using GIN index (Guo, Yun)
grants² WHERE (access_tokens @> ARRAY['124e5a1f9de325fc176a7c89152ac734']) limit 1; We tried removing "limit 1², which did give
Mailing lists >> pgsql-performance >> Thread
2015-07-30 06:28:51 | Re: Are many idle connections bad? (Alex Hunsaker)
Granted, you can still use apache & mod_perl with PSGI if you want. It's more flexible in that it gives
Mailing lists >> pgsql-performance >> Thread
2014-03-23 06:40:06 | Re: Suboptimal query plan when using expensive BCRYPT functions (Tom Lane)
Granting that there are not chance collisions of password hashes (which would surely be a bad thing if there were), success of the second AND arm means that we are on user detkin
Mailing lists >> pgsql-performance >> Thread
2013-05-27 22:18:13 | Re: Slow SELECT by primary key? Postgres 9.1.2 (John Mudd)
gives an unfair advantage to the primary key SELECT. Still, it's easy to test so here are the results. The primary key still looses even with the CLUSTER. Granted
Mailing lists >> pgsql-performance >> Thread
2013-05-13 13:05:30 | Lock and pg_stat (Desbiens, Eric)
give me information: S:\PostgreSQL\9.0\data\base>"C:\Program Files\PostgreSQL\9.0\bin\oid2name.exe" - U postgres -d mydb -f 30352481 Password: From database "lxcal": Filenode Table Name ---------------------- Certainly because the pg_stat worker
Mailing lists >> pgsql-performance >> Thread
2013-04-01 23:43:20 | Re: Problems with pg_locks explosion (Vasilis Ventirozos)
give you more information about whats happening in your server lock-wise SELECT locktype, virtualtransaction,transactionid,nspname,relname,mode,granted
Mailing lists >> pgsql-performance >> Thread
2012-12-20 22:43:26 | Re: Performance on Bulk Insert to Partitioned Table (Charles Gomes)
granted | fastpath ---------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+--------------------------+---------+---------- relation | 16385 | 19295 | | | | | | | | 72/18 | 19879 | AccessShareLock | t | t relation | 16385 | 11069 | | | | | | | | 76/32 | 19881 | AccessShareLock | t | t virtualxid | | | | | 56/34 | | | | | 56/34 | 17952 | ExclusiveLock | t | t virtualxid | | | | | 27/33 | | | | | 27/33 | 17923 | ExclusiveLock | t | t virtualxid | | | | | 6/830 | | | | | 6/830
Mailing lists >> pgsql-performance >> Thread
2011-10-27 09:04:09 | Re: PostgreSQL 9.0.4 blocking in lseek? (Sören Meyer-Eppler)
granted for hours. Although the process does in fact use CPU this time, strace still gives
Mailing lists >> pgsql-performance >> Thread
2011-08-03 10:29:23 | Re: Re: GROUP BY with reasonable timings in PLAN but unreasonable execution time (Robert Haas)
Granted, the GROUP BY might totally change the data distribution, so relying on the input column statistics to be meaningful could be totally wrong, but on average it seems more likely to give
Mailing lists >> pgsql-performance >> Thread
2011-04-26 11:44:00 | Re: Time to put theory to the test? (J Sisson)
Granted, my knowledge of PostgreSQL (and even MSSQL) far surpasses my knowledge of MySQL, but if InnoDB has such amazing benefits as being crash safe, and even speed increases in some instances
Mailing lists >> pgsql-performance >> Thread
2011-03-24 19:23:26 | Re: Shouldn't we have a way to avoid "risky" plans? (Claudio Freire)
gives me too few tools to tweak plans (increase statistics, use subqueries, rephrase joins, no direct tool before CTEs which are rather new), it becomes an art form, and it becomes very unpredictable
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2011-01-19 07:40:37 | Re: Migrating to Postgresql and new hardware (Lars)
Granted I haven't done or seen any pull the plug under max load tests on either family, so I got nothing beyond that it is the first thing I have looked at with every