FAQ

Search Discussions

125 discussions - 1,687 posts

  • I'd like to propose pgsql_fdw, FDW for external PostgreSQL server, as a contrib module. I think that this module would be the basis of further SQL/MED development for core, e.g. join-push-down and ...
    Shigeru HanadaShigeru Hanada
    Oct 25, 2011 at 9:11 am
    Apr 11, 2012 at 9:31 am
  • Hello I am sending a version with regress tests and basic documentation Regards Pavel Stehule
    Pavel StehulePavel Stehule
    Oct 6, 2011 at 11:52 am
    Aug 17, 2012 at 3:52 am
  • In researching pg_ctl -w/wait mode for pg_upgrade, I found that pg_ctl -w's handling of configuration-only directories is often incorrect. For example, 'pg_ctl -w stop' checks for the postmaster.pid ...
    Bruce MomjianBruce Momjian
    Oct 1, 2011 at 6:08 pm
    Oct 6, 2011 at 1:40 pm
  • Hey all, So, I'm dealing with a a big ol' java app that has multiple roads on the way to <IDLE in transaction. We can reproduce the problem in a test environment, but the lead dev always asks "can ...
    Scott MeadScott Mead
    Oct 31, 2011 at 9:37 pm
    Jan 20, 2012 at 11:24 am
  • Would y'all accept a patch that extended the "SELECT *" syntax to let you list fields to exclude from the A_Star? Quite regularly I'll be testing queries via psql and want to see all the columns from ...
    Eric RidgeEric Ridge
    Oct 29, 2011 at 10:26 pm
    Nov 2, 2011 at 2:49 pm
  • pg_upgrade doesn't work if the 'postgres' database has been dropped in the old cluster: ~/pgsql.master$ bin/pg_upgrade -b ~/pgsql.91stable/bin -B bin/ -d ~/pgsql.91stable/data -D data-upgraded/ ...
    Heikki LinnakangasHeikki Linnakangas
    Oct 4, 2011 at 4:11 pm
    Dec 6, 2011 at 1:55 pm
  • the complains special I also am running into this issue and can reproduce it very reliably. For me, however, it happens even when doing the "fast backup" like so: pg_start_backup('whatever', ...
    Chris RedekopChris Redekop
    Oct 16, 2011 at 1:39 am
    Nov 8, 2011 at 9:30 pm
  • Hi! There is updated version of patch. General list of changes since reviewed version: 1) Distinct slot is used for length histogram. 2) Standard statistics is collected for arrays. 3) Most common ...
    Alexander KorotkovAlexander Korotkov
    Oct 25, 2011 at 4:12 pm
    Mar 12, 2012 at 8:07 am
  • Laments at: http://wiki.postgresql.org/wiki/FAQ#Why_is_.22SELECT_count.28.2A.29_FROM_bigtable.3B.22_slow.3F http://wiki.postgresql.org/wiki/Slow_Counting I tried this on my MacBook Pro this morning, ...
    Robert HaasRobert Haas
    Oct 21, 2011 at 4:38 pm
    Oct 31, 2011 at 2:03 pm
  • I'm looking into upgrading a fairly busy system to 9.1. They use serializable mode for a few certain things, and suffer through some serialization errors as a result. While looking over the new ...
    Greg Sabino MullaneGreg Sabino Mullane
    Oct 10, 2011 at 6:55 pm
    Oct 13, 2011 at 4:22 pm
  • The first thing caught my eye in existing GiST code is idea of subtype_float. float8 has limited precision and can't respresent, for example, varlena values good enough. Even if we have large int8 ...
    Alexander KorotkovAlexander Korotkov
    Oct 7, 2011 at 8:54 am
    Mar 5, 2012 at 3:52 am
  • I talked to Robert Haas and he said that index-only scans do not optimize COUNT(*). Is this something we can do for PG 9.2? Is anyone working on this? -- Bruce Momjian <bruce@momjian.us ...
    Bruce MomjianBruce Momjian
    Oct 10, 2011 at 5:23 pm
    Dec 14, 2011 at 2:00 pm
  • I'm not sure if these can/should be fixed or not, but here are the compiler warnings I'm getting on gcc and clang on ubuntu 11.10 with -O2. The gcc ones are mostly new. ==================== GCC ...
    Jeff DavisJeff Davis
    Oct 18, 2011 at 8:08 am
    Oct 19, 2011 at 4:28 pm
  • Hi! *Waves* First off, it all seems to work as described: - regressions pass - domains work - tried various inherit options (merging constraints, alter table no inherit etc) - pg_dump/restore I ...
    Alex HunsakerAlex Hunsaker
    Oct 5, 2011 at 7:45 pm
    Jan 17, 2012 at 6:39 am
  • My understanding is that libpq does not allow one to find if a result set column is nullable. Is this right? (I know how to get a table column nullability information from pg_attribute.attnotnull, ...
    Alex GoncharovAlex Goncharov
    Oct 6, 2011 at 6:02 pm
    Oct 10, 2011 at 1:57 pm
  • Hi, Here's a patch to allow TOAST tables to be moved to a different tablespace. This item has been picked up from the TODO list. Main idea is to consider that a TOAST table can have its own ...
    Julien TachoiresJulien Tachoires
    Oct 7, 2011 at 3:10 pm
    Feb 10, 2012 at 7:28 pm
  • During the discussion of Alexey Klyukin's rewrite of ParseConfigFile, considerable unhappiness was expressed by various people about the complexity and relative uselessness of the ...
    Tom LaneTom Lane
    Oct 2, 2011 at 9:05 pm
    Oct 10, 2011 at 7:28 pm
  • 9.1 has been out for only a couple of months, and we've seen a lot of people trying to do that already. In hindsight, we probably should've chosen a different filename extension for those files, to ...
    Heikki LinnakangasHeikki Linnakangas
    Oct 12, 2011 at 8:39 am
    Oct 12, 2011 at 9:08 pm
  • Initial Review for patch: http://archives.postgresql.org/pgsql-hackers/2011-09/msg00744.php Submission review The patch is in context diff format and applies cleanly to the git master. The patch ...
    Royce AusburnRoyce Ausburn
    Oct 6, 2011 at 2:05 pm
    Nov 15, 2011 at 10:18 am
  • It occurs to me that we could really use two things to make it easier to move copies of database stuff around: pg_dump -r, which would include a CREATE ROLE for all roles needed to restore the ...
    Josh BerkusJosh Berkus
    Oct 11, 2011 at 12:53 am
    Oct 13, 2011 at 5:05 pm
  • All, I'm noticing some inconsistent and (I believe) undesirable behavior on RAISE INFO. If you call a function, and it posts progress reports using RAISE INFO, then you get the INFO statements plain ...
    Josh BerkusJosh Berkus
    Oct 14, 2011 at 5:00 pm
    Oct 15, 2011 at 9:02 pm
  • When walsender calls out to do_pg_stop_backup() (during base backups), it is not possible to terminate the process with a SIGTERM - it requires a SIGKILL. This can leave unkillable backends for ...
    Magnus HaganderMagnus Hagander
    Oct 5, 2011 at 1:30 pm
    Dec 9, 2011 at 12:31 pm
  • Hello all, While working on an application I have been developing for about two years now, I have come across a base-limitation in PostgreSQL for three separate problems. I was talking with other ...
    JoshJosh
    Oct 7, 2011 at 3:11 pm
    Oct 12, 2011 at 4:30 am
  • Hi, While the system is idle, we skip duplicate checkpoints for some reasons. But when wal_level is set to hot_standby, I found that checkpoints are wrongly duplicated even while the system is idle. ...
    Fujii MasaoFujii Masao
    Oct 5, 2011 at 5:19 am
    Oct 6, 2011 at 7:34 pm
  • This patch would appear(?) to have languished: https://commitfest.postgresql.org/action/patch_view?id=541 I'd really like to see it included. In the last comments of the review, there seem to be ...
    Daniel FarinaDaniel Farina
    Oct 1, 2011 at 1:25 am
    Dec 13, 2011 at 3:34 pm
  • Adding CORRESPONDING to Set Operations Initial patch, filename: corresponding_clause_v2.patch This patch adds CORRESPONDING clause to set operations according to SQL20nn standard draft as Feature ...
    Kerem KatKerem Kat
    Oct 19, 2011 at 1:01 pm
    Nov 17, 2011 at 8:55 am
  • Is it really necessary for GetSerializableTransactionSnapshotInt to acquire an empty SERIALIZABLEXACT before it acquires a snapshot? If so, why? The proposed synchronized-snapshots feature will mean ...
    Tom LaneTom Lane
    Oct 19, 2011 at 4:57 pm
    Oct 24, 2011 at 9:51 pm
  • The September commitfest has been drifting sideways for most of this month. I think it's about time to put it out of its misery, especially since the next one is due to start in barely more than 2 ...
    Tom LaneTom Lane
    Oct 28, 2011 at 7:51 pm
    Nov 14, 2011 at 6:57 pm
  • I've thought of another nasty problem for the sync-snapshots patch. Consider the following sequence of events: 1. Transaction A, which is about to export a snapshot, is running in database X. 2. ...
    Tom LaneTom Lane
    Oct 21, 2011 at 3:36 pm
    Oct 22, 2011 at 3:28 pm
  • Hi, An example in the PG documentation gives an error: http://www.postgresql.org/docs/9.1/interactive/plperl-global.html CREATE OR REPLACE FUNCTION myfuncs() RETURNS void AS $$ $_SHARED{myquote} = ...
    Amit KhandekarAmit Khandekar
    Oct 12, 2011 at 9:17 am
    Oct 14, 2011 at 3:28 am
  • Postgresql 9.0.4 has the timezone: America/Blanc-Sablon However other sources seem to spell this with an underscore instead of dash: America/Blanc_Sablon It appears that beside ...
    DavegDaveg
    Oct 5, 2011 at 4:54 am
    Oct 8, 2011 at 3:16 pm
  • Hi, In 9.2dev and 9.1, when walreceiver detects an error while sending data to WAL stream, it always emits ERROR even if there are data available in the receive buffer. This might lead to loss of ...
    Fujii MasaoFujii Masao
    Oct 12, 2011 at 9:45 am
    Nov 30, 2011 at 8:37 pm
  • We have a user interface which fetches and displays many small pieces of distinct information from a PostgreSQL database. * fetches are simple lookups across a diverse set of tables, in response to ...
    Mark HillsMark Hills
    Oct 31, 2011 at 3:44 pm
    Nov 6, 2011 at 7:21 pm
  • Hello A current limits of dynamic work with row types in PL/pgSQL can be decreased with a possible casts between rows and arrays. Now we have a lot of tools for arrays, and these tools should be used ...
    Pavel StehulePavel Stehule
    Oct 11, 2011 at 8:41 am
    Nov 5, 2011 at 1:57 pm
  • Hi, this idea has cropped up last PGCon - the ability to set GUC variables for the duration of a single query. It would work by setting the GUCs for the duration of the query and setting them back to ...
    Jan UrbańskiJan Urbański
    Oct 16, 2011 at 3:45 pm
    Oct 17, 2011 at 2:11 pm
  • So I'm testing a patch to make the planner use measured all-visible-page counts for index-only scans. I was expecting to possibly see some plan changes in the regression tests, but this diff scared ...
    Tom LaneTom Lane
    Oct 14, 2011 at 8:33 pm
    Aug 16, 2012 at 3:23 pm
  • Hackers, We've just found an issue with pg_dumpall in 9.1.1 where a dump starts with lines like these: ALTER ROLE dude WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN PASSWORD ...
    David E. WheelerDavid E. Wheeler
    Oct 19, 2011 at 8:33 pm
    Nov 10, 2011 at 3:12 am
  • I believe I have reproduced the behavior described by Andrew Hammond in http://archives.postgresql.org/pgsql-general/2011-10/msg00928.php This is using the regression database: 1. In session 1, do ...
    Tom LaneTom Lane
    Oct 26, 2011 at 1:06 am
    Nov 4, 2011 at 5:30 pm
  • Hi, In 9.1, the following procedure writes a junk message into the server log; $ initdb -D data $ cat << EOF data/postgresql.conf wal_level = hot_standby max_wal_senders = 1 synchronous_standby_names ...
    Fujii MasaoFujii Masao
    Oct 17, 2011 at 10:53 am
    Oct 24, 2011 at 5:23 pm
  • On master, I see a minor test error (at least on my machine) as well as a diff. Patch attached. Regards, Jeff Davis
    Jeff DavisJeff Davis
    Oct 16, 2011 at 5:51 pm
    Oct 19, 2011 at 5:17 pm
  • Jan UrbańskiJan Urbański
    Oct 15, 2011 at 11:29 pm
    Dec 10, 2011 at 5:23 pm
  • tldr: Seems to be broken by http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=4da99ea4231e3d8bbf28b666748c1028e7b7d665 : commit 4da99ea4231e3d8bbf28b666748c1028e7b7d665 Author: Robert ...
    Alex HunsakerAlex Hunsaker
    Oct 5, 2011 at 9:54 pm
    Oct 10, 2011 at 3:48 am
  • Hello, I am a program manager with the Ecosystem Engineering team at Microsoft. At //BUILD/<http://www.buildwindows.com/ in September, Microsoft announced the availability of the Windows 8 Developer ...
    Seiko Ishida (MP Tech Consulting LLC)Seiko Ishida (MP Tech Consulting LLC)
    Oct 4, 2011 at 7:46 pm
    Oct 5, 2011 at 7:33 pm
  • While investigating a client problem I just observed that pg_dump takes a surprisingly large amount of time to dump a schema with a large number of views. The client's hardware is quite spiffy, and ...
    Andrew DunstanAndrew Dunstan
    Oct 1, 2011 at 9:08 pm
    Oct 3, 2011 at 4:02 pm
  • I just noticed that HeapTupleHeaderAdvanceLatestRemovedXid is comparing Xmax as a TransactionId without verifying whether it is a multixact or not. Since they advance separately, this could lead to ...
    Alvaro HerreraAlvaro Herrera
    Oct 17, 2011 at 6:42 pm
    Aug 16, 2012 at 4:03 pm
  • All, Was just wondering if we might want to include the default socket directory that was compiled in as part of the pg_config output..? Thanks, Stephen
    Stephen FrostStephen Frost
    Oct 28, 2011 at 2:23 am
    Oct 31, 2011 at 7:34 am
  • Hello, I have tried 9.1.1 win64 version and when I am trying to declare a cursor for a very large view (lot of joins and aggregate functions), postgres is using around 3GB of memory and the query ...
    Omar BettinOmar Bettin
    Oct 24, 2011 at 9:17 am
    Oct 24, 2011 at 5:10 pm
  • Hi, I found that by default WAL_DEBUG macro has been defined in 9.2dev and 9.1. I'm very surprised at this. Why does WAL_DEBUG need to be defined by default? The performance overhead introduced by ...
    Fujii MasaoFujii Masao
    Oct 7, 2011 at 9:19 am
    Oct 8, 2011 at 6:05 am
  • Hi All, I have not been able to reproduce this error, but wanted to report this in case it might be useful. Commit -id: 0f39d5050dc0dce99258381f33f1832c437aff85 Configure options: ...
    Gurjeet SinghGurjeet Singh
    Oct 24, 2011 at 4:56 pm
    Aug 16, 2012 at 10:44 pm
  • So, I think the critical question for this patch is "do we want this?". Tom didn't like it, and I have to admit I'm somewhat demoralized by the discovery that we can't make effective use of this in ...
    Robert HaasRobert Haas
    Oct 12, 2011 at 6:49 pm
    Nov 9, 2011 at 12:40 pm
Group Navigation
period‹ prev | Oct 2011 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions125
posts1,687
users132
websitepostgresql.org...
irc#postgresql

132 users for October 2011

Tom Lane: 276 posts Robert Haas: 232 posts Bruce Momjian: 116 posts Simon Riggs: 76 posts Kevin Grittner: 64 posts Florian Pflug: 59 posts Fujii Masao: 50 posts Magnus Hagander: 45 posts Heikki Linnakangas: 44 posts Andrew Dunstan: 37 posts Alvaro Herrera: 32 posts Kohei KaiGai: 32 posts Pavel Stehule: 31 posts Jeff Davis: 30 posts Dimitri Fontaine: 24 posts Josh Berkus: 23 posts Peter Eisentraut: 23 posts Alex Hunsaker: 20 posts Thom Brown: 20 posts Alexander Korotkov: 17 posts
show more
Archives