FAQ

PostgreSQL > pgsql-hackers > June 2006

Search Discussions

150 discussions - 1,624 posts

  • We all know that PostgreSQL suffers performance problems when rows are updated frequently prior to a vacuum. The most serious example can be seen by using PostgreSQL as a session handler for a busy ...
    Mark L. WoodwardMark L. Woodward
    Jun 21, 2006 at 5:53 pm
    Jun 29, 2006 at 3:27 pm
  • Just got this rather surprising result: regression=# \timing Timing is on. regression=# explain analyze select * from tenk1 a join tenk1 b on a.unique1 = b.unique2; QUERY PLAN ...
    Tom LaneTom Lane
    Jun 6, 2006 at 3:02 am
    Jun 13, 2006 at 5:37 pm
  • I've implemented most of ADD/DROP INHERITS but it's my first significant piece of code at this level. I would appreciate any feedback about it. In particular I'm worried I may be on the wrong track ...
    Greg StarkGreg Stark
    Jun 7, 2006 at 5:33 pm
    Jun 11, 2006 at 5:23 pm
  • [ redirecting to -hackers, as I see no need for this to be a core issue ] Charles Comiskey <comiskey@us.ibm.com writes: This code seems to have been inserted by Tom Lockhart on 1997-07-29 (geo_ops.c ...
    Tom LaneTom Lane
    Jun 22, 2006 at 3:37 pm
    Jun 26, 2006 at 5:43 pm
  • Ah, OK that makes sense. An alternative solution when the signature was changed could perhaps have been to pass one single argument, a structure appointing the data and its associated type. My idea ...
    Thomas HallgrenThomas Hallgren
    Jun 28, 2006 at 4:39 pm
    Jul 9, 2006 at 1:35 pm
  • Something someone said on IRC just now triggered a little memory ... I think we should provide an option to have pg_dump work in CSV mode rather than text mode. This probably doesn't have much ...
    Andrew DunstanAndrew Dunstan
    Jun 12, 2006 at 5:13 pm
    Jun 14, 2006 at 10:27 pm
  • I've been making another pass over getting rid of buildfarm failures. The remaining ones I see at the moment are: firefly HEAD: intermittent failures in the stats test. We seem to have fixed every ...
    Tom LaneTom Lane
    Jun 2, 2006 at 4:07 am
    Aug 19, 2006 at 10:58 am
  • The only way that I'm aware of for disabling this is at compile time ... after running configure, you want to modify: src/include/pg_config.h and undef HAVE_SETPROCTITLE ... I'm CC'ng -hackers about ...
    Marc G. FournierMarc G. Fournier
    Jun 11, 2006 at 9:34 pm
    Jun 17, 2006 at 5:57 pm
  • We have now experienced index corruption on two separate but identical slony clusters. In each case the slony subscriber failed after attempting to insert a duplicate record. In each case reindexing ...
    Marc MunroMarc Munro
    Jun 28, 2006 at 4:28 pm
    Jul 20, 2006 at 12:47 am
  • Tom had posted a question about file compression with copy. I thought about it, and I want to through this out and see if anyone things it is a good idea. Currently, the COPY command only copies a ...
    Mark L. WoodwardMark L. Woodward
    Jun 2, 2006 at 1:26 pm
    Jun 6, 2006 at 2:56 pm
  • OK, here's my problem, I have a nature study where we have about 10 video cameras taking 15 frames per second. For each frame we make a few transactions on a PostgreSQL database. We want to keep ...
    Mark L. WoodwardMark L. Woodward
    Jun 6, 2006 at 12:28 pm
    Jun 11, 2006 at 8:36 pm
  • O.k. so now what I am getting from this thread is, the functions exist now in pg_dump but we want to pull them out of pg_dump and push them into the backend? Joshua D. Drake -- === The PostgreSQL ...
    Joshua D. DrakeJoshua D. Drake
    Jun 10, 2006 at 11:09 pm
    Aug 22, 2006 at 3:40 am
  • I am thrill to inform you all that Sun has just donated a fully loaded T2000 system to the PostgreSQL community, and it's being setup by Corey Shields at OSL (osuosl.org) and should be online ...
    Robert LorRobert Lor
    Jun 16, 2006 at 3:22 pm
    Jul 24, 2006 at 3:35 am
  • I notice buildfarm member snake is unhappy: The program "postgres" is needed by initdb but was not found in the same directory as ...
    Tom LaneTom Lane
    Jun 19, 2006 at 11:02 pm
    Jun 23, 2006 at 7:29 am
  • meerkat and snake both have persistent "CVS-Unknown" failures in some but not all branches. I can't see any evidence of an actual failure in their logs though. What I do see is "?" entries about ...
    Tom LaneTom Lane
    Jun 1, 2006 at 10:34 pm
    Jun 5, 2006 at 2:17 pm
  • I redid my previous measurements after finishing up the weekend's hacking. The numbers shown below are elapsed time in seconds for time psql -f testfile.sql postgres /dev/null using CVS HEAD and ...
    Tom LaneTom Lane
    Jun 21, 2006 at 3:02 pm
    Jun 26, 2006 at 7:47 pm
  • While investigating some problems with buildfarm member spoonbill I came across this piece of code in pg_regress.sh, which seems less than robust: # Wait till postmaster is able to accept connections ...
    Andrew DunstanAndrew Dunstan
    Jun 18, 2006 at 9:31 pm
    Jun 19, 2006 at 2:49 pm
  • I am working on a possible extension of postgresql mvcc to support very timely failure masking in the context of three-tier applications so i am currently studying Postgresql internals... I am ...
    Paolo romanoPaolo romano
    Jun 16, 2006 at 11:35 pm
    Jun 19, 2006 at 8:40 am
  • Would some people please run the attached test procedure and report back the results? I basically need to know the patch is an improvement on more platforms than just my own. Thanks ...
    Bruce MomjianBruce Momjian
    Jun 15, 2006 at 4:05 am
    Jun 17, 2006 at 5:43 pm
  • In view of my oprofile results http://archives.postgresql.org/pgsql-hackers/2006-06/msg00859.php I'm thinking we need some major surgery on the way that the stats collection mechanism works. It ...
    Tom LaneTom Lane
    Jun 17, 2006 at 9:12 pm
    Jun 19, 2006 at 2:29 pm
  • I've been interested in representing and manipulating time ranges in PostgreSQL, where a time range is defined by a start time and an end time. Time ranges are useful, for example, in representing ...
    Michael GlaesemannMichael Glaesemann
    Jun 10, 2006 at 2:52 pm
    Jun 16, 2006 at 4:37 pm
  • Hi, I see a performance issue on win32. This problem is causes by the following URL. http://support.microsoft.com/kb/823764/EN-US/ On win32, default SO_SNDBUF value is 8192 bytes. And libpq's buffer ...
    Yoshiyuki AsabaYoshiyuki Asaba
    Jun 27, 2006 at 3:23 pm
    Jun 28, 2006 at 3:59 pm
  • Motivation: ---------- The main goal for this Generic Monitoring Framework is to provide a common interface for adding instrumentation points or probes to Postgres so its behavior can be easily ...
    Robert LorRobert Lor
    Jun 19, 2006 at 8:01 pm
    Jun 20, 2006 at 5:48 pm
  • Hey, I just noticed (the hard way) that in 8.2CVS, the PG_MODULE_MAGIC header is now *required* for all loadable modules. This includes non-pg modules, such as Solaris' libumem (performance ...
    Josh BerkusJosh Berkus
    Jun 14, 2006 at 11:54 pm
    Jun 16, 2006 at 2:23 pm
  • Moving to -hackers I've been able to verify this on 8.1.4; psql -A -t -c 'SELECT * FROM largetable' /dev/null results in psql consuming vast quantities of memory. Why is this? ISTM this is a bug... ...
    Jim C. NasbyJim C. Nasby
    Jun 5, 2006 at 3:23 pm
    Jun 6, 2006 at 2:47 pm
  • [ moving to -hackers to get some more eyeballs on the question ] Simon Riggs <simon@2ndquadrant.com writes: No, which is a tad annoying now that you mention it. I'm not sure that there's any very ...
    Tom LaneTom Lane
    Jun 12, 2006 at 11:15 pm
    Jun 27, 2006 at 1:58 pm
  • I'm developing the summer of code project to create a xlog viewer. The tool we want to create is a DBA tool used for inspect the xlog files, looking for some operations, statistcs of database usage ...
    Diogo BiazusDiogo Biazus
    Jun 22, 2006 at 12:02 pm
    Jun 25, 2006 at 11:19 pm
  • As I follow Relyea Mike's recent post of possible memory leak, I think that we are lack of a good way of identifing memory usage. Maybe we should also remember __FILE__, __LINE__ etc for better ...
    Qingqing ZhouQingqing Zhou
    Jun 20, 2006 at 1:57 am
    Jun 23, 2006 at 2:30 am
  • http://lwn.net/Articles/178199/ Check out the article on sync_file_range(): ---- long sync_file_range(int fd, loff_t offset, loff_t nbytes, int flags); This call will synchronize a file's data to ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jun 19, 2006 at 5:42 am
    Jun 20, 2006 at 2:22 pm
  • Here is an overview of the SITC method: http://momjian.us/cgi-bin/pgsitc Anyone want to start coding? -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a ...
    Bruce MomjianBruce Momjian
    Jun 28, 2006 at 6:16 pm
    Jun 30, 2006 at 2:36 am
  • While looking at the recently-noticed problem that HashAggregate nodes store more columns of the input than they need to, I couldn't help noticing how much of the hashtable space goes into HeapTuple ...
    Tom LaneTom Lane
    Jun 26, 2006 at 2:36 pm
    Jun 26, 2006 at 9:08 pm
  • +1 -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
    Robert TreatRobert Treat
    Jun 8, 2006 at 12:22 am
    Jun 8, 2006 at 7:35 pm
  • Sorry, but I thought it that was the most appropriate list for the issue. I was following these instructions: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/custom-dict.html And what ...
    Rodrigo HjortRodrigo Hjort
    Jun 2, 2006 at 6:35 pm
    Jun 8, 2006 at 10:42 am
  • on IRC somebody mentioned that it took 34h to greate a GIN index (on a tsvector) on a ~3 Million column table (wikipedia dump) with a reasonable speced box (AMD 3400+). After getting hold of a dump ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Jun 26, 2006 at 5:09 pm
    Jul 11, 2006 at 8:26 pm
  • I have an optimization I'd like to see which I think should be pretty easy for someone familiar with the planner code to implement. My situation is this: I have an application using veil[1]. ...
    Phil FrostPhil Frost
    Jun 28, 2006 at 2:56 pm
    Jul 2, 2006 at 12:48 am
  • Buildfarm member platypus is showing a regression failure that I'm surprised we have not seen before: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=platypus&dt=2006-06-28%2014:05:01 Basically ...
    Tom LaneTom Lane
    Jun 28, 2006 at 4:09 pm
    Jun 28, 2006 at 11:38 pm
  • This has come up before, but I was reminded of it again after noticing how confused psql gets if you use control-C to get out of a long "\lo_import" operation. Usually the control-C hits while ...
    Tom LaneTom Lane
    Jun 11, 2006 at 4:32 pm
    Jun 13, 2006 at 8:31 am
  • There is a well known command called CLUSTER which organizes table in specified index's order. It has a drawback, that new tuples added are not in this order. Last night I had idea which could be ...
    Dawid KuroczkoDawid Kuroczko
    Jun 25, 2006 at 11:48 pm
    Jun 28, 2006 at 3:46 am
  • Hi, I think there is a bug/misscalculation of some rare query i am using. Suppose we only query one specific relation R. R contains indices but not on all attributes or not on all ordered subset of ...
    Tzahi FadidaTzahi Fadida
    Jun 23, 2006 at 12:56 pm
    Jun 23, 2006 at 9:13 pm
  • Hi, after some experimentation, I came up with the attached patch, which implements parsing the following SERIAL types: SERIAL SERIAL GENERATED { ALWAYS | BY DEFAULT } SERIAL GENERATED [ ALWAYS | BY ...
    Zoltan BoszormenyiZoltan Boszormenyi
    Jun 11, 2006 at 10:39 pm
    Jun 12, 2006 at 9:59 pm
  • On a separate note. The one major remaining piece here is in constraints. I'm thinking what I have to check is that every constraint present on the parent table is present on the child tables. And ...
    Greg StarkGreg Stark
    Jun 8, 2006 at 8:30 pm
    Jun 9, 2006 at 6:50 pm
  • I originally suggested a methodology for preserving MVCC and everyone is confusing it as update "in place," this isnot what I intended. How about a form of vacuum that targets a particular row? Is ...
    Mark L. WoodwardMark L. Woodward
    Jun 24, 2006 at 6:11 pm
    Jun 26, 2006 at 6:50 pm
  • Lines 509-512 of contrib/dblink/expected/dblink.out read: -- this should fail because there is no open transaction SELECT dblink_exec('myconn','DECLARE xact_test CURSOR FOR SELECT * FROM foo'); ...
    Tom LaneTom Lane
    Jun 18, 2006 at 3:35 pm
    Jun 20, 2006 at 9:00 pm
  • SELECT INTO doesn't set ROW_COUNT ... but if we change the code to set FOUND before throwing the error, it'd work to tell people to check FOUND. (Thinks a bit...) Actually not, because if the ...
    Tom LaneTom Lane
    Jun 16, 2006 at 8:06 pm
    Jun 16, 2006 at 11:02 pm
  • I looked into the timezone specifications and basically extracted a list of existing offsets from the zic database. My proposed format for the timezone files is something like this: HADT -32400 D # ...
    Joachim WielandJoachim Wieland
    Jun 13, 2006 at 12:20 pm
    Jun 14, 2006 at 9:40 pm
  • We got a lot requests about including stemmers and ispell dictionaries for all accessible languages into tsearch2. I understand that tsearch2 will be closer to end user. But sources of snowball ...
    Teodor SigaevTeodor Sigaev
    Jun 7, 2006 at 5:06 pm
    Jun 9, 2006 at 2:27 pm
  • Can someone please explain why in include/utils/datetime.h (struct datetkn) there is a check for _AIX that either initializes a char* pointer or a char array? Is there any advantage of a char-array ...
    Joachim WielandJoachim Wieland
    Jun 6, 2006 at 10:33 am
    Jun 7, 2006 at 1:41 am
  • A bug reported by Josh Drake, crashes 8.1 and CVS HEAD: Test case is: create table pk (id bigserial primary key); insert into pk values (DEFAULT); insert into pk values (DEFAULT); insert into pk ...
    Alvaro HerreraAlvaro Herrera
    Jun 20, 2006 at 4:53 pm
    Jun 21, 2006 at 6:44 pm
  • Awhile back, there was a discussion about psql \d display being really slow in a database with 4000 tables: http://archives.postgresql.org/pgsql-hackers/2005-09/msg01085.php I looked into this some, ...
    Tom LaneTom Lane
    Jun 14, 2006 at 11:25 pm
    Jun 15, 2006 at 1:32 pm
  • Currently, the only way to get a listing of tables in a schema via psql is to modify your search_path, which is both non-intuitive and a PITA. You can do \d schemaname., but that's the equivalent of ...
    Jim C. NasbyJim C. Nasby
    Jun 9, 2006 at 7:34 pm
    Jun 9, 2006 at 9:08 pm
Jun 2006
123
Group Navigation
period‹ prev | Jun 2006 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions150
posts1,624
users147
websitepostgresql.org...
irc#postgresql

147 users for June 2006

Tom Lane: 337 posts Andrew Dunstan: 88 posts Jim Nasby: 83 posts Greg Stark: 75 posts Martijn van Oosterhout: 71 posts Bruce Momjian: 67 posts Alvaro Herrera: 58 posts Bruce Momjian: 53 posts Mark L. Woodward: 48 posts Hannu Krosing: 43 posts Simon Riggs: 39 posts Josh Berkus: 37 posts Joshua D. Drake: 34 posts Qingqing Zhou: 24 posts Dave Page: 23 posts Jonah H. Harris: 23 posts Stefan Kaltenbrunner: 21 posts Andreas Zeugswetter: 19 posts Thomas Hallgren: 18 posts Magnus Hagander: 16 posts
show more
Archives