FAQ

PostgreSQL > pgsql-hackers > July 2000

Search Discussions

253 discussions - 1,428 posts

  • On wednesday or thursday, I'm going to be publishing my article on MySQL vs. Postgres on PHPBuilder.com. Before I do that I want to confirm the major problem I had w/postgres: the 8K tuple limit. ...
    Tim PerdueTim Perdue
    Jul 4, 2000 at 7:39 pm
    Jul 11, 2000 at 5:55 am
  • Uh oh - on one side I'm a happy camper. pg_dump already ignored pg_* tables and since the TOAST tables are named pg_toast_..., nothing to be done. I loaded my test DB with TOAST entries, dumped and ...
    Jan WieckJan Wieck
    Jul 5, 2000 at 8:08 pm
    Jul 8, 2000 at 9:41 pm
  • Thanks. Yes, I have added to the TODO list: * Add function to return primary key value on INSERT -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a ...
    Bruce MomjianBruce Momjian
    Jul 8, 2000 at 1:15 pm
    Jan 19, 2001 at 4:07 am
  • Brian Baquiran in the [GENERAL] list recently asked if it was possible to 'throttle-down' pg_dump so that it did not cause an IO bottleneck when copying large tables. Can anyone see a reason not to ...
    Philip WarnerPhilip Warner
    Jul 28, 2000 at 2:41 pm
    Aug 1, 2000 at 1:42 pm
  • I suggest that we change vacuum to only move remove tuples if there is more than 20% expired tuples. When we do vacuum, we drop all indexes and recreate them. This fixes the complaint about vacuum ...
    Bruce MomjianBruce Momjian
    Jul 12, 2000 at 12:41 am
    Jul 25, 2000 at 3:02 pm
  • Any idea why 6.5.3 would have created tens of thousands of files like these in the /data/base/db_geocrawler/ directory? There may have even been a million of these files there - so many that rm -f ...
    Tim PerdueTim Perdue
    Jul 10, 2000 at 3:48 am
    Jul 12, 2000 at 1:29 am
  • FYI, during the day I committed a couple of changes to TOAST. - Secondary relations for the toaster (to move off values) are now automatically created during CREATE TABLE, ALTER TABLE ... ADD COLUMN ...
    Jan WieckJan Wieck
    Jul 5, 2000 at 5:37 pm
    Jul 12, 2000 at 1:05 am
  • Okay, from seeing the responses so far on the list, I'm not the only one that has issues with the whole "juristiction of virginia" issue *or* the "slam this copyright in ppls faces" ... I do like the ...
    The Hermit HackerThe Hermit Hacker
    Jul 4, 2000 at 2:43 pm
    Jul 6, 2000 at 2:15 am
  • I noticed a discussion on this list about a re-do of the INET/CIDR types. I was wondering if there was ANY way at all to add an output function that ALWAYS returns all 4 octets of an INET or CIDR ...
    Larry RosenmanLarry Rosenman
    Jul 23, 2000 at 2:01 pm
    Jul 27, 2000 at 7:11 pm
  • I am wondering if anyone can see an immediate problem in creating a function: heap_create_oid which is just like heap_create, but takes an oid arg. This oid (assuming it's free) would be used to ...
    Philip WarnerPhilip Warner
    Jul 4, 2000 at 6:36 am
    Jul 7, 2000 at 3:20 am
  • This is an alpha version of NetBSD 1.5. System is a fairly stock PowerMac 7500 with a 604 CPU upgrade, original disk drive. The Perl is from the NetBSD package system, version 5.004_04. egcs-1.1.2 ...
    Henry B. HotzHenry B. Hotz
    Jul 26, 2000 at 12:58 am
    Jul 27, 2000 at 7:28 pm
  • Maybe you just want to use zlib. Let other guys hammer out the details. -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
    EisentrpEisentrp
    Jul 7, 2000 at 1:14 pm
    Jul 13, 2000 at 8:44 am
  • Greetings all, I'm sending this to -announce, -hackers, and -general; apologies for the cross-post. Replies should automatically go to -general, which is the best forum for this discussion. But I ...
    Ned LillyNed Lilly
    Jul 3, 2000 at 3:09 pm
    Jul 5, 2000 at 5:21 am
  • I don't know in his case, but I think you could get into this state from a partial restore from pg_dump. If you restore one of the two tables, and create the constraint trigger for the ...
    Stephan SzaboStephan Szabo
    Jul 11, 2000 at 7:26 pm
    Jul 12, 2000 at 9:13 am
  • Yes, and now the story is up on slashdot: http://slashdot.org/comments.pl?sid=00%2F07%2F25%2F1439226&cid=&pid=0&startat=&threshold=-1&mode=nested&commentsort=3&op=Change So if anyone feels like ...
    Joe BrennerJoe Brenner
    Jul 25, 2000 at 10:40 pm
    Jul 31, 2000 at 12:55 am
  • Well, I took Thomas' advice and upgraded to 7.0.2 from source.tar.gz. For some reason, I cannot create the following index: db_geocrawler=# DROP INDEX idx_mail_archive_list_subject; ERROR: index ...
    Tim PerdueTim Perdue
    Jul 12, 2000 at 12:48 am
    Jul 12, 2000 at 6:21 pm
  • Since I broke my table on hub and am awaiting assistance I'm shifting away from the website temporarily and back to the md5 stuff. In going over the previous conversations I've come up with the ...
    Vince VielhaberVince Vielhaber
    Jul 11, 2000 at 2:50 pm
    Jul 12, 2000 at 2:35 am
  • I'm wondering about the comments that postgres is slower in connection time, could this be related to that libpq always uses asynchronous sockets to connect? It always turns off blocking and then ...
    Chris BitmeadChris Bitmead
    Jul 10, 2000 at 12:34 am
    Jul 10, 2000 at 10:33 pm
  • I've been thinking about what changes are necessary to the libpq interface to support returning variable type tuples. This was discussed a number of months back but an exact interface wasn't nailed ...
    Chris BitmeadChris Bitmead
    Jul 5, 2000 at 7:27 am
    Jul 6, 2000 at 12:11 pm
  • I have been speaking to Pavel about pg_dump support of blobs, and he thinks it is important to allow for some kind of human-readable version of the dump to be created. My guess is that this will ...
    Philip WarnerPhilip Warner
    Jul 12, 2000 at 1:51 pm
    Jul 12, 2000 at 10:40 pm
  • Having now flirted with recreating BLOBs (and even DBs) with matching OIDs, I find myself thinking it may be a waste of effort for the moment. A modified version of the system used by Pavel Janik in ...
    Philip WarnerPhilip Warner
    Jul 5, 2000 at 1:56 pm
    Jul 8, 2000 at 12:36 am
  • I've been collecting a few ideas for integrating the distribution making process into the build system. (I did take a look at the mk-release and mk-snapshot scripts on hub.org as well.) I have a ...
    Peter EisentrautPeter Eisentraut
    Jul 10, 2000 at 6:17 pm
    Jul 12, 2000 at 10:45 am
  • I've done a little work on enabling session-specific default behavior for transaction isolation level. I'm thinking about how to extend this to default "database-specific" behaviors which persist ...
    Thomas LockhartThomas Lockhart
    Jul 5, 2000 at 6:10 am
    Jul 10, 2000 at 7:40 am
  • I'm going to be on vacation for essentially the next month. So if there's anything that you'd like fixed before that, now's a good time to tell. Meanwhile a few TODO updates: * Creating index of ...
    Peter EisentrautPeter Eisentraut
    Jul 23, 2000 at 12:58 pm
    Jul 27, 2000 at 6:52 pm
  • This question comes out of my work on pg_dump. AFAICT, the only way of showing, eg, the SQL for a procedure definition (other than 'select prosrc from pg_procs, or whatever'), is to use pg_dump. This ...
    Philip WarnerPhilip Warner
    Jul 17, 2000 at 6:21 am
    Jul 18, 2000 at 1:36 am
  • In an effort to complicate the postmaster beyond recognition I'm proposing an idea that I hope can be useful to the developers. Connection pooling: The idea is to have the postmaster multiplex and do ...
    Alfred PerlsteinAlfred Perlstein
    Jul 12, 2000 at 1:53 am
    Jul 12, 2000 at 7:48 am
  • 12

    mac.c

    Any comments on my ideas on the macaddr_manuf stuff? Larry -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, ...
    Larry RosenmanLarry Rosenman
    Jul 20, 2000 at 2:14 am
    Jul 31, 2000 at 1:17 am
  • Some people suggested it might be a good idea to define a new interface, maybe call it libpq2. (Actually this would be a good time to abandon pq = postquel in favour of libpg.a ). I'll therefore put ...
    Chris BitmeadChris Bitmead
    Jul 6, 2000 at 5:56 am
    Jul 12, 2000 at 5:02 am
  • This is not right. OIDs were used *only* to find parent tuple in _bt_getstackbuf, where only *per level* uniqueness is required. I removed OIDs because of on any level there are no two (or more) ...
    Mikheev, VadimMikheev, Vadim
    Jul 19, 2000 at 12:25 am
    Jul 27, 2000 at 3:28 am
  • ISTM that the template mechanism used in configure is, well, flawed. Among the problems: 1) The templates preempt the choice of compiler. A recent report from AIX said that it automatically picked up ...
    EisentrpEisentrp
    Jul 10, 2000 at 1:13 pm
    Jul 12, 2000 at 12:24 am
  • Now I know that you all believe that postgres only has problems due to bad programming, but I'm getting another problem that I can't figure out in 6.5.3 [PostgreSQL 6.5.3 on i686-pc-linux-gnu, ...
    Tim PerdueTim Perdue
    Jul 10, 2000 at 2:22 am
    Jul 10, 2000 at 10:39 pm
  • Hmm. There are several things going on here, but one thing that needs clarification is whether this UPDATE is written correctly. Since it has no constraint on entry_stats, it seems to me that *every* ...
    Tom LaneTom Lane
    Jul 7, 2000 at 7:06 am
    Jul 10, 2000 at 1:44 am
  • I think we need a --with-zlib switch for the new pg_dump. Or at least a --without-zlib switch, if you think that it's widespread enough. -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net ...
    Peter EisentrautPeter Eisentraut
    Jul 4, 2000 at 7:50 pm
    Jul 7, 2000 at 4:10 pm
  • I'm trying to sort out the documentation regarding the SysV IPC settings, but I better understand them myself first. :) We use three shared-memory segments: One is for the spin locks and is of ...
    Peter EisentrautPeter Eisentraut
    Jul 19, 2000 at 10:45 pm
    Jul 27, 2000 at 6:36 pm
  • There is already precedent -- postmaster is a symlink to postgres, but operates differently due to its invocation name. -- Lamar Owen WGCR Internet Radio 1 Peter 4:11
    Lamar OwenLamar Owen
    Jul 10, 2000 at 10:36 pm
    Jul 12, 2000 at 1:50 am
  • Today afternoon I a little study libpython1.5 and I mean create new PL language is not a problem. I a little play with it, and here is effect: test=# CREATE FUNCTION py_test() RETURNS text AS ' ...
    Karel ZakKarel Zak
    Jul 19, 2000 at 3:24 pm
    Jul 27, 2000 at 3:52 am
  • An interesting problem has been brought to my attention in pg_dump (V7.0.2+, I think). It uses the following code to disable triggers prior to a data load: UPDATE "pg_class" SET "reltriggers" = 0 ...
    Philip WarnerPhilip Warner
    Jul 25, 2000 at 1:30 pm
    Jul 26, 2000 at 12:48 am
  • Lamar et al: what is the current state of the posted (and upcoming) RPMs? Did the Mandrake stuff get integrated into The One True SpecFile (modulo the .bz input files)? I've got Mandrake-7.1 up on my ...
    Thomas LockhartThomas Lockhart
    Jul 23, 2000 at 11:17 pm
    Jul 25, 2000 at 2:53 am
  • I'm not sure whether my long post made it to the list, so I created a tarball of the patch and the awk script: ftp://ftp.lerctr.org/postgresql-patches/macupdate.tar.gz This has the patch file for ...
    Larry RosenmanLarry Rosenman
    Jul 17, 2000 at 4:10 pm
    Jul 20, 2000 at 6:36 am
  • I've tried doing as much reading on the mailing lists as I can on this. The problem lies in that I'm trying to use PostgreSQL to store HTML documents which are larger than the default tuple size of ...
    Thomas SwanThomas Swan
    Jul 17, 2000 at 6:58 pm
    Jul 19, 2000 at 12:43 am
  • I added the suggested index and changed my sql and the subjective tests seem to be improved somewhat. I checked EXPLAIN and it is using the new index. I still think there must be sorting going on, as ...
    Tim PerdueTim Perdue
    Jul 12, 2000 at 11:23 pm
    Jul 13, 2000 at 2:18 pm
  • While testing the just-committed executor memory leak fixes, I observe that there are still slow leaks in some operations such as sorts on large text fields. With a little digging, it seems that the ...
    Tom LaneTom Lane
    Jul 12, 2000 at 3:49 am
    Jul 13, 2000 at 10:06 am
  • I know you're all sick of hearing from me, but I'm passing this along anyway. Looks like I need to go back down to 6.5.3 for some reason. The following query is at the very heart of the site and it ...
    Tim PerdueTim Perdue
    Jul 12, 2000 at 1:33 am
    Jul 13, 2000 at 4:30 am
  • I'm looking at implementing the SQL99 C interface, which looks more or less reasonable. There are some annoyances however. The API to describe the return result SQLDescribeCol takes a pointer to a ...
    Chris BitmeadChris Bitmead
    Jul 7, 2000 at 4:51 pm
    Jul 10, 2000 at 12:26 am
  • Is this a known problem? pjw=# create temporary table tt(f int4); CREATE pjw=# create index tt_ix1 on tt(f); CREATE pjw=# \q The postmaster says: NOTICE: mdopen: couldn't open pg_temp.31633.1: No ...
    Philip WarnerPhilip Warner
    Jul 10, 2000 at 5:57 am
    Oct 11, 2000 at 9:26 pm
  • Hello, What does this mean????? ---------- Forwarded Message ---------- Subject: Postgres update Date: Fri, 28 Jul 2000 04:00:09 -0500 (EST) From: webmail@webmailstation.com (WebmailStation User) ...
    Denis PerchineDenis Perchine
    Jul 28, 2000 at 9:50 am
    Jul 29, 2000 at 3:49 pm
  • Something on the TODO list is that indexes should be inherited by default. Unfortunately, right now they are not. I'm not sure what the interaction is here with the foreign key mechanism, so I'm ...
    Chris BitmeadChris Bitmead
    Jul 19, 2000 at 4:02 am
    Jul 20, 2000 at 5:06 am
  • Would it be possible to actually delete those entries during vacuum ? I guess that would be an overall win, no ? Andreas
    Andreas ZeugswetterAndreas Zeugswetter
    Jul 11, 2000 at 2:17 pm
    Jul 12, 2000 at 8:01 pm
  • I spent some time looking around for possible causes of the recently reported deadlock conditions. I couldn't find any smoking gun, but I found a couple of things that look fishy: 1. I notice that ...
    Tom LaneTom Lane
    Jul 27, 2000 at 8:14 pm
    Jul 29, 2000 at 3:28 am
  • Executive summary: I have discarded the idea of (partially) implementing Info Schemas as part of a pg_dump/psql enhancement, and returned to my original plan. You can now skip to 'Questions', below. ...
    Philip WarnerPhilip Warner
    Jul 21, 2000 at 3:08 pm
    Jul 26, 2000 at 12:54 am
Jul 2000
123456
Group Navigation
period‹ prev | Jul 2000 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions253
posts1,428
users119
websitepostgresql.org...
irc#postgresql

119 users for July 2000

Tom Lane: 266 posts Philip Warner: 148 posts Bruce Momjian: 113 posts Jan Wieck: 91 posts Peter Eisentraut: 87 posts The Hermit Hacker: 78 posts Andreas Zeugswetter: 51 posts Thomas Lockhart: 49 posts Chris Bitmead: 44 posts Karel Zak: 34 posts Hiroshi Inoue: 30 posts Tim Perdue: 28 posts Larry Rosenman: 25 posts Chris Bitmead: 24 posts Hannu Krosing: 17 posts Alfred Perlstein: 16 posts Mikheev, Vadim: 16 posts Lamar Owen: 15 posts Mike Mascari: 15 posts Eisentrp: 14 posts
show more
Archives