Search Discussions

220 discussions - 2,514 posts

  • Agreed. The patch is exactly what I was hoping to see: o only covers existing Postgres ACLs o has both user and developer documentation o includes regression tests o main code impact is minimal Now, ...
    Bruce MomjianBruce Momjian
    Dec 1, 2009 at 4:03 am
    Dec 16, 2009 at 2:57 am
  • I updated the description as your suggest. Applied with minor editorialization, mainly around tab-completion support in psql. # This is my first commit :) Regards, --- Takahiro Itagaki NTT Open ...
    Takahiro ItagakiTakahiro Itagaki
    Dec 11, 2009 at 3:41 am
    Feb 10, 2010 at 2:25 am
  • I had proposed a temporal contrib module earlier and you wanted to see support for many range types not just timestamptz. So I had an idea on how to implement this but I want to see if you guys ...
    Scott BaileyScott Bailey
    Dec 14, 2009 at 7:50 am
    Dec 23, 2009 at 7:05 pm
  • Are planning to send a new version soon? As it is, we're 12 days from the end of this commitfest, so we don't have much time to hand the patch back and forth before we're out of time. Regards, Jeff ...
    Jeff DavisJeff Davis
    Dec 4, 2009 at 6:22 am
    Feb 18, 2010 at 6:47 pm
  • Hello I am working on new patch. I see a problem with copy quote_ident on client side. This function call ScanKeywordLookup function. const ScanKeyword *keyword = ScanKeywordLookup(ident, ...
    Pavel StehulePavel Stehule
    Dec 29, 2009 at 4:57 pm
    Jan 29, 2010 at 4:20 pm
  • There are several pg_migrator limitations that appeared late in the 8.4 development cycle and were impossible to fix at that point. I would like to fix them for Postgres 8.5: o a user-defined ...
    Bruce MomjianBruce Momjian
    Dec 18, 2009 at 7:29 pm
    Dec 28, 2009 at 4:31 pm
  • Well. It was a long day... Anyway. In this patch I delay the fsync done in copy_file and simply do a second pass over the directory in copy_dir and fsync everything in that pass. Including the ...
    Andres FreundAndres Freund
    Dec 28, 2009 at 10:55 pm
    Feb 15, 2010 at 12:08 am
  • I find the backend libpq changes related to non-blocking I/O quite complex. Can we find a simpler solution? The problem we're trying to solve is that while the walsender backend sends a lot of WAL ...
    Heikki LinnakangasHeikki Linnakangas
    Dec 8, 2009 at 2:23 pm
    Jan 16, 2010 at 1:29 pm
  • Microsoft C doesn't matter? I seem to remember that when the Win32 version became available it actually increased the number of people trying postgres rather dramatically. Did that count for nothing?
    James MansionJames Mansion
    Dec 2, 2009 at 8:13 pm
    Feb 13, 2010 at 2:36 am
  • As I have observed before, I think we need some infrastructure to help committers claim items, so we don't duplicate work. Right now the only items marked "ready for reviewer" are Streaming ...
    Andrew DunstanAndrew Dunstan
    Dec 1, 2009 at 4:03 am
    Dec 11, 2009 at 2:57 am
  • I just realized that this was easy to do, and despite my complete lack of C skillz was able to throw this together in a couple of hours. It might be handy to some, though the possible downsides are: ...
    David E. WheelerDavid E. Wheeler
    Dec 16, 2009 at 7:28 pm
    Jan 5, 2010 at 4:37 am
  • Fixed a lot of memory/reference leaks, added some minor features(mostly around Arrays), and filled in more documentation. At this point, I don't have any more minor features in mind(save extending ...
    James PyeJames Pye
    Dec 13, 2009 at 10:03 pm
    May 8, 2010 at 8:01 pm
  • Enclose latest version of Hot Standby. This is the "basic" patch, with no must-fix issues and no known bugs. Further additions will follow after commit, primarily around usability, which will include ...
    Simon RiggsSimon Riggs
    Dec 13, 2009 at 7:20 pm
    Dec 17, 2009 at 10:08 am
  • pg_migrator has become more popular recently, so it seems time to look at some enhancements that would improve pg_migrator. None of these are required, but rather changes that would be nice to have: ...
    Bruce MomjianBruce Momjian
    Dec 31, 2009 at 3:50 am
    Jan 12, 2010 at 2:47 am
  • Kris JurkaKris Jurka
    Dec 27, 2009 at 1:15 am
    Jan 15, 2010 at 12:08 am
  • Hi, attached is a small patch that makes it possible for clients to receive row count for SELECT ... INTO ... and CREATE TABLE ... AS ... Comments? Best regards, Zoltán Böszörményi -- Bible has ...
    Boszormenyi ZoltanBoszormenyi Zoltan
    Dec 28, 2009 at 9:58 am
    Feb 16, 2010 at 8:59 pm
  • Hi, pg_stop_backup deletes the previous backup history file from pg_xlog. So replication of a backup history file would fail if just one new online-backup is caused after the base-backup for the ...
    Fujii MasaoFujii Masao
    Dec 4, 2009 at 1:06 pm
    Feb 8, 2010 at 9:43 am
  • Good point. I attached a suggestion of how it might look if you detected the server version explicitly. You don't have to use it, but it's what I had in mind. Also, I think the current version fails ...
    Jeff DavisJeff Davis
    Dec 1, 2009 at 9:48 am
    Jan 30, 2010 at 2:39 pm
  • Attached is the fix pointed out in the previous CommitFest plus RANGE offset support. *fix - move window regression test to another parallel group, but regarding the limitation of 20 per group the ...
    Hitoshi HaradaHitoshi Harada
    Dec 31, 2009 at 9:49 am
    Feb 13, 2010 at 6:42 am
  • Do people want more time to play with hot standby? Otherwise alpha3 should go out on Monday or Tuesday.
    Peter EisentrautPeter Eisentraut
    Dec 19, 2009 at 12:20 pm
    Dec 22, 2009 at 7:15 pm
  • The Cahill thesis mentions an interesting optimization -- they defer determination of the snapshot until after any locks required for the first statement have been acquired. Where the first statement ...
    Kevin GrittnerKevin Grittner
    Dec 16, 2009 at 10:18 pm
    Dec 18, 2009 at 12:20 am
  • It is a cleanup patch apart from SELinux and security framework. Now, EnableDisableRule() checks ownership of the relation which owns the rewrite rule to be enabled/disabled. But it has the following ...
    KaiGai KoheiKaiGai Kohei
    Dec 16, 2009 at 6:16 am
    Jan 15, 2010 at 1:07 am
  • While waiting for feedback on my earlier plperl refactor and feature patches I'm working on a further patch that adds, among other things, fast inter-plperl-sp calling. I want to outline what I've ...
    Tim BunceTim Bunce
    Dec 30, 2009 at 10:55 pm
    Jan 7, 2010 at 10:48 am
  • Hot Standby node can freeze when startup process calls LockBufferForCleanup(). This bug can be reproduced by the following procedure. 0. start Hot Standby, with one active node(node A) and one ...
    Hiroyuki YamadaHiroyuki Yamada
    Dec 15, 2009 at 11:25 am
    Jan 21, 2010 at 10:21 am
  • Could we create an option to create index names automatically, so you'd only have to write CREATE INDEX ON foo (a); which would pick a name like foo_a_idx. We already do this in a number of places ...
    Peter EisentrautPeter Eisentraut
    Dec 19, 2009 at 9:06 pm
    Dec 26, 2009 at 6:28 am
  • All, One of our clients is having query plan issues with a table with a continuously advancing timestamp column (i.e. one with default now()). The newest rows, which are the most in demand, are ...
    Josh BerkusJosh Berkus
    Dec 30, 2009 at 2:54 am
    Jan 5, 2010 at 3:08 pm
  • Of course I did before he publishes the patches. (I and he are working for the same company). However I'm not a Windows programmer by no means. So my suggestion was mainly for designs... -- Tatsuo ...
    Tatsuo IshiiTatsuo Ishii
    Dec 9, 2009 at 3:48 am
    Jan 12, 2010 at 11:09 am
  • Just to make those who care aware of it, here is Michael Cahill's Doctoral Thesis based on implementing Serializable Snapshot Isolation in InnoDB using a refined version of the techniques previously ...
    Kevin GrittnerKevin Grittner
    Dec 15, 2009 at 7:02 pm
    Dec 18, 2009 at 8:25 pm
  • Building on my earlier plperl refactoring patch, here's a draft of my first plperl feature patch. Significant changes in this patch: - New GUC plperl.on_perl_init='...perl...' for admin use. - New ...
    Tim BunceTim Bunce
    Dec 3, 2009 at 11:30 pm
    Dec 5, 2009 at 8:37 pm
  • I have just noticed while checking the EXPLAIN YAML patch that the non-text explain formats are output as a single line with embedded line feeds, while the text format is delivered as a set of text ...
    Andrew DunstanAndrew Dunstan
    Dec 9, 2009 at 7:38 pm
    Dec 12, 2009 at 9:18 am
  • I've tried to benchmark this now on my (fairly slow compared to server hardware) MacBook and see some negative trend for those memory probes in pgbench. Running dozens of rounds with pgbench (scale ...
    Bernd HelmleBernd Helmle
    Dec 8, 2009 at 8:42 pm
    Dec 12, 2009 at 2:27 am
  • This thread never got resolved. I think we can all agree that EOL for 7.4 is a "when", not an "if"? Can we get -core to take a stance here and pick a date? I like the clean smooth lines of January ...
    Greg Sabino MullaneGreg Sabino Mullane
    Dec 1, 2009 at 4:24 pm
    Dec 4, 2009 at 1:46 pm
  • Here is an update partitioning syntax patch. A bug reported by Marko is fixed. Regards, --- ITAGAKI Takahiro NTT Open Source Software Center
    Itagaki TakahiroItagaki Takahiro
    Dec 4, 2009 at 2:53 am
    Nov 16, 2011 at 10:00 am
  • Since the pg_stat_bgwriter structure was introduced in 8.3, there's never been any way to reset its statistics back to 0. A week of analyzing data from that every day drove me crazy enough to finally ...
    Greg SmithGreg Smith
    Dec 5, 2009 at 3:18 am
    Jan 19, 2010 at 2:12 pm
  • It's funny; we started out this CommitFest with me scrambling to find someone, anyone, willing to review the latest SE-PostgreSQL patch, knowing it was a big job and few were likely to volunteer. ...
    Greg SmithGreg Smith
    Dec 10, 2009 at 10:26 pm
    Dec 17, 2009 at 1:07 am
  • +1 This SESSION/CONNECITION terminology is confusing, better would be talk about client connection/session (client- pooler) and server connection/session (pooler- server) if you are talking about ...
    Marko KreenMarko Kreen
    Dec 1, 2009 at 8:14 am
    Dec 2, 2009 at 3:19 pm
  • Following up on the discussion here http://archives.postgresql.org/message-id/4B3875C6020000250002D97D@gw.wicourts.gov I'd like to propose making the following changes that would allow saner planning ...
    Tom LaneTom Lane
    Dec 28, 2009 at 10:41 pm
    Jan 8, 2010 at 3:27 am
  • After getting off to a good start, it looks like this patch is now stuck waiting for a second review pass from Kevin right now, with no open items for Andres to correct. Since the only issues on the ...
    Greg SmithGreg Smith
    Dec 7, 2009 at 1:14 am
    Dec 15, 2009 at 8:40 pm
  • Hello I wonder why the function pg_relation_size(text) does not take into account the space used by toast data in a table when returning the space used by the table. As an administrator I would ...
    Rafael MartinezRafael Martinez
    Dec 21, 2009 at 1:36 pm
    Jan 19, 2010 at 5:51 am
  • For perspective: Since our current application framework is about ten years old now, the Wisconsin State Courts System has put together a "Long-Term Application Development Group" to review all ...
    Kevin GrittnerKevin Grittner
    Dec 28, 2009 at 5:54 pm
    Jan 8, 2010 at 9:59 pm
  • Based on research done as part of this thread, it seems plpgsql has similar risks to recursive queries, so the idea of installing plpgsql by default now makes more sense. The attached patch installs ...
    Bruce MomjianBruce Momjian
    Dec 4, 2009 at 12:04 am
    Dec 18, 2009 at 9:29 pm
  • Hello there, I am a graduate student at the University of Washington, Tacoma (http://www.tacoma.washington.edu/tech/) with an interest in databases (especially query processing). I am familiar with ...
    Dec 7, 2009 at 3:29 am
    Dec 16, 2009 at 8:14 am
  • Greetings, Row-Level security has been implemented in a number of existing commercial databases. There exists an implementation of row-level security for PostgreSQL today in the form of SEPostgres. I ...
    Stephen FrostStephen Frost
    Dec 12, 2009 at 8:30 pm
    Dec 15, 2009 at 12:20 pm
  • Hi, I compiled current HEAD and trying to use pgbench, i initialized a test database this way: bin/pgbench -i -F80 -s100 test and then run with this options: bin/pgbench -c 50 -j 5 -l -t 20 test and ...
    Jaime CasanovaJaime Casanova
    Dec 9, 2009 at 7:03 pm
    Dec 14, 2009 at 2:55 pm
  • Possibly, but even if I can measure a difference doing it that way, it's not clear that it matters. It's fairly certain that there will be a performance degradation if we measure carefully enough, ...
    Robert HaasRobert Haas
    Dec 3, 2009 at 4:01 pm
    Jan 6, 2010 at 5:42 pm
  • While inspecting a complain from a pgpool user, I found that PostgreSQL crushes with following statck trace: #0 0x0826436a in list_length (l=0xaabe4e28) at ../../../src/include/nodes/pg_list.h:94 #1 ...
    Tatsuo IshiiTatsuo Ishii
    Dec 29, 2009 at 1:05 am
    Jan 3, 2010 at 11:59 am
  • I've attached an update of my previous refactoring of plperl.c. It's been rebased over the current (git) HEAD and has a few very minor additions. Background: I've started work on the enhancements to ...
    Tim BunceTim Bunce
    Dec 2, 2009 at 3:04 pm
    Jan 10, 2010 at 6:11 pm
  • I get this when testing prepared transactions, which looks like it is unrelated to Hot Standby. 2009-12-15 17:28:08 GMT[10385]LOG: archive recovery complete 2009-12-15 17:28:08 GMT[10428]LOG: ...
    Simon RiggsSimon Riggs
    Dec 15, 2009 at 6:52 pm
    Dec 17, 2009 at 2:57 pm
  • Hi. test/example does not support win32. Although I posted also in the past, I am slightly persistent. I think whether it also needs correction of a document. == CVS-HEAD on as for MinGW + gcc == ...
    Hiroshi SaitoHiroshi Saito
    Dec 30, 2009 at 4:50 am
    Dec 30, 2009 at 4:48 pm
  • As a not-quite aside, I think I have a better syntax suggestion. I have recently been digging around in the grammar with the changes made in the following commit: commit ...
    Daniel FarinaDaniel Farina
    Dec 5, 2009 at 8:32 am
    Dec 30, 2009 at 6:03 am
Group Navigation
period‹ prev | Dec 2009 | next ›
Group Overview
grouppgsql-hackers @

161 users for December 2009

Tom Lane: 387 posts Robert Haas: 295 posts Simon Riggs: 164 posts Bruce Momjian: 112 posts Greg Smith: 87 posts Kevin Grittner: 81 posts Andrew Dunstan: 80 posts Heikki Linnakangas: 80 posts Alvaro Herrera: 61 posts KaiGai Kohei: 56 posts Peter Eisentraut: 55 posts Takahiro Itagaki: 53 posts Greg Stark: 51 posts Andres Freund: 44 posts Fujii Masao: 43 posts Jeff Davis: 42 posts Magnus Hagander: 42 posts Pavel Stehule: 40 posts Stephen Frost: 34 posts David E. Wheeler: 33 posts
show more