FAQ

PostgreSQL > pgsql-hackers > March 2005

Search Discussions

153 discussions - 1,069 posts

  • Hi! I've put together a patch for using IBM's ICU package for collation. If your OS does not have full support for collation ur uppercase/lowercase in multibyte locales, this might be useful. If you ...
    Palle GirgensohnPalle Girgensohn
    Mar 24, 2005 at 11:40 pm
    May 10, 2005 at 10:02 am
  • I was profiling a case involving UPDATEs into a table with too many indexes (brought to mind by mysql's sql-bench, about which more later) and got this rather surprising result for routines costing ...
    Tom LaneTom Lane
    Mar 6, 2005 at 5:18 am
    Jun 1, 2005 at 7:04 pm
  • After reading the spec a little, I think that we have oversimplified our handling of aggregate-free HAVING clauses. If you look in planner.c you'll find that such a clause is converted into a WHERE ...
    Tom LaneTom Lane
    Mar 9, 2005 at 11:40 pm
    Mar 14, 2005 at 4:51 pm
  • AndrewSN pointed out on IRC that ALTER TABLE ... ADD FOREIGN KEY and CREATE TRIGGER both acquire AccessExclusiveLocks on the table they are adding triggers to (the PK table, in the case of ALTER ...
    Neil ConwayNeil Conway
    Mar 22, 2005 at 5:56 am
    May 30, 2005 at 11:33 am
  • PostgreSQL should invalidate a cached query plan when one of the objects the plan depends upon is modified. This is the common case of a more general problem: a query plan depends on various parts of ...
    Neil ConwayNeil Conway
    Mar 14, 2005 at 6:20 am
    Apr 2, 2005 at 4:45 pm
  • I'm currently adding support for the v3 protocol in PHP pgsql extension. I'm wondering if anyone minds if I lift documentation wholesale from the PostgreSQL docs for the PHP docs for these functions. ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Mar 15, 2005 at 7:32 am
    Mar 18, 2005 at 1:06 pm
  • Hi, I have found what is causing the crash described in Bug 1500. Now I would like to fix it, but need opinions about what is the correct behaviour. The bug can be easily duplicated when formatting ...
    Lyubomir PetrovLyubomir Petrov
    Mar 25, 2005 at 7:55 pm
    May 7, 2005 at 5:58 pm
  • We have the following definition in fd.c: typedef struct vfd { signed short fd; /* current FD, or VFD_CLOSED if none */ ... } Vfd; but seems we use Vfd.fd as an integer, say in fileNameOpenFile() we ...
    Qingqing ZhouQingqing Zhou
    Mar 14, 2005 at 5:26 am
    Mar 16, 2005 at 12:00 pm
  • In HEAD psql, \df doesn't show functions that have no arguments: test= CREATE FUNCTION foo() RETURNS integer AS 'SELECT 1' LANGUAGE sql; CREATE FUNCTION test= \df foo List of functions Schema | Name ...
    Michael FuhrMichael Fuhr
    Mar 31, 2005 at 5:49 am
    Apr 4, 2005 at 1:09 am
  • Now that Tom has gotten the ARC- 2Q changes into the 8.0.x Branch, and Josh has had some time to do some preliminary performance testing on it, we need to put out 8.0.2 ... Core's hope is to wrap a ...
    Marc G. FournierMarc G. Fournier
    Mar 24, 2005 at 4:35 pm
    Mar 27, 2005 at 6:10 pm
  • Are we still bumping the libpq major version number for 8.0.2? I think it is a bad idea because we will require too many client apps to be recompiled, and we have had few problem reports. We do need ...
    Bruce MomjianBruce Momjian
    Mar 11, 2005 at 5:58 pm
    Mar 13, 2005 at 9:37 pm
  • Hi there, below is the problem I just bitten when play with toy db. I did: 1.initdb -D ./t1 2. pg_ctl -D ./t1 start 3. createdb test 4. psql test -c "create table a (f integer);" 5. run script which ...
    Oleg BartunovOleg Bartunov
    Mar 22, 2005 at 9:40 pm
    Mar 24, 2005 at 6:11 am
  • I've been taking a look at how to stop the planner from scribbling on its input. This is my first modification of any significance to the planner, so don't hesitate to tell me what I've gotten wrong ...
    Neil ConwayNeil Conway
    Mar 18, 2005 at 4:50 am
    Mar 21, 2005 at 1:36 am
  • Hi, Bernd and myself are working in updateable views, one thing we find is that when we have something like: create table foo ( col1 serial, col2 text default 'default' ); create view vfoo as select ...
    Jaime CasanovaJaime Casanova
    Mar 18, 2005 at 10:12 pm
    Mar 30, 2005 at 4:58 pm
  • Specs: 7.3.6 machine Dual Athlon MP 2 GIG of ram, 4 Drive IDE (3ware) RAID 10 OS FC1 with 2.4 kernel 7.4.6 machine Dual Opteron MP (64bit PostgreSQL), 2 Gig of Ram 10 Drive RAID 10 with 128 Meg ...
    Joshua D. DrakeJoshua D. Drake
    Mar 19, 2005 at 6:12 pm
    Mar 21, 2005 at 7:23 pm
  • No problem; thank you for supplying the test case. What I find is rather surprising: most of the runtime can be blamed on disassembling and reassembling tuples during the join steps. Here are the hot ...
    Tom LaneTom Lane
    Mar 14, 2005 at 12:08 am
    Mar 15, 2005 at 7:53 pm
  • I have seen some small regression failures on REL8_0_STABLE - I thought as we're coming up to a release I'd better run the stable branch through on my buildfarm clients. Windows has ordering failures ...
    Andrew DunstanAndrew Dunstan
    Mar 25, 2005 at 11:09 pm
    Mar 29, 2005 at 12:29 pm
  • Hi there, while learning inkscape I did a sketch of picture describing history of relational databases. It's available from http://mira.sai.msu.su/~megera/pgsql/ I'd be very grateful for any ...
    Oleg BartunovOleg Bartunov
    Mar 27, 2005 at 9:34 pm
    Mar 29, 2005 at 3:49 am
  • Hi there, I just noticed a little optimizer problem - in second query there is unused 'tycho t2' table alias which gets backend buried. This is artificial query, I just tried to check if optimizier ...
    Oleg BartunovOleg Bartunov
    Mar 8, 2005 at 11:05 pm
    Mar 24, 2005 at 5:16 am
  • Here is a more fully fleshed-out proposal. The basic goal that I'm aiming at is to be able to use OUT-parameter notation in plpgsql as an easy way of returning multiple values from a function. There ...
    Tom LaneTom Lane
    Mar 21, 2005 at 7:25 pm
    Mar 22, 2005 at 9:18 pm
  • Hello, I am looking at having one of our guys write up the code to allow logging as insert statements. I have a couple of questions. What would we like the postgresql.conf option to be? I was ...
    Joshua D. DrakeJoshua D. Drake
    Mar 1, 2005 at 10:15 pm
    Mar 3, 2005 at 11:38 pm
  • Hackers, I'm seeing what can I do about spilling the lock table to disk I welcome comments on the ideas outlined here. If anyone sees a showstopper please let me know. Notes on Spilling the Lock ...
    Alvaro HerreraAlvaro Herrera
    Mar 30, 2005 at 10:09 pm
    Apr 5, 2005 at 3:50 am
  • ... is apparently broken for Windows and Cygwin. See for example http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=loris&dt=2005-03-16%2001:55:33 cheers andrew
    Andrew DunstanAndrew Dunstan
    Mar 16, 2005 at 2:40 am
    Apr 4, 2005 at 1:03 am
  • You can't just randomly rearrange the pg_enc enum without forcing an initdb, because the numeric values of the encodings appear in system catalogs (eg pg_conversion). regards, tom lane
    Tom LaneTom Lane
    Mar 16, 2005 at 9:57 pm
    Mar 18, 2005 at 4:21 pm
  • Hello, I'd like to start working on the following TODO item: Referential Integrity / Support triggers on columns Is somebody else already working on this? Bye :) Chris.
    Chris MairChris Mair
    Mar 10, 2005 at 4:21 pm
    Mar 15, 2005 at 2:14 am
  • Folks, Although the SQL:2003 command MERGE has not yet been implemented in PostgreSQL, I'm guessing that there are best practices for how to implement the MERGE functionality. To recap, MERGE means ...
    David FetterDavid Fetter
    Mar 8, 2005 at 3:34 am
    Apr 19, 2005 at 3:56 am
  • I'd like to make add_missing_from=false the default for 8.1. Any objections? I think the only reason not to do this is for backward compatibility with previous releases of PostgreSQL, but I don't ...
    Neil ConwayNeil Conway
    Mar 31, 2005 at 1:27 am
    Apr 8, 2005 at 1:14 am
  • Hi, I've Google'd for the situation below and could not find any solution. We are using PostgreSQL 8.0.1, installed using PGDG RPMs on RHEL ES 3.0: ...
    Devrim GündüzDevrim Gündüz
    Mar 25, 2005 at 10:52 am
    Mar 27, 2005 at 7:31 pm
  • Running latest cvs on freebsd gives me errors in test strings and test errors, and completely hangs at this point: parallel group (14 tests): limit prepare sequence copy2 truncate rowtypes ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Mar 9, 2005 at 6:56 am
    Mar 9, 2005 at 3:17 pm
  • Scenario: A user download a pre-built PostgreSQL 7.4.7 from somewhere and a pre-built pljava distro from gborg. He gets everything running but suddenly encounteres problems with the timetz type. ...
    Thomas HallgrenThomas Hallgren
    Mar 9, 2005 at 6:27 pm
    Mar 11, 2005 at 9:54 am
  • I'm experimenting with pgpool 2.51 on my Linux box runnung two postgresql backends: pg74:5432 and pg801:5433 I configured pgpool to use pg74:5432 as primary backend and pg801:5433 as second one. ...
    Oleg BartunovOleg Bartunov
    Mar 9, 2005 at 5:10 pm
    Mar 10, 2005 at 4:43 am
  • Please let me know, if there is any option in postgresql to achieve the following usage of a b-tree index: For a relation R(att0, att1) and a btree index on attribute att0 In each insertion of a ...
    Ioannis TheoharisIoannis Theoharis
    Mar 6, 2005 at 9:33 pm
    Mar 9, 2005 at 9:24 am
  • I see this in my PQA analyzed PostgreSQL log: ######## Slowest queries select dict_init, dict_initoption, dict_lexize from pg_ts_dict where oid = $1 It's my number one slowest query apparently! Can ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Mar 31, 2005 at 3:56 am
    Apr 4, 2005 at 7:16 am
  • Hackers, I'd like to pose a problem we are facing (historical query time profiling) and see if any of you interested backend gurus have an opinion on the promise or design of a built-in backend ...
    Ed L.Ed L.
    Mar 23, 2005 at 8:32 pm
    Mar 24, 2005 at 3:42 pm
  • Hi everybody, I've just run into a seemingly strange behaviour of postgresql and I'd like to know if it's normal or what. I've got a table "operation" in which there _isn't_ any column "id_compte". ...
    David PradierDavid Pradier
    Mar 16, 2005 at 11:12 am
    Mar 16, 2005 at 4:14 pm
  • Hi, i have a table: create table triples( att0 varchar(1000), att1 int4, att2 varchar(20), att3 varchar(1000) ) My table has 990 raws. The (possibly wrong) way, with wich i compute the size of the ...
    Ioannis TheoharisIoannis Theoharis
    Mar 10, 2005 at 6:07 pm
    Mar 14, 2005 at 1:13 pm
  • Hi there, I noticed client error logging was changed in REL8_0_STABLE in compare with 8.0.1 release. 8.0.1: tycho=# select * from pg_stas where srelnae='tycho'; ERROR: relation "pg_stas" does not ...
    Oleg BartunovOleg Bartunov
    Mar 12, 2005 at 9:37 pm
    Mar 13, 2005 at 2:23 pm
  • We saw a case recently where a hash join was using much more memory than it was supposed to, causing failure when the server ran out of memory. The hash join code is supposed to spill tuples to disk ...
    Tom LaneTom Lane
    Mar 3, 2005 at 10:05 pm
    Mar 7, 2005 at 12:46 am
  • The problem with this is what happens to indexes on shared relations. If you change the collation, they are no longer valid. And you can't just reindex them, because then they would no longer be ...
    Alvaro HerreraAlvaro Herrera
    Mar 28, 2005 at 2:48 pm
    May 7, 2005 at 6:01 pm
  • Is there a reason why the implementation of hash joins uses a separate "hash" child node? AFAICS that node is only used in hash joins. Perhaps the intent was to be able to provide a generic "hashing" ...
    Neil ConwayNeil Conway
    Mar 31, 2005 at 3:57 am
    Apr 16, 2005 at 8:18 pm
  • This is a good point. While DELETE keeps the old rows around and VACUUM perserves them until the serialized transaction commits, truncate does not keep the old rows around. In fact, would a truncate ...
    Bruce MomjianBruce Momjian
    Mar 23, 2005 at 4:41 am
    Mar 23, 2005 at 6:40 pm
  • From src/backend/tcop/postgres.c: appendStringInfo(&str, "!\t%ld/%ld [%ld/%ld] filesystem blocks in/out\n", r.ru_inblock - Save_r.ru_inblock, /* they only drink coffee at dec */ r.ru_oublock - ...
    Michael FuhrMichael Fuhr
    Mar 18, 2005 at 8:01 am
    Mar 23, 2005 at 6:11 am
  • Currently, in places like heap_drop_with_catalog, we issue a FlushRelationBuffers() call followed by smgrscheduleunlink(). The latter doesn't actually do anything right away, but schedules a file ...
    Tom LaneTom Lane
    Mar 19, 2005 at 11:53 pm
    Mar 21, 2005 at 9:32 pm
  • Hi all, I've read TODO list in the 8.0.1, then I'm interested in the following topic. Does anyone have any plan to work on this? I think we need to extend the pg_database catalog to have a database ...
    Satoshi NagayasuSatoshi Nagayasu
    Mar 16, 2005 at 12:29 pm
    Mar 21, 2005 at 5:12 am
  • Hi all, When pgfoundry was opened, there was some talk about moving the projects from gborg there. This has not, to date, happened. Is there any chance of this happening now, even if only for the ...
    Shachar ShemeshShachar Shemesh
    Mar 20, 2005 at 8:06 am
    Mar 20, 2005 at 10:22 pm
  • We've had a TODO item for some time about allowing the user to set the size of the local buffer array that's used for accessing temporary tables. The holdup has been that localbuf.c used very ...
    Tom LaneTom Lane
    Mar 19, 2005 at 5:57 pm
    Mar 20, 2005 at 5:37 pm
  • Right now in postgres it is impossible to hide stored procedure source code from non-privileged users...namely the prosrc column of the pg_proc table. For those of you in a hurry skip to the summary ...
    Merlin MoncureMerlin Moncure
    Mar 17, 2005 at 3:47 pm
    Mar 18, 2005 at 3:09 pm
  • Hi, I am trying to compile postgresql-8.0.1 with icc-8.1.028 on a Linux RHEL AS3 SMP Itanium2 machine and I get an error as follows- The complete config.log and make.log is online at ...
    Vikram KalsiVikram Kalsi
    Mar 3, 2005 at 7:35 am
    Mar 9, 2005 at 4:30 am
  • Hi *, I have submitted a patch which does exactly this. Somebody edited it and Bruce put it on the queue for 8.1. Now we both did the same work twice. This is a good example how a public accessible ...
    Matthias SchmidtMatthias Schmidt
    Mar 1, 2005 at 5:58 pm
    Mar 9, 2005 at 3:52 am
  • Its there a reason postgresql doesn't record vacuum/analyze and dump times in pg_class (or another table). This seems like it would be a very helpful feature. for pg_dump I would add an option ...
    Jim ButtafuocoJim Buttafuoco
    Mar 7, 2005 at 6:03 pm
    Mar 7, 2005 at 9:47 pm
Mar 2005
1234
Group Navigation
period‹ prev | Mar 2005 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions153
posts1,069
users144
websitepostgresql.org...
irc#postgresql

144 users for March 2005

Tom Lane: 211 posts Bruce Momjian: 101 posts Christopher Kings-Lynne: 51 posts Neil Conway: 45 posts Mark L. Woodward: 34 posts Oleg Bartunov: 30 posts Andrew Dunstan: 27 posts Alvaro Herrera: 24 posts Greg Stark: 23 posts Simon Riggs: 23 posts Qingqing Zhou: 17 posts Michael Fuhr: 16 posts Peter Eisentraut: 16 posts Marc G. Fournier: 14 posts Nicolai Tufar: 14 posts Josh Berkus: 13 posts Bruno Wolff III: 11 posts Karel Zak: 11 posts Palle Girgensohn: 11 posts Thomas Hallgren: 11 posts
show more
Archives