Search Discussions

145 discussions - 1,575 posts

  • Using 9.0devel cvs HEAD, 2010.04.08. I am trying to understand the performance difference between primary and standby under a standard pgbench read-only test. server has 32 GB, 2 quadcores. primary: ...
    Erik RijkersErik Rijkers
    Apr 9, 2010 at 11:23 pm
    May 7, 2010 at 12:05 pm
  • This is a change in pg_control layout and requires a bump to the pg_control version number (and hence forced initdb's all round). I think it was quite premature to commit this when the design is ...
    Tom LaneTom Lane
    Apr 23, 2010 at 8:04 pm
    Apr 30, 2010 at 6:43 pm
  • Wouldn't this help even for beta1? Cheers Mark
    Mark KirkwoodMark Kirkwood
    Apr 29, 2010 at 9:46 pm
    May 12, 2010 at 2:23 am
  • I'm thinking of changing pg_start_backup and pg_stop_backup so that they just check that wal_level = 'archive', and changing pg_stop_backup so that it doesn't wait for archiving when archive_mode is ...
    Fujii MasaoFujii Masao
    Apr 28, 2010 at 10:40 am
    Jun 3, 2010 at 9:32 pm
  • One way we could fix this is use 2 bits rather than 1 for XLogStandbyInfoMode. One bit could indicate that either archive_mode=on or max_wal_senders 0, and the second bit could indicate that ...
    Robert HaasRobert Haas
    Apr 22, 2010 at 5:02 pm
    Apr 27, 2010 at 2:53 pm
  • When there is a specific reject rule, why does the server say FATAL: no pg_hba.conf entry That sounds like an administrative error, rather than a specific decision on the part of an admin to reject ...
    Simon RiggsSimon Riggs
    Apr 7, 2010 at 10:52 am
    Apr 22, 2010 at 9:14 pm
  • A couple of recent threads made got me thinking again about the idea of global temporary tables. There seem to be two principal issues: 1. What is a global temporary table? 2. How could we implement ...
    Robert HaasRobert Haas
    Apr 24, 2010 at 2:52 am
    Apr 26, 2010 at 8:19 pm
  • Hello, I've been reading the earlier threads at: http://archives.postgresql.org/pgsql-hackers/2009-05/thrd7.php#00252 http://archives.postgresql.org/pgsql-hackers/2005-10/thrd4.php#00632 and I'm not ...
    Kjell Rune SkaaraasKjell Rune Skaaraas
    Apr 27, 2010 at 10:52 pm
    Jul 26, 2010 at 1:27 am
  • There are a couple of features that were considered but not committed for 9.0 which require additional information about the properties of various data types. At PGeast I had a chance to talk with ...
    Robert HaasRobert Haas
    Apr 9, 2010 at 2:29 am
    Apr 22, 2010 at 4:04 am
  • Yes. Since SR connection is superuser connection, setting superuser_reserved_connections appropriately would be useful to prevent non-superuser connections from blocking the connection from the ...
    Fujii MasaoFujii Masao
    Apr 1, 2010 at 1:50 am
    Apr 21, 2010 at 5:57 pm
  • Hello, I am sending my proposal on GSoC. Details are listed below. Please, if you have ideas, tips, or if you only want to say you opinion about my project, go ahead. thanks, Pavel Baros Abstract: It ...
    Apr 9, 2010 at 8:36 pm
    Apr 21, 2010 at 3:59 pm
  • I think postgres git repo is broken. The compilation of REL7_4_STABLE from git fails on my system with: make -C src all make -C port all make[2]: *** No rule to make target `sprompt.o', needed by ...
    Alexey KlyukinAlexey Klyukin
    Apr 30, 2010 at 11:06 am
    May 3, 2010 at 8:32 pm
  • On the recent discussion (*1), some people argued that specifying neither primary_conninfo nor restore_command in the standby mode is not unreasonable, and we reached the consensus that the setting ...
    Fujii MasaoFujii Masao
    Apr 5, 2010 at 8:09 am
    Apr 6, 2010 at 5:33 pm
  • I triaged the list of open items on the Streaming Replication wiki page. I propose that we drop the ones I've marked as Drop below, and move the remaining items to the main Open Items page for better ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 6, 2010 at 7:09 am
    Apr 16, 2010 at 9:06 am
  • TFM says: Sets the amount of memory the database server uses for shared memory buffers. The default is typically 32 megabytes (32MB), but might be less if your kernel settings will not support it (as ...
    Robert HaasRobert Haas
    Apr 14, 2010 at 3:06 pm
    Apr 23, 2010 at 3:15 am
  • Here's a thread that incorrectly started on the security list, but really is more about functionality. Looking for comments: The function is_absolute_path() is incorrect on Windows. As it's ...
    Magnus HaganderMagnus Hagander
    Apr 9, 2010 at 1:17 pm
    Feb 12, 2011 at 2:49 pm
  • Hackers, Continuing the performance test: DBD, like a number of monitoring systems, does "pings" on the database which look like this: SELECT 'DBD::Pg ping test'; In our test, which does 5801 of ...
    Josh BerkusJosh Berkus
    Apr 6, 2010 at 5:47 am
    Apr 7, 2010 at 6:04 am
  • Thinking about allowing a backup to tell which files have changed in the database since last backup. This would allow an external utility to copy away only changed files. Now there's a few ways of ...
    Simon RiggsSimon Riggs
    Apr 27, 2010 at 1:33 pm
    Apr 28, 2010 at 6:55 pm
  • When diagnosing a problem for a guy in the german channel (with Stefan as mediator :P), we've found a case where the timezone information in the registry seem to be empty for some timezones. The ...
    Magnus HaganderMagnus Hagander
    Apr 6, 2010 at 9:13 pm
    Apr 15, 2010 at 8:12 am
  • I've often said in the past that we have too many mailing lists with overlapping and vague charters. I submit the following thread as evidence that this causes real problems. ...
    Greg StarkGreg Stark
    Apr 8, 2010 at 5:11 am
    Apr 8, 2010 at 9:24 pm
  • Most Esteemed Hackers: Due to popular demand on #postgresql (by which I mean David Fetter), I have been spending a little time making the internal SQL parser available to clients via a C-language SQL ...
    Michael TharpMichael Tharp
    Apr 2, 2010 at 7:59 pm
    Apr 28, 2010 at 8:11 am
  • Time for a new thread specific to this subject. For previous discussion, see here: http://archives.postgresql.org/pgsql-hackers/2010-04/msg01140.php ...
    Robert HaasRobert Haas
    Apr 26, 2010 at 1:07 am
    Jun 4, 2010 at 11:16 pm
  • Resending, my ISP lost my mail yesterday. :-( =========================================================== Hi, attached is a patch that does $SUBJECT, we are submitting it for 9.1. I have updated it ...
    Apr 30, 2010 at 3:47 pm
    May 20, 2010 at 3:20 am
  • Hackers, Here's a way to trap yourself: (1) Set up an HS/SR master (2) pg_start_backup on the master (3) clone the master to 1 or more slaves (4) Fast shutdown the master (without pg_stop_backup) (5) ...
    Josh BerkusJosh Berkus
    Apr 4, 2010 at 7:29 pm
    Apr 28, 2010 at 2:44 am
  • Hello this version has enhanced AllocSet allocator - it can use a mmap API. Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Apr 1, 2010 at 1:23 pm
    Jul 20, 2010 at 11:39 am
  • Benefits of Project Partitioning refers to splitting what is logically one large table into smaller physical pieces. Partitioning can provide several benefits: Query performance can be improved ...
    Necati BaturNecati Batur
    Apr 8, 2010 at 7:58 pm
    Apr 10, 2010 at 12:28 am
  • The following messages from the postgres catalog either appear to be internal errors that should be marked differently, or they are in my estimation unintelligible to users and should be rephrased. ...
    Peter EisentrautPeter Eisentraut
    Apr 3, 2010 at 8:00 am
    Apr 6, 2010 at 4:53 pm
  • 12


    I think it might be time to think about shipping a beta release. I guess this is a -core decision, but I can't argue for it there, so I'll argue for it here. It seems like we're about ready, so maybe ...
    Robert HaasRobert Haas
    Apr 20, 2010 at 5:09 pm
    Apr 23, 2010 at 3:49 pm
  • Hi, i'm startint to try Hot Standby & Streaming Replication, so i started a replication: 1) Install master server with regression database 2) Start WAL archive (archive_mode=on, archive_command='cp ...
    Jaime CasanovaJaime Casanova
    Apr 9, 2010 at 8:40 pm
    Apr 13, 2010 at 4:43 pm
  • what i want to do. 1) make standbycheck should be accesible from top source dirs 2) it should use an existing regression database on an already configured standby server (no need of the ...
    Jaime CasanovaJaime Casanova
    Apr 14, 2010 at 2:17 pm
    May 2, 2010 at 2:15 pm
  • Following a great deal of discussion, I'm pleased to announce that the PostgreSQL Core team has decided that the major theme for the 9.1 release, due in 2011, will be 'NoSQL'. There is a growing ...
    Dave PageDave Page
    Apr 1, 2010 at 8:13 am
    Apr 1, 2010 at 5:26 pm
  • Hi, COPY is not working on latest HEAD? """ regression=# select * from a; aa ---- 32 56 (2 rows) regression=# COPY a TO '/tmp/copy_test'; COPY 0 """ -- Atentamente, Jaime Casanova Soporte y ...
    Jaime CasanovaJaime Casanova
    Apr 30, 2010 at 5:47 am
    May 4, 2010 at 3:56 am
  • Hi there, below is an example of interesting query and two plans - the bad plan, which uses merge join and big sorting, took 216 sec, and good plan with merge join disabled took 8 sec. Sorry for odd ...
    Oleg BartunovOleg Bartunov
    Apr 15, 2010 at 4:48 pm
    Apr 16, 2010 at 9:49 am
  • Initial patch. I will be testing over next day. No commit before at least midday on Wed 7 Apr. The existing call to PrescanPreparedTransactions() looks correct to me but the comment is wrong. I will ...
    Simon RiggsSimon Riggs
    Apr 6, 2010 at 9:25 am
    Apr 14, 2010 at 10:32 am
  • Hackers, I tried this: try=# create or replace function try() returns void language plperl as $$ spi_prepare('select length($1)', 'unknown'); $$; CREATE FUNCTION try=# select try(); ERROR: error from ...
    David E. WheelerDavid E. Wheeler
    Apr 6, 2010 at 11:18 pm
    Apr 7, 2010 at 12:28 am
  • The XXX comment is out-of-date, the latestRemovedXid value is calculated by btree_xlog_delete_get_latestRemovedXid() nowadays. If we're re-replaying the WAL record, for example after restarting the ...
    Heikki LinnakangasHeikki Linnakangas
    Apr 22, 2010 at 7:25 am
    Nov 9, 2010 at 12:12 pm
  • The order of events is as you say, though I don't see the problem. The new xids will be beyond xmax and would be filtered out even if we did scan the procs, so they will be treated as running, which ...
    Simon RiggsSimon Riggs
    Apr 19, 2010 at 8:06 am
    Apr 19, 2010 at 6:18 pm
  • I'm breaking this out to a separate email thread, since i think the original question may hvae been lost in the "I've applied this patch" part that made people ignore it at the end of a long thread ...
    Magnus HaganderMagnus Hagander
    Apr 13, 2010 at 12:13 pm
    Apr 15, 2010 at 11:02 am
  • I started to doubt this theory after wondering why the problem hadn't been exposed by CLOBBER_CACHE_ALWAYS testing, which is done routinely by the buildfarm. That setting would surely cause the cache ...
    Tom LaneTom Lane
    Apr 14, 2010 at 6:32 pm
    Apr 14, 2010 at 11:05 pm
  • * Environment: CentOS 5.2 on VirtualBox 3.0.6 of WindowsXP SP3 $ uname -a Linux localhost.localdomain 2.6.18-92.1.22.el5 #1 SMP Tue Dec 16 12:03:43 EST 2008 i686 i686 i386 GNU/Linux $ gcc -v Target: ...
    Hitoshi HaradaHitoshi Harada
    Apr 4, 2010 at 7:59 am
    Apr 6, 2010 at 1:15 am
  • Hi all, Please accept attached patch for the following problem. aftab@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ aftab@aftab-laptop:/opt/dev/pgsql/install/dbserver/bin$ ./psql postgres psql ...
    Aftab HussainAftab Hussain
    Apr 30, 2010 at 10:09 am
    May 16, 2010 at 1:49 pm
  • I've just realized that one of the confusing things about this debate is that the recovery_connections parameter is very confusingly named. It might have been okay when HS existed in isolation, but ...
    Tom LaneTom Lane
    Apr 29, 2010 at 5:19 pm
    Apr 29, 2010 at 6:33 pm
  • Hi, I have an application project based on a database. I am really interested in using PostgreSQL. I have only one issue, I want to use autonomous transactions to put in place a debug / logging ...
    Loïc VaumerelLoïc Vaumerel
    Apr 4, 2010 at 2:27 pm
    Apr 14, 2010 at 12:25 am
  • Hello Hackers: Two questions. 1. I would like to execute queries such as select * from part and time the query. But I want to ignore how much time is taken for printing the result to a file or the ...
    Murali M. KrishnaMurali M. Krishna
    Apr 26, 2010 at 6:39 pm
    Apr 26, 2010 at 11:41 pm
  • What exactly are we doing adding new features without discussion (or documentation, or known use cases) at this stage of the release cycle? regards, tom lane
    Tom LaneTom Lane
    Apr 23, 2010 at 10:56 pm
    Apr 24, 2010 at 5:14 pm
  • Hi, Does anyone know how to generate the following WAL records from psql? I'm now fixing pg_lesslog, which I reported a bug. Now code is almost okay and I'd like to add test tools to show pg_lesslog ...
    Koichi SuzukiKoichi Suzuki
    Apr 13, 2010 at 11:18 am
    Apr 19, 2010 at 12:29 am
  • I'd like to revive the discussion about offering another compression algorithm than zlib to at least pg_dump. There has been a previous discussion here: ...
    Joachim WielandJoachim Wieland
    Apr 8, 2010 at 11:17 pm
    Apr 15, 2010 at 1:16 am
  • Simple tuning of btree_xlog_vacuum() using an idea I had a while back, just never implemented. XXX comments removed. Allows us to avoid reading in blocks during VACUUM replay that are only required ...
    Simon RiggsSimon Riggs
    Apr 29, 2010 at 8:12 pm
    Dec 9, 2010 at 11:12 am
  • I've been working on a brute force method of saving view and function source when changes to an underlying object force that object to be dropped. But I think there is a way for Postgres to handle ...
    Scott BaileyScott Bailey
    Apr 30, 2010 at 7:33 am
    May 3, 2010 at 4:27 am
  • I asked on IRC if there was any way to make \d behave like \d+ by default, and davidfetter said no but suggest it here. endpoint_david pointed out you could use \d- to get the old behavior if you ...
    Terry BrownTerry Brown
    Apr 23, 2010 at 4:06 pm
    Apr 25, 2010 at 10:10 am
Group Navigation
period‹ prev | Apr 2010 | next ›
Group Overview
grouppgsql-hackers @

132 users for April 2010

Robert Haas: 270 posts Tom Lane: 243 posts Simon Riggs: 169 posts Heikki Linnakangas: 124 posts Bruce Momjian: 67 posts Fujii Masao: 63 posts Kevin Grittner: 54 posts Magnus Hagander: 42 posts Jaime Casanova: 37 posts Alvaro Herrera: 34 posts Josh Berkus: 31 posts Andrew Dunstan: 24 posts Takahiro Itagaki: 24 posts Greg Smith: 22 posts David E. Wheeler: 19 posts Dimitri Fontaine: 17 posts Erik Rijkers: 17 posts Peter Eisentraut: 16 posts Boszormenyi Zoltan: 12 posts Pavel Stehule: 11 posts
show more