char failed - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread
2021-09-23 13:00:22 | hashjoins, index loops to retrieve pk/ux constrains in pg12 (Arturas Mazeika)
char"[])) Rows Removed by Filter: 2 Buffers: shared hit=52 -> Materialize (cost=0.00..1.09 rows=4 width=4) (actual time=0.000..0.001 rows=4 loops=1707) Output: nr_6.oid Buffers: shared
Mailing lists >> pgsql-performance >> Thread
2021-05-22 05:41:43 | RE: Partition with check constraint with "like" (Michel SALAIS)
char(encoding) "encoding", datcollate, datctype from pg_database; It is also possible to define an explicit collation for the column. You can have it when you describe the table… But I think like others have
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2016-01-01 17:13:46 | Re: Plan differences (Anton Melser)
char(timezone('UTC'::text, a.tstamp), 'YYYY-MM-DD'::text), a.column1, CASE WHEN (d.column1 IS NOT NULL) THEN d.column1 ELSE fff.column1 END, a.column2 -> Merge Left Join (cost=110018.15..3072358.66 rows=23780215 width=143) (actual time
Mailing lists >> pgsql-performance >> Thread
2014-12-17 15:14:23 | Excessive memory used for INSERT (Alessandro Ipe)
char(_slot, 'YYYY-MM-DD'); _tablename := 'MSG_'||_date; PERFORM 1 FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind = 'r' AND c.relname = _tablename
Mailing lists >> pgsql-performance >> Thread
2010-10-27 11:00:28 | Re: Postgres insert performance and storage requirement compared to Oracle (Divakar Singh)
failed: %s", PQerrorMessage(conn)); PQclear(res); exit_nicely(conn); } /* * Should PQclear PGresult whenever it is no longer needed to avoid memory * leaks */ PQclear(res); char
Mailing lists >> pgsql-performance >> Thread
2010-01-13 00:59:25 | a heavy duty operation on an "unused" table kills my server (Eduardo Piombino)
char(250), and it locked up my system. No surprise, since I had many threads waiting for this alter table to finish. What I did not foresee was that this alter table would take
Mailing lists >> pgsql-performance >> Thread
2009-04-07 19:49:39 | Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 (Bruce Momjian)
char $ac_func (); ! /* The GNU C library defines this for functions which it implements ! to always fail
Mailing lists >> pgsql-performance >> Thread
2008-11-28 13:59:17 | Re: Increasing GROUP BY CHAR columns speed (Andrus)
CHAR(10) AS dbobjekt is ugly. I tried to rewrite it using NullIfNot(dbkonto.objekt1, '+') AS dbobjekt, bot got error ERROR: function nullifnot(character, "unknown") does not exist How to re-write this in nicer
Mailing lists >> pgsql-performance >> Thread
2008-08-13 19:30:50 | Re: Filesystem benchmarking for pg 8.3.3 server (Ron Mayer)
failed on hda3 - disabling barriers and %hdparm -I /dev/hdf | grep FLUSH_CACHE_EXT will not show you anything on those devices. IMHO that's cool; and doesn't count as a lying IDE drive since
Mailing lists >> pgsql-performance >> Thread
2008-03-10 06:31:51 | Utility functions for enabling/disabling fkey triggers (Craig Ringer)
CHAR; BEGIN SELECT contype INTO constraint_type FROM pg_catalog.pg_constraint WHERE pg_catalog.pg_constraint.conname = constraint_name; IF constraint_type <> 'f' THEN RAISE EXCEPTION 'Can only disable triggers for foreign key constraints
Mailing lists >> pgsql-performance >> Thread
2008-01-24 20:32:52 | 8.3rc1 Out of memory when performing update (Stephen Denne)
Failed on request of size 28. 2008-01-25 11:53:10.362 NZDT [3824]: [5-1] STATEMENT: UPDATE document_file SET document_type_id = (SELECT document_type_id FROM document d where d.id = document
Mailing lists >> pgsql-performance >> Thread
2007-10-10 16:34:16 | Re: Performance problems with prepared statements (Theo Kramer)
fail to see how preparing a query using PQprepare() and then executing it using PQexecPrepared(), is 8 thousand times slower than directly executing it.,, ( 403386.583ms/50.0ms = 8067 ). When doing a 'manual' prepare and explain analyze
Mailing lists >> pgsql-performance >> Thread
2007-01-14 08:44:02 | Problem with grouping, uses Sort and GroupAggregate, HashAggregate is better(?) (Rolf Østvik (HA/EXA))
char(ur.start_date_time, 'YYYY-MM-DD'), count(*) as num_test from uut_result as ur inner join units as u on ur.unit_ref=u.ref inner join step_result
Mailing lists >> pgsql-performance >> Thread
2007-01-14 08:31:41 | (Rolf Østvik (HA/EXA))
char(ur.start_date_time, 'YYYY-MM-DD'), count(*) as num_test from uut_result as ur inner join units as u on ur.unit_ref=u.ref inner join step_result
Mailing lists >> pgsql-performance >> Thread
2006-12-13 17:49:51 | Re: Optimizing a query (Tom Lane)
char(3) columns, shouldn't you be quoting the constants? select * from nanpa where npa='775' and nxx='413'; Any non-numeric input will fail