FAQ

PostgreSQL > pgsql-hackers > September 2010

Search Discussions

155 discussions - 2,173 posts

  • Awhile back I ranted about replacing the planner's concept of inner indexscans with a more generalized notion of "parameterized paths": ...
    Tom LaneTom Lane
    Sep 2, 2010 at 9:31 pm
    Nov 10, 2011 at 2:06 am
  • 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
  • All, While working on some database maintenance, I was just tripped up by the fact that there is no good way to query reloptions for tables. By "no good way" I mean "no way which does not involve ...
    Josh BerkusJosh Berkus
    Sep 27, 2010 at 5:19 am
    Feb 26, 2011 at 5:49 pm
  • Can someone update the PostgreSQL shared memory usage table for 9.0? http://www.postgresql.org/docs/9.0/static/kernel-resources.html#SYSVIPC Right now it says "Approximate shared memory bytes ...
    Bruce MomjianBruce Momjian
    Sep 13, 2010 at 8:44 pm
    Feb 21, 2011 at 3:08 am
  • Greetings, After watching a database import go abysmally slow on a pretty beefy box with tons of RAM, I got annoyed and went to hunt down why in the world PG wasn't using but a bit of memory. Turns ...
    Stephen FrostStephen Frost
    Sep 20, 2010 at 4:51 pm
    Feb 20, 2011 at 2:42 pm
  • In http://www.postgresql.org/docs/9.0/static/tutorial-window.html it say "Although avg will produce the same result no matter what order it processes the partition's rows in, this is not true of all ...
    Dennis BjörklundDennis Björklund
    Sep 22, 2010 at 10:35 am
    Feb 20, 2011 at 5:02 am
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Hello who is psycopg maintainer, please? Can somebody explains to me, why psycopg doesn't support twophase commit still, although some implementation was done in summer 2008? Now two phase commit is ...
    Pavel StehulePavel Stehule
    Sep 18, 2010 at 4:02 pm
    Nov 6, 2010 at 4:34 pm
  • 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
  • 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, Is there any reason the postmaster.pid and external_pid_file contents to be different? -- Euler Taveira de Oliveira http://www.timbira.com/
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Sep 30, 2010 at 12:18 am
    Oct 19, 2010 at 3:09 am
  • 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
  • In about a week I propose to have the buildfarm server start to reject results based on snapshots where the newest file is older than the time of the git migration a week ago. That means buildfarm ...
    Andrew DunstanAndrew Dunstan
    Sep 27, 2010 at 12:13 pm
    Oct 15, 2010 at 9:32 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
  • 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
  • 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
  • Attached is a small patch that adds a few comments for the settings that require restart. Applicable for 9.0+. Regards, -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer ...
    Devrim GündüzDevrim Gündüz
    Sep 27, 2010 at 8:58 am
    Oct 14, 2010 at 5:18 pm
  • 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
  • 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
  • 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
  • Where does PGXS makefile get /usr/share/doc/pgsql/contrib directory from? While building 3rd party RPMs using PGXS, even if I specify docdir in Makefile, README.* files are installed to this ...
    Devrim GündüzDevrim Gündüz
    Sep 19, 2010 at 9:25 pm
    Oct 12, 2010 at 1:50 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
  • 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
  • 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
  • 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
  • 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
  • -- 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
  • I just discovered the --patience flag on the git diff command, and I'd like to suggest that we encourage people to use it when possible for building patches. I just looked at output with and without ...
    Kevin GrittnerKevin Grittner
    Sep 15, 2010 at 5:58 pm
    Oct 1, 2010 at 9:53 pm
  • Can we please change the comment lines below the patch heading to have the real name instead of the postgresql.org ID? Patch by Pavel Stehule Patch by Gurjeet Singh instead of Patch by okbobcz Patch ...
    Gurjeet SinghGurjeet Singh
    Sep 30, 2010 at 9:38 pm
    Oct 1, 2010 at 6:06 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
  • (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
  • Hackers, Any tips / conventional wisdom regarding running postgres on large- ish memory ccNUMA intel machines, such as a 32G dual-quad-core, showing two NUMA nodes of 16G each? I expect each postgres ...
    James RobinsonJames Robinson
    Sep 29, 2010 at 7:15 pm
    Oct 1, 2010 at 1:32 am
  • Attached is a patch that implements replacing a primary key with another index. This would help overcome the limitation that primary keys cannot be reindexed without taking exclusive locks. The use ...
    Gurjeet SinghGurjeet Singh
    Sep 30, 2010 at 12:43 am
    Sep 30, 2010 at 8:33 pm
  • Hello The attached patch contains a implementation of "subscripts" function. The functionality of this function is same like generate_subscripts function, but it's based for iteration from plpgsql's ...
    Pavel StehulePavel Stehule
    Sep 30, 2010 at 7:29 pm
    Sep 30, 2010 at 7:29 pm
  • Hello, I propose a new hook type - that helps with controlling a life cycle of some tsearch dictionaries. This hook has minimal impact on performance - it's called once per session for one tsearch ...
    Pavel StehulePavel Stehule
    Sep 5, 2010 at 6:37 am
    Sep 30, 2010 at 9:37 am
  • Hello This patch add iteration over array to plpgsql now is supported only iteration over scalar array Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Sep 30, 2010 at 8:03 am
    Sep 30, 2010 at 8:55 am
  • Hi, Starting from 9.0, it seems unable to generate man pages for Japanese translated sgml(generating html is ok). Until 8.4 it worked fine. Does anybody succeeded in generating non English/multibyte ...
    Tatsuo IshiiTatsuo Ishii
    Sep 29, 2010 at 2:23 pm
    Sep 30, 2010 at 6:11 am
  • Hello What is the way to get tupledesc from array of records? Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Sep 29, 2010 at 7:23 pm
    Sep 29, 2010 at 7:23 pm
  • I'm not subscribed to pgsql-committers, but apparently under the new git-enabled setup, I'm getting a "Stalled post to pgsql-committers" message for every commit. Fix that please.
    Peter EisentrautPeter Eisentraut
    Sep 25, 2010 at 4:43 pm
    Sep 29, 2010 at 7:16 pm
  • Hello, just doing an upgrade form PostgreSQL 8.4.4 on Windows 2007 64bit to PostgreSQL 9.0 64bit on the same system. I am working along http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html ...
    Massa, Harald ArminMassa, Harald Armin
    Sep 26, 2010 at 9:42 am
    Sep 29, 2010 at 6:27 pm
  • When we drop an operator used by other operators as COMMUTATOR or NEGATOR, pg_dump generates an invalid SQL command for the operators depending on the dropped one. Is it an unavoidable restriction? ...
    Itagaki TakahiroItagaki Takahiro
    Sep 29, 2010 at 7:56 am
    Sep 29, 2010 at 3:25 pm
  • Does the git.postgresql.org down? Harada-san being also unreachable now. -- KaiGai Kohei <kaigai@kaigai.gr.jp
    KaiGai KoheiKaiGai Kohei
    Sep 29, 2010 at 11:44 am
    Sep 29, 2010 at 12:09 pm
Sep 2010
1234
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