Search Discussions
-
I have been thinking about the problem of VACUUM and how we might fix it for 7.2. Vadim has suggested that we should attack this by implementing an overwriting storage manager and transaction UNDO, ...
Tom Lane
May 17, 2001 at 11:05 pm
May 29, 2001 at 8:38 pm -
70
7.2 items
Here is a small list of big TODO items. I was wondering which ones people were thinking about for 7.2? --------------------------------------------------------------------------- * Add replication of ...Bruce Momjian
May 10, 2001 at 5:21 pm
Jun 28, 2001 at 9:35 am -
I was talking to a Linux user yesterday, and he said that performance using the xfs file system is pretty bad. He believes it has to do with the fact that fsync() on log-based file systems requires ...
Bruce Momjian
May 2, 2001 at 8:18 pm
May 11, 2001 at 12:37 pm -
I am starting to package 7.1.1, and I see I did not brand 7.1 properly. I forgot the date in the HISTORY file, and didn't update register.txt. I will do all those now for 7.1.1. -- Bruce Momjian | ...
Bruce Momjian
May 3, 2001 at 4:16 pm
Nov 28, 2001 at 12:33 am -
About to be implemented, for your approval... Variable name: dynamic_library_path Permissions: superuser Default value: empty string Specification: When the dynamic loader attempts to load a file ...
Peter Eisentraut
May 15, 2001 at 3:39 pm
May 17, 2001 at 2:02 am -
OK, now that we have started 7.2 development, I am going to go through the outstanding patches and start to apply them or reject them. They are at: http://candle.pha.pa.us/cgi-bin/pgpatches I could ...
Bruce Momjian
May 8, 2001 at 7:57 pm
Jun 7, 2001 at 12:08 am -
I was remembering tonight some of the strange fixes we made in the early days of PostgreSQL. I particularly remember the LIKE optimization I did in gram.y to allow queries that are anchored to the ...
Bruce Momjian
May 31, 2001 at 3:42 am
Jun 6, 2001 at 4:54 am -
Bpalmer
May 10, 2001 at 5:25 pm
May 13, 2001 at 1:34 am -
That makes sense to me. On "traditional" Unices, we could use the raw character device for a partition (eg /dev/rdsk/* on Solaris), and on Linux we'd use /dev/raw*, which is a mapping to a specific ...
Doug McNaught
May 7, 2001 at 6:51 pm
May 11, 2001 at 12:29 pm -
Are we releasing tomorrow. I will stamp the CVS STABLE branch tonight as 7.1.2. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | ...
Bruce Momjian
May 11, 2001 at 12:48 am
May 13, 2001 at 1:26 am -
We have on the TODO list: * SELECT pg_class FROM pg_class generates strange error It passes the tablename as targetlist all the way to the executor, where it throws an error about Node 704 unkown. ...
Bruce Momjian
May 19, 2001 at 3:17 am
Jun 13, 2001 at 1:52 pm -
ftp://ftp.postgresql.org/pub/source/v7.1.2 ... Just want a second opinion before I announce more publicly ... Thanks ... Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org ...
The Hermit Hacker
May 22, 2001 at 5:31 pm
May 28, 2001 at 12:31 pm -
I have an external search engine system which plugs in to postgres. I use a few C functions to interface the search daemon with the Postgres back-end. The best that I have been able to do is do a ...
Mark L. Woodward
May 18, 2001 at 11:22 pm
May 20, 2001 at 9:17 pm -
Except for re-adding users. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this ...
Jan Wieck
May 7, 2001 at 2:42 pm
May 14, 2001 at 4:11 pm -
Sorry to gripe here. Don't get me wrong, I think Postgres is amazing, and I think all you guys do an amazing job. Is it just me, or do others agree, functions returning sets need to be able to be ...
Mark L. Woodward
May 19, 2001 at 8:35 pm
May 20, 2001 at 6:56 pm -
I've tried the pg_dump bundled in the new 7.1.1 release. I wanted to test its feature of dumping a 7.0.X database. Let's say I have database A running 7.1.1, B running 7.0.2. Both servers have the ...
Alessio Bragadini
May 7, 2001 at 10:19 am
Nov 28, 2001 at 10:23 pm -
Wouldn't a sequential scan on the heap table be the fastest way to find keys, that need to be deleted ? foreach tuple in heap that can be deleted do: foreach index call the current "index delete" ...
Andreas Zeugswetter
May 18, 2001 at 10:14 am
May 29, 2001 at 5:41 pm -
14
C++ Headers
Is any support for reworking the postgres headers such that they can be used, cleanly, in a C++ program?Mark L. Woodward
May 19, 2001 at 2:20 pm
May 23, 2001 at 10:57 pm -
Hi guys, I have an experimental piece of code like this (that tries to remove pg_relcheck entries): deleted = 0; while (HeapTupleIsValid(tup = heap_getnext(rcscan, 0))) { simple_heap_delete(rcrel, ...
Christopher Kings-Lynne
May 14, 2001 at 10:14 am
May 23, 2001 at 2:53 am -
Can someone tell me what we use indislossy for? The only comment I could find was: /* * WITH clause reinstated to handle lossy indices. -- JMH, 7/22/96 */ foreach(pl, parameterList) { DefElem *param ...
Bruce Momjian
May 14, 2001 at 8:35 pm
May 15, 2001 at 1:51 pm -
We did not bump the shared library versions before the 7.1 release. Maybe we should do this before 7.1.2 goes out. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
Peter Eisentraut
May 9, 2001 at 6:54 pm
May 11, 2001 at 10:08 pm -
Hi folks, I just committed changes to the SPI manager and PL/pgSQL, providing full CURSOR support. A detailed description is attached as a Postscript file. Brief description follows. # # Note: # The ...
Jan Wieck
May 21, 2001 at 7:02 pm
May 31, 2001 at 5:16 pm -
Christopher
May 20, 2001 at 7:55 am
May 30, 2001 at 1:33 pm -
I am loathe to even bring this up, but with two messages today about it, I am going to be short and sweet: We don't have a reasonable upgrade path. ASCII dump- install new- initdb- restore is not a ...
Lamar Owen
May 16, 2001 at 8:51 pm
May 18, 2001 at 5:35 pm -
The idea is very very good, and since there is an exaple implementation in pg 4 it should probably be possible to reimplement. (DB2 has this feature also) In real life, you would e.g. index a status ...
Andreas Zeugswetter
May 15, 2001 at 10:15 am
Jul 10, 2001 at 9:36 pm -
Would it be possible to allocate varibles that can be addressed with SET? CREATE [TEMP] VARIABLE fubar ; set FUBAR=5 ; -- I'm not offering myself as an example; every life evolves by its own laws. ...
Mark L. Woodward
May 13, 2001 at 1:15 am
May 14, 2001 at 12:16 am -
Right now anyone can look in pg_statistic and discover the min/max/most common values of other people's tables. That's not a lot of info, but it might still be more than you want them to find out. ...
Tom Lane
May 6, 2001 at 5:15 pm
May 7, 2001 at 11:36 pm -
One more feature for discussion :-) In the next couple of hours (at least tomorrow) I would be ready to commit the backend changes for table-/index-access statistics and current backend activity ...
Jan Wieck
May 31, 2001 at 4:16 pm
Jun 1, 2001 at 4:23 pm -
Are these columns in pg_class: relukeys | relfkeys | relhaspkey unused or what? Chris
Christopher Kings-Lynne
May 30, 2001 at 9:01 am
May 30, 2001 at 3:42 pm -
It was my understanding, that the heap xtid is part of the key now, and thus with a somewhat modified access, it would find the one exact row directly. And in above case, the keys (since identical ...
Andreas Zeugswetter
May 18, 2001 at 1:59 pm
May 30, 2001 at 8:16 pm -
Hi, I want to learn, how the pl/plsql-parser/compiler works. Therefore I planned to implement a simple ELSIF, like oracle does. I added the following K_ELSIF branch to gram.y, in the hope that, when ...
Klaus Reger
May 16, 2001 at 10:35 am
May 22, 2001 at 1:54 pm -
Be careful. That will only work if the static library contains relocatable code so that the entire resulting library 'plpython.so' can be loaded dynamically. From what I can tell, this is true on ...
Mark Hollomon
May 10, 2001 at 6:19 pm
May 14, 2001 at 7:56 am -
Hi, I have noticed that it is possible to create duplicate CHECK (haven't tried other) constraints in 7.0.3 by doing something like this: CREATE TABLE "test" ( "a" int4, CHECK (a < 400), CONSTRAINT ...
Christopher Kings-Lynne
May 4, 2001 at 1:51 am
May 9, 2001 at 9:14 pm -
Hello all- Yesterday I upgraded my database from Pg v7.1RC1 to v7.1.1. Since this upgrade, I have been having unbelievable performance problems with updates to a particular table, and I've tracked ...
Jon Lapham
May 10, 2001 at 8:54 pm
May 13, 2001 at 12:57 am -
Joel Burton
May 3, 2001 at 8:17 pm
May 9, 2001 at 11:00 pm -
Hello I see the following proba= select * from pg_language; lanname |lanispl|lanpltrusted|lanplcallfoid|lancompiler --------+-------+------------+-------------+-------------- internal|f |f | 0|n/a ...
Vladimir V. Zolotych
May 5, 2001 at 1:54 pm
May 8, 2001 at 7:29 pm -
I'm trying to get my geometric type to spatially index. I tried RTrees, but they dont like objects that are bigger than 8k. I'm now trying to get a GiST index to index based on the bounding box thats ...
Dave Blasby
May 25, 2001 at 1:47 am
Jul 24, 2003 at 6:56 pm -
We have implemented multi-key index support for GiST. Patch is available from http://www.sai.msu.su/~megera/postgres/gist/code/7.1.2/patch_multikeygist.7.1.2.gz The patch could be applied for ...
Oleg Bartunov
May 26, 2001 at 12:33 pm
Jun 1, 2001 at 9:42 am -
The docs seem a little sketchy but the source implies that there is a difference between new and old style triggers. I can't seem to find this difference. I tried following the only current example I ...
D'Arcy J.M. Cain
May 27, 2001 at 2:56 pm
May 28, 2001 at 7:07 pm -
http://www.postgresql.org/~petere/gettext.html This is a compilation of the BSD-licensed gettext tools from NetBSD plus some of my own code, put into a (hopefully) portable package, intended to be ...
Peter Eisentraut
May 22, 2001 at 8:33 pm
May 24, 2001 at 9:10 pm -
Since there is no plan yet how to do a wholesale overhaul of the ACL system, I'd like to stick a few improvements into the current implementation: * Make DELETE distinct from UPDATE privilege * ...
Peter Eisentraut
May 24, 2001 at 11:06 am
May 24, 2001 at 8:05 pm -
They are already small (16Mb). Or do you mean even smaller ? This imposes one huge risk, that is already a pain in other db's. You need all logs of one transaction online. For a GigaByte transaction ...
Andreas Zeugswetter
May 21, 2001 at 2:45 pm
May 23, 2001 at 3:28 pm -
In addition to my RedHat 6.2 server, I'm installing Postgres 7.1.1 on an SGI O2 (IRIX 6.5.10). The configure works, but the 'gmake all' fails when it tries to compile 'xact.c': cc-1521 cc: WARNING ...
G. Anthony Reina
May 11, 2001 at 11:57 pm
May 15, 2001 at 5:08 pm -
I have been using PostgreSQL and XFS file systems on SGI's for many years, and PostgreSQL is fast. Dumping and loading 100GB of table files takes less than one day elapsed (provided there is no other ...
Robert E. Bruccoleri
May 2, 2001 at 10:42 pm
May 7, 2001 at 6:39 pm -
Has it been established to satisfaction that a BSD-licensed gettext implementation is available and working? (Note that we still need xgettext and msgmerge from GNU, but this only on the maintainer ...
Peter Eisentraut
May 29, 2001 at 5:47 pm
Jun 2, 2001 at 2:46 pm -
Starting pg_dump, this error occured (there is no output dump, unfortunately). Getting closer, I got this: tir=# SELECT pg_get_viewdef(c.relname) AS definition FROM pg_class c offset 441 limit 1; ...
Kovacs Zoltan
May 31, 2001 at 12:42 pm
Jun 2, 2001 at 11:54 am -
psql -c 'select * from pg_class; select * from no_such_table;' Shouldn't this at least give me the result of the first select before aborting the second? Moreover, shouldn't psql -c 'select * from ...
Peter Eisentraut
May 26, 2001 at 2:22 pm
May 27, 2001 at 2:03 am -
As long as you're fixing bugs in pgindent, here are some more follies exhibited by the most recent pgindent run. Some of these bugs have been there for awhile, but at least one (the removal of space ...
Tom Lane
May 20, 2001 at 9:03 pm
May 24, 2001 at 4:38 am -
The PL/Python build is now up to speed to as much as an extend as is under our control. I can also confirm that it works (as defined by the test suite) with Python 1.5 and 2.1. I've also put a ...
Peter Eisentraut
May 12, 2001 at 5:49 pm
May 16, 2001 at 7:36 pm -
Hi all! I have to convert functions and procedures from Oracle to PostgreSQL. I looked at all the stuff of the Pg-Homepage and I ask me if there are any tools, that support the conversion. Writing ...
Klaus Reger
May 10, 2001 at 1:38 pm
May 12, 2001 at 9:25 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 252 |
posts | 1,457 |
users | 176 |
website | postgresql.org... |
irc | #postgresql |
176 users for May 2001
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)