Search Discussions
-
91
enums
If people would like to play, I have created a little kit to help in creating first class enum types in a few seconds. It works something like this: make TYPENAME=rainbow ENUMS=' "red", "orange", ...Andrew Dunstan
Oct 27, 2005 at 7:47 pm
Jan 29, 2006 at 1:49 am -
I am absolutely sure that I never changed any of the enable_xxx settings other than enable_mergejoin during these tests. The only other setting I played with was random_page_cost, but the nested loop ...
Kevin Grittner
Oct 7, 2005 at 5:39 am
Dec 2, 2005 at 9:48 am -
First, that was Merlin and not me :-) Second, it didn't really show any improvement for him either in his normal test. But when he re-ran it with just the count(*) test it showed improvement. Did you ...
Magnus Hagander
Oct 22, 2005 at 10:55 am
Oct 25, 2005 at 3:16 pm -
Hi, I'm using 8.1beta4 on a development server for a rather db-intensive application. This application has a multiprocess daemon which was working fairly well in past. After some recent changes I ...
Matteo Beccati
Oct 27, 2005 at 8:59 am
Oct 28, 2005 at 4:51 pm -
I'm looking at trying to fix some clear flaws in costing which cause of our real-world queries to choose sub-optimal plans under PostgreSQL. It's clear that there needs to be a tool to analyze the ...
Kevin Grittner
Oct 12, 2005 at 11:29 pm
Oct 19, 2005 at 7:59 pm -
Just before 8.1beta2 went out, Neil made the following changes: Rename pg_complete_relation_size() to pg_total_relation_size(), for the sake of brevity and clarity. Make pg_reload_conf(), ...
Tom Lane
Oct 7, 2005 at 1:27 am
Oct 8, 2005 at 11:34 pm -
This behaviour has been around so long that I've gotten used to it but I've always considered it a bug. Yet it has never been fixed so I'm going to ask if anybody else has issues with this behaviour. ...
Martijn van Oosterhout
Oct 16, 2005 at 1:25 pm
Jun 14, 2006 at 4:58 pm -
Richard_D_Levine@raytheon.com; Oracle cast('a ' about I suppose that there may be some value in having 'J&^% ' be different from 'J&^% '. I would expect to insert a password with trailing blanks to ...
Dann Corbit
Oct 19, 2005 at 9:38 pm
Oct 25, 2005 at 4:01 am -
http://archives.postgresql.org/pgsql-patches/2005-10/msg00191.php This looks to me like a pretty important performance tweak for Windows. Can any of the people who worked on the Windows signal ...
Tom Lane
Oct 21, 2005 at 3:29 pm
Oct 22, 2005 at 3:41 pm -
Autovacuum is getting put into the 8.1 release which is awesome. A lot of us are wondering now that PostgreSQL has all the features that many of us need, what are the features being planned for ...
Karen hill
Oct 14, 2005 at 4:57 pm
Nov 15, 2005 at 6:24 am -
I've been having this problem since trying to upgrade from 7.4.1 to 8.03, and now 8.1. It's a dual Xenon machine: Linux annette.stortek.com 2.4.22-26mdkenterprise #1 SMP Wed Jan 7 07:10:39 MST 2004 ...
Robert Creager
Oct 14, 2005 at 12:12 am
Nov 5, 2005 at 3:02 am -
Sample case: regression=# create table t1(f1 int, f2 int); CREATE TABLE regression=# set add_missing_from = true; SET regression=# create view v1 as select t1.*; NOTICE: adding missing FROM-clause ...
Tom Lane
Oct 25, 2005 at 9:43 pm
Oct 31, 2005 at 12:47 am -
I've got a customer who was having a problem with a backend running away with memory. It would hit 46G before finally being running the box completely out of memory. It didn't appear to be related to ...
Jim C. Nasby
Oct 26, 2005 at 8:25 pm
Oct 28, 2005 at 5:38 pm -
Yes, but the crashes are somewhat sporadic and most importantly they don't appear to involve any data loss/corruption. I just don't want to make matters any worse. In any case, my client's gone home ...
Jim Nasby
Oct 28, 2005 at 10:10 pm
Jun 14, 2006 at 10:33 pm -
I find that libpq.so exports the following symbols that have neither PQ, pq, pg, nor lo_ as a prefix: EncryptMD5 SockAddr_cidr_mask fe_getauthname fe_getauthsvc fe_sendauth fe_setauthsvc ...
Tom Lane
Oct 16, 2005 at 10:21 pm
Jun 14, 2006 at 10:32 pm -
do we maintain anything anywhere for this? mainly, some way of determining # of 'sorts to disk' vs 'sort in memory', to determine whether or not sort_mem is set to a good value? I don't think there ...
Marc G. Fournier
Oct 18, 2005 at 8:08 pm
Oct 26, 2005 at 10:00 pm -
Good people, Just had a thought! Might it be worth while protecting the postmaster from an OOM Kill on Linux by setting /proc/{pid}/oom_adj to -17 ? (Described vaguely in mm/oom_kill.c) Kind Regards, ...
John Hansen
Oct 3, 2005 at 1:03 pm
Oct 25, 2005 at 1:24 pm -
Something changed very recently in the output from pg_config --pgxs command on Win32. It now outputs double backslash everywhere instead of forward slashes. The mingw GNU Make is not too happy about ...
Thomas Hallgren
Oct 13, 2005 at 4:18 pm
Oct 15, 2005 at 7:56 pm -
I am not sure if this idea was mentioned before. The basic prefix btree idea is quite straightforward, i.e., try to compress the key items within a data page by sharing the common prefix. Thus the ...
Qingqing Zhou
Oct 5, 2005 at 4:00 am
Oct 7, 2005 at 2:04 pm -
Because it is a test, I am not sure there is any way to know what the possible impact of a bug is. If we knew there were bug in the patch, it would have been fixed already. That is probably overkill. ...
Bruce Momjian
Oct 31, 2005 at 6:01 pm
Nov 4, 2005 at 2:15 am -
Upped the stack to 8Mb. Now it dies in Plcheck. Logs/bt.out in: http://www.lerctr.org/~ler/alphadeath2.tar.gz $ tar tzvf alphadeath2.tar.gz drwxr-xr-x 2 ler users 0 Oct 18 16:01 lastrun-logs ...
Larry Rosenman
Oct 18, 2005 at 9:05 pm
Oct 19, 2005 at 2:06 pm -
This may or may not be related to previous threads regarding vacuum problems. Following the last thread, we built the development snapshot of Oct 6 with --enable-integer-datetimes and --enable-debug. ...
Kevin Grittner
Oct 11, 2005 at 7:09 pm
Oct 12, 2005 at 9:00 pm -
Applications that frequently use LISTEN/NOTIFY can suffer from performance problems because of the MVCC bloat created by frequent insertions into pg_listener. A solution to this has been suggested in ...
Neil Conway
Oct 6, 2005 at 4:37 am
Oct 10, 2005 at 1:21 am -
1. Move the test for strange memory alloc sizes to the palloc macros so that on error, it points at the palloc call rather than mcxt.c. Sure, it only attacks a small set of problems, but still. 2. ...
Martijn van Oosterhout
Oct 27, 2005 at 11:17 am
Dec 6, 2005 at 8:47 pm -
Core's current plan is to bundle 8.1beta3 tomorrow evening (Tuesday PM, North American east coast time) for announcement Wednesday. Any last minute bug fixes out there? regards, tom lane
Tom Lane
Oct 10, 2005 at 10:04 pm
Oct 12, 2005 at 1:39 am -
Yeah, MMCacheLock is for long-dead code, so you can probably get away with using it in the back versions. Hmm ... the comment for LWLockAssign is not meant to imply that the caller could do that; in ...
Tom Lane
Oct 7, 2005 at 8:21 pm
Oct 10, 2005 at 12:00 am -
From time to time the suggestion crops up of allowing a DROP IF EXISTS ... syntax. This seems not unreasonable, and I just spent a few minutes looking at what might be involved. Especially in the ...
Andrew Dunstan
Oct 15, 2005 at 12:29 am
Oct 15, 2005 at 9:15 pm -
I am working on the development of a military application which uses PostgreSQL trigger functions. I cannot (unfortunately) tell you specify use, being as it is classified. What I need the ability to ...
Lane Van Ingen
Oct 10, 2005 at 7:40 pm
Oct 12, 2005 at 2:10 pm -
I've been doing some test imports of UNICODE databases into Postgres 8.1beta3. The only problem I've seen is that some data from 8.0 databases will not import. I've generated dumps using pg_dump from ...
Paul Lindner
Oct 22, 2005 at 3:43 pm
Nov 1, 2005 at 12:16 pm -
8.0.3.
Jim Nasby
Oct 28, 2005 at 5:40 pm
Oct 28, 2005 at 10:06 pm -
not sure exactly when this was changed, but expanded display of \df+ output is broken in beta4. compare: [postgres@localhost data]$ /usr/local/pgsql-8.1.x/bin/psql -p 5481 template1 Welcome to psql ...
Robert Treat
Oct 25, 2005 at 6:27 pm
Oct 26, 2005 at 2:48 pm -
Hi, I installed 8.04 via RPM on Centos 4.2 which is the same as RedHat 4.2 and while booting the init script reports that the daemon [FAILED], but after I logon it shows the postmaster running and I ...
Tony Caduto
Oct 18, 2005 at 9:16 pm
Oct 21, 2005 at 8:01 am -
As I understand it vacuum operates outside of the regular transaction and if you stop it (SIGTERM, or pg_cancel_backend()) some of the work it accomplished will be kept when it rolls back. For large ...
Rod Taylor
Oct 4, 2005 at 4:27 am
Oct 6, 2005 at 2:04 am -
The long history of spinlock issues has recently been attacked significantly by Tom, but I wanted to get a status on this issue before we release 8.1 My understanding of the problems of spinlocking ...
Simon Riggs
Oct 11, 2005 at 12:17 pm
Oct 11, 2005 at 7:59 pm -
The following patch implements a fairly light set of timing statements aimed at understanding external sort performance. There is no attempt to alter the algorithms. Each major point in the ...
Simon Riggs
Oct 2, 2005 at 6:43 pm
Oct 4, 2005 at 3:51 am -
I've noticed that row count estimates for expression indexes appear to rely on default_statistics_target rather than on a column's actual statistics target. That is, if I use ALTER TABLE SET ...
Michael Fuhr
Oct 1, 2005 at 2:15 am
Oct 1, 2005 at 5:16 pm -
I was wonderring, because I create a lot of server side utility functions, whether adding an option to pg_dump to just dump functions has been considered. I did a quick perusal of the code, and noted ...
Sean Utt
Oct 8, 2005 at 2:09 am
Oct 30, 2005 at 11:24 pm -
Hi. To allow indexes to be inherited so unique, foreign keys and such works properly with inheritance has been on the todo for quite some time. I thought that most probably it is a very non trivial ...
Fredrik Olsson
Oct 2, 2005 at 9:37 pm
Oct 11, 2005 at 12:53 pm -
Tomorrow evening, I'm going to wrap up RC1, to announce it on Monday ... if anyone is sitting on *anything*, please say something before about midnight GMT ... ---- Marc G. Fournier Hub.Org ...
Marc G. Fournier
Oct 29, 2005 at 3:47 am
Nov 1, 2005 at 7:34 am -
As in subject. What it does, it gets through picksplit, I return good values, valid unions, etc. Than (I guess) postgres is trying to insert another value in tree, hence penalty is called. Why one of ...
Grzegorz Piotr Jaskiewicz
Oct 27, 2005 at 9:16 pm
Oct 28, 2005 at 10:19 am -
Does any of this need to be backpatched? --------------------------------------------------------------------------- Tom Lane wrote: -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us ...
Bruce Momjian
Oct 13, 2005 at 2:29 am
Oct 22, 2005 at 9:50 am -
I am playing with our allowed timezone settings and saw a few strange things. It understands "EST5EDT", but how does it understand "XYT5ABT"? test= set timezone = 'XYT5ABT'; SET test= SELECT ...
Bruce Momjian
Oct 13, 2005 at 4:57 pm
Oct 14, 2005 at 11:40 am -
Folks, Are foreign keys on temp tables not allowed just because nobody requested them, or because they're hard to do? -- --Josh Josh Berkus Aglio Database Solutions San Francisco
Josh Berkus
Oct 29, 2005 at 12:30 am
Oct 31, 2005 at 5:56 pm -
People, After writing dblink-ldap (http://pgfoundry.org/projects/dblink-ldap), several people have contacted me asking if this will give LDAP authentication to PostgreSQL, because they need this. And ...
Magnus Hagander
Oct 6, 2005 at 7:56 pm
Oct 31, 2005 at 1:50 pm -
Just testing pl/pgsql functions in 8.1beta4, I see failures for syntax that works in 8.0.3. The simplest test case for this is: create table ptest(foo int, bar varchar(10)); create or replace ...
Philip Yarra
Oct 28, 2005 at 2:32 am
Oct 28, 2005 at 6:30 pm -
Folks, Before I dive into this, is there some reason why the pg_catalog.* tables/views should not have comments that match the descriptions in the docs? I can see where this could cause some ...
David Fetter
Oct 12, 2005 at 7:54 pm
Oct 16, 2005 at 5:45 am -
Hi, I did see the message about the change of the function signatures to include IMMUTABLE and thought "Yes, that makes sense" - however, it has now occurred to me that: 1. xpath_table uses a SELECT ...
John Gray
Oct 10, 2005 at 1:08 pm
Oct 13, 2005 at 4:10 pm -
Based upon profiling of the initial stage of external sorting, it seems that this stage is overall CPU bound, with hotspots in comparetup_* accounting for around 50% of CPU time; lets just call that ...
Simon Riggs
Oct 3, 2005 at 8:35 pm
Oct 4, 2005 at 11:22 am -
If you don't see your favorite platform already listed as tested for 8.1 at http://developer.postgresql.org/docs/postgres/supported-platforms.html then please give it a try and send in your results. ...
Tom Lane
Oct 23, 2005 at 3:09 pm
Nov 2, 2005 at 6:46 am -
Hmm. pqStrerror is defined in libpgport (which is linked into the backend) as well as libpq. ISTM that libpq should not be linked with -Wl,-bI:../../../src/backend/postgres.imp, since it's not ...
Tom Lane
Oct 27, 2005 at 7:46 pm
Oct 30, 2005 at 2:27 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 189 |
posts | 1,417 |
users | 167 |
website | postgresql.org... |
irc | #postgresql |
167 users for October 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)