FAQ

PostgreSQL > pgsql-hackers > August 2008

Search Discussions

132 discussions - 1,374 posts

  • Here is a simple select output. darcy=# select title_id, title_name from title; title_id | title_name ----------+------------ 2 | Mrs 3 | Ms 4 | Miss (3 rows) Now I change the border. darcy=# \pset ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Aug 21, 2008 at 4:16 pm
    Jan 14, 2009 at 3:32 am
  • This is a followup for thread "plan invalidation vs stored procedures". The background is that it is impossible to change function return type without dropping and recreating. Unfortunately dropping ...
    Martin PihlakMartin Pihlak
    Aug 6, 2008 at 6:28 pm
    Sep 9, 2008 at 7:06 pm
  • Current GUC units code has 2 problems: - It requires case-sensiteive representation of units ("kB"). As the main point of units is to make configuring easier, requiring byte-exact typing makes them ...
    Marko KreenMarko Kreen
    Aug 31, 2008 at 10:17 pm
    Sep 11, 2008 at 12:20 pm
  • "a"= "b" is a value of hstore type, so query should be: select '"a"= "b"'::hstore; " character was chosen to simplify escaping, I see, but your problem is that password is one-way encrypted, so, you ...
    Teodor SigaevTeodor Sigaev
    Aug 23, 2008 at 10:04 am
    Aug 25, 2008 at 7:06 am
  • The way pg_hba.conf is set up to be loaded/parsed now, we have: postmaster: open and tokenize file (load_hba(), tokenize_file()). backend: parse lines (parse_hba) and check for matches ...
    Magnus HaganderMagnus Hagander
    Aug 2, 2008 at 10:58 am
    Sep 15, 2008 at 8:55 pm
  • I seem to recall that there was general support for installing a smaller default postgresql.conf file with only, say, a dozen parameters mentioned for initial tuning. The complete file can stay as a ...
    Peter EisentrautPeter Eisentraut
    Aug 19, 2008 at 9:58 am
    Aug 28, 2008 at 6:23 pm
  • I'm implementing collation support. Proposal can be found at http://archives.postgresql.org/pgsql-hackers/2008-07/msg00557.php Progress so far: - created catalogs pg_collation a pg_charset which are ...
    Radek StrnadRadek Strnad
    Aug 31, 2008 at 9:39 pm
    Sep 24, 2008 at 5:40 am
  • I would like to propose some changes to the infrastructure for recovery. These changes are beneficial in themselves, but also form the basis for other work we might later contemplate. Currently * the ...
    Simon RiggsSimon Riggs
    Aug 7, 2008 at 11:37 am
    Jan 27, 2009 at 3:38 pm
  • Currently dblink allows regular users to initiate libpq connection to user-provided connection string. This breaks the default policy that normal users should not be allowed to freely interact with ...
    Marko KreenMarko Kreen
    Aug 7, 2008 at 1:53 pm
    Sep 23, 2008 at 3:28 am
  • hello ... i picked up csaba nagy's idea and implemented a very simple yet very useful extension. i introduced a GUC called statement_cost_limit which can be used to error out if a statement is ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Aug 2, 2008 at 6:20 pm
    Aug 17, 2008 at 3:15 pm
  • Here's the latest window functions patch against HEAD. It seems to be ready for the September commit fest, as added documents, WINDOW clause feature and misc tests. I guess this would be the window ...
    Hitoshi HaradaHitoshi Harada
    Aug 29, 2008 at 5:04 pm
    Sep 9, 2008 at 4:45 pm
  • I'd like to stop autovac by changing the conf file then sending the server a HUP This "appears" to work, the logs show autovac terminated by administrative command. Then a few minutes later I see a ...
    Dave CramerDave Cramer
    Aug 25, 2008 at 2:09 am
    Aug 27, 2008 at 2:45 am
  • Here's an updated FSM patch. Changes since last patch: - Per comments and discussion with Simon, I've changed the "bubble up" behavior so that when a bottom-level page is updated, if the amount of ...
    Heikki LinnakangasHeikki Linnakangas
    Aug 29, 2008 at 7:47 am
    Sep 18, 2008 at 10:38 pm
  • Hi, Thanks to Brendan Jurd, who spent a lot of effort in creating useful Mediawiki templates, we now have moved the TODO list to the Wiki site. The new official location for the TODO list is here: ...
    Alvaro HerreraAlvaro Herrera
    Aug 20, 2008 at 5:12 pm
    Aug 22, 2008 at 5:39 pm
  • When primary server fails, it would be good if the clients connected to the primary knew to reconnect to the standby servers automatically. We might want to specify that centrally and then send the ...
    Simon RiggsSimon Riggs
    Aug 4, 2008 at 9:02 pm
    Aug 18, 2008 at 8:49 am
  • Here's a patch that allows CREATE OR REPLACE VIEW to add new columns to an existing view. Any feedback would be appreciated, especially if it meant that I could fix any problems before the next ...
    Robert HaasRobert Haas
    Aug 7, 2008 at 12:05 pm
    Dec 6, 2008 at 11:23 pm
  • It occurred to me a while ago that our query cancel messages are sent unencrypted, even when SSL is otherwise used. That's not a big issue on its own, because the cancellation message only contains ...
    Heikki LinnakangasHeikki Linnakangas
    Aug 8, 2008 at 6:55 pm
    Nov 21, 2008 at 4:31 am
  • Howdy, What is the status of plan invalidation vs stored procedures? From the initial design discussion I understand that function change handling was postponed to "some time in the future". Is ...
    Martin PihlakMartin Pihlak
    Aug 5, 2008 at 8:53 am
    Aug 7, 2008 at 2:11 am
  • Folks, As the things stored in databases grow, we're going to start needing to think about database objects that 4 bytes of size can't describe. People are already storing video in lo and bytea ...
    David FetterDavid Fetter
    Aug 18, 2008 at 8:09 pm
    Aug 20, 2008 at 1:02 pm
  • If we access a 1 block table using a SeqScan then it costs seq_page_cost, or 1 by default. If we access the same 1 block table using an IndexScan then the access costs random_page_cost to access the ...
    Simon RiggsSimon Riggs
    Aug 12, 2008 at 6:25 pm
    Aug 20, 2008 at 5:25 pm
  • Hello all, I have been digging into the database page layout (specifically the tuples) to ensure the unsigned integer types were consuming the proper storage. While digging around, I found one thing ...
    Ryan BradetichRyan Bradetich
    Aug 11, 2008 at 8:07 am
    Sep 3, 2008 at 3:27 pm
  • I feel the above comment about Firefox is the crux of the plugin issue. Having per-operating system options for each plugin is never going to scale. Having users compile/install these plugins works, ...
    Bruce MomjianBruce Momjian
    Aug 12, 2008 at 3:51 am
    Aug 16, 2008 at 9:19 pm
  • Hello, Here is a patch to add duration option (-T) to pgbench instead of number of transactions (-t). -t and -T are mutually exclusive. $ pgbench -n -S -c10 -T10 transaction type: SELECT only scaling ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Aug 13, 2008 at 1:55 am
    Sep 12, 2008 at 8:29 am
  • Currently, we calculate a single OldestXmin across all snapshots on the assumption that any transaction might access any table. I propose creating "Visibility Groups" that *explicitly* limit the ...
    Simon RiggsSimon Riggs
    Aug 7, 2008 at 10:31 am
    Aug 11, 2008 at 7:02 pm
  • Hello everybody. We have a dusty old server, FreeBSD 3.3-RELEASE, PostgreSQL 6.5.3. I need to migrate four DBs from old server to new server (FreeBSD 6.2, PostgreSQL 8.3.1). I've tried to do pg_dump ...
    Alexander lunyovAlexander lunyov
    Aug 14, 2008 at 2:28 pm
    Aug 21, 2008 at 12:31 pm
  • Hello, combination functions to_ascii and convert_to is broken now. Problem is in convert_to function. It doesn't support 8bit output encoding. Current workaround: CREATE FUNCTION to_ascii(bytea, ...
    Pavel StehulePavel Stehule
    Aug 11, 2008 at 7:39 am
    Aug 12, 2008 at 6:59 am
  • I've attached a patch that allows the generation of code coverage statistics. To test it, apply the patch, then: autoconf ./configure --enable-coverage make make check (or execute any other ...
    Michelle CaisseMichelle Caisse
    Aug 27, 2008 at 11:38 pm
    Sep 5, 2008 at 2:40 pm
  • I happened to be looking at nodes.h and started wondering just how sane this coding really is: extern PGDLLIMPORT Node *newNodeMacroHolder; #define newNode(size, tag) \ ( \ AssertMacro((size) = ...
    Tom LaneTom Lane
    Aug 26, 2008 at 6:57 pm
    Aug 30, 2008 at 3:51 pm
  • Hi, After the Magnus patch [1], that make it possible store statistics files at another (RAM-based) disk, I was thinking that would be useful to add an option at initdb time to do the symlink as we ...
    Euler Taveira de OliveiraEuler Taveira de Oliveira
    Aug 10, 2008 at 5:33 am
    Aug 25, 2008 at 3:34 pm
  • It seems there's something wrong with CheckOtherDBBackends() but I haven't exactly figured out what. There are no other sessions but drop database keeps saying "regression" is being accessed by other ...
    Gregory StarkGregory Stark
    Aug 4, 2008 at 12:29 pm
    Aug 5, 2008 at 6:38 pm
  • Volkan YAZICIVolkan YAZICI
    Aug 8, 2008 at 12:01 pm
    Sep 9, 2008 at 3:16 pm
  • Folks, While initdb allows you to choose a directory for transaction logs, it can't already exist, so it can't be in its usual place under $PGDATA. I'd like to propose that this be allowed by having ...
    David FetterDavid Fetter
    Aug 25, 2008 at 3:40 pm
    Aug 26, 2008 at 9:01 pm
  • Hi, Here's a patch to make autovacuum process TOAST tables separately from main tables. The most important change is that when called from autovac, vacuum does not process the TOAST table at all. It ...
    Alvaro HerreraAlvaro Herrera
    Aug 8, 2008 at 4:58 pm
    Oct 11, 2008 at 12:15 am
  • It seems that we allow several function arguments to have same name (or is it label :) hannu=# create or replace function ff(a int, a int) returns int language plpgsql as $$begin return $1+$2; ...
    Hannu KrosingHannu Krosing
    Aug 31, 2008 at 9:55 pm
    Sep 2, 2008 at 3:02 pm
  • I was looking just now at gram.y's handling of various peculiar SQL constructs, and was reminded of a point that's bothered me before, but I don't recall if it's ever been discussed explicitly on ...
    Tom LaneTom Lane
    Aug 25, 2008 at 1:24 am
    Aug 25, 2008 at 8:01 pm
  • Gregory StarkGregory Stark
    Aug 31, 2008 at 11:25 pm
    Jan 8, 2009 at 12:25 am
  • So, if you edit the current version of the TODO page, you get this stern warning: Hmm ... my browser isn't failing, but I do seem to detect a certain lack of snappiness to the edits. But what's more ...
    Tom LaneTom Lane
    Aug 26, 2008 at 4:59 am
    Aug 26, 2008 at 7:01 pm
  • Here's a snapshot of my current work on improving IN/EXISTS support, pursuant to the discussion here: http://archives.postgresql.org/pgsql-hackers/2008-08/msg00347.php I'm posting it because it's a ...
    Tom LaneTom Lane
    Aug 14, 2008 at 12:40 am
    Aug 22, 2008 at 12:54 am
  • Hi In HEAD, pg_stop_backup waits until the history file has been archived. But, in order to ensure that the last wal file was archived, pg_stop_backup should wait until not only the history file but ...
    Fujii MasaoFujii Masao
    Aug 7, 2008 at 12:14 pm
    Sep 8, 2008 at 4:44 pm
  • Current content of control file is insufficient to check if database is compatible with postgres server. I think we should create footprint file which will contains all page data structures and their ...
    Zdenek KotalaZdenek Kotala
    Aug 11, 2008 at 5:40 am
    Aug 11, 2008 at 2:44 pm
  • Hello, I'd like to use NDirectFileRead and NDirectFileWrite statistics counters for counting reads and writes in BufFile. They are defined, but not used now. BufFile is used for tuple sorting or ...
    ITAGAKI TakahiroITAGAKI Takahiro
    Aug 1, 2008 at 7:24 am
    Sep 17, 2008 at 1:22 pm
  • The way my rewritten FSM works at the moment is that pages are handed out of the FSM in random order, to spread the load of multiple backends to different pages. That's good for spreading the load, ...
    Heikki LinnakangasHeikki Linnakangas
    Aug 29, 2008 at 7:45 am
    Sep 13, 2008 at 7:00 am
  • Reference: Bruce Momjian writes: - http://archives.postgresql.org/pgsql-committers/2007-09/msg00402.php Other references: Boyer Moore?? - ...
    David RowleyDavid Rowley
    Aug 30, 2008 at 11:21 pm
    Sep 11, 2008 at 7:51 am
  • I've pretty much finished the project I got a bee in my bonnet about last week, which is to teach SELECT DISTINCT how to (optionally) use hashing for grouping in the same way that GROUP BY has been ...
    Tom LaneTom Lane
    Aug 5, 2008 at 2:51 pm
    Aug 6, 2008 at 7:17 pm
  • I just noticed, to my dismay, that has_table_privilege() does not allow me to check for usage privileges on sequences. I suspect this may have been an oversight. If so, the attached patch fixes it ...
    Abhijit Menon-SenAbhijit Menon-Sen
    Aug 7, 2008 at 8:08 am
    Dec 6, 2008 at 11:57 pm
  • Since 8.3, the system provides automatic I/O conversion casts between the built-in string types and other types, but there's currently no way for a user to declare additional casts using the I/O ...
    Heikki LinnakangasHeikki Linnakangas
    Aug 29, 2008 at 10:59 am
    Oct 30, 2008 at 10:50 pm
  • Hello. Here are these functions with detailed documentation: http://en.dklab.ru/lib/dklab_postgresql_patch/ intagg.int_array_append_aggregate(int[]): fast merge arrays into one large list ...
    Dmitry KoterovDmitry Koterov
    Aug 13, 2008 at 11:29 am
    Sep 25, 2008 at 5:39 pm
  • yeah, actually, i have not been successful to set up this, but let me give some information for you. 1. download the postgresql snapshot source code from here: ...
    LeiyonghuaLeiyonghua
    Aug 18, 2008 at 9:28 am
    Aug 21, 2008 at 6:56 pm
  • Back in April we changed EXPLAIN VERBOSE to not dump the internal plan tree anymore, on the grounds that non-hackers didn't want that info and hackers could get it with debug_print_plan and related ...
    Tom LaneTom Lane
    Aug 19, 2008 at 4:45 pm
    Aug 20, 2008 at 2:28 am
  • Hi there, is there psql static binary, which I can use on my iphone (version 1) ? I have no mac available, so I can't compile it myself. I heard about gui tool for iphone, but it's not free and is ...
    Oleg BartunovOleg Bartunov
    Aug 17, 2008 at 6:40 pm
    Aug 18, 2008 at 4:53 pm
Aug 2008
123
Group Navigation
period‹ prev | Aug 2008 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions132
posts1,374
users132
websitepostgresql.org...
irc#postgresql

132 users for August 2008

Tom Lane: 233 posts Alvaro Herrera: 87 posts Bruce Momjian: 70 posts Simon Riggs: 64 posts Magnus Hagander: 54 posts Pavel Stehule: 52 posts Greg Stark: 51 posts Peter Eisentraut: 38 posts Joshua Drake: 35 posts Hannu Krosing: 27 posts David Fetter: 26 posts Markus Wanner: 24 posts Andrew Dunstan: 23 posts Asko Oja: 23 posts Robert Haas: 23 posts Zdenek Kotala: 23 posts Decibel!: 21 posts Heikki Linnakangas: 21 posts Josh Berkus: 20 posts Dimitri Fontaine: 18 posts
show more
Archives