Search Discussions

191 discussions - 2,404 posts

  • Hackers, WIP patch of fast GiST index build is attached. Code is dirty and comments are lacking, but it works. Now it is ready for first benchmarks, which should prove efficiency of selected ...
    Alexander KorotkovAlexander Korotkov
    Jun 3, 2011 at 11:03 am
    Feb 2, 2012 at 7:55 pm
  • If you set up a pgbench test case that hits the database with a lot of concurrent selects and non-exclusive-locking ALTER TABLEs, 9.1 soon falls over. For example: $ cat foo.script alter table ...
    Tom LaneTom Lane
    Jun 16, 2011 at 10:54 pm
    Aug 17, 2012 at 7:45 pm
  • I've now spent enough time working on this issue now to be convinced that the approach has merit, if we can work out the kinks. I'll start with some performance numbers. The case where the current ...
    Robert HaasRobert Haas
    Jun 3, 2011 at 1:18 pm
    Jun 9, 2011 at 1:30 pm
  • The attached patch adds contrib/sepgsql a cache mechanism for access control decision of SELinux. It shall reduce the total number of system call invocations to improve the performance on its access ...
    Kohei KaiGaiKohei KaiGai
    Jun 9, 2011 at 8:23 am
    Sep 27, 2011 at 12:38 pm
  • Following up on the idea we've been exploring for making some extensions more prominent, attached is the first rev that I think may be worth considering seriously. Main improvement from the last is ...
    Greg SmithGreg Smith
    Jun 9, 2011 at 4:15 am
    Feb 10, 2012 at 7:59 pm
  • Can someone explain why pg_stat_activity has a column named procpid and not simply pid? 'pid' is that pg_locks uses, and 'procpid' is redundant (proc-process-id). A mistake? -- Bruce Momjian ...
    Bruce MomjianBruce Momjian
    Jun 9, 2011 at 3:55 pm
    Jun 17, 2011 at 11:19 pm
  • Different ranges over the same subtype make sense when using different total orders for the subtype. This is most apparent with text collation, but makes sense (at least mathematically, if not ...
    Jeff DavisJeff Davis
    Jun 25, 2011 at 10:29 pm
    Jul 7, 2011 at 3:09 am
  • I'd like to take another look at Range Types and whether part of it should be an extension. Some of these issues relate to extensions in general, not just range types. First of all, what are the ...
    Jeff DavisJeff Davis
    Jun 5, 2011 at 6:59 pm
    Jun 21, 2011 at 8:31 am
  • You might remember we added a postmaster/postgres -b switch to indicate binary upgrade mode. The attached patch prevents any client without an application_name of 'binary-upgrade' from connecting to ...
    Bruce MomjianBruce Momjian
    Jun 15, 2011 at 3:01 am
    Jun 24, 2011 at 1:39 am
  • Hi I've recently wanted to define a check constraint on an array column that verifies that all array entries match some regular expression. Unfortunately, t The most natural way of expressing such a ...
    Florian PflugFlorian Pflug
    Jun 12, 2011 at 11:46 am
    Jun 20, 2011 at 5:32 pm
  • Hi Unfortunately, I found another way to produce invalid XML values. template1=# SELECT (XPATH('/*', XMLELEMENT(NAME "root", XMLATTRIBUTES('<' as xmlns))))[1]; xpath ------------------- <root ...
    Florian PflugFlorian Pflug
    Jun 1, 2011 at 1:17 am
    Jul 26, 2011 at 7:44 pm
  • We've occasionally seen problems with VACUUM getting stuck for failure to acquire a cleanup lock due to, for example, a cursor holding a pin on the buffer page. In the worst case, this can cause an ...
    Robert HaasRobert Haas
    Jun 5, 2011 at 3:07 am
    Nov 10, 2011 at 2:11 am
  • Pavel StehulePavel Stehule
    Jun 16, 2011 at 7:25 am
    Jun 28, 2011 at 8:29 pm
  • I fooled around with this a while back and saw no benefit. It's possible a more careful test would turn up something, but I think the only real way forward here is going to be to eliminate some of ...
    Robert HaasRobert Haas
    Jun 23, 2011 at 3:42 pm
    Jul 21, 2011 at 11:10 pm
  • Hi, I would like to propose support for per-column generic option, which is defined in the SQL/MED standard. In 9.0 release, support for foreign tables and per-table generic option have been added, ...
    Shigeru HanadaShigeru Hanada
    Jun 14, 2011 at 8:56 am
    Jul 18, 2011 at 7:31 pm
  • In the next couple of days it's going to be time to branch off REL9_1_STABLE from master, and I realized that I am pretty foggy on how to do that in git. I suppose it's some variant of git checkout ...
    Tom LaneTom Lane
    Jun 10, 2011 at 3:05 am
    Jun 14, 2011 at 12:48 pm
  • Hello, I partialy implemented following missing LOBs types. Requirement for this was to give ability to create (B/C)LOB columns and add casting functionality e.g. SET my_clob = 'My long text'. Idea ...
    Radosław SmoguraRadosław Smogura
    Jun 1, 2011 at 8:06 pm
    Jun 6, 2011 at 5:48 pm
  • Hello Attached patch implements a new erros's fields that describes table, colums related to error. This enhanced info is limited to constraints and RI. example: postgres=# create table omega(a int ...
    Pavel StehulePavel Stehule
    Jun 8, 2011 at 8:15 pm
    Jul 28, 2011 at 4:12 am
  • Hi hackers, At first I've posted to pgsql-docs but there is no reply at present. http://archives.postgresql.org/pgsql-docs/2011-06/msg00006.php So I post revised patch to pgsql-hackers, because the ...
    Shigeru HanadaShigeru Hanada
    Jun 9, 2011 at 10:12 am
    Jun 16, 2011 at 4:15 pm
  • Hello Hackers, There is some strange behavior we're experiencing with one of the customer's DBs (8.4) We've noticed that free disk space went down heavily on a system, and after a short analysis ...
    Alexander ShulginAlexander Shulgin
    Jun 3, 2011 at 9:53 pm
    Jun 9, 2011 at 9:43 pm
  • Robert Hass (whose name I misspelled in the commit message above) just mentioned to me (in an answer to my apologizing about it) that he didn't think that mentioning sponsors for patch development ...
    Alvaro HerreraAlvaro Herrera
    Jun 30, 2011 at 7:09 pm
    Nov 26, 2011 at 4:09 am
  • There's been a steady flow of messages on pgsql-advocacy since last month (threads "Crediting sponsors in release notes?" and "Crediting reviewers & bug-reporters in the release notes") talking about ...
    Greg SmithGreg Smith
    Jun 24, 2011 at 5:15 pm
    Jul 22, 2011 at 3:27 pm
  • Purpose & Goal -------------- Allow planner to create NestLoop with parameterized aggregate subquery just like inner IndexScan pattern. This helps to avoid unnecessary aggregate process that would be ...
    Hitoshi HaradaHitoshi Harada
    Jun 9, 2011 at 6:28 am
    Jul 27, 2011 at 3:50 pm
  • Here is a patch that applies over the "reducing the overhead of frequent table locks" (fastlock-v3) patch and allows heavyweight VXID locks to spring into existence only when someone wants to wait on ...
    Robert HaasRobert Haas
    Jun 12, 2011 at 9:39 pm
    Jul 24, 2011 at 5:53 pm
  • Hello, I'm sending following patch which disables optimization when --enable-debug is passed. It was nasty (for me, at least) that debug build required passing of CFLAGS with -O0 to get nice ...
    Radosław SmoguraRadosław Smogura
    Jun 16, 2011 at 12:31 pm
    Dec 2, 2011 at 10:10 pm
  • I don't think we should just steal a port from the reserved range. Picking a random port from the private/dynamic range seems more appropriate. I would prefer that all PostgreSQL-related environment ...
    Peter EisentrautPeter Eisentraut
    Jun 24, 2011 at 1:04 pm
    Jul 2, 2011 at 3:10 am
  • Hello. Reproduced under Windows XP SP3 using Visual C++ 2008 and Delphi. If PQsetvalue is called with second parameter equals to PQntuples then memory corruption appears. But it should grow internal ...
    Pavel GolubPavel Golub
    Jun 3, 2011 at 7:10 pm
    Jul 18, 2011 at 10:25 am
  • This is the second time I've had this happen in the last week or so. I have a 'regular' postgresql server running, and then test test setup (both llvm ang gcc). It's chewing up 1 core on my MBP, ...
    Robert CreagerRobert Creager
    Jun 7, 2011 at 12:05 am
    Jun 24, 2011 at 1:21 am
  • Attached is a WIP possible replacement for pgindent. Instead of a shell script invoking a mishmash of awk and sed, some of which is pretty impenetrable, it uses a single engine (perl) to do all the ...
    Andrew DunstanAndrew Dunstan
    Jun 22, 2011 at 12:27 am
    Aug 4, 2012 at 4:43 pm
  • Hi, There are some releases that autovacuum was enabled by default and, up to now there is an easy way to estimate the number of autovacuum workers. I tune it observing if the number of slots are ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Jun 8, 2011 at 10:01 pm
    Oct 14, 2011 at 5:31 pm
  • I believe I have found a bug in libpq COPY handling with non-blocking SSL connections. The bug manifests itself by dropping the connection in PGputCopyData() with "server closed the connection ...
    Martin PihlakMartin Pihlak
    Jun 9, 2011 at 2:39 pm
    Jul 25, 2011 at 7:33 am
  • Previous version (at7-alt-index-opfamily.patch): http://archives.postgresql.org/message-id/20110113230124.GA18733@tornado.gateway.2wire.net Design: ...
    Noah MischNoah Misch
    Jun 15, 2011 at 5:03 am
    Jul 19, 2011 at 2:31 pm
  • It makes wonders to take a couple of months break from looking at a piece of code, and then review it in detail again. It's like a whole new pair of eyes :-). Here's a bunch of small issues that I ...
    Heikki LinnakangasHeikki Linnakangas
    Jun 10, 2011 at 10:59 am
    Jul 7, 2011 at 7:10 pm
  • Done. Updated patch attached. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center
    Fujii MasaoFujii Masao
    Jun 14, 2011 at 5:08 am
    Jul 19, 2011 at 1:03 pm
  • The attached patch is a preparation to rework implementation of DROP statement using a common code. That intends to apply get_object_address() to resolve name of objects to be removed, and eventually ...
    Kohei KaiGaiKohei KaiGai
    Jun 14, 2011 at 12:07 pm
    Jun 28, 2011 at 1:24 am
  • In earlier discussions of how to improve WALInsertLock contention, it was observed that we must zero each new page before we advance the WAL insertion point. ...
    Simon RiggsSimon Riggs
    Jun 6, 2011 at 4:15 pm
    Oct 14, 2011 at 12:34 pm
  • AFAIK this won't have any effect. This change needs to go to through pgtranslation project. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL ...
    Devrim GündüzDevrim Gündüz
    Jun 20, 2011 at 12:03 pm
    Jun 21, 2011 at 3:19 pm
  • From a review of recent emails I've put together a list of what I'm going to try to do this evening, in order of attack. It's ambitious and I may well not get to the end tonight, but I wanted to get ...
    Kevin GrittnerKevin Grittner
    Jun 8, 2011 at 10:48 pm
    Jun 17, 2011 at 4:45 am
  • Hi Tom, Issue is on Windows: If you see in attached failure.out file, (after running failure.sql) we are getting "ERROR: invalid byte sequence for encoding "UTF8": 0xe59aff" error. Please note that ...
    Jeevan ChalkeJeevan Chalke
    Jun 7, 2011 at 7:43 am
    Jun 9, 2011 at 7:14 pm
  • Hello. I'm some kind of PQdeleteTuple function will be very usefull in libpq. Because right now after deleting some record I need refetch result set, or mark tuple as deleted and this is headache for ...
    Pavel GolubPavel Golub
    Jun 1, 2011 at 3:43 pm
    Jun 3, 2011 at 5:54 am
  • Yes, while here I noticed that the query was long to be killed. I added a CHECK_FOR_INTERRUPT() in the for(;;) loop in nodeHashjoin.c. It fixes the delay when trying to kill but I don't know about ...
    Cédric VillemainCédric Villemain
    Jun 1, 2011 at 12:43 am
    Jun 1, 2011 at 10:49 pm
  • I'd like to add a feature to the buildfarm that automatically picks up any new branch and automatically stops building any branch we're not maintaining any more. To do the latter, I need some way for ...
    Andrew DunstanAndrew Dunstan
    Jun 28, 2011 at 5:46 pm
    Jul 12, 2011 at 2:21 pm
  • After compilation I got big list of differences about binaries and other files. You may see it in patch. Regards, Radek
    Radosław SmoguraRadosław Smogura
    Jun 8, 2011 at 10:35 am
    Jun 18, 2011 at 4:29 pm
  • I looked into $SUBJECT. There appear to be two distinct issues: 1. On colugos (OS X with LLVM), the plperl link step is spitting up because Apple's ExtUtils::Embed puts some -arch switches into ...
    Tom LaneTom Lane
    Jun 14, 2011 at 12:06 am
    Jun 16, 2011 at 4:58 pm
  • I didn't get a lot of comments on my the previous version of my patch to accelerate table locks. http://archives.postgresql.org/pgsql-hackers/2011-06/msg00953.php Here's a new version anyway. In this ...
    Robert HaasRobert Haas
    Jun 27, 2011 at 2:13 pm
    Jul 18, 2011 at 4:51 am
  • Review of patch https://commitfest.postgresql.org/action/patch_view?id=580 === Patch description === SUMMARY: When text() based XPATH expression is invoked output is not XML escaped DESCRIPTION: ...
    Radosław SmoguraRadosław Smogura
    Jun 29, 2011 at 5:34 pm
    Jul 14, 2011 at 1:40 pm
  • Hello, Because, I work a little bit on streaming protocol and from time to time I have crashes. I want ask if you wont crash reporting (this is one of minors products from mmap playing) those what I ...
    Radosław SmoguraRadosław Smogura
    Jun 14, 2011 at 6:37 pm
    Jul 7, 2011 at 2:22 pm
  • I would like to propose to add Japanese translated version of README in the source tree(for example against backend/storage/buffer/README). Benefits of our community include: - Increase possibility ...
    Tatsuo IshiiTatsuo Ishii
    Jun 29, 2011 at 11:01 pm
    Jun 30, 2011 at 11:59 am
  • Wow, this is the first I am hearing GNU cp -i can return zero exit if it doesn't do the copy. I tested this on Ubuntu 10.04 using cp 7.4 and got: $ touch x y $ cp -i x y; echo $? cp: overwrite `y'? n ...
    Bruce MomjianBruce Momjian
    Jun 17, 2011 at 11:32 pm
    Jun 20, 2011 at 8:29 pm
  • Hello, I'm new to PostgreSQL and git, but having read through the wiki entries such as http://wiki.postgresql.org/wiki/Submitting_a_Patch, I think I have a patch worthy of submission. It's a ...
    Jun 12, 2011 at 11:33 am
    Jun 16, 2011 at 9:06 pm
Group Navigation
period‹ prev | Jun 2011 | next ›
Group Overview
grouppgsql-hackers @

146 users for June 2011

Robert Haas: 366 posts Tom Lane: 270 posts Alvaro Herrera: 142 posts Kevin Grittner: 99 posts Bruce Momjian: 95 posts Heikki Linnakangas: 92 posts Florian Pflug: 89 posts Simon Riggs: 79 posts Andrew Dunstan: 60 posts Noah Misch: 51 posts Jeff Davis: 48 posts Merlin Moncure: 48 posts Peter Eisentraut: 47 posts Pavel Stehule: 44 posts Radosław Smogura: 41 posts Greg Smith: 39 posts Magnus Hagander: 31 posts Joshua Berkus: 30 posts Alexander Korotkov: 27 posts Dan Ports: 25 posts
show more