FAQ

Search Discussions

135 discussions - 1,623 posts

  • Hi, http://archives.postgresql.org/pgsql-hackers/2010-12/msg02343.php In previous discussion, we've reached the consensus that we should unite recovery.conf and postgresql.conf. The attached patch ...
    Fujii MasaoFujii Masao
    Sep 9, 2011 at 9:56 am
    May 11, 2012 at 5:06 pm
  • Recent discussions on the threads "Double sorting split patch" and "CUDA sorting" raised the possibility that there could be significant performance optimisation "low-hanging fruit" picked by having ...
    Peter GeogheganPeter Geoghegan
    Sep 20, 2011 at 1:56 am
    Jan 28, 2012 at 2:55 pm
  • FYI, here are all the C files with over 6k lines: - 45133 ./interfaces/ecpg/preproc/preproc.c - 33651 ./backend/parser/gram.c - 17551 ./backend/parser/scan.c 14209 ./bin/pg_dump/pg_dump.c 10590 ...
    Bruce MomjianBruce Momjian
    Sep 3, 2011 at 11:18 pm
    Oct 19, 2011 at 7:40 pm
  • Hello all, what I saw on PHP unconference told me that I should ask all again. I feel lonely. Believe me it is a bad feeling when it seems that nobody has interests in what you are doing. Since 4 ...
    Susanne EbrechtSusanne Ebrecht
    Sep 16, 2011 at 6:25 am
    Sep 21, 2011 at 4:50 pm
  • The above has been posted in pgsql-general. The reason why Chris thinks a counterpart of pg_last_xact_replay_timestamp() is required sounds reasonable to me. So I'd like to propose new function ...
    Fujii MasaoFujii Masao
    Sep 8, 2011 at 8:36 am
    Dec 14, 2011 at 4:06 pm
  • Hello everyone, I'm implementing a CUDA based sorting on PostgreSQL, and I believe it can improve the ORDER BY statement performance in 4 to 10 times. I already have a generic CUDA sort that performs ...
    Vitor ReusVitor Reus
    Sep 19, 2011 at 12:14 pm
    Feb 16, 2012 at 12:37 am
  • As discussed previously... Currently the bgwriter process performs both background writing, checkpointing and some other duties. This means that we can't perform the final checkpoint fsync without ...
    Simon RiggsSimon Riggs
    Sep 15, 2011 at 11:24 pm
    Nov 2, 2011 at 1:40 am
  • Hackers, Later this week I'm giving a [brief][] for an audience of what I hope will be corporate PostgreSQL users that covers how to get a feature developed for PostgreSQL. The idea here is that ...
    David E. WheelerDavid E. Wheeler
    Sep 12, 2011 at 4:21 am
    Sep 24, 2011 at 2:14 pm
  • Hi there, To enable file_fdw to estimate costs of scanning a CSV file more accurately, I would like to propose a new FDW callback routine, AnalyzeForeignTable, which allows to ANALYZE command to ...
    Etsuro FujitaEtsuro Fujita
    Sep 12, 2011 at 10:50 am
    Apr 9, 2012 at 2:52 am
  • Hi all, I spent a bit of today diagnosing a problem where long held transactions were preventing auto vacuum from doing its job. Eventually I had set log_autovacuum_min_duration to 0 to see what was ...
    Royce AusburnRoyce Ausburn
    Sep 27, 2011 at 5:51 pm
    Nov 18, 2011 at 12:06 am
  • Hi Hackers,
    George BarnettGeorge Barnett
    Sep 9, 2011 at 12:13 am
    Aug 16, 2012 at 12:45 am
  • Hello, * Context * I'm observing problems with provisioning a standby from the master by following a basic and documented "Making a Base Backup" [1] procedure with rsync if, in the mean time, heavy ...
    Linas VirbalasLinas Virbalas
    Sep 21, 2011 at 2:54 pm
    Sep 29, 2011 at 6:22 pm
  • Hi, I'd like to support UTF-8 text or csv files that has BOM (byte order mark) in COPY FROM command. BOM will be automatically detected and ignored if the file encoding is UTF-8. WIP patch attached. ...
    Itagaki TakahiroItagaki Takahiro
    Sep 26, 2011 at 4:58 am
    Sep 27, 2011 at 2:32 pm
  • Hi, Is there a plan to wrap up 9.2 Alpha 1 before the next commitfest? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL ...
    Devrim GündüzDevrim Gündüz
    Sep 6, 2011 at 1:49 pm
    Sep 13, 2011 at 3:09 am
  • Hi list! This is the third version of my CacheExpr patch. The patch is now feature-complete -- meaning that it's now capable of caching all expression types that are currently constant-foldable. ...
    Marti RaudseppMarti Raudsepp
    Sep 25, 2011 at 2:17 am
    Dec 17, 2011 at 5:24 pm
  • And, here's an updated version, with some of the more obviously broken things fixed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
    Robert HaasRobert Haas
    Sep 14, 2011 at 8:29 pm
    Sep 24, 2011 at 5:38 pm
  • Hi all, I'd like to propose $SUBJECT for further foreign query optimization. I've not finished development, but I'd appreciate it if I got someone's review on my WIP code and its design. Changes I ...
    Shigeru HanadaShigeru Hanada
    Sep 14, 2011 at 9:24 am
    Jan 5, 2012 at 10:58 am
  • Hi, Currently, if a reference to an invalid page is found during recovery, its information is saved in hash table "invalid_page_tab". Then, if such a reference is resolved, its information is removed ...
    Fujii MasaoFujii Masao
    Sep 26, 2011 at 9:50 am
    Dec 2, 2011 at 8:59 am
  • Hackers, I've got my patch with double sorting picksplit impementation for GiST into more acceptable form. A little of testing is below. Index creation time is slightly higher, but search is much ...
    Alexander KorotkovAlexander Korotkov
    Sep 11, 2011 at 7:30 pm
    Oct 6, 2011 at 10:19 am
  • It would perhaps be useful to add optional --old-confdir and --new-confdir parameters to pg_upgrade. If these parameters are absent then pg_upgrade would work as it does now and assume that the ...
    Steve CrawfordSteve Crawford
    Sep 27, 2011 at 11:13 pm
    Oct 10, 2011 at 11:43 am
  • All, I just tripped over this: select 'josh'::varchar(32) = 'Josh'::citext; ?column? ---------- f While it's clear why it's that way, it's not how people would expect citext to behave. Users expect ...
    Josh BerkusJosh Berkus
    Sep 21, 2011 at 11:52 pm
    Sep 23, 2011 at 5:00 pm
  • Hi list, This patch adds the backend's current running query to the "backend crash" message. The crashing query is often a good starting point in debugging the cause, and much more easily accessible ...
    Marti RaudseppMarti Raudsepp
    Sep 6, 2011 at 8:52 pm
    Sep 24, 2011 at 7:58 pm
  • While testing 9.1 RPMs on Fedora 15 (2.6.40 kernel), I notice messages like these in the kernel log: Sep 11 13:38:56 rhl kernel: [ 415.308092] postgres (18040): /proc/18040/oom_adj is deprecated, ...
    Tom LaneTom Lane
    Sep 16, 2011 at 2:57 pm
    Jun 12, 2012 at 6:35 pm
  • I ruined a 5 hour UPDATE by typoing a table name on a SELECT to verify the update worked. I suppose I have no one else to blame, but it was really frustrating, to say the least. I assume this has ...
    Will LeinweberWill Leinweber
    Sep 28, 2011 at 12:05 am
    Aug 17, 2012 at 8:08 pm
  • So I thought it would be a good idea to enable contrib/sepgsql in the Fedora build of 9.1. This soon crashed and burned, though, because (1) if you build sepgsql, there is no way to omit the sepgsql ...
    Tom LaneTom Lane
    Sep 26, 2011 at 1:07 am
    Oct 2, 2011 at 1:20 am
  • Greetings postgres hackers! Here you can find www_fdw feature documentation: http://wiki.postgresql.org/wiki/WWW_FDW Looking forward for your feedback. -- Alexander Soudakov Developer Programmer ...
    Alexander SoudakovAlexander Soudakov
    Sep 28, 2011 at 1:32 pm
    Nov 28, 2011 at 2:04 am
  • Pavel, this patch: https://commitfest.postgresql.org/action/patch_view?id=624 It applied clean and compiled ok, but I cannot get it to work at all. $ psql Timing is on. psql (9.2devel) Type "help" ...
    Andy ColsonAndy Colson
    Sep 5, 2011 at 9:03 pm
    Oct 5, 2011 at 12:41 pm
  • It looks to me like there could at least in theory be an attack vector or two that we're not covering with this bug. Anybody want to tackle same? Cheers, David. -- David Fetter <david@fetter.org ...
    David FetterDavid Fetter
    Sep 12, 2011 at 5:21 pm
    Sep 24, 2011 at 12:33 pm
  • Hmm, so you included walsender.h into xlog.h? That seems a bit funny considering that walsender.h already includes xlog.h. It seems the reason for this is only the AllowCascadeReplication() ...
    Alvaro HerreraAlvaro Herrera
    Sep 2, 2011 at 4:53 pm
    Sep 12, 2011 at 7:11 pm
  • Hello, I am new to postgresql code, I would like to start implementing easyish TODO items. I have read most of the development guidelines, faqs, articles by Greg Smith (Hacking Postgres with UDFs, ...
    Kerem KatKerem Kat
    Sep 18, 2011 at 9:39 am
    Oct 19, 2011 at 4:21 am
  • Hello, Please let me ask you some questions about RelCache/SysCache/CatCache design. I know I should post this to pgsql-general, but I decided to post here because the content includes design ...
    MauMauMauMau
    Sep 28, 2011 at 11:48 am
    Sep 29, 2011 at 3:43 pm
  • Attached patch implements a "low watermark wal location" in the walsender shmem array. Setting this value in a walsender prevents transaction log removal prior to this point - similar to how ...
    Magnus HaganderMagnus Hagander
    Sep 2, 2011 at 5:52 pm
    Sep 9, 2011 at 2:09 pm
  • As discussed, patch attached. cheers andrew
    Andrew DunstanAndrew Dunstan
    Sep 15, 2011 at 2:44 pm
    Dec 4, 2011 at 4:49 pm
  • Hackers, Since installing Perl 5.14.1, I installed newer version of ExtUtils::ParseXS from CPAN. I installed it with `make install UNINST=1`, which removes the copy of xsubpp that ships with core ...
    David E. WheelerDavid E. Wheeler
    Sep 15, 2011 at 4:44 pm
    Nov 28, 2011 at 5:37 pm
  • As has been mentioned a couple times, we're well overdue for updates of the back branches. Seems like time to get that done, so we'll be wrapping 8.2.x and up this Thursday for release Monday the ...
    Tom LaneTom Lane
    Sep 20, 2011 at 5:37 am
    Sep 21, 2011 at 4:01 am
  • Hi, Here's a patch for $SUBJECT based on the feedback here: http://archives.postgresql.org/message-id/9053.1295888538@sss.pgh.pa.us I intentionally decided to omit the information for Join Filter, ...
    Marko TiikkajaMarko Tiikkaja
    Sep 8, 2011 at 12:17 pm
    Sep 22, 2011 at 4:53 pm
  • So both fstat and lseek do more work than postgres wants. lseek modifies the file pointer while fstat copies all kinds of unnecessary information into userspace. I imagine this is the source of the ...
    Matthew WilcoxMatthew Wilcox
    Sep 16, 2011 at 3:46 pm
    Sep 20, 2011 at 7:19 am
  • Hello there is one regress test, that failed on my f14 [pavel@nemesis postgresql]$ uname -a Linux nemesis 2.6.35.14-95.fc14.i686.PAE #1 SMP Tue Aug 16 21:12:22 UTC 2011 i686 i686 i386 GNU/Linux ...
    Pavel StehulePavel Stehule
    Sep 4, 2011 at 12:23 pm
    Sep 9, 2011 at 12:02 pm
  • Hello Andy Colson found a bug in GUC implementation. When we have a custom SUSET variable, like plpgsql.variable_conflikt, then setting this variable before plpgsql initalisation raises a exception, ...
    Pavel StehulePavel Stehule
    Sep 7, 2011 at 5:24 pm
    Sep 7, 2011 at 7:26 pm
  • What pgrminclude does it to lock down the minimal set of includes, and that easily could cause something like xlog.h becoming the go-to include file for many C files. I don't remember this problem ...
    Bruce MomjianBruce Momjian
    Sep 5, 2011 at 1:52 pm
    Aug 16, 2012 at 10:52 pm
  • Hi, Magnus's patch for adding tab completion of views to the TABLE statement reminded me of a minor annoyance of mine -- that EXECUTE always completes with "PROCEDURE" as if it would have been part ...
    Andreas KarlssonAndreas Karlsson
    Sep 26, 2011 at 9:12 pm
    Oct 24, 2011 at 4:53 pm
  • Hi, I don't find the following error message very helpful: =# create collation "sr_SP" (LOCALE ='sr_SB.utf8'); ERROR: could not create locale "sr_SB.utf8": No such file or directory It's correct in ...
    Thom BrownThom Brown
    Sep 20, 2011 at 12:25 am
    Sep 20, 2011 at 5:47 pm
  • Isn't the naming of the xlog files slightly bogus? We have the following sequence: 00000001000008D0000000FD 00000001000008D0000000FE 00000001000008D100000000 Ignoring that we skip FF for some obscure ...
    Peter EisentrautPeter Eisentraut
    Sep 12, 2011 at 6:55 pm
    Aug 23, 2012 at 1:30 pm
  • Hi guys! I know Postgresql 9.x includes "unaccent" contrib on their deliver package. "unaccent" is compatible with postgresql 8.4 (but not is in their contrib version distribution) what's better way ...
    Daniel VázquezDaniel Vázquez
    Sep 21, 2011 at 4:29 pm
    Sep 26, 2011 at 2:31 pm
  • Hi, Currently createuser cannot create a role with REPLICATION privilege because it doesn't have any option to do that. Which sometimes annoys me when setting up replication. I'd like to propose to ...
    Fujii MasaoFujii Masao
    Sep 10, 2011 at 5:08 am
    Sep 26, 2011 at 8:55 am
  • http://archives.postgresql.org/message-id/4E04C099.3020604@enterprisedb.com The patch I reviewed was added to the CF app before the post you cite was written. I didn't see it in following the links ...
    Kevin GrittnerKevin Grittner
    Sep 26, 2011 at 2:32 am
    Oct 1, 2011 at 4:03 am
  • Hi, I find the current behaviour of locking of sequences rather problematic. Multiple things: - First and foremost I find it highly dangerous that "ALTER SEQUENCE ..." is for the biggest part not ...
    Andres FreundAndres Freund
    Sep 21, 2011 at 3:15 pm
    Sep 21, 2011 at 6:09 pm
  • Hi, This is a proof of concept patch for recognizing stable function calls with constant arguments and only calling them once per execution. I'm posting it to the list to gather feedback whether this ...
    Marti RaudseppMarti Raudsepp
    Sep 10, 2011 at 10:27 pm
    Sep 18, 2011 at 10:26 pm
  • We are seeing numerous occasional buildfarm failures of the fk-deadlock2 isolation test, that look like this: *************** *** 32,39 **** step s2u1: UPDATE B SET Col2 = 1 WHERE BID = 2; step s1u2: ...
    Andrew DunstanAndrew Dunstan
    Sep 26, 2011 at 3:43 pm
    Sep 27, 2011 at 7:59 pm
  • In the "refactoring Large C files" discussion one of the biggest files Bruce mentioned is pg_dump.c. There has been discussion in the past of turning lots of the knowledge currently embedded in this ...
    Andrew DunstanAndrew Dunstan
    Sep 8, 2011 at 7:20 pm
    Sep 11, 2011 at 7:34 pm
Group Navigation
period‹ prev | Sep 2011 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions135
posts1,623
users147
websitepostgresql.org...
irc#postgresql

147 users for September 2011

Tom Lane: 225 posts Robert Haas: 168 posts Bruce Momjian: 98 posts Peter Eisentraut: 63 posts Alvaro Herrera: 48 posts Fujii Masao: 47 posts Joshua Berkus: 45 posts Andrew Dunstan: 44 posts Heikki Linnakangas: 43 posts Magnus Hagander: 40 posts Kevin Grittner: 38 posts Simon Riggs: 38 posts Florian Pflug: 37 posts Marti Raudsepp: 30 posts Kohei KaiGai: 26 posts Thom Brown: 24 posts Dimitri Fontaine: 21 posts Greg Stark: 20 posts David E. Wheeler: 18 posts Alexander Korotkov: 17 posts
show more
Archives