FAQ

PostgreSQL > pgsql-hackers > April 2013

Search Discussions

122 discussions - 1,283 posts

  • Hello, We have been trying to figure out possible solutions to the following problem in streaming replication Consider following scenario: If master receives commit command, it writes and flushes ...
    Samrat RevagadeSamrat Revagade
    Apr 8, 2013 at 10:34 am
    Apr 21, 2013 at 12:43 pm
  • The schedule says we're going to wrap 9.3beta1 on Monday, but it doesn't feel to me like we are anywhere near ready to ship a credible beta. Of the items on the 9.3 open-items page, ...
    Tom LaneTom Lane
    Apr 27, 2013 at 2:59 pm
    Apr 30, 2013 at 9:19 pm
  • I've changed the subject from "regression test failed when enabling checksum" because I now know they are totally unrelated. My test case didn't need to depend on archiving being on, and so with a ...
    Jeff JanesJeff Janes
    Apr 3, 2013 at 10:58 pm
    Apr 30, 2013 at 9:54 pm
  • I am not sure if Tom shared yet, but we are planning to package 9.3 beta1 on April 29, with a release on May 2. Those dates might change, but that is the current plan. I have completed a draft 9.3 ...
    Bruce MomjianBruce Momjian
    Apr 21, 2013 at 5:02 am
    Apr 28, 2013 at 12:30 am
  • COPY cannot be optimised correctly if we have before triggers or volatile default expressions. The multi-insert code detects those cases and falls back to the single row mechanism in those cases ...
    Simon RiggsSimon Riggs
    Apr 15, 2013 at 2:01 pm
    Apr 16, 2013 at 3:44 pm
  • Starting a new thread to more narrowly address the topic. Attached is my reorganization of Ants's patch here: http://www.postgresql.org/message-id/CA +<span class="m_body_email_addr" ...
    Jeff DavisJeff Davis
    Apr 23, 2013 at 7:17 am
    Apr 30, 2013 at 11:53 pm
  • I just found out that if you use continuous archiving and online backups, it's surprisingly difficult to restore a backup, without replaying any more WAL than necessary. If you don't set a recovery ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 18, 2013 at 6:11 pm
    Apr 26, 2013 at 5:13 pm
  • Hi all, Inspired by the awesome work done by Oleg sir in HStore, I have been thinking about making a graph data type as an extension in postgres. I have been reading about graph databases and how ...
    Atri SharmaAtri Sharma
    Apr 28, 2013 at 5:06 am
    Apr 30, 2013 at 12:34 pm
  • Hi, I find problem about failing start-up achive recovery at Standby mode in PG9.2.4 streaming replication. I test same problem in PG9.2.3. But it is not occerd... We search this problem patch in ...
    KONDO MitsumasaKONDO Mitsumasa
    Apr 24, 2013 at 8:40 am
    Apr 26, 2013 at 11:46 am
  • Existing: pg_get_constraintdef pg_get_indexdef pg_get_viewdef pg_get_triggerdef pg_get_functiondef pg_get_ruledef Missing: pg_get_ts_templatedef pg_get_ts_parserdef pg_get_ts_configdef ...
    Joel JacobsonJoel Jacobson
    Apr 29, 2013 at 9:16 pm
    Apr 30, 2013 at 10:31 pm
  • I'm having trouble finding documentation about how to write event triggers. The chapter in the documentation http://www.postgresql.org/docs/devel/static/event-triggers.html says they can be written ...
    Peter EisentrautPeter Eisentraut
    Apr 16, 2013 at 3:57 am
    Apr 26, 2013 at 7:39 am
  • Hi all, I'd like to introduce myself to the dev community. I am Shuai Fan, a student from Dalian University of Technology, DLUT , for short, China. And I am interested in working with PostgreSQL ...
    帅帅
    Apr 10, 2013 at 2:54 pm
    Apr 20, 2013 at 8:27 pm
  • After quite a bit of hair-pulling trying to install Fedora 19 Alpha, I've been able to reproduce the initdb-time failure that's currently being seen on buildfarm member anchovy, and was also ...
    Tom LaneTom Lane
    Apr 5, 2013 at 10:14 pm
    Apr 30, 2013 at 3:04 pm
  • I guess I'm a couple releases late to review the "autovacuum truncate exclusive lock" patch (a79ae0bc0d454b9f2c95a), but this patch did not only affect autovac, it affects manual vacuum as well (as ...
    Jeff JanesJeff Janes
    Apr 11, 2013 at 6:45 am
    Apr 18, 2013 at 3:46 pm
  • Just today one of my systems experienced a kernel panic, and halted abruptly. Running Linux 3.1.9, PostgreSQL 9.0.4 (Debian 9.0.4-1+b1, to be precise). The system was moderately active, i.e. about ...
    Stephen R. van den BergStephen R. van den Berg
    Apr 9, 2013 at 4:21 pm
    Apr 10, 2013 at 7:06 am
  • Ah. Andres Freund found it, after Dimitri prodded me on IM after Andrew's today mailing list post -- the problem is the new UTILITY_BEGIN_QUERY macro. Or, more accurately, the fact that this macro is ...
    Alvaro HerreraAlvaro Herrera
    Apr 9, 2013 at 3:44 pm
    Apr 30, 2013 at 8:50 am
  • We never reached a consensus on the user interface of the new 'fast promotion'. We should settle that before beta. The thread died here ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 22, 2013 at 7:13 am
    Apr 24, 2013 at 9:24 am
  • Hello. I created a type my_uint that is a unsigned int 32. I am trying to update data of a table that contains a column of this type. Here is what happens: postgresql= explain analyze UPDATE ...
    Rodrigo BarbozaRodrigo Barboza
    Apr 5, 2013 at 10:27 pm
    Apr 10, 2013 at 4:59 am
  • Folks, The "FOR ROLE" syntax is completely broken, as of 9.2.4. Not sure when exactly this got broken; I remember it working sometime in the past: [jberkus@pgx-test ~]$ psql -U postgres analytics2 ...
    Josh BerkusJosh Berkus
    Apr 29, 2013 at 12:01 am
    Apr 30, 2013 at 12:26 am
  • Hi, We are seeing some overall performance degradation in our application since we installed the security release. Other commits were also done at the same time in the application so we don't know ...
    Anne RossetAnne Rosset
    Apr 22, 2013 at 5:38 pm
    Apr 23, 2013 at 3:47 pm
  • My first message has been banned for too many latters. Hi all There is something wrong and ugly. 1) Intel 32 core = 2*8 *2threads Linux avi-sql09 2.6.32-5-amd64 #1 SMP Sun May 6 04:00:17 UTC 2012 ...
    Миша ТюринМиша Тюрин
    Apr 22, 2013 at 6:22 pm
    Apr 28, 2013 at 11:18 am
  • Hi, I have observed that following sequence is causing server crash. CREATE MATERIALIZED VIEW temp_class_mv AS SELECT * FROM pg_class WITH NO DATA; CREATE OR REPLACE FUNCTION test_refresh_mv() ...
    Jeevan ChalkeJeevan Chalke
    Apr 22, 2013 at 1:05 pm
    Apr 24, 2013 at 1:48 pm
  • I think his point is why don't we clear currval() on DISCARD ALL? I can't think of a good reason we don't. He is saying currval() should throw an error after DISCARD ALL: test= SELECT ...
    Bruce MomjianBruce Momjian
    Apr 16, 2013 at 8:48 pm
    Apr 19, 2013 at 4:03 pm
  • I'm not sure who is supposed to be able to read this sort of stuff: Latest checkpoint's NextXID: 0/7575 Latest checkpoint's NextOID: 49152 Latest checkpoint's NextMultiXactId: 7 Latest checkpoint's ...
    Peter EisentrautPeter Eisentraut
    Apr 26, 2013 at 3:07 am
    Apr 26, 2013 at 4:31 pm
  • Hello, The current process of transferring data files from one cluster to another by using pg_dump and pg_restore is time consuming. The proposed tool tries to make migration faster for tables and ...
    Sameer ThakurSameer Thakur
    Apr 12, 2013 at 9:20 am
    Apr 13, 2013 at 6:46 am
  • Hi All, Currently the -j option to pg_restore, which allows for parallelization in the restore, can only be used if the input file is a regular file and not, for ex., a pipe. However this is a pretty ...
    Timothy GarnettTimothy Garnett
    Apr 23, 2013 at 11:54 pm
    Apr 25, 2013 at 9:06 pm
  • psql currently collects the query result rows in memory before writing them to a file and can cause out of memory problems for large results in low memory environments like ec2. I can't use COPY TO ...
    Christopher ManningChristopher Manning
    Apr 23, 2013 at 3:31 pm
    Apr 29, 2013 at 8:33 pm
  • We are nearing April 15 --- are we nearing a time when we can close 9.3 development and start focusing on the beta? -- Bruce Momjian <<span class="m_body_email_addr" ...
    Bruce MomjianBruce Momjian
    Apr 11, 2013 at 2:48 pm
    Apr 14, 2013 at 3:57 am
  • Hackers, I am working on scripts to copy data from Oracle via oracle_fdw. They each do something like this: CREATE SCHEMA migrate_stuff; SET search_path TO migrate_stuff,public; CREATE EXTENSION ...
    David E. WheelerDavid E. Wheeler
    Apr 2, 2013 at 10:19 pm
    Apr 5, 2013 at 4:32 pm
  • Hi all, I noticed the need to simply stop a bgworker after its work is done but still have it restart in unusual circumstances like a crash. Obviously I can just have it enter a loop where it checks ...
    Andres FreundAndres Freund
    Apr 23, 2013 at 1:48 pm
    Apr 25, 2013 at 4:06 pm
  • The materialized views patch adjusted ExplainOneQuery to take an additional DestReceiver argument, but failed to add a matching argument to the definition of ExplainOneQuery_hook. This makes the hook ...
    Robert HaasRobert Haas
    Apr 9, 2013 at 2:00 pm
    Apr 9, 2013 at 6:17 pm
  • Hello, Please find attached a small patch to add a throttling capability to pgbench, that is pgbench aims at a given client transaction rate instead of maximizing the load. The throttling relies on ...
    Fabien COELHOFabien COELHO
    Apr 29, 2013 at 12:42 pm
    Apr 29, 2013 at 10:40 pm
  • I looked into the problem reported at http://www.postgresql.org/message-id/E1UPa3B-0004K0-PJ@wrigleys.postgresql.org which is that we're deriving a bogus plan for this query: SELECT * FROM ( SELECT ...
    Tom LaneTom Lane
    Apr 11, 2013 at 5:25 pm
    Apr 29, 2013 at 8:24 pm
  • In current 9.3, I see: $ select p.proname, p.provolatile from pg_proc p join pg_namespace n on p.pronamespace = n.oid where n.nspname = 'pg_catalog' and p.proname ~ 'json'; proname | provolatile ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Apr 15, 2013 at 3:17 pm
    Apr 15, 2013 at 11:55 pm
  • [ pokes around ... ] You certain 9.2.3 didn't do this too? This appears to be an intentional behavior of the 9.2.3 patch that made it cancel truncation when there were conflicting lock requests: /* * ...
    Tom LaneTom Lane
    Apr 11, 2013 at 11:59 pm
    Apr 12, 2013 at 5:34 pm
  • While playing with Alexander's pg_trgm regexp patch, I noticed that the regexp library trips an assertion (if enabled) or crashes, when passed an input string that contains more than 32k different ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 3, 2013 at 3:11 pm
    Apr 4, 2013 at 4:53 pm
  • Hi All, If group by clause has primary key, the targetlist may have columns which are not part of the aggregate and not part of group by clause. The relevant commit is ...
    Ashutosh BapatAshutosh Bapat
    Apr 26, 2013 at 1:49 pm
    Apr 30, 2013 at 5:51 am
  • Folks, While testing the upcoming FILTER clause for aggregates, Erik Rijkers uncovered a long-standing bug in $subject, namely that this case wasn't handled. Please find attached a patch by Andrew ...
    David FetterDavid Fetter
    Apr 23, 2013 at 4:57 pm
    Apr 26, 2013 at 7:50 pm
  • Hello, I was playing with pg_xlogdump in the HEAD and found a few issues. 1. Tried compiling pg_xlogdump via PGXS mechanism and it fails with the following error: make: *** No rule to make target ...
    Pavan DeolaseePavan Deolasee
    Apr 23, 2013 at 9:21 am
    Apr 23, 2013 at 6:12 pm
  • While trying out CURRENT OF with foreign table, ending up with error. postgres=# select version(); version ...
    Rushabh LathiaRushabh Lathia
    Apr 19, 2013 at 12:01 pm
    Apr 19, 2013 at 5:38 pm
  • Hi, I'm regularly using pg_stat_database view to analyze various aspects of behavior of the cluster. The #1 issue I'm constantly running into is that to get cluster-level view (across all the ...
    Tomas VondraTomas Vondra
    Apr 6, 2013 at 7:51 pm
    Apr 16, 2013 at 10:19 pm
  • Hi, Debian has been patching pg_regress for years because our default unix socket directory is /var/run/postgresql, but that is not writable by the build user at build time. This used to be a pretty ...
    Christoph BergChristoph Berg
    Apr 9, 2013 at 12:08 pm
    Apr 15, 2013 at 8:18 pm
  • I have also tried those, but they didn't work that's why I have proposed this feature in 9.3 Please send mail on community list, others can also help you if they have any idea for avoiding such ...
    Amit KapilaAmit Kapila
    Apr 10, 2013 at 9:35 am
    Apr 10, 2013 at 2:56 pm
  • Hello. I'm trying to create a generic add function. I have defined a type my_uint and it needs a '+' operator. This operator should work like normal int + int operation. The function is defined ...
    Rodrigo BarbozaRodrigo Barboza
    Apr 3, 2013 at 3:26 pm
    Apr 3, 2013 at 9:38 pm
  • Noah Misch pointed out something interesting to me: /* * PQputCopyEnd - send EOF indication to the backend during COPY IN * * After calling this, use PQgetResult() to check command completion ...
    Robert HaasRobert Haas
    Apr 22, 2013 at 7:04 pm
    Apr 26, 2013 at 8:10 pm
  • If I create a database and install postgis as an extension, and then run pg_dump I get this: [...] CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public; [...] CREATE RULE geometry_columns_delete ...
    Joe ConwayJoe Conway
    Apr 6, 2013 at 11:49 pm
    Apr 26, 2013 at 7:35 pm
  • Hm. I guess the reason nobody noticed this before now is that generally the idea with CREATE INDEX CONCURRENTLY is to minimize the impact on system load, hence you wouldn't do more than one at a ...
    Tom LaneTom Lane
    Apr 25, 2013 at 5:17 pm
    Apr 26, 2013 at 4:00 pm
  • With the stats file split patch 187492b6c2e8cafc5 introduced in 9.3dev, now after a crash the postmaster will try to delete all files in the directory stats_temp_directory. When that is just a ...
    Jeff JanesJeff Janes
    Apr 24, 2013 at 11:12 pm
    Apr 26, 2013 at 3:40 pm
  • Greetings, Hello, my name is Michael Schuh and I am a PhD student in Computer Science at Montana State University. I have never participated in GSOC before, but I am very excited to propose a project ...
    Michael SchuhMichael Schuh
    Apr 22, 2013 at 12:28 pm
    Apr 24, 2013 at 7:11 pm
  • Hello, Many of the links in the TODO wiki page result in a "page not found" error. Is this page up-to-date? Can anything be inferred about the status of these items from the broken link? Thanks ...
    Stephen ScheckStephen Scheck
    Apr 17, 2013 at 4:21 am
    Apr 17, 2013 at 1:27 pm
Apr 2013
123
Group Navigation
period‹ prev | Apr 2013 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions122
posts1,283
users131
websitepostgresql.org...
irc#postgresql

131 users for April 2013

Tom Lane: 166 posts Robert Haas: 89 posts Andres Freund: 77 posts Simon Riggs: 61 posts Bruce Momjian: 49 posts Ants Aasma: 40 posts Jeff Davis: 40 posts Kevin Grittner: 40 posts Alvaro Herrera: 39 posts Heikki Linnakangas: 34 posts Jeff Janes: 31 posts Peter Eisentraut: 30 posts Dimitri Fontaine: 27 posts Florian Pflug: 23 posts Amit Kapila: 22 posts Rodrigo Barboza: 20 posts Stephen Frost: 20 posts Andrew Dunstan: 19 posts Josh Berkus: 17 posts Merlin Moncure: 15 posts
show more
Archives