Search Discussions
-
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 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 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 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 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 Conway
Mar 14, 2005 at 6:20 am
Apr 2, 2005 at 4:45 pm -
22
PHP stuff
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-Lynne
Mar 15, 2005 at 7:32 am
Mar 18, 2005 at 1:06 pm -
21
Bug 1500
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 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 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 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. 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 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 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 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 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. 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 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 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 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 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 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. 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 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 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 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 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 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 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ü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-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 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 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 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-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.
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 Pradier
Mar 16, 2005 at 11:12 am
Mar 16, 2005 at 4:14 pm -
7
Raw size
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 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 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 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 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 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 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 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 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 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 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 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 Moncure
Mar 17, 2005 at 3:47 pm
Mar 18, 2005 at 3:09 pm -
6
postgreSQL-8.0.1 compilation with icc-8.1 on Itanium-2 gives "error: asm statements not supported"
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 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 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 Buttafuoco
Mar 7, 2005 at 6:03 pm
Mar 7, 2005 at 9:47 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 153 |
posts | 1,069 |
users | 144 |
website | postgresql.org... |
irc | #postgresql |
144 users for March 2005
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)