Search Discussions

135 discussions - 1,225 posts

  • Hi all, As we will soon enter beta, I decided to give a try to 8.3devel. The first step is of course to load a dump from an existing database. The dump is a text dump of 1.6 GB (database is ...
    Guillaume SmetGuillaume Smet
    Sep 18, 2007 at 4:51 pm
    Oct 12, 2007 at 6:17 pm
  • Hi Hackers, In my Project i have to handle a Database with 600 GByte Text only, distributed on 4 Tablespaces on multiple Harddisks and Remote SAN's connected via Gigaethernet to the Remote ...
    Sep 6, 2007 at 9:08 am
    Apr 7, 2008 at 4:36 am
  • I have been looking at fixing the issue of accepting strings that are not valid in the database encoding. It appears from previous discussion that we need to add a call to pg_verifymbstr() to the ...
    Andrew DunstanAndrew Dunstan
    Sep 9, 2007 at 4:02 am
    Sep 19, 2007 at 12:00 am
  • Dear PostgreSQL Hackers: After following the hackers mailing list for quite a while, I am going to start investigating what will need to be done to improve hash index performance. Below are the ...
    Kenneth MarshallKenneth Marshall
    Sep 2, 2007 at 6:04 pm
    Nov 15, 2007 at 12:13 am
  • We're so close I can almost taste it ... Here are the open tasks I can see, does anyone have others? * Review the one remaining patch from Simon that's on Bruce's patch queue page ...
    Tom LaneTom Lane
    Sep 27, 2007 at 3:23 pm
    Oct 8, 2007 at 6:43 pm
  • Hi hackers, I've noticed that there is a lot of code, particularly in src/backend, that goes through the motions of making a text datum into a cstring to perform some work on it, and likewise for ...
    Brendan JurdBrendan Jurd
    Sep 21, 2007 at 6:43 pm
    May 4, 2008 at 4:49 pm
  • Now that we've "announced" (see http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375&subSection=News) that 8.3 will include a debugger (don't worry, it's a PL/pgSQL debugger :-), ...
    Sep 4, 2007 at 2:04 pm
    Sep 6, 2007 at 5:37 pm
  • I've committed the HOT patch. I'd still like to think about whether we can be smarter about when to invoke pruning, but that's a small enough issue that the patch can go in without it. regards, tom ...
    Tom LaneTom Lane
    Sep 20, 2007 at 6:00 pm
    Sep 25, 2007 at 2:53 am
  • It seems possible to write your own functions to support various possibilities with text search. One of the more common thoughts is to have a list of words that you would like to include, i.e. the ...
    Simon RiggsSimon Riggs
    Sep 10, 2007 at 10:50 am
    Mar 10, 2008 at 4:02 pm
  • Hello I am found small bug postgres=# CREATE TEXT SEARCH DICTIONARY cz1(TEMPLATE = ispell, DictFile= 'cs_czutf'); ERROR: invalid text search configuration file name "cs_czutf" postgres=# CREATE TEXT ...
    Pavel StehulePavel Stehule
    Sep 2, 2007 at 8:28 pm
    Sep 9, 2007 at 3:10 pm
  • I have finished a first review pass over all of the HOT patch (updated code is posted on -patches). I haven't found any showstoppers, but there seem still several areas that need discussion: * The ...
    Tom LaneTom Lane
    Sep 18, 2007 at 2:49 am
    Sep 21, 2007 at 9:46 pm
  • I believe we had consensus that 8.3 needs to include an easier way for a function to set a local value of search_path, as proposed here: ...
    Tom LaneTom Lane
    Sep 1, 2007 at 4:41 pm
    Sep 12, 2007 at 3:29 am
  • Greg SmithGreg Smith
    Sep 6, 2007 at 3:32 am
    Sep 25, 2007 at 10:41 pm
  • dugong has been failing contribcheck repeatably for the last day or so, with a very interesting symptom: CREATE DATABASE is failing with ERROR: could not fsync segment 0 of relation 1663/40960/41403: ...
    Tom LaneTom Lane
    Sep 11, 2007 at 4:01 am
    Sep 16, 2007 at 10:00 pm
  • So I coded up a patch for this, based on the idea of creating a quasi-subtransaction that affects only GUC while entering/exiting a function that has GUC settings attached. The specified settings are ...
    Tom LaneTom Lane
    Sep 2, 2007 at 2:22 am
    Sep 5, 2007 at 7:57 am
  • Simon was complaining a bit ago that we still have problems with excessive contention for the ProcArrayLock, and that much of this stems from the need for transaction exit to take that lock ...
    Tom LaneTom Lane
    Sep 7, 2007 at 1:37 am
    Mar 12, 2008 at 8:20 pm
  • I have reduced the build and regress .bat files to one liners: build.bat: @perl build.pl %* vcregress.bat: @perl vcregress.pl %* These mirror exactly what the buildfarm will do when it's modified. In ...
    Andrew DunstanAndrew Dunstan
    Sep 24, 2007 at 10:58 pm
    Sep 26, 2007 at 1:16 pm
  • Preparations are being made for PostgreSQL releases 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20. The CVS branches are nearly ready. The releases will happen sometime early next week. The packagers have ...
    Bruce MomjianBruce Momjian
    Sep 11, 2007 at 10:56 pm
    Sep 13, 2007 at 12:45 pm
  • Hello Current result from xpath function isn't indexable. It cannot be problem with possibility cast it to some base types. CREATE OR REPLACE FUNCTION xml_list_to_int(xml[]) RETURNS int[] AS $$ ...
    Pavel StehulePavel Stehule
    Sep 25, 2007 at 7:57 am
    Mar 24, 2008 at 11:46 pm
  • It seems like there isn't any good reason the perl scripts for the MSVC build don't support readline Readline for windows is available as part of the GnuWin32 project. ...
    Chuck McDevittChuck McDevitt
    Sep 24, 2007 at 2:03 am
    Sep 25, 2007 at 9:10 pm
  • [ just when you thought it was safe to go back in the water ] In threads starting here and here: http://archives.postgresql.org/pgsql-hackers/2007-07/msg00874.php ...
    Tom LaneTom Lane
    Sep 23, 2007 at 4:51 pm
    Sep 25, 2007 at 9:36 am
  • This morning's ecpg patch certainly seems to have been snake-bit. Although the Windows gcc buildfarm members seem happy, the MSVC ones are all failing with Linking... Creating library ...
    Tom LaneTom Lane
    Sep 30, 2007 at 10:47 pm
    Oct 9, 2007 at 8:31 am
  • Hi, The Current architecture of Updates in PostgreSQL is 1) Make a select query out of update. It involves a READ lock/BUFFER_SHARE 2) Get the tupleid 3) Goto the buffer containing the tupleid, make ...
    Gokulakannan SomsundaramGokulakannan Somsundaram
    Sep 20, 2007 at 7:11 am
    Oct 8, 2007 at 3:19 pm
  • A while back in an off-hand comment Tom packed varlenas he mentioned that we might want to have more types of toast pointers. Since then the idea of some alternative column-wise partitioning scheme ...
    Gregory StarkGregory Stark
    Sep 29, 2007 at 1:58 pm
    Oct 4, 2007 at 7:15 am
  • Hi everyone, I was playing with converting unixtop (the version of top used in FreeBSD) to only show PostgreSQL processes pulled from the pg_stat_activity table. I have a version that kind of works ...
    Mark WongMark Wong
    Sep 25, 2007 at 7:01 am
    Sep 27, 2007 at 4:45 am
  • All, A Hibernate developer pointed out the following odd behavior to me in 8.2.1: create table test ( test1 text ); create table test2 ( test_col text ); create rule test_insert as on insert to test ...
    Josh BerkusJosh Berkus
    Sep 12, 2007 at 4:45 pm
    Sep 14, 2007 at 8:06 pm
  • Hmm ... http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=luna_moth&dt=2007-09-19%2013:10:01 Exact same error --- is it at the same place in the tests where you saw it? Now that I think about it, ...
    Tom LaneTom Lane
    Sep 19, 2007 at 3:15 pm
    Sep 24, 2007 at 9:07 am
  • I spent a bit of time tonight poking at the issue reported here: http://archives.postgresql.org/pgsql-novice/2007-08/msg00123.php It turns out to be quite easy to reproduce, at least for me: start ...
    Tom LaneTom Lane
    Sep 29, 2007 at 3:58 am
    Oct 9, 2007 at 7:44 am
  • I was reminded again just now of the bad consequences of selecting a database encoding that is not compatible with your LC_CTYPE setting: ...
    Tom LaneTom Lane
    Sep 28, 2007 at 4:02 pm
    Oct 5, 2007 at 8:11 pm
  • Hi hackers, I note that we currently expose the usefulness of the quote_identifier function to the user with quote_ident(text). Is there any reason we shouldn't do the same with ...
    Brendan JurdBrendan Jurd
    Sep 12, 2007 at 3:15 am
    Mar 26, 2008 at 2:49 am
  • Um ... so that means CONVERT(c USING y) now fails entirely? That might be going a bit far. If we do want to get rid of that syntax then I'm noting a lack of parser changes in this patch. regards, tom ...
    Tom LaneTom Lane
    Sep 18, 2007 at 10:19 pm
    Nov 1, 2007 at 11:28 pm
  • Strange. It passed all regression tests for me and it seems like this is something that would have been caught even in single-byte mode by a simple test. It seems to me that like_match.c only used ...
    Gregory StarkGregory Stark
    Sep 23, 2007 at 12:44 pm
    Mar 24, 2008 at 6:24 pm
  • Be forewarned - this is probably a very long post, and I'm just a mere mortal (ie. admin) who doesn't write copious amounts of C code. Take the following posts and suggestions with a grain of salt. ...
    Avery PayneAvery Payne
    Sep 7, 2007 at 8:58 pm
    Sep 12, 2007 at 8:58 am
  • I've completed a review of all of the LWlocking in the backends. This is documented in the enclosed file. I would propose that we use this as comments in lwlock.h or in the README, if people agree. A ...
    Simon RiggsSimon Riggs
    Sep 11, 2007 at 9:48 am
    Mar 19, 2008 at 6:15 pm
  • While looking at the HOT patch I suddenly started to question the sanity of vacuumlazy.c's count_nondeletable_pages(). It sits there and does a HeapTupleSatisfiesVacuum on any tuples it finds, and is ...
    Tom LaneTom Lane
    Sep 15, 2007 at 11:49 pm
    Oct 29, 2007 at 6:58 pm
  • Hi, Darcy Buskermolen noticed that when one has many databases, the autovac launcher starts eating too much CPU. I tried it here with 200 databases and indeed it does seem to eat its share. Even with ...
    Alvaro HerreraAlvaro Herrera
    Sep 13, 2007 at 4:16 pm
    Sep 24, 2007 at 4:40 pm
  • Hello, In order to make some trivial test, I have start patching pg_dump to get insert using multi-rows (like --inserts option). I say "start" because it was just a poor hack to pg_dump.c. If you are ...
    Cédric VillemainCédric Villemain
    Sep 4, 2007 at 4:23 pm
    Sep 14, 2007 at 3:08 pm
  • Hello last time I checked utf8 database. Now I checked latin2 encoding database. I used dictionaries from last test. client_encoding | utf8 lc_collate | cs_CZ.iso-8859-2 lc_ctype | cs_CZ.iso-8859-2 ...
    Pavel StehulePavel Stehule
    Sep 7, 2007 at 7:13 pm
    Sep 10, 2007 at 4:25 pm
  • Section 12.1.3. Configurations of the developer docs notes that "Fortunately, PostgreSQL comes with predefined configurations for many languages. (psql's \dF shows all predefined configurations.)" ...
    Robert TreatRobert Treat
    Sep 2, 2007 at 12:56 pm
    Sep 3, 2007 at 7:11 pm
  • 200 sounds like a badly chosen value. With a 8k block size, that's a bit less than MaxHeapTuplesPerPage, which means that in the worst case you don't allocate enough space to hold all dead tuples, ...
    Heikki LinnakangasHeikki Linnakangas
    Sep 24, 2007 at 9:03 am
    Sep 26, 2007 at 8:54 pm
  • We previously discussed compressing the numeric data type for small values: http://archives.postgresql.org/pgsql-hackers/2007-06/msg00715.php We didn't do this for 8.3 but in any case Tom did suggest ...
    Gregory StarkGregory Stark
    Sep 24, 2007 at 3:27 pm
    Sep 26, 2007 at 7:23 pm
  • Hello, I am a graduate student of computer science and I have been looking at PostgreSQL for my master's thesis work. I am looking into implementing raw device I/O for large objects into PostgreSQL ...
    Georgi ChulkovGeorgi Chulkov
    Sep 18, 2007 at 1:55 am
    Sep 20, 2007 at 11:03 am
  • Hello, "pg_ctl -w -D ... start" doesn't work when unix_socket_directory is set to somewhere else than the compiled in default ("/tmp"). Having this is useful for the startup scripts, so the status ...
    Radoslaw ZielinskiRadoslaw Zielinski
    Sep 18, 2007 at 10:23 pm
    Sep 19, 2007 at 7:05 pm
  • We know that HOT can cause line pointer bloat because of redirect dead line pointers. In the worst case there could be MaxHeapTuplesPerPage redirect-dead line pointers in a page. VACUUM can reclaim ...
    Pavan DeolaseePavan Deolasee
    Sep 13, 2007 at 1:06 pm
    Sep 14, 2007 at 4:21 am
  • I brought back clownfish(still a bit dubious about the unexplained failures which seem vmware emulation bugs but this one seems to be easily reproduceable) onto the buildfarm and enabled ...
    Stefan KaltenbrunnerStefan Kaltenbrunner
    Sep 9, 2007 at 3:14 pm
    Sep 12, 2007 at 7:54 am
  • Hi there, seems something is broken in ispell dictionary (CVS HEAD). event=# CREATE TEXT SEARCH DICTIONARY en_ispell ( TEMPLATE = ispell, DictFile = english, AffFile = english, StopWords = english ); ...
    Oleg BartunovOleg Bartunov
    Sep 9, 2007 at 4:43 am
    Sep 10, 2007 at 9:35 pm
  • I spent a fair amount of time this afternoon trying to measure the performance impact of this patch using pgbench, without a lot of success --- as far as average transaction rates go, it's a wash ...
    Tom LaneTom Lane
    Sep 8, 2007 at 8:22 pm
    Sep 8, 2007 at 9:51 pm
  • Hello I am testing fulltext. 1. I am not able use fulltext with latin2 encoding :( I missing note about only utf8 dictionaries in doc). 2. with hspell dictionaries (fresh copy from open office) I got ...
    Pavel StehulePavel Stehule
    Sep 3, 2007 at 7:25 am
    Sep 4, 2007 at 12:43 pm
  • The SQL:2003 standard definition of SET TRANSACTION differs in major ways from PostgreSQL's, which produces some interesting behaviour. We currently claim conformance, though this is not accurate. ...
    Simon RiggsSimon Riggs
    Sep 5, 2007 at 8:04 pm
    Apr 16, 2008 at 10:05 am
  • Hi, Now that PostgreSQL 8.3 enables autovacuum by default, I think pgbench should stop issuing vacuum in pgbench -i since an ordinary vacuum will take very long time under autovacuum running. If ...
    Tatsuo IshiiTatsuo Ishii
    Sep 25, 2007 at 1:57 pm
    Sep 29, 2007 at 12:40 am
Group Navigation
period‹ prev | Sep 2007 | next ›
Group Overview
grouppgsql-hackers @

117 users for September 2007

Tom Lane: 273 posts Andrew Dunstan: 68 posts Bruce Momjian: 60 posts Gregory Stark: 56 posts Simon Riggs: 56 posts Heikki Linnakangas: 50 posts Alvaro Herrera: 31 posts Florian G. Pflug: 28 posts Magnus Hagander: 23 posts Pavan Deolasee: 20 posts Teodor Sigaev: 19 posts Greg Smith: 18 posts Kenneth Marshall: 18 posts Kevin Grittner: 18 posts Brendan Jurd: 17 posts Jeff Davis: 17 posts Zdenek Kotala: 17 posts Dave Page: 16 posts Josh Berkus: 16 posts Oleg Bartunov: 16 posts
show more