Search Discussions

222 discussions - 1,225 posts

  • Folks, Please help us resolve a discussion on -hackers. PostgreSQL 9.1 is likely to have, as a feature, the ability to create tables which are "unlogged", meaning that they are not added to the ...
    Josh BerkusJosh Berkus
    Nov 16, 2010 at 10:46 pm
    Nov 20, 2010 at 7:36 pm
  • There was an interesting post today on highscalability - http://highscalability.com/blog/2010/11/4/facebook-at-13-million-queries-per-second-recommends-minimiz.html The discussion/comments touched ...
    Sandeep SrinivasaSandeep Srinivasa
    Nov 9, 2010 at 4:31 am
    Nov 16, 2010 at 2:35 am
  • Hi everyone, This is my first post on the mailing list :) As of today I have started the first dedicated postgres forum at: http://forums.postgresql.com.au I would much appreciate anyone that has the ...
    Elliot ChanceElliot Chance
    Nov 13, 2010 at 3:43 am
    Nov 22, 2010 at 11:54 am
  • Hi again, I've taken in all the feedback about http://forums.postgresql.com.au and the general consensus is that nobody wants a separate entity - a few people mentioned that if it was interoperable ...
    Elliot ChanceElliot Chance
    Nov 15, 2010 at 8:34 am
    Dec 31, 2010 at 1:24 am
  • Greeting PostgreSQL Gurus. From my goggling I know this has been discussed before and from what I have read it seems that the consensus is you can re-compile postgres and increase the block size from ...
    Mark MitchellMark Mitchell
    Nov 12, 2010 at 5:20 am
    Nov 13, 2010 at 3:50 am
  • Hi, I've set up 8.3 to use SSPI for authentication (clients and server on windows XP). I can successfully connect from clients using psql and another db client using SSPI authentication. However when ...
    Reto SchöningReto Schöning
    Nov 22, 2010 at 9:21 am
    Jan 23, 2012 at 3:06 pm
  • I did an upgrade on my database server this past weekend and the database fails to start. I checked /var/log/postgresql and found the reason: [root@slave ~]# ps aux | grep postgres root 5189 0.0 0.0 ...
    Carlos MennensCarlos Mennens
    Nov 1, 2010 at 4:36 pm
    Nov 2, 2010 at 11:04 pm
  • You are registered in the forum already (it does this automatically), you simply reply on the mailing list as you have always done. If you feel the sudden urge to only reply via the forum then simply ...
    Elliot ChanceElliot Chance
    Nov 20, 2010 at 1:04 pm
    Nov 22, 2010 at 6:33 am
  • Hello, is there a syntax to add a column not at the last place, but somewhere inbetween or do I have to dump/restore the table? For example if I'd like to add last_logout right after last_login: \d ...
    Alexander FarberAlexander Farber
    Nov 24, 2010 at 7:42 am
    Nov 30, 2010 at 10:26 am
  • 21


    I know that this is probably a "religion" issue but we are looking to move Postgres to a Linux server. We currently have a Windows 2008 R2 active directory and all of the other servers are ...
    Michael GouldMichael Gould
    Nov 4, 2010 at 3:01 pm
    Nov 5, 2010 at 9:05 pm
  • Hi I have a problem with libpq on windows. Connecting to a db and running a "select * from some_table;" is very slow. The table has only 1800 rows, 7 columns. No blobs etc. The query is taking around ...
    Rob Brown-BaylissRob Brown-Bayliss
    Nov 6, 2010 at 11:54 pm
    Nov 10, 2010 at 7:38 am
  • Hi Everyone, I'm looking for the best solution for "Hot Standbys" where once the primary server fails, the standby will take over and act just like the master did. The standby must support INSERTS ...
    Jonathan TripathyJonathan Tripathy
    Nov 1, 2010 at 7:53 pm
    Nov 4, 2010 at 12:07 am
  • Hi Everyone, I'm trying to create a server for a database system which will be used by multiple clients. Of course, table locking is very important. Reading the Postgresql docs, locking occurs on a ...
    Jonathan TripathyJonathan Tripathy
    Nov 1, 2010 at 5:50 pm
    Nov 2, 2010 at 11:28 pm
  • I tried in Debian ("PostgreSQL 9.0.1 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit") : 1. CREATE DATABASE "mydb" WITH TEMPLATE=template0 ...
    Nov 30, 2010 at 5:13 pm
    Dec 2, 2010 at 10:45 pm
  • I currently have Postgres 9.0 install after an upgrade. My database is relatively small, but complex. The dump is about 90MB. Every night when there is no activity I do a full vacuum, a reindex, and ...
    Jason LongJason Long
    Nov 8, 2010 at 6:59 pm
    Feb 28, 2011 at 8:35 pm
  • hi, got (another time, it's not the first thing) this situation: 1. server: 64gb of ram, 24 cores of xeon processors (hyperthreading is off), storage is fusion io. 2. at one point load skyrocketed to ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Nov 29, 2010 at 5:18 pm
    Nov 30, 2010 at 1:24 pm
  • A while back, I thought I remembered seeing a Mac OS X client for PostgreSQL which had a feature where it would display a graphic schema of whatever database you connect to but I can't seem to find ...
    Aram FingalAram Fingal
    Nov 11, 2010 at 5:01 pm
    Nov 15, 2010 at 7:31 pm
  • Hi - I'm trying to find where I can download PostgreSQL 8.2.3. I've looked on the PostgreSQL website but I do not see version 8.2.3 specifically. Any help would be appreciated. Thanks, Jason -- View ...
    Nov 10, 2010 at 4:47 pm
    Nov 11, 2010 at 2:16 am
  • Hi there I need to add periodically some data from a remote mysql database into our postgresql database. So, does anyone know how to do it having in mind that it must be runned every minute or so for ...
    Nov 14, 2010 at 1:01 pm
    Nov 17, 2010 at 9:03 pm
  • Hello, I'm getting an error message in my Python script: pg.ProgrammingError: ERROR: out of memory DETAIL: Failed on request of size 16. The query that caused the error was: UPDATE table1 SET string ...
    Jorge ArévaloJorge Arévalo
    Nov 16, 2010 at 10:04 pm
    Nov 17, 2010 at 12:18 am
  • Hi, we have several instances of following error in server log: 2010-11-08 18:44:18 CET 5177 1 @ ERROR: out of memory 2010-11-08 18:44:18 CET 5177 2 @ DETAIL: Failed on request of size 16384. It's ...
    Jakub OuhrabkaJakub Ouhrabka
    Nov 8, 2010 at 6:44 pm
    Nov 8, 2010 at 8:51 pm
  • Hi have strange situation - too many xlog files. PostgreSQL 8.3.11 on i386-pc-solaris2.10, compiled by cc -Xa config: # select name, setting from pg_settings where name ~ 'checkpoint|wal' order by 1; ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Nov 1, 2010 at 5:54 pm
    Nov 1, 2010 at 8:06 pm
  • Hi all - I am trying to create an index on character varying field. The column is just character varying with no limit. I am getting the following error " index row requires 10040 bytes, maximum size ...
    Akp geekAkp geek
    Nov 12, 2010 at 8:47 pm
    Sep 19, 2011 at 6:28 am
  • I am running ubuntu 10.04 I have problem installing postgresql-8.4 when i tried to start postgresql /etc/init.d/postgresql-8.4 start I am getting this error * Starting PostgreSQL 8.4 database server ...
    Mohammed RashadMohammed Rashad
    Nov 29, 2010 at 3:02 pm
    Nov 29, 2010 at 4:01 pm
  • Hi everyone, I've just noticed a strange behaviour when estimating row counts (I'm running 9.0.1). A small demonstration - let's create table with two columns, and fill it with data so that the ...
    Tomas VondraTomas Vondra
    Nov 17, 2010 at 1:27 am
    Dec 12, 2010 at 8:19 pm
  • Hello, I'm trying to program a PHP-script, where users can rate the "goodness" of the other players: create table pref_rep ( id varchar(32) references pref_users(id) check (id < author), author ...
    Alexander FarberAlexander Farber
    Nov 20, 2010 at 1:31 pm
    Nov 30, 2010 at 6:33 pm
  • Hi list, i cannot restore my data from 8.2 to 8.4 because i always get this error message, does anyone know what to do?? hasta luego Andreas -- Dipl. Geoökologe Andreas Laggner Institut für ...
    Andreas LaggnerAndreas Laggner
    Nov 19, 2010 at 4:12 pm
    Nov 20, 2010 at 3:03 am
  • Hello, if I have this table with 3 boolean columns: # \d pref_rate Table "public.pref_rep" Column | Type | Modifiers ------------+-----------------------------+--------------- id | character ...
    Alexander FarberAlexander Farber
    Nov 16, 2010 at 4:23 pm
    Nov 17, 2010 at 8:39 pm
  • Hi, I need to update various tables in the same update. It is possible to do it? Best Regards,
    Andre LopesAndre Lopes
    Nov 7, 2010 at 2:59 pm
    Nov 9, 2010 at 12:56 am
  • Hello, Does calling a pl/python function from each database connection load the python interpreter each time? what are the effects of using pl/python function in a environment where no. of concurrent ...
    C kC k
    Nov 23, 2010 at 4:44 pm
    Jan 21, 2011 at 12:15 am
  • Hi, As part of datamining activity. I have some plpgsql functions (executed in parallel, up to 6 such concurrent calls) that perform some reads and writes of large number of (maybe 10000) records at ...
    Allan KamauAllan Kamau
    Nov 11, 2010 at 6:42 am
    Nov 15, 2010 at 8:20 pm
  • Hi all, I've collected some interesting results during my experiments which I couldn't figure out the reason behind them and need your assistance. I'm running PostgreSQL 9.0 on a quad-core machine ...
    Umut orhanUmut orhan
    Nov 8, 2010 at 3:34 pm
    Nov 9, 2010 at 1:38 pm
  • Hi everyone, When adding a new record, we run an insert query which auto-increments the primary key for the table. However the method (in java) which calls this query must return the newly created ...
    Jonathan TripathyJonathan Tripathy
    Nov 2, 2010 at 8:43 pm
    Nov 3, 2010 at 8:15 pm
  • Hi, I can't find pg_stat_activity in the the documentation. There are many pg_stat_xxx tables and views, but their columns are not described, or so it seems. Maybe that is a bug in the documentation, ...
    Willy-Bas LoosWilly-Bas Loos
    Nov 15, 2010 at 10:15 am
    Nov 18, 2010 at 3:07 pm
  • I am trying to write a postgres function and I'm getting errors when the parameter sub is empty (it wont ever be null) and meetCode has a number. This is the function code: create or replace function ...
    Christine PennerChristine Penner
    Nov 16, 2010 at 9:27 pm
    Nov 16, 2010 at 10:13 pm
  • Windows uses % as subnet mask delimiter. Trying to use it like create temp table test (test inet) on commit drop; insert into test values('fe80::f1ea:f3f4:fb48:7155%10') returns error ERROR: invalid ...
    Nov 11, 2010 at 6:34 pm
    Nov 16, 2010 at 8:39 pm
  • Hello, I'm having this table filled with data: \d pref_users; Table "public.pref_users" Column | Type | Modifiers ------------+-----------------------------+--------------- id | character varying(32) ...
    Alexander FarberAlexander Farber
    Nov 8, 2010 at 2:50 pm
    Nov 8, 2010 at 5:09 pm
  • Is it possible to create an index in descending order?
    AI RummanAI Rumman
    Nov 2, 2010 at 9:37 am
    Nov 2, 2010 at 3:23 pm
  • Hello, I have created a temporary table using create temporary table foo ( id integer ); and noticed this was created in a schema called "pg_temp_2" My question is: is this always "pg_temp_2"? Or ...
    Thomas KellererThomas Kellerer
    Nov 1, 2010 at 10:47 am
    Nov 1, 2010 at 10:29 pm
  • Hi, I want to access part of a table on the disk sequentially, i,e., when I get to a tuple in the table, I need to read several pages of data in the table starting from this tuple. I guess CTID could ...
    Zhipan WangZhipan Wang
    Nov 27, 2010 at 9:01 am
    Nov 29, 2010 at 5:03 pm
  • Hi, I'm curious why the following is not working: c:\psql postgres postgres psql (9.0.1) Type "help" for help. postgres=# select version(); version ...
    Thomas KellererThomas Kellerer
    Nov 22, 2010 at 6:18 pm
    Nov 22, 2010 at 7:56 pm
  • Hi, I am experiencing the "row is too big" error (with postgreSQL-9.0.1) when populating a table having a tsquery and tsvector fields. Are fields of tsquery and tsvector datatypes affected by this ...
    Allan KamauAllan Kamau
    Nov 18, 2010 at 4:37 am
    Nov 18, 2010 at 6:23 pm
  • Is it possible to modify source code in executor to keep a log of old tuples and new tuples after an UPDATE, INSERT or DELETE command is executed? (so basically Store Old Tuple Values - ...
    Nov 17, 2010 at 2:26 pm
    Nov 17, 2010 at 5:24 pm
  • I just downloaded 9.0 onto my laptop and desktop Windows XP machines. Nether one could run the stack builder. Windows would fault any time I tried to run it. I tried inputing the proxy server but ...
    Nov 11, 2010 at 2:24 am
    Nov 15, 2010 at 5:33 pm
  • Assume I have a local process which leaves a transaction open & idle for an extended period of time. Is there any way to identify the local process connected to a particular backend? pg_stat_activity ...
    Scott RibeScott Ribe
    Nov 15, 2010 at 3:34 pm
    Nov 15, 2010 at 4:41 pm
  • I am going to install Postgresql 9.0 for my running applicaiton which is at 8.1. My Db size is 3 GB. Server Specification: dual-core 4 cpu RAM: 32 GB OS: Centos What will be good settings for DB ...
    AI RummanAI Rumman
    Nov 11, 2010 at 7:59 am
    Nov 11, 2010 at 8:30 pm
  • Dear all, Imagine I have two users "Maria" and "Ana" using a PHP site. There is a common Postgres user "phpuser" for both. I'm creating audit tables to track the actions made by each PHP site user. ...
    Gabriel DinisGabriel Dinis
    Nov 3, 2010 at 12:32 pm
    Nov 4, 2010 at 3:35 pm
  • Hi, My name is Fernando, i work with C# and PostgreSQL. I need save a jpg in a PostgreSQL table. How do i this? I read in a forum to use this to save in database: INSERT INTO table (image) VALUES ...
    Nov 4, 2010 at 1:19 pm
    Feb 6, 2012 at 5:53 pm
  • Hello I use postgres 8.3.12 on machineA and 8.4.5 on machineB. On machineA I have created a tablespace with CREATE TABLESPACE tablelocation_name LOCATION '/my/location/machineA'; I then created a ...
    Vangelis KatsikarosVangelis Katsikaros
    Nov 19, 2010 at 11:59 am
    Jan 28, 2011 at 6:55 pm
  • I'm interested in playing with some of the features in the Alpha 2. Is there an ETA for the release for the one-click installer? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL ...
    Richard BroersmaRichard Broersma
    Nov 8, 2010 at 11:06 pm
    Dec 6, 2010 at 6:13 am
Group Navigation
period‹ prev | Nov 2010 | next ›
Group Overview
grouppgsql-general @

298 users for November 2010

Tom Lane: 88 posts Vivek Khera: 31 posts Scott Marlowe: 29 posts Dmitriy Igrishin: 27 posts John R Pierce: 27 posts Alexander Farber: 21 posts Elliot Chance: 21 posts Craig Ringer: 20 posts Jonathan Tripathy: 20 posts Magnus Hagander: 20 posts Thomas Kellerer: 18 posts Hubert depesz lubaczewski: 17 posts Andy Colson: 16 posts Pavel Stehule: 16 posts Adrian Klaver: 15 posts Raymond O'Donnell: 15 posts Thom Brown: 14 posts Alban Hertroys: 13 posts Marc Mamin: 13 posts Richard Broersma: 13 posts
show more