grants files - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2024-04-20 12:57:20 | Re: Extremely slow to establish connection when user has a high number of roles (Tomas Vondra)
granted through other roles), but I've been unable to reproduce this. A reproducer would be great - a script that creates user/roles, and triggers the long login time would allow us to investigate that. Another
Mailing lists >> pgsql-performance >> Thread
2023-08-09 16:50:05 | Re: Function call very slow from JDBC/java but super fast from DBear (An, Hongguo (CORP))
granted and no waiting, but why it never comes back?
Thanks
Andrew
From: Dave Cramer
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)
grant that mean_query_len is that big, overflow here would make garbage collection of the query text file
Mailing lists >> pgsql-performance >> Thread
2021-05-28 18:48:28 | AWS forcing PG upgrade from v9.6 a disaster (Dean Gibson (DB Administrator))
file_num | character(14) | | | | extended | radio_service | text | | | | extended | license_status | text | | | | extended | grant
Mailing lists >> pgsql-performance >> Thread
2020-05-03 08:58:27 | Please help! Query jumps from 1s -> 4m (James Thompson)
file Operating system and version: 5.0.0-1029-gcp #30~18.04.1-Ubuntu SMP Mon Jan 13 05:40:56 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux What program you're using to connect to PostgreSQL
Mailing lists >> pgsql-performance >> Thread
2018-03-19 20:26:32 | RE: PG 9.6 Slow inserts with long-lasting LWLocks (Pavel Suderevsky)
granted = false and locktype = 'extend'; I don't know if this is your particular problem, but perhaps it is. Regards, Michael Vitale Pavel Suderevsky Thursday, March 15, 2018 6:29 AM Hi, Well, unfortunately
Mailing lists >> pgsql-performance >> Thread
2017-07-19 16:43:55 | Re: [PERFORM] How to grant only create schemas and create databaseobjects permission to user. (vinny)
GRANT command: https:///docs/9.1/static/sql-grant.html About halfway down that page it says: ----- CREATE For databases, allows new schemas to be created within the database. For schemas, allows new objects to be created within the schema
Mailing lists >> pgsql-performance >> Thread
2016-09-19 07:30:05 | Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher (Knels, Udo)
files" "20MB" "log_truncate_on_rotation" "on" "logging_collector" "on" "maintenance_work_mem" "256MB" "max_connections" "200" "max_stack_depth" "2MB" "port" "5432" "shared_buffers" "4000MB" "wal_buffers" "2MB" "wal_level" "archive" "work_mem" "20MB
Mailing lists >> pgsql-performance >> Thread
2016-06-29 18:02:10 | Re: Random slow queries (devel.brain99@xoxy.net)
file log the contents of pg_stat_activity and pg_locks every 5 seconds. During my test run, there was one offending query invocation, a simple SELECT * FROM job WHERE field = $1 Of course
Mailing lists >> pgsql-performance >> Thread
2015-08-25 07:22:55 | Long running query: How to monitor the progress (Johann Spies)
files so far: INSERT INTO table_a_link(uid,gn_id) WITH p AS (SELECT ARRAY[ARRAY['t','some_xpath']] AS some_xpath), q AS (SELECT (xpath('//t:UID/text()',xml,some_xpath))[1] uid, unnest
Mailing lists >> pgsql-performance >> Thread
2015-06-10 12:39:59 | Slow query - lots of temporary files. (Johann Spies)
files of 173GB in /var/lib/postgresql/9.4/main/base/pgsql_tmp. COPY (SELECT A.ut, B.go AS funding_org, B.gn AS grant
Mailing lists >> pgsql-performance >> Thread
2014-12-17 15:14:23 | Excessive memory used for INSERT (Alessandro Ipe)
GRANT ALL ON TABLE public.' || quote_ident(_tablename) || ' TO seviri'; EXECUTE 'ALTER TABLE ONLY public.' || quote_ident(_tablename) || ' ADD CONSTRAINT ' || quote_ident(_tablename||'_pkey') || ' PRIMARY KEY (slot,msg)'; END IF; EXECUTE 'INSERT INTO public.' || quote
Mailing lists >> pgsql-performance >> Thread
2014-03-23 06:40:06 | Re: Suboptimal query plan when using expensive BCRYPT functions (Tom Lane)
profile_id = p.id WHERE ( ( u.username ILIKE 'detkin' OR i.email ILIKE 'foo(at)example(dot)com' ) AND ( SUBSTRING(password FROM 8) = CRYPT( 'detkin', SUBSTRING(password FROM 8)) ) ) Granting
Mailing lists >> pgsql-performance >> Thread
2013-05-13 13:05:30 | Lock and pg_stat (Desbiens, Eric)
file locked, so I check pg_locks with: select pg_class.relname, pg_locks.virtualtransaction, pg_locks.mode, pg_locks.granted
Mailing lists >> pgsql-performance >> Thread
2012-09-24 10:33:37 | Postgres becoming slow, only full vacuum fixes it (Kiriakos Tsourapas)
GRANT ALL ON TABLE "AWAITINGSTATUSSMPP" TO "MassSMsUsers"; CREATE INDEX "IX_AWAITINGSTATUSSMPP_MSGID_RCP" ON "AWAITINGSTATUSSMPP" USING btree ("MESSAGEID", "RECIPIENT"); CREATE TRIGGER bucardo_add_delta AFTER INSERT OR UPDATE OR DELETE ON "AWAITINGSTATUSSMPP" FOR EACH