PgSql
in [SQL]
|
Large (almost 50%!) performancedrop after upgrading to 8.4.4? Bruce Momjian wrote: Alvaro Herrera wrote: Excerpts from Tom Lane's message of jue jun 10 11:46:25 -0400 2010: Yes, the folks at commandprompt need to be told about this. Loudly. It's a serious packaging error. Just notified Lacey, the packager (not so loudly, though); she's work... 13 Jun 2010 11:34
It's possible to get pg_class oid from GETSTRUC macro? On 13/06/10 15:28, Mohammad Heykal Abdillah wrote: After i read PostgreSQL documentation, i found that pg_attribute contain "attrelid" that reference to pg_class oid. But after i look to "/src/include/catalog/pg_class.h" there is no member named "oid". This what i trying to acomplish using "heap_getnext"... 13 Jun 2010 00:46
[HACKERS] It's possible to get pg_class oid from GETSTRUC macro? After i read PostgreSQL documentation, i found that pg_attribute contain "attrelid" that reference to pg_class oid. But after i look to "/src/include/catalog/pg_class.h" there is no member named "oid". This what i trying to acomplish using "heap_getnext" function: if (((Form_pg_class) GETSTRUCT(ht_1)->oid) == (... 12 Jun 2010 23:41
pg_regress --use-existing does not appear in--help Jan Urbański wrote: Hi, per $SUBJECT. Applied. -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org)... 12 Jun 2010 13:45
[HACKERS] Patch to show individual statement latencies in pgbench output Hi To be able to asses the performance characteristics of the different wal-related options, I patched pgbench to show the average latency of each individual statement. The idea is to be able to compare the latency of the COMMIT with the ones of the other statements. This patch adds two new finds to the Command s... 12 Jun 2010 11:32
[HACKERS] GSoC - Materialized Views - is stale or fresh? I am curious how could I solve the problem: During refreshing I would like to know, if MV is stale or fresh? And I had an idea: In fact, MV need to know if its last refresh (transaction id) is older than any INSERT, UPDATE, DELETE transaction launched against source tables. So if MV has information about la... 12 Jun 2010 10:26
pg_upgrade output directory Andrew Dunstan wrote: Why does pg_upgrade create its output directory in the user's home directory (or TMP on Windows)? I should have thought that the current working directory would be a more suitable choice. At the very least there should be an option for where to create it. Also, this location ... 12 Jun 2010 13:45
[HACKERS] 9.0beta2 - server crash when using HS + SR -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello I am testing HS + SR in a system running 9.0beta2. What I am doing is just trying all kind of crazy combinations and see how the system handles them. One of the test I knew was going to fail was to create a tablespace in the master node with the directory... 11 Jun 2010 22:33
[HACKERS] The smallest patch (vacuumdb.c) Folks, Looks like someone accidentally deleted the -Z option from vacuumdb. Patch attached, one character. ;-) (thanks Gabrielle, and Jan Urbanski) -- -- Josh Berkus PostgreSQL Experts Inc. http://... 11 Jun 2010 19:15
[HACKERS] pg_upgrade output directory Why does pg_upgrade create its output directory in the user's home directory (or TMP on Windows)? I should have thought that the current working directory would be a more suitable choice. At the very least there should be an option for where to create it. Also, this location doesn't seem to be referred to at... 11 Jun 2010 10:19 |