FAQ

PostgreSQL > pgsql-hackers > February 2009

Search Discussions

110 discussions - 1,399 posts

  • I've been doing some benchmarking and profiling on the PostgreSQL query analyzer, and it seems that (at least for the sorts of queries that I typically run) the dominant cost is add_path(). I've been ...
    Robert HaasRobert Haas
    Feb 1, 2009 at 4:37 am
    Feb 28, 2010 at 1:02 am
  • Jeff Davis asked me if I'd be willing to do a review of the GIN fast insert patch about two weeks ago, but I haven't actually had a chance to read through it in detail until tonight. I can't say I ...
    Robert HaasRobert Haas
    Feb 11, 2009 at 2:59 am
    Mar 25, 2009 at 12:40 am
  • Andrew Gierth was just pointing out to me how badly broken our XPath processing is. For fear of passing an ill formed fragment of xml to the processor, we strip the xml declaration if any and ...
    Andrew DunstanAndrew Dunstan
    Feb 26, 2009 at 4:08 am
    Mar 20, 2009 at 11:02 pm
  • Hi, I need SE-PostgreSQL *ONLY* for row level security, but AFAIK SE-PostgreSQL works only on SELinux. This, for me, is unacceptable, because I want to use row level security on windows too. I don't ...
    BogDan VatraBogDan Vatra
    Feb 10, 2009 at 10:36 am
    Feb 18, 2009 at 3:32 pm
  • We have an open problem with CVS HEAD that ALTER TABLE SET WITHOUT OIDS causes problems: http://archives.postgresql.org/pgsql-hackers/2008-11/msg00332.php I opined at the time that what we really ...
    Tom LaneTom Lane
    Feb 8, 2009 at 4:13 pm
    Feb 12, 2009 at 11:57 am
  • Hi, Could you please let me know what are the outstanding features that are still to be developed in the respective patches? I'am currently referring the wiki: "Todo and Claim" for NTT and for ...
    K, Niranjan (NSN - IN/Bangalore)K, Niranjan (NSN - IN/Bangalore)
    Feb 24, 2009 at 6:47 am
    Mar 2, 2009 at 2:11 am
  • Hi, Right now, when autovacuum is turned on we always assume it's supposed to process all tables except those that have autovacuum_enabled=false. Now, sometimes it might make more sense to keep it ...
    Alvaro HerreraAlvaro Herrera
    Feb 5, 2009 at 8:52 pm
    Feb 10, 2009 at 12:22 am
  • Hello some years ago there was some plans about parser's extensibility. I am able write bison extensions, but I thing, so lot of work should be done via hooking of transform stage. I did small ...
    Pavel StehulePavel Stehule
    Feb 11, 2009 at 10:32 am
    Feb 20, 2009 at 2:19 pm
  • Hey guys, I had two running threads here: http://archives.postgresql.org/pgsql-general/2009-02/msg00859.php http://www.postgresqlforums.com/forums/viewtopic.php?f=41&t=1574 Both have not come to a ...
    Frank FeatherlightFrank Featherlight
    Feb 21, 2009 at 1:26 pm
    Feb 27, 2009 at 2:50 pm
  • Hello, I was helping a customer today with what is becoming a common theme with a lot of work we do. Basically, "It was working fine until recently." Now 90% of the time it is as simple as running an ...
    Joshua D. DrakeJoshua D. Drake
    Feb 13, 2009 at 12:06 am
    Feb 21, 2009 at 2:15 am
  • After doing some math I've concluded this is in fact the case. Anyone want to check my work? regards, tom lane ----------------------------------- The basic outer-join identities used up through 8.3 ...
    Tom LaneTom Lane
    Feb 10, 2009 at 8:10 pm
    Feb 20, 2009 at 4:14 pm
  • Hi, alvherre@postgresql.org (Alvaro Herrera) wrote: I tested this changes and found two issues: 1. fillfactor.* options are silently ignored when the table doesn't have toast relation. Should we ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Feb 10, 2009 at 3:19 am
    Feb 11, 2009 at 9:51 pm
  • I know we've already had a discussion on the naming of the pg_restore -m option, but in any case this description in pg_restore --help is confusing: -m, --multi-thread=NUM use this many parallel ...
    Peter EisentrautPeter Eisentraut
    Feb 12, 2009 at 3:41 pm
    Mar 19, 2009 at 9:32 pm
  • Hi. Is it in todo or in a plan to implement lmza commpression in pg_dump backups? Thanks Stano -- ------------------------------------------------------------------------ Space Systems *Mgr. Stano ...
    Stanislav LackoStanislav Lacko
    Feb 4, 2009 at 9:49 pm
    Feb 8, 2009 at 10:37 pm
  • Hadoop backend for PostGreSQL.... A problem that my client has, and one that I come across often, is that a database seems to always be associated with a particular physical machine, a physical ...
    Paul SheerPaul Sheer
    Feb 21, 2009 at 8:17 pm
    Jul 22, 2009 at 3:29 am
  • We're using SIGQUIT to signal immediate shutdown request. Upon receiving SIGQUIT, postmaster in turn kills all the child processes with SIGQUIT and exits. This is a problem when child processes use ...
    Heikki LinnakangasHeikki Linnakangas
    Feb 27, 2009 at 9:52 am
    Mar 18, 2009 at 9:31 pm
  • I have completed all the outstanding pg_migratory TODO items. I still have more work to do in cleanup and testing, but if people want to look at my progress, now is a good time. You can download the ...
    Bruce MomjianBruce Momjian
    Feb 18, 2009 at 2:01 pm
    Mar 28, 2009 at 7:18 pm
  • I looked into the planning problems in HEAD discussed here: http://archives.postgresql.org/pgsql-hackers/2009-02/msg00120.php As I suspected, there are really two independent bugs there, though both ...
    Tom LaneTom Lane
    Feb 5, 2009 at 5:05 pm
    Feb 19, 2009 at 10:25 pm
  • I would like to add a --freeze parameter to vacuumdb for use by the binary upgrade utility, and for symmetry with the existing VACUUM options; patch attached. I could also accomplish with with ...
    Bruce MomjianBruce Momjian
    Feb 17, 2009 at 4:58 pm
    Feb 19, 2009 at 7:13 pm
  • Hello, Last week, i took some time to check if i was still able to write some basic C code. So i looked into the TODO list and picked some trivial items. This one is very basic, it just shows the ...
    Damien clochardDamien clochard
    Feb 25, 2009 at 11:25 pm
    Jul 7, 2009 at 7:37 pm
  • (back to reviewing the main hot standby patch at last) Why do we need recovery procs? AFAICS the only fields that we use are xid and the subxid cache. Now that we also have the unobserved xids array, ...
    Heikki LinnakangasHeikki Linnakangas
    Feb 24, 2009 at 8:40 am
    Feb 26, 2009 at 10:29 am
  • CC="xlC_r -q64" \ CXX="xlC_r -q64" \ AR="ar -X64" \ OBJECT_MODE=64 \ PATH=/usr/bin:/usr/vacpp/bin ./configure make Make builds fine, but pg_regress: initdb fails. src/test/regress/log reads: Running ...
    Mihai CrivetiMihai Criveti
    Feb 9, 2009 at 2:11 am
    Feb 11, 2009 at 8:03 pm
  • The pg_autovacuum system catalog will be deprecated in 8.4, but my customers use them to control autovacuum to emulate maintenance window. So, I'm trying to re-implement the catalog using a VIEW and ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Feb 16, 2009 at 4:03 am
    Mar 9, 2009 at 2:35 pm
  • I've been examining multi-major-version binary packaging again, and I was wondering whether we have a good overview over which pieces of the installation are backward compatible (that is, they can be ...
    Peter EisentrautPeter Eisentraut
    Feb 12, 2009 at 2:16 pm
    Feb 16, 2009 at 11:33 am
  • Attached is a patch that modifies psql \dX commands to treat objects in information_schema as "system objects". This prevents them from showing up in \dX *.* and polluting the user objects list. This ...
    Martin PihlakMartin Pihlak
    Feb 25, 2009 at 10:06 am
    Apr 8, 2009 at 10:30 pm
  • Might that have anything to do with this? http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=dungbeetle&dt=2009-02-18%2019:44:01 regards, tom lane
    Tom LaneTom Lane
    Feb 18, 2009 at 8:43 pm
    Feb 25, 2009 at 10:53 pm
  • Hi everyone, I've been recently testing PostgreSQL 8.3.4 (upgrade to 8.3.6 is scheduled) with a large number of connections from separate boxes each using a locally installed pgpool-II set in ...
    Matteo BeccatiMatteo Beccati
    Feb 11, 2009 at 9:30 am
    Feb 14, 2009 at 11:11 am
  • Hi, Is there any way to stop autovacuum temporarily?(other than edit postgresql.conf and reload it) Pgpool-II does not want autovacuum running while doing "onlie recovery". -- Tatsuo Ishii SRA OSS, ...
    Tatsuo IshiiTatsuo Ishii
    Feb 10, 2009 at 1:15 am
    Feb 12, 2009 at 10:04 am
  • I have thought about how to handle dumped columns and would like to get some feedback on this. It is easy to find the dropped columns with 'pg_attribute.attisdropped = true'. The basic problem is ...
    Bruce MomjianBruce Momjian
    Feb 12, 2009 at 4:30 pm
    Feb 17, 2009 at 3:42 pm
  • We often discuss changing user-visible behavior of various kinds and are usually clueless on the question of "someone might rely on this" or "how many people are still using this" etc. Still, it is ...
    Peter EisentrautPeter Eisentraut
    Feb 11, 2009 at 7:47 am
    Feb 12, 2009 at 3:07 am
  • Hi, I see a regression test failure in my mingw-vista port when I invoke the command make check MULTIBYTE=euc_jp NO_LOCALE=yes . It causes a crash at tsearch. The crash seems to occur when the server ...
    Hiroshi InoueHiroshi Inoue
    Feb 17, 2009 at 11:57 pm
    Mar 2, 2009 at 8:43 pm
  • Hi, I'm interested in data representation and debug of optimizer routines. Thus, I've changed the debug functions of allpaths.c to make a graphviz-like output of RelOptInfo structure. Any idea about ...
    Adriano LangeAdriano Lange
    Feb 18, 2009 at 3:32 pm
    Feb 27, 2009 at 1:06 am
  • Hi, When I read function "EvalPlanQual", I found the following code: if (heap_fetch(relation, &SnapshotDirty, &tuple, &buffer, true, NULL)) { /* * If xmin isn't what we're expecting, the slot must ...
    Jacky LengJacky Leng
    Feb 19, 2009 at 5:47 am
    Feb 20, 2009 at 9:16 am
  • When we take the snapshot of running transactions in the master, in GetRunningTransactionData(), it only includes top-level xids and those subxids that are in the subxid caches. Overflowed subxids ...
    Heikki LinnakangasHeikki Linnakangas
    Feb 25, 2009 at 8:40 pm
    Mar 4, 2009 at 3:44 am
  • Hmm. The comments in vacuum.c about this case suppose that it could only be a transient condition, ie the tuple became dead while we were looking at the page. Evidently it's persistent for you, which ...
    Tom LaneTom Lane
    Feb 12, 2009 at 10:13 pm
    Feb 25, 2009 at 5:42 pm
  • With the new snapshot maintenance code, it looks like we can advance the xmin more aggressively. For instance: S1: INSERT INTO foo VALUES(1); S2: BEGIN; DECLARE c1 CURSOR FOR SELECT i FROM foo; S1: ...
    Jeff DavisJeff Davis
    Feb 10, 2009 at 8:31 pm
    Feb 12, 2009 at 4:40 am
  • Hmm, so is this needed on all other PLs too?
    Alvaro HerreraAlvaro Herrera
    Feb 17, 2009 at 5:14 pm
    Mar 8, 2009 at 4:10 pm
  • hi, i've been testing new -m option of pg_restore with great pleasure. first, let me thank the developpers, it cut restoring time by half. is it normal that -m doesn't cope well with -C? createdb db ...
    OhpOhp
    Feb 18, 2009 at 6:06 pm
    Feb 20, 2009 at 1:45 pm
  • Hello, I found this today. Note, auto vacuum has been disabled for this relation for a very, very long time. At the very end you will see that this relation has been autovacuumed previously as well. ...
    Joshua D. DrakeJoshua D. Drake
    Feb 13, 2009 at 8:21 pm
    Feb 19, 2009 at 4:26 pm
  • It would be very useful if there were an option to have ts_headline append ellipses before or after a result fragement based on the position of the fragment in the source document. For instance, when ...
    Asher SnyderAsher Snyder
    Feb 14, 2009 at 8:43 pm
    Feb 14, 2009 at 9:55 pm
  • One independent change included in the Hot Standby patch is the change to the way subtransaction cache works. With the patch, only subtransactions that don't fit in the subxid cache in PGPROC are ...
    Heikki LinnakangasHeikki Linnakangas
    Feb 12, 2009 at 7:50 am
    Feb 13, 2009 at 11:16 am
  • Here is my problem and also the question. I'd like adding a field in Path structure and Plan structure as follows: typedef struct Path{ ....bla bla bla Cost energy_cost; ....bla bla bla } typedef ...
    Zichen XuZichen Xu
    Feb 23, 2009 at 9:14 pm
    Feb 24, 2009 at 1:31 pm
  • Hi everyone, I want to try to add a multi calendar system for pgsql. I want to know if it will be accepted as a patch to pgsql? More details: Multi calendar systems are useful for several languages ...
    Mohsen AlimomeniMohsen Alimomeni
    Feb 18, 2009 at 4:21 pm
    Feb 22, 2009 at 2:22 pm
  • I reported the following bug to -bugs, and I'd like to discuss whether we need to fix the issue or how to fix it. "ITAGAKI Takahiro" wrote: We already have some codes to avoid -0 float8um (unary ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Feb 17, 2009 at 1:13 am
    Feb 18, 2009 at 1:35 am
  • If Kerberos V5 is not installed on a Windows platform, the following error dialog is returned upon attempted installation: Posgres.exe - Unable to Locate Component This application has failed to ...
    Dann CorbitDann Corbit
    Feb 27, 2009 at 1:32 am
    Feb 27, 2009 at 11:16 am
  • Should we log a warning at startup when effective_cache_size is less than shared_buffers? -Kevin
    Kevin GrittnerKevin Grittner
    Feb 25, 2009 at 11:21 pm
    Feb 26, 2009 at 9:43 am
  • ... and the build logs don't show any particular reason for it. What is wrong, and why isn't the buildfarm script capturing a useful error message? regards, tom lane
    Tom LaneTom Lane
    Feb 25, 2009 at 4:41 pm
    Feb 25, 2009 at 5:42 pm
  • Hello I am checking this functionality and I am afraid, so option all is broken. postgres=# select * from pg_stat_user_functions; funcid | schemaname ...
    Pavel StehulePavel Stehule
    Feb 22, 2009 at 2:27 pm
    Feb 22, 2009 at 11:51 pm
  • Howdy, I was just updating a function in pgTAP that, given a schema name and an array of function names, returns a set of those function names that are not in the named schema. I got it working with ...
    David E. WheelerDavid E. Wheeler
    Feb 20, 2009 at 1:13 am
    Feb 20, 2009 at 4:09 am
  • Hmm, I suppose we can't readily run pg_dump against a stand-alone backend? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
    Heikki LinnakangasHeikki Linnakangas
    Feb 10, 2009 at 4:52 pm
    Feb 10, 2009 at 5:22 pm
Feb 2009
123
Group Navigation
period‹ prev | Feb 2009 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions110
posts1,399
users128
websitepostgresql.org...
irc#postgresql

128 users for February 2009

Tom Lane: 220 posts Robert Haas: 122 posts Bruce Momjian: 99 posts Heikki Linnakangas: 69 posts Simon Riggs: 66 posts Andrew Dunstan: 63 posts Peter Eisentraut: 47 posts Alvaro Herrera: 37 posts Kevin Grittner: 34 posts Andrew Chernow: 26 posts Fujii Masao: 26 posts KaiGai Kohei: 26 posts Joshua D. Drake: 25 posts Greg Stark: 24 posts Pavel Stehule: 21 posts Teodor Sigaev: 19 posts David E. Wheeler: 18 posts David Fetter: 17 posts Grzegorz Jaskiewicz: 17 posts Jaime Casanova: 16 posts
show more
Archives