FAQ

PostgreSQL > pgsql-hackers > August 2007

Search Discussions

143 discussions - 1,221 posts

  • 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 TillyBen 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 MomjianBruce 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 JurkaKris 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 LinnakangasHeikki 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önigHans-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 ArenyAlbert 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. PflugFlorian 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 SmithGreg 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 LaneTom 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 DunstanAndrew Dunstan
    Aug 9, 2007 at 3:16 pm
    Aug 19, 2007 at 3:23 am
  • 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 KhareRohit 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 SugawaraManuel Sugawara
    Aug 23, 2007 at 11:50 pm
    Nov 11, 2007 at 3:57 am
  • 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 HerreraAlvaro 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 LaneTom 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. PflugFlorian 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 LaneTom 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 MomjianBruce 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 ScharpfBertram 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 MoncureMerlin 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 StarkGregory 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 LaneTom 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!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 LaneTom 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 MomjianBruce 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 LaneTom 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 LaurenzAlbe 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 LaneTom 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 MomjianBruce 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 EisentrautPeter 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 DunstanAndrew 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 StarkGregory 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 LinnakangasHeikki 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 LaneTom 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!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 VoegeLodewijk 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 BrowneChris 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 MomjianBruce 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 ChernowAndrew 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 GrittnerKevin 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 BerkusJosh 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 RiggsSimon 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. PflugFlorian 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 MeskesMichael 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 SavageCharlie 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 GrittnerKevin 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 LaneTom 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 LaneTom 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 BettinOmar 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 AsabaYoshiyuki 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 DeolaseePavan Deolasee
    Aug 8, 2007 at 12:35 pm
    Aug 14, 2007 at 3:22 pm
Aug 2007
123
Group Navigation
period‹ prev | Aug 2007 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions143
posts1,221
users147
websitepostgresql.org...
irc#postgresql

147 users for August 2007

Tom Lane: 245 posts Andrew Dunstan: 80 posts Gregory Stark: 69 posts Bruce Momjian: 65 posts Heikki Linnakangas: 45 posts Alvaro Herrera: 43 posts Decibel!: 41 posts Simon Riggs: 34 posts Josh Berkus: 32 posts Joshua D. Drake: 31 posts Magnus Hagander: 31 posts Florian G. Pflug: 28 posts Oleg Bartunov: 23 posts Peter Eisentraut: 20 posts Greg Smith: 17 posts Merlin Moncure: 16 posts Pavan Deolasee: 15 posts Stefan Kaltenbrunner: 15 posts Kevin Grittner: 14 posts Pavel Stehule: 14 posts
show more
Archives