FAQ

PostgreSQL > pgsql-hackers

Search Discussions

32,858 discussions - 261,686 posts

  • Seems like this might be a good idea to avoid the type of failure exhibited in bug #8128. We don't care too much about the readability of the dump script created during an upgrade, so it's hard to ...
    Tom LaneTom Lane
    Apr 30, 2013 at 11:55 pm
    Apr 30, 2013 at 11:55 pm
  • I think that at http://www.postgresql.org/docs/current/static/functions-admin.html and http://www.postgresql.org/docs/current/static/continuous-archiving.html two important points on how ...
    Dmitry KoterovDmitry Koterov
    Apr 30, 2013 at 10:25 pm
    Apr 30, 2013 at 11:36 pm
  • I did a little more research on this. The Oracle equivalent of WITH NO DATA is apparently BUILD DEFERRED. And as far as I can see, if you specify BUILD DEFERRED when creating the view, then it just ...
    Robert HaasRobert Haas
    Apr 30, 2013 at 5:46 pm
    Apr 30, 2013 at 6:39 pm
  • 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
  • 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'd rather leave the Startup process alone, it does too much already. It's easy enough to start a new process that can run SQL properly after the Startup process has gone, maybe we can have more than ...
    Simon RiggsSimon Riggs
    Apr 29, 2013 at 5:07 am
    Apr 29, 2013 at 5:07 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
  • After a bit of discussion, the core committee has decided that we're not really ready to wrap a credible beta1 candidate tomorrow. There are several unresolved issues such as what to do about ...
    Tom LaneTom Lane
    Apr 28, 2013 at 6:22 pm
    Apr 28, 2013 at 6:22 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
  • The pg_resetxlog -m option was changed from -m XID set next multitransaction ID to -m XID,OLDEST set next multitransaction ID and oldest value but the man page does not reflect that change. It was ...
    Peter EisentrautPeter Eisentraut
    Apr 28, 2013 at 1:23 am
    Apr 28, 2013 at 1:23 am
  • Hello All, I've been doing some extensive modifications of the storage manager (md.c) in postgres. My code all compiles just fine, but when i run initdb, i receive the following output: "creating ...
    Will Childs-KleinWill Childs-Klein
    Apr 27, 2013 at 9:52 pm
    Apr 27, 2013 at 10:08 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
  • These two questions are about the correct coding practice in Postgresql vs the specifics of xact.c Is the main difference between: if (s- blockState != TBLOCK_SUBINPROGESS) elog(*FATAL*, ... vs ...
    Daniel WoodDaniel Wood
    Apr 27, 2013 at 3:24 am
    Apr 27, 2013 at 4:26 am
  • It seems the backend and libpq don't agree. The backend makes no special provision to wait for a CopyDone message if an error occurs during copy-both. It simply sends an ErrorResponse and that's it ...
    Robert HaasRobert Haas
    Apr 27, 2013 at 2:22 am
    Apr 27, 2013 at 10:12 pm
  • This needs back-patching to 9.1, where the bug was introduced. Cheers, David. -- David Fetter <<span class="m_body_email_addr" title="ebb53d621ad68a6e34eee7464153958c" [email protected]</span ...
    David FetterDavid Fetter
    Apr 26, 2013 at 11:47 pm
    Apr 27, 2013 at 2:22 am
  • After 87306184580c9c49717, if the postmaster dies without cleaning up (i.e. power outage), running "pg_ctl start" just gives this message and then exits: pg_ctl: another server might be running Under ...
    Jeff JanesJeff Janes
    Apr 26, 2013 at 10:09 pm
    Apr 30, 2013 at 2:01 am
  • 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
  • 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
  • After reviewing the threads and thinking about the various historical behaviors, I'm suggesting that we apply the attached, back-patched to 9.0, to fix the unintended changes from historical behavior ...
    Kevin GrittnerKevin Grittner
    Apr 25, 2013 at 11:29 pm
    Apr 29, 2013 at 6:13 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
  • Silly typo report. Line 3774 of lmgr's lock.c says: * Re-acquire a lock belonging to a transaction that was prepared, when * when starting up into hot standby mode. This has been the case since the ...
    Peter GeogheganPeter Geoghegan
    Apr 25, 2013 at 6:36 am
    Apr 25, 2013 at 11:11 am
  • Folks, The 2013 cluster-hackers meeting is less than a month away. If you are attending, and have topics of common interest to discuss, such as core APIs (i.e. event triggers are in, at least ...
    Josh BerkusJosh Berkus
    Apr 25, 2013 at 4:15 am
    Apr 25, 2013 at 4:15 am
  • 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
  • Hi, our internal testbuilds show a new warning on windows: src\bin\psql\command.c(2617): warning C4013: 'time' undefined; assuming extern returning int ...
    Andres FreundAndres Freund
    Apr 24, 2013 at 1:27 pm
    Apr 24, 2013 at 4:16 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
  • Thanks for the many suggestions on improving the 9.3 release notes. There were many ideas I would have never thought of. Please keep the suggestions coming. -- Bruce Momjian <<span ...
    Bruce MomjianBruce Momjian
    Apr 24, 2013 at 3:41 am
    Apr 26, 2013 at 12:23 am
  • The primary change we made to Postgres in order to support our own version of foreign data wrappers was a row-at-a-time execution for table functions. In standard Postgres, when you execute a table ...
    David GudemanDavid Gudeman
    Apr 24, 2013 at 1:09 am
    Apr 24, 2013 at 1:21 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • The function static char * path_encode(bool closed, int npts, Point *pt) is actually occasionally passed -1 as its first parameter to mean something like "neither" or "don't print any delimiters" ...
    Peter EisentrautPeter Eisentraut
    Apr 23, 2013 at 1:51 am
    Apr 23, 2013 at 1:51 am
  • 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
  • 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, 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
  • 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
  • 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
  • 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
  • A few years ago I wrote a roll-your-own foreign-data-wrapper system for Postgres because Postgres didn't have one at the time (some details ...
    David GudemanDavid Gudeman
    Apr 22, 2013 at 1:57 am
    Apr 25, 2013 at 4:24 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
  • Hi all, I have been writing pg extensions for a while but I just ran into a problem that has me stumped. I have code for a SRF and it works fine on pg 9.2.2 on linux, but fails with am error in the ...
    Stephen WoodbridgeStephen Woodbridge
    Apr 20, 2013 at 8:36 pm
    Apr 21, 2013 at 3:32 am
  • Do we really want to generate just a warning for a checksum failure, and not an error; see PageIsVerified(). -- Bruce Momjian <<span class="m_body_email_addr" title="ecaa579ddbd27537b4ac50a26f1814a9" ...
    Bruce MomjianBruce Momjian
    Apr 20, 2013 at 12:54 pm
    Apr 21, 2013 at 6:36 pm
  • Hello All, I'm writing today to inquire about finding the exact point in the source where postgres writes to disk. I'm trying to implement some compression in postgres. The idea is to compress the ...
    Will Childs-KleinWill Childs-Klein
    Apr 19, 2013 at 3:17 pm
    Apr 19, 2013 at 4:32 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
  • 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
  • When archive_command fails three times, it prints this message into the logs: "transaction log file \"%s\" could not be archived: too many failures" This leaves it open what happens next. What will ...
    Peter EisentrautPeter Eisentraut
    Apr 18, 2013 at 2:02 am
    Apr 19, 2013 at 8:58 pm
  • I'm wondering how I can store word-level bigrams/trigrams in a tsvector that I can query against. I was expecting the final query to match "the air" and return the one tuple to me. For instance ...
    Alan LiAlan Li
    Apr 17, 2013 at 9:46 pm
    Apr 17, 2013 at 9:46 pm
  • Hi all, The attached patch fix a little typo on contrib/hstore/crc32.c comment. Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL
    Fabrízio de Royes MelloFabrízio de Royes Mello
    Apr 17, 2013 at 7:58 pm
    Apr 19, 2013 at 1:33 pm
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
grouppgsql-hackers @
Notice: Undefined variable: pl_domain_short in /home/whirl/sites/grokbase/root/www/public_html__www/cc/flow/grp.php on line 466
categoriespostgresql
discussions32,858
posts261,686
users6,606
websitepostgresql.org...
irc#postgresql

Top users

Tom Lane: 42168 posts Bruce Momjian: 11386 posts Robert Haas: 11298 posts Peter Eisentraut: 7399 posts Simon Riggs: 6776 posts Andrew: 6741 posts Bruce Momjian: 6653 posts Bruce Momjian: 5548 posts Alvaro Herrera: 4373 posts Marc G. Fournier: 4372 posts Josh Berkus: 3525 posts Magnus Hagander: 3262 posts Heikki Linnakangas: 3057 posts Kevin Grittner: 2715 posts Thomas G. Lockhart: 2519 posts Joshua D. Drake: 2475 posts Christopher: 2390 posts Pavel Stehule: 2351 posts Gregory Stark: 1774 posts Fujii Masao: 1763 posts
show more
Archives