Search Discussions
-
Rasmus Lerdorf, the big PHP developer, told me that the existance of GNU readline hooks in our source tree could cause RMS/GNU to force us to a GNU license. Obviously, we could remove readline hooks ...
Bruce Momjian
Dec 23, 2000 at 2:56 pm
Jan 3, 2001 at 2:23 am -
Hello all, I am new to postgreSQL. When I read the documents, I find out the Postmaster daemon actual spawns a new backend server process to serve a new client request. Why not use threads instead? ...
Junfeng Zhang
Dec 4, 2000 at 4:53 am
Jan 2, 2001 at 5:24 pm -
OK, I am through mail email backlog from my Japan visit. I will work on a full 7.1 changes list this week. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your ...
Bruce Momjian
Dec 11, 2000 at 1:53 am
Jan 11, 2001 at 2:25 pm -
TOAST breaks data into a few 2K (or so) tuples to be inserted separately. But first after checkpoint btree split will require logging of 2x8K record -:( Other opinions? Also, we shouldn't forget ...
Mikheev, Vadim
Dec 7, 2000 at 8:36 pm
Dec 12, 2000 at 8:31 pm -
I know you guys are pretty busy with the upcoming release but I was hoping for more interest in this work. With this (which needs forward porting) we're able to cut vacuum time down from ~10minutes ...
Alfred Perlstein
Dec 11, 2000 at 8:31 pm
Jan 25, 2001 at 2:14 pm -
I have been asked by the major PHP developer Rasmus Lerdorf to see if the PostgreSQL/PHP interface needs any improvements. Is the current PostgreSQL interface module in PHP adequate? Does it support ...
Bruce Momjian
Dec 27, 2000 at 5:56 am
Jan 23, 2001 at 6:11 pm -
Well, no one seemed very unhappy at the idea of changing the file format for binary COPY, so here is a proposal. The objectives of this change are: 1. Get rid of the tuple count at the front of the ...
Tom Lane
Dec 6, 2000 at 11:36 pm
Dec 13, 2000 at 6:09 pm -
22
Why vacuum?
I noticed the other day that one of my pg databases was slow, so I ran vacuum on it, which brought a question to mind: why the need? I looked at my oracle server and we aren't doing anything of the ...Bpalmer
Dec 13, 2000 at 10:50 pm
Dec 14, 2000 at 5:39 pm -
I have been digging into the observed failure FATAL: Checkpoint lock is busy while data base is shutting down on some Alpha machines. It apparently doesn't happen on all Alphas, but it's quite ...
Tom Lane
Dec 28, 2000 at 8:54 pm
Jan 9, 2001 at 4:17 am -
Hi, I saw the thread from a few days ago about Linux/Alpha and 7.1. I believe I'm seeing the same problems with DEC/Alpha (Tru64Unix 4.0D). I noticed the following in the postmaster.log, which ...
Brent Verner
Dec 23, 2000 at 1:27 am
Dec 28, 2000 at 8:24 am -
I've been looking into Brian Hirt's complaint that 7.0.3 and 7.1 are lots slower than 7.0.2 in planning big joins. The direct cause is that since we now deduce implied equality clauses, the system ...
Tom Lane
Dec 13, 2000 at 11:14 pm
Feb 28, 2001 at 1:00 pm -
I have a working version of a text search engine. I want to make it work for Postgres (I will be releasing it GPL). It can literally find the occurrence of a string of words within 5 million records ...
Mark L. Woodward
Dec 8, 2000 at 4:07 pm
Dec 10, 2000 at 12:30 pm -
As far as I know (and have tested in excess) Informix IDS does survive any power loss without leaving the db in a corrupted state. The basic technology is, that it only relys on writes to one "file" ...
Andreas Zeugswetter
Dec 5, 2000 at 9:12 am
Dec 8, 2000 at 7:36 pm -
This problem with foreign keys has been reported to me, and I have confirmed the bug exists in current sources. The DELETE should succeed: ...
Bruce Momjian
Dec 12, 2000 at 5:13 pm
Jan 27, 2001 at 10:21 pm -
17
Tuple data
Hi. I've still got something I can't seem to get. In my test cases with simple tables the first uint16 of tuple data after the header contained the length of the tuple. In this case I can't seem to ...Michael Richards
Dec 16, 2000 at 7:32 pm
Dec 19, 2000 at 6:40 am -
It seems that R-trees become inefficient when the number of dimensions increase. Has anyone thoght of a transparent way to use Peano codes (hhcode in Oracle lingo), and use B-tree indexes instead? ...
Edmar Wiggers
Dec 12, 2000 at 1:25 pm
Dec 15, 2000 at 3:47 pm -
Okay, since I haven't gotten word back on where to find the docs for v7.1, it still contains those for v7.0, but I just put up beta1 tarballs in the /pub/dev directory ... can someone take a look at ...
The Hermit Hacker
Dec 7, 2000 at 7:48 pm
Dec 11, 2000 at 5:02 pm -
I know it's been a while since we last discussed a possible rewrite of the C++ API but I now have some time to devote to it. The following are my ideas for implementing the C++ API: I need ...
Randy Jonasz
Dec 6, 2000 at 11:36 pm
Dec 14, 2000 at 1:34 am -
I thought the hackers team would be interested in knowing that SourceForge, as of Friday evening, is running on Postgres. Some 95,000 users and 12,500 Open Source projects are depending on your ...
Tim Perdue
Dec 12, 2000 at 2:24 am
Feb 10, 2001 at 3:08 pm -
I've just noticed that COPY BINARY is pretty thoroughly broken by TOAST, because what it does is to dump out verbatim the bytes making up each tuple of the relation. In the case of a moved-off value, ...
Tom Lane
Dec 1, 2000 at 10:35 pm
Jan 23, 2001 at 4:20 am -
13
GEQO status?
What is the status of the genetic algorithm query optimizer? Is this supposed to work well on many-table joins, or has it fallen out of favor or in disrepair? [I'm needing to optimize some large, ...Ed Loehr
Dec 22, 2000 at 10:39 pm
Dec 30, 2000 at 2:19 am -
(plz cc me on your replies, i'm not on pgsql-hackers for some reason.) http://www.vix.com/~vixie/results-psql.png shows a gnuplot of the wall time of 70K executions of "pgcat" (shown below) using a ...
Paul A Vixie
Dec 19, 2000 at 6:38 am
Dec 21, 2000 at 5:10 pm -
tas() is not supposed to contain a loop. It can succeed or fail, but it should not wait. The code now in s_lock.h does seem rather gratuitously obscure about the instructions it uses to load ...
Tom Lane
Dec 28, 2000 at 2:37 am
Dec 29, 2000 at 4:58 am -
I've run tests (with 50 .. 250 simult users) for some PG project of my company. 7.1 was 3 times faster than 7.0.3 (fsync) but near 3 times slower than 7.0.3 (nofsync). It was not the best day in my ...
Mikheev, Vadim
Dec 8, 2000 at 11:17 pm
Dec 14, 2000 at 12:28 am -
We recently had a very satisfactory contract completed by Vadim. Basically Vadim has been able to reduce the amount of time taken by a vacuum from 10-15 minutes down to under 10 seconds. We've been ...
Alfred Perlstein
Dec 7, 2000 at 11:06 pm
Jan 24, 2001 at 4:55 pm -
Hm. This is one of the areas that I had put down on my personal TODO list as needing a close look before release. So, let's get to it. My first scan of SQL92 looks like our current behavior is right. ...
Tom Lane
Dec 16, 2000 at 6:39 am
Dec 20, 2000 at 8:12 pm -
Hm. It seems fairly unlikely that select() would return error ECHILD, which is what this message *appears* to imply. The code is if (select(nSockets, &rmask, &wmask, (fd_set *) NULL, (struct timeval ...
Tom Lane
Dec 18, 2000 at 3:47 am
Dec 19, 2000 at 1:28 pm -
It seems very dangerous to me. When VACUUM of a master table was finished, the transaction is in already committed state in many cases. Regards. Hiroshi Inoue
Hiroshi Inoue
Dec 9, 2000 at 1:23 pm
Dec 12, 2000 at 12:21 am -
I have had the time to test today's (12/19) snapshot on my Linux/Alpha and the good news is that only two regression tests are failing. The bad news is that these regression tests do not fail on ...
Ryan Kirkpatrick
Dec 20, 2000 at 4:08 am
Jan 23, 2001 at 2:51 pm -
I'm trying to delete all the records or only one record or insert one record in a table but i'm having this message: ERROR: Unable to identify an operator '=' for types 'int4' and 'text' You will ...
Luis Sousa
Dec 14, 2000 at 3:33 pm
Dec 20, 2000 at 3:43 pm -
On FreeBSD 4.1.1 and above there's a sysctl tunable called kern.ipc.shm_use_phys, when set to 1 it's supposed to make the kernel's handling of shared memory much more effecient at the expense or ...
Alfred Perlstein
Dec 5, 2000 at 3:14 pm
Dec 5, 2000 at 10:52 pm -
I think the newC function idea is pretty good, however, what would be great is just one more step of protocol, perhaps an API verson 2 or 3: One thing than makes writing a non-trivial function a bit ...
Mark L. Woodward
Dec 12, 2000 at 4:27 pm
Dec 13, 2000 at 10:51 pm -
Ok, just a small issue here: I'm running: select attname,attlen,attalign from pg_attribute where attnum 0 and attrelid = (select oid from pg_class where relname = 'users') order by attnum; This is to ...
Michael Richards
Dec 17, 2000 at 5:40 pm
Mar 2, 2001 at 4:39 pm -
This line works: /usr/local/pgsql/bin/postmaster -N 32 -B 928 -i -S -D/home/postgres/pgdev -o "-F -fs -S 4096" Where as this line: /usr/local/pgsql/bin/postmaster -N 32 -B 1024 -i -S ...
Mark L. Woodward
Dec 25, 2000 at 2:01 am
Jan 1, 2001 at 3:35 am -
Try to compare 7.0.3 & 7.1beta in multi-user environment. Vadim
Mikheev, Vadim
Dec 7, 2000 at 8:27 pm
Dec 8, 2000 at 9:06 pm -
Hi all, In InitPostgres()(postinit.c) I see the following code. RelationCacheInitialize(); /* pre-allocated reldescs created here */ InitializeTransactionSystem(); /* pg_log,etc init/crash recovery ...
Hiroshi Inoue
Dec 19, 2000 at 3:40 pm
Jan 6, 2001 at 12:57 am -
Yes, it would be nice for cursors too - they should be able to cross transaction boundaries... Use BackendID instead of XID in XIDTAG? Add internal (ie per backend) hash of locks that should not be ...
Mikheev, Vadim
Dec 15, 2000 at 8:28 pm
Dec 22, 2000 at 1:11 am -
Morning ... Just to let ppl know what I'm using as milestones for beta releases: beta2 - vadim finishes WAL stuff he's currently working on beta3 - vadim incorporates LAZY extension to VACUUM beta4 - ...
The Hermit Hacker
Dec 20, 2000 at 9:05 pm
Dec 21, 2000 at 6:15 am -
I am doing some testing and development on Postgres. Is there, by chance, a good source of data which can be used as a test database? I have been using a music database, but it is proprietary, and ...
Mark L. Woodward
Dec 19, 2000 at 6:17 pm
Dec 21, 2000 at 5:48 am -
I suspect that you are really looking at the problem from the wrong end. CRC checking should not need to be done by the database user, with a fancy type. The postgres server itself should guarantee ...
Christopher Kings-Lynne
Dec 8, 2000 at 8:16 am
Dec 13, 2000 at 5:17 am -
Hi, I see now the following message and couldn't start postmaster. FATAL 2: btree_insert_redo: uninitialized page Is it a bug ? Anyway,how do I reset my WAL environment ? Regards. Hiroshi Inoue
Hiroshi Inoue
Dec 6, 2000 at 1:16 am
Dec 8, 2000 at 12:06 am -
Oh, I didn't consider log consistency that time. Anyway we need in CRC for entire log record not for its 512-bytes parts. Well, I didn't care about not atomic 8K-block writes in current WAL ...
Mikheev, Vadim
Dec 7, 2000 at 4:04 am
Dec 7, 2000 at 8:06 pm -
Some SQL92 functionality is missing from the BIT and VARBIT types. It should be possible to enter hexadecimal values as: B'[<bit ...]'[{<separator ...'[<bit...]'}...] X'[<hexdigit ...]'[{<separator ...
Oliver Elphick
Dec 21, 2000 at 9:34 pm
Dec 27, 2000 at 2:12 pm -
Hi, I am using the following command to check out the 7.1 branch of PostgreSQL. cvs -d :pserver:anoncvs@postgresql.org:/home/projects/pgsql/cvsroot co -r REL7_1 pgsql This is the error I am getting. ...
Yusuf Goolamabbas
Dec 22, 2000 at 11:30 pm
Dec 23, 2000 at 12:05 am -
I've been experimenting with the SSL connection support. Unfortunately I can't get the postmaster to start because the instructions in the documentation for setting up a certificate don't work. They ...
Oliver Elphick
Dec 20, 2000 at 4:04 pm
Dec 21, 2000 at 7:08 pm -
peter=# select 1 as current; old ----- 1 This is now the inverse of what it used to do, but it's still not what it *should* do. I see someone already tried to fix that (keywords.c 1.76 - 1.77, TODO ...
Peter Eisentraut
Dec 15, 2000 at 10:47 pm
Dec 15, 2000 at 11:36 pm -
Hi, I have been using Postgres-7.0.2 on Solaris 8 for the past few months, and was about to upgrade to 7.1-test, and after following carefully the docs, I get this: postgres@ultra31:~ ...
Martin A. Marques
Dec 12, 2000 at 3:59 pm
Dec 14, 2000 at 1:03 pm -
If we move tuples in already committed state, a page with new tuple position goes to disk and backend crashes before page with old tuple position updated then we'll have two version of tuple after ...
Mikheev, Vadim
Dec 11, 2000 at 5:33 pm
Dec 12, 2000 at 4:13 am -
It was just pointed out on pggeneral that hash indexes on macaddr columns don't work. Looking into it, I find that someone (me :-() made a booboo: pg_amproc claims that hashvarlena is the appropriate ...
Tom Lane
Dec 8, 2000 at 9:37 pm
Dec 8, 2000 at 11:52 pm -
I have an abstract solution for a problem in postgresql's handling of what should be constant data. We had problem with a query taking way too long, basically we had this: select ...
Alfred Perlstein
Dec 7, 2000 at 11:06 pm
Dec 8, 2000 at 1:58 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 226 |
posts | 1,222 |
users | 155 |
website | postgresql.org... |
irc | #postgresql |
155 users for December 2000
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)