Search Discussions
-
Hi, looking for the way how to increase performance at Windows XP box, I found the parameters #fsync = true # turns forced synchronization on or off #wal_sync_method = fsync # the default varies ...
E.Rodichev
Feb 16, 2005 at 5:50 pm
Mar 18, 2005 at 1:59 am -
Hi! The new snpritnf code appears not to deal with 64-bit ints. I'm getting failures on win32 for int8 as well as all the time related tests (win32 uses int8 for tinmestamps). Removing the snprintf ...
Magnus Hagander
Feb 27, 2005 at 6:07 pm
May 5, 2005 at 9:03 pm -
Hi folks, I ran into big trouble - it seems that my DB is lost. "select * from pg_database" gives me 0 rows, but I still can connect to databases with \c and even select from tables there, although ...
Kouber Saparev
Feb 14, 2005 at 11:36 am
Feb 23, 2005 at 10:05 pm -
Here's one: I have the USA census TIGER database loaded, the WHOLE THING, the whole country. It isn't the biggest database, but it is about 40G before indexes. Every table is over a few million rows. ...
Mark L. Woodward
Feb 4, 2005 at 10:08 pm
Feb 21, 2005 at 4:51 pm -
Martin Pitt has detected that the libpq API has changed incompatibly between 7.4 and 8.0. This has the effect, for example, that 7.4's psql cannot run with 8.0's libpq. Example: $ ...
Peter Eisentraut
Feb 2, 2005 at 1:53 pm
Jun 7, 2005 at 6:34 pm -
FYI, core has discussed the pending IBM ARC patent and the usage of those ideas in 8.0. Tom has found a 2Q cache algorithm that predates the ARC patent and is very similar to ARC. The major ...
Bruce Momjian
Feb 14, 2005 at 11:17 pm
Mar 5, 2005 at 7:18 pm -
I want to see if there is a concensus of opinion out there. We've all known that data loss "could" happen if vacuum is not run and you perform more than 2b transactions. These days with faster and ...
Mark L. Woodward
Feb 18, 2005 at 4:17 pm
Mar 11, 2005 at 6:25 pm -
I had an idea that might improve parallel seqscans on the same relation. If you have lots of concurrent seqscans going on a large relation, the cache hit ratio is very low. But, if the seqscans are ...
Jeff Davis
Feb 25, 2005 at 8:35 am
Apr 25, 2005 at 1:45 am -
Apropos to all this: Tatsuo recently proposed a RESET CONNECTION command that could be used to reset a connection between pooling assignments, so as to be sure that different pooled threads wouldn't ...
Tom Lane
Feb 1, 2005 at 7:04 am
Feb 3, 2005 at 11:19 am -
Should our multi-byte encoding be referred to as UTF8 or Unicode? I know UTF8 is a type of unicode but do we need to rename anything from Unicode to UTF8? Someone asked me via private email. -- Bruce ...
Bruce Momjian
Feb 15, 2005 at 2:15 am
Feb 25, 2005 at 6:36 pm -
22
Patch Count?
Marc and/or Bruce: Hey, for my information (people ask me this a lot) can one of you do a count of patch submitters for 8.0? For 7.4, it was around 180. -- Josh Berkus Aglio Database Solutions San ...Josh Berkus
Feb 4, 2005 at 6:12 pm
Feb 7, 2005 at 12:25 am -
I'm giving a talk next week on PostgreSQL 8, so I would like some input from the community on a few issues, so that my answers are as close to majority opinion as possible. One of the most frequent ...
Simon Riggs
Feb 25, 2005 at 10:43 am
Feb 28, 2005 at 12:23 am -
Here's the design of bitmap AM I'm planning to implement. I've discussed it with Neil, but I'm willing to get more feedback on it. There are going to be 1 metapage, 1 list of CTIDs (LOC), one list of ...
Victor Y. Yegorov
Feb 28, 2005 at 7:50 pm
Mar 5, 2005 at 9:00 am -
I'm working on an experimental patch to break up the BufMgrLock along the lines we discussed a few days ago --- in particular, using a clock sweep algorithm instead of LRU lists for the buffer ...
Tom Lane
Feb 13, 2005 at 10:07 pm
Feb 22, 2005 at 9:26 pm -
I'm wondering how useful it is to store explicit representations of the system attributes in pg_attribute. We could very easily hard-wire those things instead, which would make for a large reduction ...
Tom Lane
Feb 18, 2005 at 8:49 pm
Feb 22, 2005 at 6:43 pm -
Tom, I thought we were trying to get away from a midsummer feature freeze, due to the general lack of personnel in that season? I can tell you that, while I'm probably the least critical person for a ...
Josh Berkus
Feb 25, 2005 at 5:48 pm
Feb 26, 2005 at 6:49 pm -
Hi hackers! I have done initial implementation of SQL99 WITH clause (attached). It's now only for v7.3.4 and haven't a lot of checks and restrictions. It can execute only simple WITH queries like ...
Evgen Potemkin
Feb 24, 2005 at 10:02 am
May 5, 2005 at 1:46 am -
Gavin and Neil made some noise in late September about implementing stored procedures for PG 8.1, but I haven't heard anything more about it since that thread died off. I've been getting some ...
Tom Lane
Feb 24, 2005 at 8:13 pm
Mar 1, 2005 at 1:28 am -
(crossposting this to hackers, I'm sure there are interested people there as well) Since Dave set the site up for tracking clickthroughs, I hit the db with a couple of queries to count our downloads. ...
Magnus Hagander
Feb 24, 2005 at 4:35 pm
Feb 25, 2005 at 5:18 pm -
Hello, Ran into this little gem with a customer today: This works: create table foo (foo int not null, bar text); create sequence foo_seq; alter table foo alter column foo set default ...
Joshua D. Drake
Feb 2, 2005 at 8:01 pm
Feb 8, 2005 at 9:40 am -
Is there a way to bypass the optimizer and to specify a plan to be executed? Something like: Limit - Nested Loop - Nested Loop - Seq Scan on tab00 t00 - Index Scan using tab03_pkey on tab03 t03 Index ...
Hicham G. Elmongui
Feb 10, 2005 at 7:07 pm
Feb 16, 2005 at 2:46 am -
I've been doing a bit of research on $subj, and coming to the conclusion that the ARC patent is a lot narrower than it might appear. In fact most of the parts of the algorithm that we actually want ...
Tom Lane
Feb 3, 2005 at 10:27 pm
Feb 5, 2005 at 5:14 pm -
Is there a way to recall the previous command in psql? Obviously, "up arrow" or Ctrl-P using readline and the default readline bindings is close, but it recalls the previous _line_ of input. That is ...
Neil Conway
Feb 22, 2005 at 4:27 am
Feb 25, 2005 at 12:24 am -
Hi All I have a quite strange problem with RETURN NEXT statement. I have a big table with 500 millions of rows running on Postgres 8.0. Table "public.usno" Column | Type | Modifiers ...
Sergey E. Koposov
Feb 12, 2005 at 5:11 pm
Feb 17, 2005 at 8:58 pm -
I am getting a float4 regression test failure. I have extracted the SQL from both the float4 and float8 tests below. Both should return NAN I looked at the code, The float4div does the operation as ...
Jim Buttafuoco
Feb 1, 2005 at 3:12 pm
Feb 8, 2005 at 4:47 pm -
We've been speculating for awhile about ways to reduce contention for the BufMgrLock, in hopes of fixing the "context swap storm" problem exhibited by certain patterns of concurrent queries. The ...
Tom Lane
Feb 7, 2005 at 12:30 am
Feb 8, 2005 at 12:24 am -
I was thinking about one of the "pathological cases" where Slony-I behaves badly, and had an optimization thought... There is a cleanup loop that (commonly) runs every 10 minutes or so and vacuums ...
Chris Browne
Feb 23, 2005 at 11:50 pm
Feb 25, 2005 at 7:21 am -
I'm not entirely sure that requiring ownership of the table is the appropriate restriction for TRUNCATE. It made some sense back when TRUNCATE wasn't transaction-safe, but now that it is, you could ...
Tom Lane
Feb 22, 2005 at 7:01 pm
Feb 24, 2005 at 10:47 pm -
I notice the CONNECT BY patch has been updated for 8.0: http://gppl.moonbone.ru/ Seriously, we really need to get this into 8.1. Convert it to the standard WITH RECURSIVE syntax if necessary... Chris
Christopher Kings-Lynne
Feb 1, 2005 at 11:08 am
Feb 9, 2005 at 5:12 am -
Hi list, Attached for your perusal, unicode versions of upper/lower, that work independent of locale except for the following languages: Turkish, Azeri, and Lithuanian. There are 15 locale specific ...
John Hansen
Feb 3, 2005 at 12:39 am
Jun 7, 2005 at 1:00 am -
I'm communicating with psql via a pipe stream. This works pretty well, but one problem I have is trying to cancel an operation. If I send a sigint, psql dies. In looking at the source I gather this ...
John DeSoi
Feb 18, 2005 at 1:16 pm
Feb 21, 2005 at 10:07 pm -
I'd like to write a C-function that returns a SETOF a complex type. This set is obtained from a query performed using an SPI cursor. I don't want to build the complete set in memory so I tried the ...
Thomas Hallgren
Feb 18, 2005 at 2:06 pm
Feb 19, 2005 at 10:08 am -
I believe that this is what Oleg et al tap into with the tsearch2 stuff, no? I have someone asking me about it, and want to make sure that I'm telling him the right answer ... is this what GiST is? ...
Marc G. Fournier
Feb 8, 2005 at 7:23 pm
Feb 9, 2005 at 5:49 am -
Peter Bierman
Feb 20, 2005 at 2:58 am
Apr 14, 2005 at 9:25 pm -
I am interested in hacking COPY TO such that one can specify that rows are copied in a certain index order. I got as far as src/backend/commands/copy.c:CopyTo(), and it looks like I would need to ...
Dave Held
Feb 25, 2005 at 10:18 pm
Feb 26, 2005 at 4:46 am -
Presently the planner considers left-deep, right-deep, and bushy plans (i.e. it will consider plans in which the outer operand of a join is a join, the inner operand is a join, or both operands are ...
Neil Conway
Feb 22, 2005 at 4:09 am
Feb 23, 2005 at 1:42 pm -
Summary: I can crash 7.4-CVS and 8.0/HEAD by sending what appears to be a valid query. I'm trying to insert a unique entry into this table: create table bodyparts ( id serial primary key, bytes ...
Abhijit Menon-Sen
Feb 19, 2005 at 4:09 pm
Feb 21, 2005 at 3:23 am -
Hi As VACUUM is not something that can be rolled back, could we not make it run completely outside transactions. It already needs to be run outside a transaction block. I try to explain the problem ...
Hannu Krosing
Feb 7, 2005 at 10:53 am
Feb 9, 2005 at 9:40 am -
Hi, A TRUSTED language specifies that ordinary users can use the language. It also implies that access to the file system should be prevented. In essence, ordinary users can never access the ...
Thomas Hallgren
Feb 8, 2005 at 10:12 pm
Feb 9, 2005 at 2:56 am -
Michael Klatt reported here: http://archives.postgresql.org/pgsql-admin/2005-02/msg00031.php that we have problems because the flat files global/pg_pwd and global/pg_group aren't rebuilt following ...
Tom Lane
Feb 4, 2005 at 8:16 pm
Feb 6, 2005 at 5:25 pm -
Following some advice from Intel, http://www.intel.com/cd/ids/developer/asmo-na/eng/technologies/threading /20469.htm?page=2 I'm looking at whether the LWLock data structures may be within the same ...
Simon Riggs
Feb 3, 2005 at 7:11 am
Feb 4, 2005 at 2:01 am -
Hi! I work on memory leaks during creation index on time/timestamp column using GiST and found follow problem (?): For timestamp storage and defines are defined as (from utils/timestamp.h): #ifdef ...
Teodor Sigaev
Feb 22, 2005 at 10:32 am
Mar 14, 2005 at 8:04 am -
I read the following report from the NetBSD group: http://kerneltrap.org/node/4680 It has some interesting points. First, they analyze how the fit with other open source database offerings. Their ...
Bruce Momjian
Feb 25, 2005 at 4:00 am
Feb 25, 2005 at 9:40 pm -
Hello all Is it possible to get the oid of a function on the basis of its name?. The scenario which i am currently facing is that i have the function name, now i want search the pg_proc system ...
Sibtay Abbas
Feb 14, 2005 at 7:47 am
Feb 15, 2005 at 1:07 pm -
Just got reminded... Is there a way for a C function to determine the name of the schema in which is was created? ... John
John Hansen
Feb 14, 2005 at 8:32 am
Feb 14, 2005 at 9:36 pm -
That's not very helpful, is it? [ looks at code... ] dbcommands.c is expecting that rmtree() will have printed out a more-detailed message about the problem, but someone has carefully removed every ...
Tom Lane
Feb 11, 2005 at 5:16 pm
Feb 14, 2005 at 4:25 pm -
Dear Michael Fuhr, The word you said is correct on most information. I will give you more information. <Q I'd guess that you haven't installed some third-party modules that you need on the Linux box, ...
Premsun Choltanwanich
Feb 7, 2005 at 7:34 am
Feb 10, 2005 at 1:09 pm -
Hello, Has anyone seen the following: http://pecl.php.net/package/PDO The description from the site: PDO provides a uniform data access interface, sporting advanced features such as prepared ...
Joshua D. Drake
Feb 7, 2005 at 11:45 pm
Feb 9, 2005 at 7:42 pm -
Hi there, what's wrong to use SERIAL as FK without explicit PRIMARY KEY or UNIQUE ? qq=# create table t1( id serial); NOTICE: CREATE TABLE will create implicit sequence "t1_id_seq" for "serial" ...
Oleg Bartunov
Feb 28, 2005 at 9:26 am
Feb 28, 2005 at 8:16 pm -
Some SQL constructs will be satisfied before all rows of a set has been examined. I'm thinking of for instance: EXISTS(SELECT * FROM y WHERE y.a 0) If the first row of collection y fulfills the WHERE ...
Thomas Hallgren
Feb 17, 2005 at 9:14 am
Feb 17, 2005 at 3:39 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 110 |
posts | 969 |
users | 136 |
website | postgresql.org... |
irc | #postgresql |
136 users for February 2005
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)