FAQ

PostgreSQL > pgsql-hackers > May 2001

Search Discussions

252 discussions - 1,457 posts

  • 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 LaneTom Lane
    May 17, 2001 at 11:05 pm
    May 29, 2001 at 8:38 pm
  • 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 MomjianBruce 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 MomjianBruce 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 MomjianBruce 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 EisentrautPeter 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 MomjianBruce 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 MomjianBruce Momjian
    May 31, 2001 at 3:42 am
    Jun 6, 2001 at 4:54 am
  • BpalmerBpalmer
    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 McNaughtDoug 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 MomjianBruce 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 MomjianBruce 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 HackerThe 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. WoodwardMark 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 WieckJan 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. WoodwardMark 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 BragadiniAlessio 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 ZeugswetterAndreas Zeugswetter
    May 18, 2001 at 10:14 am
    May 29, 2001 at 5:41 pm
  • Is any support for reworking the postgres headers such that they can be used, cleanly, in a C++ program?
    Mark L. WoodwardMark 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-LynneChristopher 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 MomjianBruce 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 EisentrautPeter 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 WieckJan Wieck
    May 21, 2001 at 7:02 pm
    May 31, 2001 at 5:16 pm
  • ChristopherChristopher
    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 OwenLamar 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 ZeugswetterAndreas 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. WoodwardMark 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 LaneTom 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 WieckJan 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-LynneChristopher 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 ZeugswetterAndreas 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 RegerKlaus 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 HollomonMark 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-LynneChristopher 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 LaphamJon Lapham
    May 10, 2001 at 8:54 pm
    May 13, 2001 at 12:57 am
  • Joel BurtonJoel 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. ZolotychVladimir 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 BlasbyDave 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 BartunovOleg 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. CainD'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 EisentrautPeter 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 EisentrautPeter 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 ZeugswetterAndreas 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 ReinaG. 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. BruccoleriRobert 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 EisentrautPeter 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 ZoltanKovacs 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 EisentrautPeter 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 LaneTom 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 EisentrautPeter 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 RegerKlaus Reger
    May 10, 2001 at 1:38 pm
    May 12, 2001 at 9:25 pm
May 2001
123456
Group Navigation
period‹ prev | May 2001 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions252
posts1,457
users176
websitepostgresql.org...
irc#postgresql

176 users for May 2001

Tom Lane: 274 posts Bruce Momjian: 248 posts Peter Eisentraut: 85 posts Andreas Zeugswetter: 49 posts Mark L. Woodward: 40 posts Vadim Mikheev: 35 posts Christopher Kings-Lynne: 31 posts The Hermit Hacker: 31 posts Lamar Owen: 30 posts Hannu Krosing: 27 posts Jan Wieck: 25 posts Oleg Bartunov: 25 posts Stephan Szabo: 24 posts Trond Eivind Glomsrød: 21 posts Philip Warner: 19 posts Don Baccus: 16 posts Ian Lance Taylor: 16 posts Larry Rosenman: 16 posts Thomas Lockhart: 16 posts Hiroshi Inoue: 15 posts
show more
Archives