FAQ

PostgreSQL > pgsql-hackers > February 2005

Search Discussions

110 discussions - 969 posts

  • 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.RodichevE.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 HaganderMagnus 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 SaparevKouber 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. WoodwardMark 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 EisentrautPeter 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 MomjianBruce 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. WoodwardMark 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 DavisJeff 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 LaneTom 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 MomjianBruce Momjian
    Feb 15, 2005 at 2:15 am
    Feb 25, 2005 at 6:36 pm
  • 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 BerkusJosh 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 RiggsSimon 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. YegorovVictor 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 LaneTom 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 LaneTom 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 BerkusJosh 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 PotemkinEvgen 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 LaneTom 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 HaganderMagnus 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. DrakeJoshua 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. ElmonguiHicham 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 LaneTom 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 ConwayNeil 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. KoposovSergey 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 ButtafuocoJim 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 LaneTom 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 BrowneChris 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 LaneTom 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-LynneChristopher 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 HansenJohn 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 DeSoiJohn 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 HallgrenThomas 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. FournierMarc G. Fournier
    Feb 8, 2005 at 7:23 pm
    Feb 9, 2005 at 5:49 am
  • Peter BiermanPeter 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 HeldDave 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 ConwayNeil 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-SenAbhijit 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 KrosingHannu 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 HallgrenThomas 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 LaneTom 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 RiggsSimon 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 SigaevTeodor 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 MomjianBruce 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 AbbasSibtay 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 HansenJohn 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 LaneTom 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 CholtanwanichPremsun 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. DrakeJoshua 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 BartunovOleg 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 HallgrenThomas Hallgren
    Feb 17, 2005 at 9:14 am
    Feb 17, 2005 at 3:39 pm
Feb 2005
123
Group Navigation
period‹ prev | Feb 2005 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions110
posts969
users136
websitepostgresql.org...
irc#postgresql

136 users for February 2005

Tom Lane: 186 posts Bruce Momjian: 94 posts Mark L. Woodward: 50 posts Magnus Hagander: 28 posts Marc G. Fournier: 28 posts Neil Conway: 25 posts Christopher Kings-Lynne: 24 posts Greg Stark: 22 posts Peter Eisentraut: 22 posts Simon Riggs: 21 posts Joshua D. Drake: 19 posts Jim C. Nasby: 18 posts John Hansen: 16 posts Oleg Bartunov: 16 posts Merlin Moncure: 15 posts Evgeny Rodichev: 13 posts Michael Fuhr: 12 posts Thomas Hallgren: 12 posts Alvaro Herrera: 11 posts Andrew Dunstan: 11 posts
show more
Archives