FAQ

Search Discussions

155 discussions - 2,173 posts

  • This is just speculation at this point, because I haven't taken time to think through the details, but couldn't we improve on that still further? There are always going to be some conditions that we ...
    Tom LaneTom Lane
    Sep 15, 2010 at 2:02 pm
    Sep 24, 2010 at 3:30 pm
  • Hello. This is a proposal patch for SQL/MED for 9.1. At the prev. CF, this patch had so many features to make it hard to review all of them. So I devided it into smaller parts: (1) foreign table DDL ...
    SAKAMOTO MasahikoSAKAMOTO Masahiko
    Sep 15, 2010 at 6:04 am
    Oct 15, 2010 at 1:33 am
  • Hello this patch implement a new iteration construct - iteration over an array. The sense of this new iteration is: * a simple and cleaner syntax * a faster execution - this bring down a number of ...
    Pavel StehulePavel Stehule
    Sep 30, 2010 at 12:46 pm
    Nov 24, 2010 at 6:07 pm
  • hello everybody, we came across an issue which turned out to be more serious than previously expected. imagine a system with, say, 1000 partitions (heavily indexed) or so. the time taken by the ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Sep 3, 2010 at 9:40 am
    Nov 13, 2010 at 10:26 pm
  • I've spent much of the weekend examining the discrepancies between our CVS repository and the tarballs available from our FTP archives, and after that trying to remove infelicities in the cvs2git ...
    Tom LaneTom Lane
    Sep 13, 2010 at 3:03 am
    Sep 20, 2010 at 11:35 am
  • I noticed in postgres you cannot return multiple result sets from a stored procedure (surprisingly as it looks like a very good dbms). I would like to suggest adding this feature. - It is very ...
    John AdamsJohn Adams
    Sep 2, 2010 at 10:25 pm
    Sep 10, 2010 at 3:27 pm
  • Hi! CVS has been frozen, and all commit access locked out. Since there haven't been any commits in cvs during the day, the test conversoin I created after lunch should be identical to a new one I'd ...
    Magnus HaganderMagnus Hagander
    Sep 20, 2010 at 4:49 pm
    Sep 22, 2010 at 11:47 pm
  • Reference: https://commitfest.postgresql.org/action/patch_view?id=312 The patch from http://archives.postgresql.org/message-id/CA2E4C4762EAE28D68404E75@amenophis does not apply cleanly to the current ...
    Andrew GeeryAndrew Geery
    Sep 30, 2010 at 3:05 am
    Jun 29, 2011 at 10:42 pm
  • Dear All, I have just generate a new patch of MERGE command. One main change in this edition is the removal of RASIE ERROR action from MEREG, because its semantics is not well defined yet. I also ...
    Boxuan ZhaiBoxuan Zhai
    Sep 23, 2010 at 10:31 am
    Nov 12, 2010 at 6:05 pm
  • Back here I asked what we were going to do about .gitignore files: http://archives.postgresql.org/pgsql-hackers/2010-08/msg01232.php The thread died off when the first git conversion attempt crashed ...
    Tom LaneTom Lane
    Sep 21, 2010 at 4:00 am
    Oct 11, 2010 at 7:28 am
  • So, I found (with some helpful hints from Robert who caught the final nail in the coffin) a good reason why we really can't run a git-cvsserver globally. Any user can point their cvs client at the ...
    Magnus HaganderMagnus Hagander
    Sep 22, 2010 at 2:03 pm
    Oct 12, 2010 at 9:07 pm
  • Attached is the latest Serializable Snapshot Isolation (SSI) patch. With Joe's testing and review, and with stress tests adapted from those used by Florian for his patch, we were able to identify and ...
    Kevin GrittnerKevin Grittner
    Sep 14, 2010 at 4:35 pm
    Sep 26, 2010 at 3:52 am
  • It's been discussed before that it would be cool if you could stream a new base backup from the master server, via libpq. That way you would not need low-level filesystem access to initialize a new ...
    Heikki LinnakangasHeikki Linnakangas
    Sep 3, 2010 at 11:19 am
    Sep 8, 2010 at 1:29 am
  • So we've got two patches that implement synchronous replication, and no agreement on which one, if either, should be committed. We have no agreement on how synchronous replication should be ...
    Robert HaasRobert Haas
    Sep 29, 2010 at 2:47 am
    Oct 14, 2010 at 10:28 pm
  • I took a quick look at the code, and from what I can tell this is because PQconnectionNeedsPassword() always returns false if a pgpass.conf has been used. There is no handling the case where pgpass ...
    Magnus HaganderMagnus Hagander
    Sep 24, 2010 at 1:23 pm
    Nov 27, 2010 at 4:10 pm
  • This patch allows external security providers to check privileges to create a new relation and to inform the security labels to be assigned on the new one. This hook is put on DefineRelation() and ...
    KaiGai KoheiKaiGai Kohei
    Sep 2, 2010 at 12:38 am
    Oct 19, 2010 at 4:34 am
  • Hi all! It seems that the git move has broken the generation of the automatic snapshot tarballs - has anybody yet looked into what it would take to move those to fetching from git? Stefan
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Sep 22, 2010 at 8:34 am
    Sep 24, 2010 at 9:34 pm
  • Hi, I noticed that there's no way to specify the location of recovery.conf in postgresql.conf. The pg_hba and pg_ident files can be altered, so I'm wondering why this file can't have a specified ...
    Thom BrownThom Brown
    Sep 26, 2010 at 9:57 pm
    Oct 3, 2010 at 10:38 am
  • Jayant Kumar did some benchmarking of InnoDB vs. PostgreSQL and PG came out 5 times faster. The benchmark isn't very thoroughly described, but it turns out not to matter. ...
    Robert HaasRobert Haas
    Sep 30, 2010 at 7:26 pm
    Oct 27, 2010 at 1:07 am
  • Following up on my previous patch [0], here is a fairly complete implementation of this feature. The general description and implementation outline of the previous message still apply. This patch ...
    Peter EisentrautPeter Eisentraut
    Sep 15, 2010 at 8:46 pm
    Nov 25, 2010 at 3:57 am
  • Hi, we are experimenting with modifying table partitioning so the ORDER BY clause can be pushed down to child nodes on the grounds that: 1. smaller datasets are faster to sort, e.g. two datasets that ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Sep 1, 2010 at 1:57 pm
    Oct 15, 2010 at 12:18 am
  • Hello I looked on some constructs that helps with iteration over array in plpgsql. I propose a following syntax: FOR var IN [array variable | array expression] LOOP .. END LOOP var - declared ...
    Pavel StehulePavel Stehule
    Sep 28, 2010 at 6:25 am
    Sep 29, 2010 at 5:20 am
  • Okay, so now that I've actually done a couple of multi-branch commits... I'm using the multiple-work-directory arrangement suggested on our wiki page. The work flow seems to boil down to: * Prepare ...
    Tom LaneTom Lane
    Sep 22, 2010 at 1:20 am
    Sep 22, 2010 at 4:52 pm
  • Hi, Back in 2002 these were proposed, what happened to them? http://archives.postgresql.org/pgsql-sql/2002-09/msg00406.php Also I note: colin@ruby:~/workspace/eyedb$ psql psql (8.4.4) Type "help" for ...
    Colin 't HartColin 't Hart
    Sep 20, 2010 at 2:30 pm
    Sep 26, 2010 at 3:03 am
  • Attached is the patch that tries to speedup prep_buildtree script, which is used in VPATH builds, from our configure script. The idea is to ask `find` to emit directory listing in depth-first order ...
    Gurjeet SinghGurjeet Singh
    Sep 27, 2010 at 2:16 am
    Nov 21, 2010 at 5:31 pm
  • The patch attached is based on the one rejected at the last CF for 9.0 last year. http://archives.postgresql.org/message-id/16303.1266023203@sss.pgh.pa.us This patch implements the feature that ...
    Hitoshi HaradaHitoshi Harada
    Sep 13, 2010 at 1:15 pm
    Oct 16, 2010 at 12:01 am
  • Uhm, could you stop massively changing the behavior of this script with no discussion at all? I happen to think that this is a distinctly bad idea. It defeats one of the major use cases of the ...
    Robert HaasRobert Haas
    Sep 26, 2010 at 3:48 pm
    Oct 14, 2010 at 9:43 am
  • -- http://developer.postgresql.org/pgdocs/postgres/sql-expressions.html#SYNTAX-AGGREGATES That, however, is not true of array_agg(): try=# CREATE TABLE foo(id int); CREATE TABLE try=# INSERT INTO foo ...
    David E. WheelerDavid E. Wheeler
    Sep 1, 2010 at 5:45 am
    Oct 2, 2010 at 2:58 am
  • All, I was just checking on our year-2027 compliance, and happened to notice that time with time zone takes up 12 bytes. This seems peculiar, given that timestamp with time zone is only 8 bytes, and ...
    Josh BerkusJosh Berkus
    Sep 22, 2010 at 9:01 pm
    Sep 25, 2010 at 10:21 am
  • Agreed. The attached patch introduces new function which is used to send ACK back from walreceiver. The function sends a message to XLOG stream by calling PQputCopyData. Also I allowed PQputCopyData ...
    Fujii MasaoFujii Masao
    Sep 17, 2010 at 9:22 am
    Dec 13, 2010 at 2:44 am
  • Hello this simple patch reduce a persistent allocated memory for tsearch ispell dictionaries. on 32bit from 27MB (3399 blocks) to 13MB (1564 blocks) on 64bit from 55MB to cca 27MB. Regards Pavel ...
    Pavel StehulePavel Stehule
    Sep 7, 2010 at 7:11 am
    Oct 7, 2010 at 12:01 am
  • I just went to do my usual merge from the git version of HEAD (at git://git.postgresql.org/git/postgresql.git), and it seemed to be doing an awful lot of work to prepare to attempt the merge. That ...
    Kevin GrittnerKevin Grittner
    Sep 21, 2010 at 3:29 pm
    Sep 22, 2010 at 5:20 pm
  • Hi, Is there any way to use regclass without having ERROR? pgpool-II needs to find the oid from table name and for the purpose it issues something like "SELECT 'table_name'::regproc::oid". Problem ...
    Tatsuo IshiiTatsuo Ishii
    Sep 3, 2010 at 8:28 am
    Jan 4, 2011 at 4:01 pm
  • Here is a patch for basic JSON support. It adds only those features: * Add "json" data type, that is binary-compatible with text. * Syntax checking on text to JSON conversion. * json_pretty() -- ...
    Itagaki TakahiroItagaki Takahiro
    Sep 15, 2010 at 2:33 am
    Oct 5, 2010 at 5:13 am
  • Everyone using git diff in color mode will already or soon be aware that psql, for what I can only think is an implementation oversight, produces trailing whitespace in the table headers, like this: ...
    Peter EisentrautPeter Eisentraut
    Sep 21, 2010 at 6:28 pm
    Sep 28, 2010 at 5:45 pm
  • On the Serializable Snapshot Isolation thread, Heikki pointed out a collection of objects in an HTAB which didn't really need its key on VirtualTransactionId, but there isn't really any other useful ...
    Kevin GrittnerKevin Grittner
    Sep 20, 2010 at 3:13 pm
    Sep 22, 2010 at 1:08 pm
  • There are some minor stylistic issues with this patch - e.g. lines ending in whitespace, cuddled elses - but those don't look too terribly difficult to fix. I'm more concerned about the fact that I ...
    Robert HaasRobert Haas
    Sep 24, 2010 at 8:01 pm
    Oct 13, 2010 at 4:31 pm
  • As has been previously mentioned a couple of times, it should be perfectly possible to use streaming replication to get around the limitations of archive_command/archive_timeout to do log archiving ...
    Magnus HaganderMagnus Hagander
    Sep 27, 2010 at 12:09 pm
    Oct 1, 2010 at 11:01 am
  • FYI, I have compiled/installed git 1.7.3.rc2 on my BSD/OS 4.3.1 machine with the attached minor changes. -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB http://enterprisedb.com + ...
    Bruce MomjianBruce Momjian
    Sep 17, 2010 at 9:02 pm
    Sep 20, 2010 at 5:35 pm
  • There are many comments in the code which use "serializable transaction" to mean "transaction snapshot based transaction". This doesn't matter much as long as REPEATABLE READ and SERIALIZABLE ...
    Kevin GrittnerKevin Grittner
    Sep 1, 2010 at 3:03 pm
    Sep 13, 2010 at 8:59 pm
  • (starting yet another thread to stay focused) Having mulled through all the recent discussions on synchronous replication, ISTM there is pretty wide consensus that having a registry of all standbys ...
    Heikki LinnakangasHeikki Linnakangas
    Sep 22, 2010 at 8:43 am
    Oct 1, 2010 at 11:01 am
  • Hello I have problems defining user-defined types and functions in PostgreSQL using a Visual C++ development environment. In order to look for the solution I took the complex.c and complex.source ...
    Esteban ZimanyiEsteban Zimanyi
    Sep 25, 2010 at 3:56 pm
    Sep 28, 2010 at 11:52 pm
  • Folks, While it's interesting to note, in an historical sense, that a platform most recently updated when 1999 was still in the future, I think it's time we did a little pruning. We can start by ...
    David FetterDavid Fetter
    Sep 22, 2010 at 8:18 pm
    Sep 22, 2010 at 11:07 pm
  • Howdy, Anyone ever thought to try to add $subject to PL/pgSQL? Someone left a [comment][] on the PGXN blog about how this is a supported syntax for using named parameters on Oracle. The context is to ...
    David E. WheelerDavid E. Wheeler
    Sep 7, 2010 at 4:24 pm
    Sep 9, 2010 at 4:12 pm
  • I'm working on a patch to implement synchronous replication for PostgreSQL, with user-controlled durability specified on the master. The design also provides high throughput by allowing concurrent ...
    Simon RiggsSimon Riggs
    Sep 14, 2010 at 5:49 pm
    Dec 14, 2010 at 12:47 am
  • Hello I would to use a special memory context for shared data (based on mmap) and I like impementation of aset. There is only one difference - aset is based on malloc and I would to use a mmap. ...
    Pavel StehulePavel Stehule
    Sep 7, 2010 at 8:54 am
    Sep 16, 2010 at 9:52 pm
  • Hello folks, I've been playing around today a lot with sysbench, and observed that 2.6.32 kernel supplied by Ubuntu is having perf regression with PG (which does not affect MySQL), compared to 2.6.28 ...
    Domas MituzasDomas Mituzas
    Sep 12, 2010 at 8:31 pm
    Oct 7, 2010 at 6:44 am
  • I have just come across a weird thing. It works for any table and seems to be not documented. SELECT c.name FROM (VALUES(1, 'A', true)) c; SELECT c.name FROM pg_class c; And it does not work in these ...
    Vlad ArkhipovVlad Arkhipov
    Sep 24, 2010 at 10:28 am
    Sep 24, 2010 at 4:17 pm
  • So my first attempt at using git cherry-pick didn't go so well. The commit in master looks like commit ee63981c1fe26299162b9c7f1218d7e3ef802409 Author: Tom Lane <tgl@sss.pgh.pa.us Date: Thu Sep 23 ...
    Tom LaneTom Lane
    Sep 23, 2010 at 7:52 pm
    Sep 24, 2010 at 3:23 pm
  • Hi, I note that the implementation of tab completion for SET TRANSACTION in PSQL could benefit from the implementation of autonomous transactions (also TODO). Regards, Colin
    Colin 't HartColin 't Hart
    Sep 15, 2010 at 7:37 am
    Sep 17, 2010 at 3:28 am
Group Navigation
period‹ prev | Sep 2010 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions155
posts2,173
users126
websitepostgresql.org...
irc#postgresql

126 users for September 2010

Tom Lane: 367 posts Robert Haas: 332 posts Heikki Linnakangas: 120 posts Magnus Hagander: 114 posts Pavel Stehule: 77 posts Simon Riggs: 74 posts Kevin Grittner: 73 posts Fujii Masao: 61 posts Bruce Momjian: 58 posts Andrew Dunstan: 54 posts Peter Eisentraut: 53 posts Itagaki Takahiro: 51 posts Alvaro Herrera: 49 posts Markus Wanner: 42 posts David Fetter: 36 posts Dimitri Fontaine: 33 posts Thom Brown: 31 posts Josh Berkus: 25 posts Dave Page: 24 posts David E. Wheeler: 23 posts
show more
Archives