Search Discussions
-
Hopefully this is the right place for a few feature requests that would address some of the things that I've noticed in postgres. 1. Just a minor annoyance, but why must subqueries in FROM clauses ...
Ben Tilly
Aug 22, 2007 at 11:45 pm
Mar 12, 2008 at 5:21 pm -
A lot of work has been done to try to get /contrib/tsearch2 into the core backend for 8.3, but we have hit a roadblock in how to handle multiple text search configurations. (FYI, the documentation is ...
Bruce Momjian
Aug 14, 2007 at 7:00 pm
Aug 18, 2007 at 7:49 pm -
Looking into recent buildfarm failures on the 7.4 branch: http://www.pgbuildfarm.org/cgi-bin/show_status.pl It looks like parts of the CVS repository have been mistagged as belonging to REL7_4_STABLE ...
Kris Jurka
Aug 14, 2007 at 10:06 pm
Aug 15, 2007 at 7:13 pm -
There's three things clearly missing in the patch: 1. HOT updates on tables with expression or partial indexes. Hasn't been done yet because it should be pretty straightforward and we've had more ...
Heikki Linnakangas
Aug 7, 2007 at 6:02 pm
Aug 22, 2007 at 6:59 am -
hello everybody, one of our customers wants to store the code of interpreted procedures (PL/pgSQL, PL/Perl) and so in an encrypted way. so the idea we had to add one more column to pg_proc telling us ...
Hans-Jürgen Schönig
Aug 9, 2007 at 1:39 pm
Aug 10, 2007 at 8:03 pm -
I've been working on converting the current README files for all contrib modules into sgml and add it to the documentation. There are still some fixes to do but i'd like to have some feedback. ...
Albert Cervera i Areny
Aug 29, 2007 at 12:04 am
Aug 30, 2007 at 2:06 pm -
Hi I've updated the lazy xid assignment patch, incorporating the results of the discussion over the past few days. I'll try to explain what the patch does, and why. This reasoning got a bit lengthy, ...
Florian G. Pflug
Aug 31, 2007 at 7:41 pm
Sep 3, 2007 at 8:00 am -
In the interest of closing work on what's officially titled the "Automatic adjustment of bgwriter_lru_maxpages" patch, I wanted to summarize where I think this is at, what I'm working on right now, ...
Greg Smith
Aug 24, 2007 at 2:13 am
Sep 11, 2007 at 5:07 am -
I've applied version 0.58 of the patch with a lot of further editorializing. I feel fairly confident now in the code that interfaces between tsearch and the rest of the system, but a lot of the ...
Tom Lane
Aug 21, 2007 at 1:23 am
Aug 22, 2007 at 4:39 pm -
Before I wrap up the CSVlog stuff, we need to decide whether or not to change the name of the redirect_stderr setting, and if so to what. The reason is that with CSVlogs it will no longer apply just ...
Andrew Dunstan
Aug 9, 2007 at 3:16 pm
Aug 19, 2007 at 3:23 am -
24
.NET driver
I used NPGSQL .NET driver to connect PGSQL 8.2.4 database to VB.NET. As stated on NPGSQL page, it doesn't seem to provide seamless integration and performance with .NET. Instead when I used ODBC, the ...Rohit Khare
Aug 2, 2007 at 6:01 am
Aug 7, 2007 at 5:46 pm -
Hi, I have a simple query that uses digest(data, 'sha1') and consistently crashes the backend (tested in two different machines): ciencias=# select version(); version ...
Manuel Sugawara
Aug 23, 2007 at 11:50 pm
Nov 11, 2007 at 3:57 am -
23
GIT patch
Hi, I've started reading the GIT patch to see if I can help with the review. First thing I notice is that there are several things that seems left over; for example the comments in pg_proc for the ...Alvaro Herrera
Aug 1, 2007 at 3:00 am
Sep 21, 2007 at 2:18 pm -
While this looked like a reasonable idea in the abstract, it turns out that it was probably a waste of time. Red Hat distributions, at least, will never be able to use it in the given form. Allow me ...
Tom Lane
Aug 22, 2007 at 10:16 pm
Aug 24, 2007 at 2:01 am -
Hi When we lazily assign XIDs, we gain another flag beside the existing MyXactMadeTempRelUpdates, MyXactMadeXLogEntry, MyLastRecPtr and smgr's pendingDeletes to tell what kind of actions a ...
Florian G. Pflug
Aug 29, 2007 at 5:32 pm
Aug 31, 2007 at 1:55 am -
I don't want to pick on Teodor in particular, because I've seen other people do this too, but which of these functions do you find more readable? Datum to_tsquery_byname(PG_FUNCTION_ARGS) { ...
Tom Lane
Aug 17, 2007 at 7:16 pm
Nov 8, 2007 at 6:32 pm -
I was talking to someone at LinuxWorld and they mentioned they often have activity of 6k SELECTs per second, and that they were needing to autovacuum every few days because of xid wraparound. I did ...
Bruce Momjian
Aug 15, 2007 at 4:01 pm
Aug 16, 2007 at 8:56 pm -
Hi, I happened to feel need for something like Oracle's connect-by mechanism. In the contribs I found Joe Conways `tablefunc' but I missed some features there. So I had a look at the source code. ...
Bertram Scharpf
Aug 7, 2007 at 10:52 pm
Aug 13, 2007 at 11:09 pm -
I noticed that enums are not available to be queried as binary through the protocol. Is this a known issue? Too late to fix for 8.3? This is kind of a pain, because it forces any query that returns ...
Merlin Moncure
Aug 30, 2007 at 5:13 pm
Aug 31, 2007 at 6:55 pm -
We're seeing a problem where occasionally a process appears to be granted a lock but miss its semaphore signal. It eventually gets the 60s deadlock signal and notices that it has been granted the ...
Gregory Stark
Aug 5, 2007 at 11:41 pm
Aug 28, 2007 at 3:31 am -
This is a bit disturbing: *** ./expected/vacuum.out Sat Jul 20 00:58:14 2002 --- ./results/vacuum.out Wed Aug 8 20:16:45 2007 *************** *** 50,55 **** --- 50,56 ---- DELETE FROM vactst WHERE i ...
Tom Lane
Aug 9, 2007 at 12:29 am
Aug 11, 2007 at 5:42 am -
ISTM that having a built-in array_to_set function would be awfully useful... Is the aggregate method below an acceptable way to do it? ----- Forwarded message from Merlin Moncure <mmoncure@gmail.com ...
Decibel!
Aug 7, 2007 at 10:47 pm
Mar 12, 2008 at 3:14 pm -
I noticed a number of functions, most but not all in contrib, which allow an unprivileged user to obtain varying amounts of information about a relation he has no permissions to access: ...
Tom Lane
Aug 26, 2007 at 8:41 pm
Aug 29, 2007 at 6:08 am -
Here is the current 8.3 patch status: http://developer.postgresql.org/index.php/Todo:PatchStatus As you can see we have two major patches remaining, tsearch2 and HOT. Tom is working on tsearch2 now ...
Bruce Momjian
Aug 20, 2007 at 6:29 pm
Aug 21, 2007 at 10:04 pm -
So I was testing my fix for the problem noted here: http://archives.postgresql.org/pgsql-hackers/2007-08/msg00196.php and promptly found *another* bug. To wit, that repair_frag calls ...
Tom Lane
Aug 13, 2007 at 5:08 pm
Aug 15, 2007 at 10:46 am -
I searched for "checksum" and couldn't find it. Could someone give me a pointer? I'm not talking about WAL files here. Thanks, Laurenz Albe
Albe Laurenz
Aug 27, 2007 at 8:07 am
Aug 31, 2007 at 9:18 pm -
Actually ... I'm suddenly not happy about the choice to put text search configurations etc. into schemas at all. We've been sitting here and assuming that to_tsvector('english', my_text_col) has a ...
Tom Lane
Aug 17, 2007 at 3:15 am
Aug 18, 2007 at 7:13 pm -
Why does text search need a tsquery data type? I realize it needs tsvector so it can create indexes and updated trigger columns, but it seems tsquery could instead just be a simple text string. -- ...
Bruce Momjian
Aug 29, 2007 at 8:22 pm
Mar 12, 2008 at 7:41 pm -
I'm having trouble with the hardcoded 60 second timeout in pg_ctl. pg_ctl sometimes just times out and there is no way to make it wait a little longer. I would like to add an option to be able to ...
Peter Eisentraut
Aug 17, 2007 at 1:14 pm
Nov 5, 2007 at 5:08 pm -
I want to overhaul the MSVC build system somewhat and want to discuss my plans. The first thing I want to do is get rid of at least most of the .bat files in it altogether and make a single coherent ...
Andrew Dunstan
Aug 27, 2007 at 3:00 pm
Mar 12, 2008 at 7:28 pm -
I'm having trouble following what's going on with autovacuum and I'm finding the existing logging insufficient. In particular that it's only logging vacuum runs *after* the vacuum finishes makes it ...
Gregory Stark
Aug 7, 2007 at 2:20 pm
Aug 17, 2007 at 10:14 pm -
I ran some CPU intensive pgbench tests on HOT. Results are not surprising, HOT makes practically no difference on the total transaction rate, but reduces the need to vacuum: unpatched HOT tps 3680 ...
Heikki Linnakangas
Aug 7, 2007 at 12:16 pm
Aug 15, 2007 at 1:25 am -
This particular issue could be implemented just by adding -DCLOBBER_CACHE_ALWAYS to CFLAGS (or CPPFLAGS if you want to be anal about it). I suppose that no new buildfarm mechanism is required --- ...
Tom Lane
Aug 27, 2007 at 5:23 pm
Sep 3, 2007 at 1:35 am -
Why does the windows installer require a password for the superuser account, since it's perfectly legitimate not to have a password on that account? I could see perhaps producing a warning, but ...
Decibel!
Aug 30, 2007 at 10:30 pm
Aug 31, 2007 at 7:39 pm -
hello, I'm working on an application that once in a while needs to shuffle some data around with a query like: INSERT INTO foo (some_field, bar_FK, baz_FK) SELECT some_field, 12345 AS bar_FK, baz_FK ...
Lodewijk Voege
Aug 19, 2007 at 1:53 am
Aug 21, 2007 at 4:15 pm -
I recently had a chat with someone who was pretty intimate with Adabas for a number of years who's in the process of figuring things out about PostgreSQL. We poked at bits of the respective ...
Chris Browne
Aug 14, 2007 at 9:22 pm
Aug 16, 2007 at 3:04 pm -
-- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Bruce Momjian
Aug 15, 2007 at 3:54 pm
Aug 18, 2007 at 11:19 am -
Version 0.4 of libpq param put and PGresult get functions. Added support for inet and cidr, couple bug fixes. If you compile the test file, make sure you link with the patched libpq.so. Andrew
Andrew Chernow
Aug 21, 2007 at 7:16 pm
Dec 10, 2007 at 12:39 pm -
I've been lobbying management here for us to allocate some resources to testing 8.3 once it hits beta. If it is approved, it might happen on a time frame too short to get much feedback before the ...
Kevin Grittner
Aug 20, 2007 at 9:07 pm
Jan 18, 2008 at 7:09 pm -
All, Through the User Concurrency Thread on -performance [1], Tom and Jignesh found that our proximate bottleneck on SMP multi-user scaling is clog_buffers. Increasing clog_buffers to 64 improved ...
Josh Berkus
Aug 2, 2007 at 3:57 pm
Sep 14, 2007 at 3:21 am -
Async Commit is a useful feature, yet it requires some additional application code to be added to appropriate transactions. That code is then clearly version dependent, which may not always be ...
Simon Riggs
Aug 30, 2007 at 9:44 pm
Sep 2, 2007 at 8:55 pm -
I'm resending this without that actual patch attached, since my first mail didn't get through. The patch can be found here: http://soc.phlo.org/lazyxidassign.patch Hi Lately, there was some interest ...
Florian G. Pflug
Aug 25, 2007 at 9:45 pm
Aug 27, 2007 at 6:23 pm -
Hi, we have two build farm members failing to make since I committed teh ecpg changes: echidna and herring. It looks like they are still using an old preproc.c although they checked out the new ...
Michael Meskes
Aug 16, 2007 at 9:11 am
Aug 16, 2007 at 8:22 pm -
In addition to the encoding issues I have with the 8.2.4 MSVC++ build (see previous email), there are some other issues that I've run into: 1. The custom build step that generates DEF files for DLLS ...
Charlie Savage
Aug 30, 2007 at 2:55 am
Sep 6, 2007 at 11:29 pm -
It appears that when pg_ctl gets a stop request for a given directory, it looks for a pid file in that directory and signals that pid to stop. It doesn't appear to check that the pid is for a ...
Kevin Grittner
Aug 31, 2007 at 5:02 pm
Sep 2, 2007 at 8:20 pm -
There are a couple of naming issues that I left untouched while reviewing the tsearch patch, but wanted to bring up for discussion. One thing that had me confused for awhile is that the patch uses ...
Tom Lane
Aug 21, 2007 at 4:52 pm
Aug 22, 2007 at 2:34 pm -
No, 1.44 was a month ago. 1.45 does exist in the master CVS repo AFAICS. It looks to me like cvsweb is showing a version that hasn't gotten updated for a day or two. Some fallout of the master server ...
Tom Lane
Aug 16, 2007 at 4:25 pm
Aug 17, 2007 at 7:59 pm -
Hi, I have installed postgresql to my client as a server for a progam (libpq.dll/VCL based) that I wrote for them. Every is working fine, but I noted some general slowness, compared with an older ...
Omar Bettin
Aug 8, 2007 at 3:02 pm
Aug 10, 2007 at 11:10 am -
Hi, I have compiled PostgreSQL 8.2.4 with MinGW on Windows 2000. Then I have executed initdb as Administrator. However initdb failed with the following message. ---- The program "postgres" is needed ...
Yoshiyuki Asaba
Aug 27, 2007 at 11:57 am
Aug 31, 2007 at 6:23 am -
If HOT gets into 8.3, we might need a GUC to set database wide heap fillfactor to an appropriate value. The only way to so today is compile time value of DEFAULT_HEAP_FILLFACTOR. HOT works much ...
Pavan Deolasee
Aug 8, 2007 at 12:35 pm
Aug 14, 2007 at 3:22 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 143 |
posts | 1,221 |
users | 147 |
website | postgresql.org... |
irc | #postgresql |
147 users for August 2007
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)