FAQ

Search Discussions

159 discussions - 594 posts

  • It is amazing how much talent has been focused in just the past 24 hours on PostgreSQL. Amazing. I am excited about the memory fixes and the cleanup going on. I hope Marc is going to give us the time ...
    Bruce MomjianBruce Momjian
    Jun 2, 1997 at 4:52 am
    Jun 13, 1997 at 2:20 am
  • Can someone suggest why running the \dt comand in psql causes so many disk accesses? I am seeing some queries causing a lot of disk access that doesn't make sense to me. I am running my server with ...
    Bruce MomjianBruce Momjian
    Jun 21, 1997 at 12:04 am
    Jun 24, 1997 at 8:22 pm
  • Well, I hope that bug reported by Michael is old bug. Simple example: bt= create table test (x text); CREATE bt= create index test_i on test (x); CREATE bt= insert into test values ('0'); INSERT ...
    Vadim B. MikheevVadim B. Mikheev
    Jun 6, 1997 at 7:19 am
    Jun 12, 1997 at 7:04 pm
  • Hello, Sorry to bother you with this, but I think there is a small problem with copying abstimes in v6.1. I noticed an increment of 1 hour to abstime fields when copying tables back into the database ...
    Ronald BaljeuRonald Baljeu
    Jun 18, 1997 at 3:08 pm
    Jun 28, 1997 at 4:45 am
  • Hello! Currently libpq works as follows: If we doing a select, all rows fetched in memory, after this it returned to the caller. All OK, but: if number of rows is too big, we use a LOT of memory. ...
    Alexander DemenshinAlexander Demenshin
    Jun 29, 1997 at 12:42 pm
    Jun 30, 1997 at 10:10 am
  • With the 6.1 release two weeks old, and no one really adding any new feature, is it a good idea to think about creating a 6.1 patch in the next week or so to add some fixes? I have the ownership ...
    Bruce MomjianBruce Momjian
    Jun 20, 1997 at 1:01 pm
    Jun 21, 1997 at 3:02 am
  • With things like the date format now being set via the SET command rather than as a compile-time option, I think it would be nice for psql to read ~/.psqlrc (or some such thing) as a set of commands ...
    Andrew MartinAndrew Martin
    Jun 20, 1997 at 11:58 am
    Jun 21, 1997 at 3:05 am
  • I've been plagued with a connectivity problem to my PostgreSQL database running on a Sparc Sun4 (SunOS 4.1.4) box (both May and 6.1 release versions). I've been trying to use the postODBC drivers and ...
    Chris McGonagleChris McGonagle
    Jun 18, 1997 at 1:19 am
    Jun 25, 1997 at 3:29 pm
  • OK, here's a quick patch to psql.c which first reads commands from /etc/psqlrc and then from $HOME/.psqlrc I've used access() to check on the existence of these files; I'm not sure if every system ...
    Andrew MartinAndrew Martin
    Jun 20, 1997 at 9:34 pm
    Jun 25, 1997 at 9:56 am
  • At this point, I think we have everything resolved for 6.1. The regression tests look good. We have GEQO active for more than six tables. Vadim has fixed the btree bug. The datetime types are working ...
    Bruce MomjianBruce Momjian
    Jun 1, 1997 at 5:36 am
    Jun 3, 1997 at 6:16 pm
  • This is in the regression tests after applying the purify patches that were submitted :( Every test now, of course, fails... the boolean test alone gets something like 337 of these in its output file ...
    The Hermit HackerThe Hermit Hacker
    Jun 1, 1997 at 4:23 pm
    Jun 2, 1997 at 1:52 pm
  • Oops forgot to mention : PostgreSQL version 6.1 Linux 2.0.30 and it worked 'correctly' with version 5.1 Thanks, - -Yann- - ---------- De : Yann Courties Date=A0: jeudi 19 juin 1997 17:13 A : ...
    Yann CourtiesYann Courties
    Jun 20, 1997 at 1:23 pm
    Jun 25, 1997 at 12:39 pm
  • Just run the regression tests on 6.1 and as I suspected the array bug is still there. The regression test passes because the expected output has been fixed to the *wrong* output. As I have said ...
    Andrew MartinAndrew Martin
    Jun 18, 1997 at 4:23 pm
    Jun 25, 1997 at 9:59 am
  • Here is an update on postgres backend buffer performance (and problems). I ran the regression tests with several sizes for the "-B" option for postmaster. The best performance was for the run with ...
    Thomas G. LockhartThomas G. Lockhart
    Jun 4, 1997 at 6:03 pm
    Jun 9, 1997 at 1:57 am
  • I'd agree with the principle of case insensitivity, particularly in the interests of ANSI compatibility. Having just fetched and built 6.1, however, I am appalled at the way it has been done. Perhaps ...
    John RobinsonJohn Robinson
    Jun 29, 1997 at 1:59 am
    Jun 29, 1997 at 4:35 pm
  • Uh, "destroydb" would seem to be a specific-enough command that if you type it, you actually wanted to delete a database :) Would have preferred that the behavior remained as-is, myself. - Tom ...
    Thomas G. LockhartThomas G. Lockhart
    Jun 1, 1997 at 4:47 pm
    Jun 2, 1997 at 2:01 am
  • In an earlier message, De Clarke said he could provide a free Tk-based forms package. I would like more information on this (i.e. where to get it, etc.). As PostgreSQL is growing, we are starting to ...
    David FriendDavid Friend
    Jun 7, 1997 at 3:01 am
    Jun 10, 1997 at 7:48 pm
  • Well...I put these PQclear's in because there were memory leaks in that area. If you put it outside, of the case statement, you start clearing already freed tuples causing a mess (Marc.. that was the ...
    IgorIgor
    Jun 2, 1997 at 10:43 pm
    Jun 3, 1997 at 2:01 am
  • Hi! I have tried: create table tab (v1 char(4096), v2 char(4096), v3 char(4096)); Then: insert into tab values('1'); OK insert into tab values('1','2'); Tuple is too big: size 8256. Well, I ...
    Alexander DemenshinAlexander Demenshin
    Jun 19, 1997 at 5:39 pm
    Jun 20, 1997 at 7:36 pm
  • The ToDo list includes the following as an enhancement in version 6.1: Large objects overwriting blocks has problems there are other problems, too. Fix large object mapping scheme not to stuff ...
    Sean LyndersaySean Lyndersay
    Jun 9, 1997 at 8:57 pm
    Jun 10, 1997 at 5:40 pm
  • Just a little idea to help give everyone's mind a break from 6.1 issues for a moment. This would probably be a 7.0 thing, depending on how the releases go. Has anyone thought of making use of an ...
    BibachBibach
    Jun 3, 1997 at 11:31 pm
    Jun 4, 1997 at 1:00 pm
  • from X3H2-97-030 (I think) c) Let P be any row of TS and let Q be any other row of TS, and let PVi and QVi be the values of Ki in these rows, respectively. The relative position of rows P and Q in ...
    AdrianAdrian
    Jun 14, 1997 at 7:09 pm
    Jun 16, 1997 at 9:35 pm
  • Greetings. I just built 6.1 on a Linux 2.0.29 (RedHat) machine, following the instructions to the letter. Everything looked fine until I went to access one of my databases. Some of them seem to be ...
    Sean ReifschneiderSean Reifschneider
    Jun 15, 1997 at 8:51 am
    Jun 16, 1997 at 2:35 am
  • Hi... What is the max anyone has tried running postmaster with using the - -B flag? Under FreeBSD, I can't seem to get her above 256, and *believe* I've up'd all the kernel config stuff, but before I ...
    The Hermit HackerThe Hermit Hacker
    Jun 9, 1997 at 12:43 am
    Jun 9, 1997 at 1:37 am
  • Thanks. Fixed. I looked through the code for 'X', and it looks like that is the only place left. The lack of case-sensitivity could cause tables that start with xinv* to be confused as large objects. ...
    Bruce MomjianBruce Momjian
    Jun 6, 1997 at 3:43 am
    Jun 6, 1997 at 6:10 pm
  • ^^ though it's not what I suggested, I don't object... Vadim ------------------------------
    Vadim B. MikheevVadim B. Mikheev
    Jun 2, 1997 at 1:59 am
    Jun 2, 1997 at 6:13 am
  • Can someone verify this? Do we need the libpq++ manual page rewritten? - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Jun 26, 1997 at 10:34 am
    Jun 26, 1997 at 2:31 pm
  • Has this been fixed yet. Probably should. Do we remove -e flag, or make it work? Forwarded message: - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------ End of hackers-digest ...
    Bruce MomjianBruce Momjian
    Jun 22, 1997 at 2:01 pm
    Jun 26, 1997 at 6:52 am
  • So, what exactly does PostgreSQL need to do to "comply"...or what do we need to do to make us useable with Z39.50? Or is this something that the Z39.50 guys need to deal with? Marc G. Fournier ...
    Marc G. FournierMarc G. Fournier
    Jun 18, 1997 at 1:20 pm
    Jun 18, 1997 at 8:18 pm
  • I was cleaning out old mail and found this posting, which I started looking into. Looks like a parser problem, or something in that area, rather than a data type problem. Still present in v6.1. Bruce ...
    Thomas G. LockhartThomas G. Lockhart
    Jun 12, 1997 at 4:04 pm
    Jun 12, 1997 at 5:46 pm
  • I am using postgresql for a web site. The development environment is on a Linux system and works fine. The production machine is a Sun BSDI system. After implementing the stuf on the production ...
    PortSitePortSite
    Jun 2, 1997 at 6:28 pm
    Jun 3, 1997 at 1:49 am
  • This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for ...
    Tymm TwillmanTymm Twillman
    Jun 2, 1997 at 11:07 am
    Jun 3, 1997 at 12:37 am
  • Recently (last Saturday, as it happens) I upgraded from PostgreSQL v6.0 to v6.1. I believe I followed the correct procedure for saving the old databases, and then restoring them in the new format. ...
    Jonathan GuthrieJonathan Guthrie
    Jun 17, 1997 at 12:22 am
    Jun 25, 1997 at 7:48 pm
  • It seems what we need is someone to handle the organization of finding these third party utilities written for PostgreSQL and note something along the lines of Title Programming Language Type ...
    Adrian HallAdrian Hall
    Jun 13, 1997 at 8:00 pm
    Jun 16, 1997 at 11:52 am
  • PostgreSQL 6.1 , Linux RedHat 4.2 Kernel 2.0.30 Selecting all records and ordering ascending and descending on a field : template1= select * from pers order by cod; cod|nume |salariu - ...
    Constantin TeodorescuConstantin Teodorescu
    Jun 14, 1997 at 2:21 pm
    Jun 15, 1997 at 3:22 am
  • Hello, I am interested in knowing more about this. Could you please mail me the details. Thanks Vijaya ------------------------------
    VijayaVijaya
    Jun 12, 1997 at 11:31 am
    Jun 14, 1997 at 1:16 am
  • Hi... This is mainly for Vadim, but just so that everyone knows, I'm posting it here :) I am just confirming that we are still holding off the v6.1 release until such a time as you've been able to ...
    The Hermit HackerThe Hermit Hacker
    Jun 8, 1997 at 10:45 pm
    Jun 13, 1997 at 7:47 pm
  • ============================================================================ POSTGRES BUG REPORT TEMPLATE ============================================================================ Your name : ...
    David SmithDavid Smith
    Jun 2, 1997 at 7:50 pm
    Jun 4, 1997 at 1:38 am
  • Any comments on applying this? It looks good to me. Forwarded message: - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Jun 25, 1997 at 9:18 pm
    Jun 26, 1997 at 1:24 am
  • How about using a heap sort? Works in order of magnitude better on almost-sorted data than the quick sort. I have the code if anyone is interested. (C++, though.) Leo Subject: Re: [HACKERS] \dt and ...
    Leo ShusterLeo Shuster
    Jun 24, 1997 at 3:39 pm
    Jun 24, 1997 at 10:31 pm
  • I don't believe the data is almost-sorted. - -- Bruce Momjian maillist@candle.pha.pa.us ------------------------------
    Bruce MomjianBruce Momjian
    Jun 24, 1997 at 4:11 pm
    Jun 24, 1997 at 7:49 pm
  • I realize this. The psort() creates one or multiple DISK files to do the sort. That is the setup killer. 80% of ORDER BY's don't need this, and the overhead is huge compared to the time to perform ...
    Bruce MomjianBruce Momjian
    Jun 22, 1997 at 2:38 am
    Jun 23, 1997 at 2:23 pm
  • I know that there has been some discussion on this, but thought a more-or-less explicit roadmap to v7.0 might be helpful. Here are some thoughts: 1) dump/reload is allowed or required on every formal ...
    Thomas G. LockhartThomas G. Lockhart
    Jun 21, 1997 at 12:20 am
    Jun 21, 1997 at 1:07 pm
  • I have a very wide table, too wide to normally be created (due to buffer size constraints), which was created via inheritance of two classes. I'm trying to move the table from 6.0 to 6.1, but pg_dump ...
    Diab JeriusDiab Jerius
    Jun 20, 1997 at 4:17 pm
    Jun 20, 1997 at 4:47 pm
  • Bruce, The "SELECT on two tables where zero or one table in WHERE or target clause returns no rows" appears to have been fixed in 6.1. I'll put the script that I tested it with at the end of this ...
    Darren KingDarren King
    Jun 17, 1997 at 11:08 pm
    Jun 18, 1997 at 1:55 am
  • ===================================================== Frequently Asked Questions (FAQ) for PostgresSQL V6.1 IRIX Specific TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ ...
    Andrew MartinAndrew Martin
    Jun 13, 1997 at 9:11 am
    Jun 16, 1997 at 9:26 am
  • I like this. A few nitpicky comments below, but I think this third draft is an excellent improvement over the second draft that I wrote. I won't have time to edit this again. I would suggest that ...
    David FriendDavid Friend
    Jun 9, 1997 at 11:57 am
    Jun 14, 1997 at 10:02 am
  • Hi, I have written a database application using postgres API. The database I created is for storing the certificates. Question #1: What happens to the database if a backup is running while it is ...
    NyangNyang
    Jun 13, 1997 at 12:46 pm
    Jun 13, 1997 at 6:11 pm
  • Yep, that is my code. It is checking for the varchar() length to create the new table. I am not sure how non-old and old varattno values work in this area, but if the 'old' variable works better, ...
    Bruce MomjianBruce Momjian
    Jun 13, 1997 at 2:54 am
    Jun 13, 1997 at 3:52 am
  • compute_rel_size() call restored as if ( rel- size <= 0 ) rel- size = compute_rel_size(rel); for both GEQO & old opt-r. Vadim ------------------------------
    Vadim B. MikheevVadim B. Mikheev
    Jun 10, 1997 at 8:36 am
    Jun 11, 1997 at 2:12 pm
Group Navigation
period‹ prev | Jun 1997 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions159
posts594
users84
websitepostgresql.org...
irc#postgresql

84 users for June 1997

Bruce Momjian: 123 posts The Hermit Hacker: 79 posts Vadim B. Mikheev: 53 posts Thomas G. Lockhart: 51 posts Igor: 39 posts David Friend: 18 posts Andrew Martin: 16 posts Darren King: 16 posts Leo Shuster: 12 posts Michael Reifenberger: 12 posts Tymm Twillman: 9 posts Yann Courties: 8 posts Bibach: 7 posts Sean Lyndersay: 7 posts Henry B. Hotz: 6 posts Martin J. Laubach: 6 posts Raymond Toy: 6 posts Frank Dana: 5 posts Michał Mosiewicz: 5 posts Ronald Baljeu: 5 posts
show more
Archives