FAQ

Search Discussions

202 discussions - 1,080 posts

  • The speed benefits of SSDs as benchmarked would seem incredible. Can anybody comment on SSD benefits and problems in real life use? I maintain some 100 databases on 3 servers, with 32 GB of RAM each ...
    Benjamin SmithBenjamin Smith
    Apr 14, 2011 at 4:32 am
    Apr 30, 2011 at 4:58 am
  • A colleague of mine insists that using surrogate keys is the common practice by an overwhelming margin in relational databases and that they are used in 99 percent of large installations. I agree ...
    Jim IrrerJim Irrer
    Apr 28, 2011 at 5:30 pm
    May 4, 2011 at 8:48 pm
  • While doing a PG dump, I seem to have a problem: ERROR: invalid memory alloc request size 4294967293 Upon googling, this seems to be a data corruption issue! ( Came about while doing performance ...
    Phoenix KiulaPhoenix Kiula
    Apr 18, 2011 at 5:52 am
    Apr 26, 2011 at 6:40 pm
  • Hi there, We are evaluating using PostgreSQL to implement a multitenant database, Currently we are running some tests on single-database-multiple-schema model (basically, all tenants have the same ...
    ShianmiinShianmiin
    Apr 7, 2011 at 8:42 pm
    Apr 13, 2011 at 8:09 pm
  • I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in ...
    Dave PageDave Page
    Apr 27, 2011 at 7:53 pm
    Apr 30, 2011 at 7:56 pm
  • Hi. It is sometimes hard to tune complicated queries. Maybe add new attribute to functions returning boolean - selectivity, defining how big is percent of rows for which the function returns true. ...
    Pasman PasmańskiPasman Pasmański
    Apr 16, 2011 at 7:45 pm
    Apr 17, 2011 at 1:09 am
  • Thank goodness I'm still in development! I'm trying to use pg_restore with a dump created with pg_dump. But it keeps failing with segmentation or general protection faults. My restore command is: $ ...
    Chris CurveyChris Curvey
    Apr 5, 2011 at 3:19 am
    May 5, 2011 at 3:23 pm
  • Greets, I just noticed something odd: I'm busy with a manual vacuum on a table and an autovacuum keeps firing up as well. Thinking this looks rather weird, I pg_cancel_backend() the autovacuum ...
    Henry C.Henry C.
    Apr 2, 2011 at 11:25 am
    Apr 4, 2011 at 7:49 pm
  • hello pg fans, we have an application that communicates via ODBC directly to the postgres database. if i'm trying to add an additional column to a table in pgadmin while clients are logged in, ...
    Sven HaagSven Haag
    Apr 2, 2011 at 9:10 am
    Apr 4, 2011 at 7:43 pm
  • Suppose Postgres is installed in two computers C1 & C2. C1 have some database tables. How can I copy these database tables from C1 to C2. I mean to say that can I copy tables from postgres installed ...
    SUBHAM ROYSUBHAM ROY
    Apr 19, 2011 at 11:06 pm
    May 4, 2011 at 6:56 am
  • I have a table with the following schema: CREATE TABLE foo (bar VARCHAR(32)); Every bar value has a format like a float, e.g. "2.5". Now I want that value multiplied by two and saved again as ...
    Thomas Larsen WesselThomas Larsen Wessel
    Apr 28, 2011 at 9:26 am
    Apr 28, 2011 at 3:56 pm
  • Is there any effort to add compression into PG, a la MySQL's row_format=compressed or HBase's LZO block compression?
    Yang ZhangYang Zhang
    Apr 14, 2011 at 11:02 pm
    Oct 10, 2012 at 3:01 pm
  • We've been using a Wiki server at the office for years. It was originally configured to use MySQL and finally after 8+ years we're moving the Wiki to a new platform of hardware. My question is the ...
    Carlos MennensCarlos Mennens
    Apr 26, 2011 at 5:24 pm
    May 3, 2011 at 5:26 pm
  • Hi. The partitioning documentation in PG is very clear on how to partition a new table. Create child tables, and have triggers that manage INSERT, UPDATE and DELETE commands. How about doing this ...
    Phoenix KiulaPhoenix Kiula
    Apr 25, 2011 at 10:46 am
    Apr 30, 2011 at 7:47 pm
  • Hi all, only want to link this blog post http://blog.kimiensoftware.com/2011/04/top-10-missing-postgresql-features , i think he may have any good points. Miguel Angel.
    LinosLinos
    Apr 25, 2011 at 8:47 am
    Apr 26, 2011 at 3:06 pm
  • Hi This is probably going to turn out to be me doing something stupid, but- I have two computers, one of which I use as a remote server for my database. When I connect to the remote database through ...
    Bob PawleyBob Pawley
    Apr 20, 2011 at 6:12 pm
    Apr 22, 2011 at 9:12 pm
  • I've only been using PostgreSQL since Oct 2010 and it's my first experience with SQL or any ORDBMS. I've searched on the web and been creating my own database users, databases, tables from scratch ...
    Carlos MennensCarlos Mennens
    Apr 6, 2011 at 2:54 pm
    Apr 20, 2011 at 1:39 pm
  • Hi, I've been having repeated troubles trying to get a PostgreSQL app to play nicely on Ubuntu. I recently posted a message on this list about an out of memory error and got a resolution by reducing ...
    Jeremy PalmerJeremy Palmer
    Apr 5, 2011 at 9:51 am
    Apr 15, 2011 at 3:02 am
  • I receive a long string (about 1 per second) than content many information and for the moment it is directly inserted in the database (1 column). I have to treat the hole string every time i need ...
    Marc-André GoderreMarc-André Goderre
    Apr 4, 2011 at 3:54 pm
    Apr 5, 2011 at 6:27 pm
  • We are moving our databases to new hardware soon, so we felt it would be a good time to get the encoding correct. Our databases are currently SQL_ASCII and we plan to move them to UTF8. So, as ...
    Geoffrey MyersGeoffrey Myers
    Apr 22, 2011 at 2:59 pm
    May 3, 2011 at 6:18 pm
  • In PL/pgSQL, how does one generically access the fields of the OLD or NEW record? I've tried code such as this: 'NEW.' || quote_ident( myColumnNameVar ) || '::varchar' But when run by an "EXECUTE" ...
    Basil BourqueBasil Bourque
    Apr 28, 2011 at 7:47 pm
    May 4, 2012 at 1:12 pm
  • Hi, I am not sure if there ever was a feature request for using defined column aliases in the rest of a query. This would make queries with a lot of logic in those aliased columns a lot smaller and ...
    Robert J.C. IvensRobert J.C. Ivens
    Apr 17, 2011 at 11:11 am
    Apr 20, 2011 at 10:28 am
  • We want to protect the intellectual property of several of our stored procedures. If we put them in a separate schema in the database and only allow execute on anything in that schema would that ...
    Michael GouldMichael Gould
    Apr 7, 2011 at 1:32 pm
    Apr 7, 2011 at 5:46 pm
  • I have to add a number of years to a date field. The years come from another field in the table. I know I can do this: select (ii_purchased + interval '3 year') as date from inventory_item; But I ...
    Christine PennerChristine Penner
    Apr 6, 2011 at 4:02 pm
    Apr 6, 2011 at 10:26 pm
  • hi was pointed to the fact that security definer functions have the same default privileges as normal functions in the same language - i.e. if the language is trusted - public has the right to ...
    Hubert depesz lubaczewskiHubert depesz lubaczewski
    Apr 5, 2011 at 6:41 am
    Jun 15, 2011 at 2:08 am
  • I have a column of 2 million float values from 0 to 1. I would like to figure out how many values fit into buckets spaced by 0.10, e.g. from 0 to 0.10, from 0.10 to 0.20, etc. What is the best way to ...
    Joel ReymontJoel Reymont
    Apr 30, 2011 at 4:37 pm
    May 1, 2011 at 7:41 am
  • I have problem with GIN index. Queries over it takes a lot of time. Some informations: I've got a table with tsvector- textvector: CREATE TABLE mediawiki.pagecontent ( old_id integer NOT NULL DEFAULT ...
    MarkMark
    Apr 27, 2011 at 8:56 pm
    Apr 30, 2011 at 6:37 pm
  • I've done some testing of PostgreSQL on different filesystems, and with different filesystem mount options. I found that xfs and ext4 both performed similarly, with ext4 just a few percent faster; ...
    Toby CorkindaleToby Corkindale
    Apr 21, 2011 at 6:22 am
    Apr 27, 2011 at 5:49 am
  • ...is an amazing tool! merlin
    Merlin MoncureMerlin Moncure
    Apr 18, 2011 at 8:39 pm
    Apr 21, 2011 at 12:24 am
  • Greets, Pg 9.0.3 This must be due to my own misconfiguration, so apologies if I'm not seeing the obvious - I've noticed that my slave seems to be stuck in a permanent startup/recovery state. ps on ...
    Henry C.Henry C.
    Apr 13, 2011 at 6:22 pm
    Apr 15, 2011 at 10:17 pm
  • Dear List, Today morning at 01:00 AM in our PostgreSQL 9.0.3 server a routine maintenance script has started (vacuumdb --all --full --analyze), and stopped with this error: sqlstate=23505ERROR: ...
    Gipsz JakabGipsz Jakab
    Apr 14, 2011 at 11:56 am
    Apr 15, 2011 at 8:34 pm
  • Hi, Is there any limitations to configure streaming replication between different operating systems i.e solaris 64 bit to RHEL 64 bit. --Raghu Ram
    Raghu ramRaghu ram
    Apr 13, 2011 at 5:53 pm
    Apr 14, 2011 at 11:31 pm
  • I've searched and really can't find a definitive example or someone renaming a constraint. I renamed a table yesterday and noticed that the constraint name was still named the old table name: ...
    Carlos MennensCarlos Mennens
    Apr 9, 2011 at 12:23 am
    Apr 9, 2011 at 10:30 pm
  • Hi, this is maybe a stupid question, but I don't know how to explain to my coworkers why performing many inserts in autocommit mode is so much slower than making all of them in one transaction. Why ...
    Szymon GuzSzymon Guz
    Apr 7, 2011 at 9:00 pm
    Apr 8, 2011 at 2:57 pm
  • How do I prevent accidental non-SSL connections (at least to specific hosts) when connecting via psql? Is there any configuration for this? Thanks.
    Yang ZhangYang Zhang
    Apr 6, 2011 at 11:07 pm
    Apr 7, 2011 at 1:20 am
  • Hi, all. I'm looking for a way to lock on an arbitrary string, just how MySQL allows doing with GET_LOCK('foo.123') / RELEASE_LOCK('foo.123'). I know that at least Postgres 8.3 has pg_advisory_lock() ...
    RihadRihad
    Apr 5, 2011 at 9:42 am
    Apr 5, 2011 at 7:22 pm
  • Hey folks, So, I'm working on a little application to help me with my budget. Yeah, there are apps out there to do it, but I'm having a good time learning some more too. :) I get paid every other ...
    C. BensendC. Bensend
    Apr 5, 2011 at 12:13 am
    Apr 5, 2011 at 5:50 pm
  • Since we upgraded from postgres 8.0 to 8.4, every script where we have queries that use temp tables now has to have an explicit drop of the temp table at the end of the script, or it will blow up the ...
    Davenport, JulieDavenport, Julie
    Apr 6, 2011 at 2:11 pm
    Jun 13, 2011 at 3:39 pm
  • Hi, A database I'm handling is becoming a bit large'ish (~ 30 tables), and I'd like to break them down into their natural units. Schemas for each of these natural units seems logical, but are they ...
    SebSeb
    Apr 29, 2011 at 12:51 am
    Apr 29, 2011 at 4:40 pm
  • Hello, I have installed postgresql 9 on fedora 14 having python 2.7. Now created plpythonu language in my database and created a simple function to calculate sum of two variables. while importing ...
    C kC k
    Apr 28, 2011 at 11:19 am
    Apr 28, 2011 at 5:14 pm
  • Hello all, since (according to the docs) PostgreSQL does not propagate INSERTs from child tables unto parent tables the below does not work, unfortunately. What is the suggested approach for this ...
    Karsten HilbertKarsten Hilbert
    Apr 18, 2011 at 1:53 pm
    Apr 27, 2011 at 4:56 pm
  • HI, Which version of postgresql supports replication on RHEL6? RHEL version : 2.6.32-71.el6.x86_64 Regards, Tiru ::DISCLAIMER:: ...
    Tiruvenkatasamy BaskaranTiruvenkatasamy Baskaran
    Apr 21, 2011 at 10:57 am
    Apr 22, 2011 at 10:47 am
  • L.S. # select version(); version --------------------------------------------------------------------------------------- PostgreSQL 8.4.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.4, ...
    Frank van VugtFrank van Vugt
    Apr 18, 2011 at 2:42 pm
    Apr 20, 2011 at 10:18 pm
  • I had self signed SSL certificates on my database server but since then removed them and received updated certificates from the security team. I removed (backedup) the old server.crt & server.key and ...
    Carlos MennensCarlos Mennens
    Apr 8, 2011 at 4:42 pm
    Apr 8, 2011 at 8:11 pm
  • Hello, Is it possible yet in 8.4 to pg_dump specific functions without having to do the whole pg_restore thing? If it is possible, what is the syntax to dump a specific function? If not possible, ...
    Greg CorradiniGreg Corradini
    Apr 5, 2011 at 11:16 pm
    Apr 6, 2011 at 9:27 am
  • Hi, Is there any place I can download the default postgresql.conf that comes with 9.0? Thanks!
    Phoenix KiulaPhoenix Kiula
    Apr 26, 2011 at 5:11 pm
    Apr 27, 2011 at 6:57 pm
  • Hello All, I am wondering, why I can not add the following ' A 10' in the where clause i.e. 'where nspname !~* 'pg_' and A 10' Select nspname, (SELECT count(*) as count FROM pg_tables where ...
    Salah jubehSalah jubeh
    Apr 15, 2011 at 3:22 pm
    Apr 15, 2011 at 4:28 pm
  • Hi, I've got an IBM x3200 server, with 1,8 Ghz dual core processor, and with 4 GB RAM. I've installed a FreeBSD 8.2, PostgreSQL 9.0.3, Apache22, with php5.3.5 and extensions for postgre, session,pdf ...
    Gipsz JakabGipsz Jakab
    Apr 8, 2011 at 8:00 am
    Apr 8, 2011 at 5:58 pm
  • Hello, I have hug postgresql database and when i going to search for a query with database retrieve with limit of 669 is allow If my query fetch records more over 669 records then error is comming... ...
    Tejas tankTejas tank
    Apr 6, 2011 at 10:52 am
    Apr 7, 2011 at 6:17 am
  • Hello, I am cleaning up a database and I have a list of unused tables, views and column and I want to drop these entities. I have the following constraints: * The database is live and thats mean I ...
    Salah jubehSalah jubeh
    Apr 4, 2011 at 10:47 am
    Apr 4, 2011 at 2:57 pm
Group Navigation
period‹ prev | Apr 2011 | next ›
Group Overview
grouppgsql-general @
categoriespostgresql
discussions202
posts1,080
users258
websitepostgresql.org
irc#postgresql

258 users for April 2011

Tom Lane: 66 posts Adrian Klaver: 46 posts John R Pierce: 32 posts Merlin Moncure: 32 posts Phoenix Kiula: 27 posts Henry C.: 26 posts Craig Ringer: 23 posts Scott Marlowe: 21 posts Tomas Vondra: 21 posts David Johnston: 19 posts Yang Zhang: 18 posts Andrew Sullivan: 17 posts Vibhor Kumar: 17 posts Vivek Khera: 17 posts Carlos Mennens: 16 posts Rob Sargent: 16 posts Greg Smith: 14 posts Shianmiin: 14 posts Alban Hertroys: 13 posts Edison So: 10 posts
show more
Archives