FAQ

Search Discussions

168 discussions - 801 posts

  • Hello, Since Amazon has added new high I/O instance types and EBS volumes, anyone has done some benchmark of PostgreSQL on them ? ...
    Sébastien LorionSébastien Lorion
    Aug 21, 2012 at 5:34 am
    Sep 16, 2012 at 3:30 pm
  • Hello, Apologies if this question has been asked before, but I couldn't come up with a decent solution... Can anyone advice about a tool to visualize a database schema? Ideally, I would like ...
    Dario BeraldiDario Beraldi
    Aug 14, 2012 at 8:54 am
    Aug 20, 2012 at 8:05 am
  • Hello, I run CentOS 6.3 server with 16 GB RAM and: postgresql-8.4.12-1.el6_2.x86_64 pgbouncer-1.3.4-1.rhel6.x86_64 The modified params in postgresql.conf are: max_connections = 100 shared_buffers = ...
    Alexander FarberAlexander Farber
    Aug 30, 2012 at 11:42 am
    Oct 1, 2012 at 12:39 am
  • Hi, I'm playing around with 9.2 beta4 and was looking into the new Index Only Scan feature. I was a bit surprised that a "count(*)" query does not use an index. Not even a count(col) where col is the ...
    Thomas KellererThomas Kellerer
    Aug 26, 2012 at 9:04 am
    Aug 28, 2012 at 2:55 pm
  • I'd like to import this data into a Postgres database: http://www.ars.usda.gov/SP2UserFiles/Place/12354500/Data/SR24/dnload/sr24.zip However, I'm not quite sure what format this is. It's definitely ...
    Mike ChristensenMike Christensen
    Aug 23, 2012 at 12:23 am
    Aug 23, 2012 at 6:23 am
  • Hi: I notice when I save a view, I lose all the formatting and comments. As I was writing a complicated view, wanting to retain the format and comments, I thought I could just save it as a function ...
    Adam MacklerAdam Mackler
    Aug 17, 2012 at 9:36 pm
    Aug 29, 2012 at 7:22 pm
  • Hi all, I'm valutating a complex porting of our application based on Sybase SqlAnywhere on PostgreSQL (I've love it ...) and I'd like to have your opinion about searching/ordering funcionality. The ...
    Nicola CisterninoNicola Cisternino
    Aug 28, 2012 at 2:46 pm
    Aug 30, 2012 at 3:10 pm
  • I have a table with 40 million rows and haven't had any performance issues yet. Are there any rules of thumb as to when a table starts getting too big? For example, maybe if the index size is 6x the ...
    NickNick
    Aug 22, 2012 at 11:19 pm
    Aug 24, 2012 at 2:48 am
  • Here's the problem.... I have a table with a column called "last_name". I have one customer who likes to articulate queries and updates for this using column name "last_name" (no problem there) but ...
    Gauthier, DaveGauthier, Dave
    Aug 22, 2012 at 10:19 pm
    Aug 24, 2012 at 2:12 am
  • Hi, I am using PostgreSQL 9.1 and loading very large tables ( 13 million rows each ). The flat file size is only 25M. However, the equivalent database table is 548MB. This is without any indexes ...
    ElliottElliott
    Aug 20, 2012 at 5:54 pm
    Aug 22, 2012 at 11:31 pm
  • What is the difference between C and en_US.UTF8, please? We see that the same query (that invokes a sort) runs 15% faster under the C locale. The output between C and en_US.UTF8 is identical. We're ...
    Aleksey TsalolikhinAleksey Tsalolikhin
    Aug 29, 2012 at 5:32 pm
    Sep 21, 2012 at 9:26 pm
  • Hello from Berlin, I can't quite make sense of this (running PG 9.0.3): psql (9.0.3) Type "help" for help. FAKDB=# Select _rowid,f_firmen_isKunde(firmen),bezeichnung::text from firmen where ...
    Maximilian TyrtaniaMaximilian Tyrtania
    Aug 27, 2012 at 8:55 am
    Aug 27, 2012 at 3:09 pm
  • Hello. I've just discovered a very strange thing: SELECT '1 mon'::interval = '30 days'::interval -- TRUE??? This returns TRUE (also affected when I create an unique index using an interval column) ...
    Dmitry KoterovDmitry Koterov
    Aug 7, 2012 at 12:43 pm
    Aug 24, 2012 at 11:46 am
  • Hi; I have been reading up on object-relational features of Oracle and DB2 and found that one of the big things they have that we don't is a path operator. The idea is that you can use the path ...
    Chris TraversChris Travers
    Aug 20, 2012 at 1:29 am
    Aug 23, 2012 at 7:20 pm
  • Good Day, I'm trying to figure out why a postgresql query doesn't return what I'd expect with a query like this where there are NULL values: select * from users where is_enabled< 'Y'; I'm expecting ...
    Michael SacketMichael Sacket
    Aug 22, 2012 at 1:23 pm
    Aug 23, 2012 at 2:49 pm
  • I vaguely remember reading in the release notes (around the time 9.x was released) something about it automatically clearing out the postmaster.pid file if it was found to be stale/invalid when ...
    Sebastien BoisvertSebastien Boisvert
    Aug 20, 2012 at 4:52 pm
    Aug 26, 2012 at 5:51 pm
  • Hello, can some tell me, how I can analyze from where my server bring up load average ? I have one server with 128 GB memory, 32 CPU x86_64, RAID5 - 3 15k SAS HDD ext4 fs. That is my produce server, ...
    CondorCondor
    Aug 6, 2012 at 2:23 pm
    Aug 17, 2012 at 7:11 am
  • Dear Postgre Community, I would like to know if is possible to add metadata to Schemas. I have shemas with raster layers and I would like to add to them matadata. Is possbile in Postgre? If not how ...
    José Pedro SantosJosé Pedro Santos
    Aug 14, 2012 at 9:15 am
    Aug 14, 2012 at 2:54 pm
  • I have a skeleton table tb_audit_event that has a bunch of descendant tables. I want to remove the pk column from this table and all of the descendant tables, however issuing an ALTER TABLE ...
    Moshe JacobsonMoshe Jacobson
    Aug 28, 2012 at 8:27 pm
    Aug 30, 2012 at 12:33 pm
  • I have now been working with table inheritance for a while and after starting to grapple with many of the use cases it has have become increasingly impressed with this feature. I also think that some ...
    Chris TraversChris Travers
    Aug 23, 2012 at 3:22 am
    Aug 26, 2012 at 10:33 pm
  • Hello all, I have a weird situation I am trying to work through, and could use some help if anyone can provide some. I have a table with a column to store timestamp with time zone, and when I store ...
    Michael ClarkMichael Clark
    Aug 21, 2012 at 9:29 pm
    Aug 23, 2012 at 7:42 pm
  • Dear mailing list. My current application make use of partitioning by creating a new child table which holds transaction records for every month. I've notice that after a couple of months depending ...
    Bartel ViljoenBartel Viljoen
    Aug 18, 2012 at 8:07 am
    Aug 19, 2012 at 6:05 am
  • Hi all, great feature, but i can't find a TIMERANGE, i want to store time-ranges, for instance [10:00:00,16:00:00), how can i do that? Regards, Andreas
    Andreas KretschmerAndreas Kretschmer
    Aug 3, 2012 at 3:12 pm
    Aug 6, 2012 at 7:30 pm
  • There's another ongoing thread about range types, which was great because I wasn't familiar with the feature (guess it's new in 9.2?). I run a recipe website and was looking for *exactly* this sort ...
    Mike ChristensenMike Christensen
    Aug 3, 2012 at 8:00 pm
    Aug 3, 2012 at 11:44 pm
  • Dear all, I am designing an electronic health record repository which uses postgresql as its RDMS technology. For those who may find the topic interesting, the EHR standard I specialize in is ...
    Seref ArikanSeref Arikan
    Aug 21, 2012 at 8:45 am
    Sep 5, 2012 at 7:23 am
  • Is there a method for having unix env variables incorporated into a psql sql statement? Ie Export var='dev' Psql =c 'select count(*) from $var.customer;' Doug Little Sr. Data Warehouse Architect | ...
    Little, DouglasLittle, Douglas
    Aug 29, 2012 at 5:35 pm
    Aug 31, 2012 at 1:37 am
  • I have a question regarding the return value of PQfformat() I have a 'data' column in my table, type bytea (postgresql 9.1.5). In postgresql.conf: bytea_output = 'escape' When I execute the query ...
    Jason ArmstrongJason Armstrong
    Aug 29, 2012 at 12:30 pm
    Aug 30, 2012 at 11:39 am
  • Hi, pg_dump -s should use add_geometrycolumn(...) instead of creating a column+constraints with normal DDL Because, when you don't dump the data, then the record in geometry_columns is lost. Cheers, ...
    Willy-Bas LoosWilly-Bas Loos
    Aug 29, 2012 at 2:44 pm
    Aug 30, 2012 at 8:52 am
  • Sometimes the server process crashes and restarts, usually when I run some large calculations that eat up all available memory. Is there any way to detect this and run a cleanup routine when it ...
    John D. WestJohn D. West
    Aug 24, 2012 at 4:46 pm
    Aug 26, 2012 at 3:19 pm
  • I'd like to delete all the image files from a table by issuing an interactive psql command. Given CREATE TABLE image ( name text, rast oid ); with most tuples having images in rast, wanna do ...
    Neanderthelle JonesNeanderthelle Jones
    Aug 12, 2012 at 10:17 am
    Aug 13, 2012 at 12:52 am
  • I’m looking for a way to raise error from sql select if some condition is met. Tried code below to got error shown in comment. How to fix ? Andrus CREATE OR REPLACE FUNCTION "exec"(text) RETURNS text ...
    AndrusAndrus
    Aug 11, 2012 at 7:07 pm
    Aug 12, 2012 at 12:53 pm
  • Hi all, I'm seeing some weired errors in the postgres logs after upgrading to postgres-9.1(.3) about the schema added by default to search patch WARNING: invalid value for parameter "search_path" ...
    SambaSamba
    Aug 7, 2012 at 10:55 am
    Aug 8, 2012 at 1:55 pm
  • Hi folks, I did a test with transactions and wondered about an behavior I didn't expected. At http://pastebin.geany.org/bYQNo/raw/ I posted a complete backlog for. To make it short: I created a table ...
    Frank LanitzFrank Lanitz
    Aug 2, 2012 at 3:09 pm
    Aug 3, 2012 at 8:08 pm
  • Hi All, We are currently running PostgreSQL 8.4 on Windows server 2003 and are planning to move the instance to Ubuntu 10.4 - yay!. At the same time we will also upgrade to 9.1. One nice features ...
    Jeremy PalmerJeremy Palmer
    Aug 23, 2012 at 7:13 pm
    Aug 25, 2012 at 9:34 am
  • Hi all I've noticed that FETCH doesn't seem to be supported in subqueries or in CTEs. Is there a specific reason for that, beyond "nobody's needed it and implemented it"? I'm not complaining at all, ...
    Craig RingerCraig Ringer
    Aug 24, 2012 at 1:35 am
    Aug 25, 2012 at 8:41 am
  • As I understand it, I am allowed to redistribute Postgres so long as I include the copyright notice plus paragraphs as detailed on http://www.postgresql.org/about/licence/. What I want to confirm is ...
    Andrew HastieAndrew Hastie
    Aug 15, 2012 at 10:45 am
    Aug 16, 2012 at 3:07 pm
  • Apologies for the awkward title. I haven't quite thought of the right way to describe my problem, which may be why I've had a hard time figuring out how to solve it. I have a list of program ...
    Carey TildenCarey Tilden
    Aug 14, 2012 at 12:28 am
    Aug 14, 2012 at 3:59 am
  • Hello guys, We are running Postgres 8.3 on our production servers on Amazon EC2. We have a reoccurring problem of slowness initially in every 2 months, after enabling autovacuum every 6 months what ...
    Laszlo FogasLaszlo Fogas
    Aug 10, 2012 at 11:53 am
    Aug 11, 2012 at 7:33 am
  • I have a database that only receives updates maybe a few times a week. It is the storage for some web content where the content is not changed very often. I set archive_timeout to 5 minutes, because ...
    Jeff JanesJeff Janes
    Aug 16, 2012 at 3:58 pm
    Sep 18, 2012 at 9:31 pm
  • I would like to use an UPDATE RULE to modify the action performed when any UPDATE is attempted on a certain table, *including* an UPDATE which would fail because of no rows matching the WHERE. Is ...
    John LumbyJohn Lumby
    Aug 30, 2012 at 1:01 pm
    Sep 6, 2012 at 12:56 pm
  • Hi All, I want to write a MS-DOS command to check that the PostgreSQL database is up and running and able to accept data being pushed to it. From a bit of reading I've identified the pg_ctl status ...
    Loughrey, HughLoughrey, Hugh
    Aug 15, 2012 at 9:52 am
    Aug 23, 2012 at 1:51 pm
  • Hey folks, a question. We have a table that's getting large (6 million rows right now, but hey, no end in sight). It's wide-ish, too, 98 columns. The problem is that each of these columns needs to be ...
    Wells OliverWells Oliver
    Aug 16, 2012 at 8:54 pm
    Aug 23, 2012 at 7:09 am
  • Hello Guys, I am having a scenario close to the one below, I have defined a function which depends on a view. I am able to drop the view, but my server did not complain about the dependency. In the ...
    Salah jubehSalah jubeh
    Aug 20, 2012 at 12:14 pm
    Aug 20, 2012 at 3:12 pm
  • Hi All, I’ve just made a clean install for PostgreSQL 9.1 (postgresql-server-9.1.4, postgresql-contrib-9.1.4) on a FreeBSD 9 (FreeBSD 9.0-RELEASE-p3 FreeBSD 9.0-RELEASE-p3 #0: Tue Jun 12 02:52:29 UTC ...
    Carl von ClausewitzCarl von Clausewitz
    Aug 15, 2012 at 7:57 am
    Aug 15, 2012 at 7:19 pm
  • Hi I have two (hopefully) equivalent - and unfortunately very slow - queries which "Select all buildings that have 1 pharmacies and 1 schools within 1000m". In the first query there is an expression ...
    Stefan KellerStefan Keller
    Aug 9, 2012 at 11:32 am
    Aug 13, 2012 at 6:50 am
  • First off, I've posted this question on StackOverflow in case anyone wants to answer it ...
    Mike ChristensenMike Christensen
    Aug 5, 2012 at 5:14 am
    Aug 6, 2012 at 2:57 am
  • Hello, I have a problem with functional index feature in Postgres 8.3 There are two tables, lets call them: PARENTS and CHILDREN(with timestamp column) I created functional index on parents with ...
    Grzegorz TańczykGrzegorz Tańczyk
    Aug 29, 2012 at 9:02 pm
    Oct 8, 2012 at 10:06 pm
  • Is there a simple way to grant SELECT privileges to a user for all the tables in a database, without having to do it for each table? Thanks, Steve -- Stephen Crawford Center for Environmental ...
    Stephen CrawfordStephen Crawford
    Aug 27, 2012 at 5:09 pm
    Sep 2, 2012 at 8:01 am
  • Hi I need help in turning off autovacuum in the Database that’s running postgres 9.1.2 DB. I tried to turn it off by putting “off” in postgresql.cont file and restarted the postmaster but when I run ...
    Khangelani GamaKhangelani Gama
    Aug 30, 2012 at 10:52 am
    Aug 30, 2012 at 1:27 pm
  • Hello , Could you please tell me some one ,how to do connection PGBouncer using Perl DBI module ? Thanks Prashant
    Prashant BharuchaPrashant Bharucha
    Aug 27, 2012 at 1:51 am
    Aug 28, 2012 at 4:51 pm
Group Navigation
period‹ prev | Aug 2012 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions168
posts801
users223
websitepostgresql.org
irc#postgresql

223 users for August 2012

Craig Ringer: 62 posts Tom Lane: 36 posts Merlin Moncure: 33 posts David Johnston: 27 posts John R Pierce: 24 posts Chris Travers: 19 posts Albe Laurenz: 14 posts Chris Angelico: 13 posts Kevin Grittner: 13 posts Mike Christensen: 12 posts Pavel Stehule: 12 posts Scott Marlowe: 12 posts Bruce Momjian: 11 posts Condor: 10 posts Dmitriy Igrishin: 10 posts Jeff Janes: 10 posts Thomas Kellerer: 10 posts Sébastien Lorion: 9 posts Frank Lanitz: 8 posts Moshe Jacobson: 8 posts
show more
Archives