FAQ

PostgreSQL > pgsql-performance > May 2011

Search Discussions

46 discussions - 420 posts

  • I have a multi-threaded app. It uses ~22 threads to query Postgres. Postgres won't use more than 1 CPU core. The 22-threaded app only has 3% CPU utilization because it's mostly waiting on Postgres. ...
    Aren CambreAren Cambre
    May 9, 2011 at 9:28 pm
    May 23, 2011 at 2:07 pm
  • Hello performers, I've long been unhappy with the standard advice given for setting shared buffers. This includes the stupendously vague comments in the standard documentation, which suggest certain ...
    Merlin MoncureMerlin Moncure
    May 26, 2011 at 2:32 pm
    May 31, 2011 at 1:57 pm
  • I've got a fun problem. My employer just purchased some new db servers that are very large. The specs on them are: 4 Intel X7550 CPU's (32 physical cores, HT turned off) 1 TB Ram 1.3 TB Fusion IO (2 ...
    Chris HooverChris Hoover
    May 9, 2011 at 8:34 pm
    May 10, 2011 at 5:50 pm
  • Hi, In my DB, there is a large table containing messages and one that contains message boxes. Messages are assigned to boxes via a child parent link m- b. In order to obtain the last message for a ...
    PanamPanam
    May 24, 2011 at 4:14 am
    Jun 1, 2011 at 12:43 am
  • Hi, everyone. I'm working on a project that's using PostgreSQL 8.3, that requires me to translate strings of octal digits into strings of characters -- so '141142143' should become 'abc', although ...
    Reuven M. LernerReuven M. Lerner
    May 25, 2011 at 5:05 pm
    Jun 2, 2011 at 6:49 am
  • Hi, Our database has gotten rather large and we are running out of disk space. our disks are 15K rpm SAS disks in RAID 10. We are going to rent some space on a FibreChannel SAN. That gives us the ...
    Willy-Bas LoosWilly-Bas Loos
    May 3, 2011 at 3:53 pm
    Jun 10, 2011 at 10:02 am
  • Does anyone here have any bad experiences with the RAID card in subject ? This is in an IBM server, with 2.5" 10k drives. But we seem to observe its poor performance in other configurations as well ...
    Grzegorz JaśkiewiczGrzegorz Jaśkiewicz
    May 25, 2011 at 7:34 am
    May 28, 2011 at 10:15 am
  • What are the best practices for setting up PG 9.x on Amazon EC2 to get the best performance? Thanks in advance, Joel -------------------------------------------------------------------------- - for ...
    Joel ReymontJoel Reymont
    May 3, 2011 at 6:48 pm
    May 5, 2011 at 7:49 am
  • Hi, I am conducting a benchmark to compare KVP table vs. hstore and got bad hstore performance results when the no. of records is greater than about 500'000. CREATE TABLE kvp ( id SERIAL PRIMARY KEY, ...
    Stefan KellerStefan Keller
    May 14, 2011 at 10:10 am
    May 26, 2011 at 9:31 am
  • Hi, guys. I have following environment configuration - Postgres 8.4.7 with following postresql.conf settings modified: listen_addresses = '*' max_connections = 100 shared_buffers = 2048MB ...
    Andrey VorobievAndrey Vorobiev
    May 17, 2011 at 12:45 pm
    May 25, 2011 at 2:01 am
  • Hi, We have some indexes that don't seem to be used at all. I'd like to know since when they have not been used. That is, the time when postgres started counting to reach the number that is in ...
    Willy-Bas LoosWilly-Bas Loos
    May 12, 2011 at 3:39 pm
    May 13, 2011 at 8:44 am
  • Am I reading this right in that the sort is taking almost 8 seconds? "GroupAggregate (cost=95808.09..95808.14 rows=1 width=142) (actual time=14186.999..14694.524 rows=315635 loops=1)" " Output: ...
    Strange, John WStrange, John W
    May 19, 2011 at 9:26 pm
    May 23, 2011 at 5:57 pm
  • Hi I have 3 tables page - revision - pagecontent CREATE TABLE mediawiki.page ( page_id serial NOT NULL, page_namespace smallint NOT NULL, page_title text NOT NULL, page_restrictions text, ...
    MarkMark
    May 1, 2011 at 10:24 am
    May 14, 2011 at 2:28 am
  • Hi all: Not sure if this is a performance question or a generic admin question. I have the following script running on a host different from the database to use pgbench to test the database: pgbench ...
    John RouillardJohn Rouillard
    May 23, 2011 at 10:16 pm
    May 26, 2011 at 3:18 am
  • Hi. I'm on a 64 Bit CentOS 5 system, quadcore processor, 8GB RAM and tons of data storage (1 TB SATAII disks). The current SHMMAX and SHMMIN are (commas added for legibility) -- kernel.shmmax = ...
    Phoenix KiulaPhoenix Kiula
    May 1, 2011 at 6:48 am
    May 2, 2011 at 3:18 pm
  • Hi All My database uses joined table inheritance and my server version is 9.0 Version string PostgreSQL 9.0rc1 on x86_64-pc-linux-gnu, compiled by GCC x86_64-pc-linux-gnu-gcc (Gentoo 4.4.4-r1 p1.1, ...
    Jarrod ChesneyJarrod Chesney
    May 31, 2011 at 12:08 am
    Jun 2, 2011 at 1:46 am
  • I am using Postgres 8.3 and I have an issue very closely related to the one described here: http://archives.postgresql.org/pgsql-general/2005-06/msg00488.php Basically, I have a VIEW which is a UNION ...
    Dave JohansenDave Johansen
    May 16, 2011 at 7:38 pm
    May 23, 2011 at 9:31 pm
  • Hi, I have a quite complex, performance sensitive query in a system with a few (7) joins: select .... from t1 left join t2 .... WHERE id IN (select ....) For this query the planner evaluates the IN ...
    Clemens EissererClemens Eisserer
    May 16, 2011 at 10:30 pm
    May 18, 2011 at 5:51 pm
  • Hi all: I am adding pgiosim to our testing for new database hardware and I am seeing something I don't quite get and I think it's because I am using pgiosim incorrectly. Specs: OS: centos 5.5 kernel: ...
    John RouillardJohn Rouillard
    May 13, 2011 at 9:09 pm
    May 17, 2011 at 5:35 pm
  • Hi, I tried with the PostgreSQL 9.0.4 + Hot Standby and running the database from Fusion IO Drive to understand the PG Performance. While doing so I got the "*Query failed ERROR: catalog is missing 1 ...
    Sethu PrasadSethu Prasad
    May 3, 2011 at 9:03 am
    May 15, 2011 at 8:34 pm
  • Hello everyone, I have the following scenario: There's a web service that updates some information in two tables, every 5 minutes. In order to do this it will issue a select on the tables, get some ...
    Prodan, AndreiProdan, Andrei
    May 11, 2011 at 11:18 am
    May 12, 2011 at 11:28 pm
  • I have 8-core server, I wanted to ask whether a query can be divided for multiple processors or cores, if it could be what to do in postgresql Thanks
    Didik PrasetyoDidik Prasetyo
    May 10, 2011 at 4:32 am
    May 11, 2011 at 12:05 pm
  • Dear list, I have a table with a few million rows and this index: CREATE INDEX bond_item_common_x7 ON bond_item_common ((lower(original_filename))); There are about 2M rows on bonddump and 4M rows on ...
    Marcus EngeneMarcus Engene
    May 9, 2011 at 6:45 pm
    May 9, 2011 at 9:29 pm
  • I am using Postgres 8.3.3 and I have a VIEW which is a UNION ALL of two tables but when I do a select on the view using a LIMIT, it scans the entire tables and takes significantly longer than writing ...
    Dave JohansenDave Johansen
    May 18, 2011 at 3:26 pm
    May 26, 2011 at 5:00 pm
  • Dear all, I have a query on 3 tables in a database as :- _*Explain Analyze Output :-*_ explain anayze select c.clause, s.subject ,s.object , s.verb, s.subject_type , s.object_type ,s.doc_id ,s.svo_id ...
    Adarsh SharmaAdarsh Sharma
    May 16, 2011 at 5:39 am
    May 16, 2011 at 2:16 pm
  • Hi everyone We have recently started to port an application from Oracle to PostgreSQL. So far, we are amazed with how great most things work. However, we have run into performance problems in one ...
    Fredrik WidlertFredrik Widlert
    May 13, 2011 at 12:02 pm
    May 13, 2011 at 3:09 pm
  • While reading about NoSQL, The following ensued. Isn't it cute ? CREATE TABLE mongo ( id SERIAL PRIMARY KEY, obj hstore NOT NULL ); INSERT INTO mongo (obj) SELECT ('a= '||n||',key'||(n%10)||'= ...
    Pierre CPierre C
    May 10, 2011 at 8:42 pm
    May 11, 2011 at 11:41 am
  • i have around 25mio records of data distributed yearly over 9 child tables (data.logs_20xx) that inherit from the master table data.logs. the tables are partitioned using the field "re_timestamp", ...
    Thomas HägiThomas Hägi
    May 6, 2011 at 9:20 pm
    May 10, 2011 at 9:20 am
  • We have a generated query from our web application which takes far longer to complete in 9.0.4, than in 8.3.7 ( 60sec in 9.0.4 ~10sec in 8.3.7) The query plan generated in 9.0, includes a Materialize ...
    Brian ConnollyBrian Connolly
    May 5, 2011 at 5:43 pm
    May 5, 2011 at 8:27 pm
  • Hi, I'm running into erroneous row estimates when using an array type, and I'm running out of ideas on how to steer postgres into the right direction... I've tried setting statistics to 1000, ...
    Denis de BernardyDenis de Bernardy
    May 4, 2011 at 1:41 pm
    May 4, 2011 at 2:57 pm
  • Hi All, I have created partition on table Round_Action , which has 3 child partition tables. When I am firing a simple select query with limit on parent table it is taking huge time to execute. But ...
    JenishJenish
    May 31, 2011 at 7:21 am
    Jun 2, 2011 at 1:39 pm
  • So if you're running a RHEL5.4 or RHEL5.5 system, are you basically stuck with ext3? I'm not sure if I'm remembering correctly, but ISTM that you've been uncomfortable with BOTH ext4 and XFS prior to ...
    Robert HaasRobert Haas
    May 31, 2011 at 3:36 pm
    May 31, 2011 at 6:07 pm
  • Hi: I installed PostgreSQL9.0 from EnterpriseDB with“one click installer” in windows 7 & 32bit. and use microsoft visual studio 2010 c++. I added the libpq.lib to the link property of the project, ...
    Fanbin MengFanbin Meng
    May 13, 2011 at 3:54 pm
    May 19, 2011 at 8:10 pm
  • Hi - Linux newbie here, and more of a developer than pgsql SysAdmin... When trying to follow some performance tuning suggestions by Robert Haas here: ...
    STASTA
    May 17, 2011 at 5:28 pm
    May 17, 2011 at 5:58 pm
  • Hello, How fillfactor impact performance of query? I have two cases, One is a operational table, for each insert it have an update, this table must have aprox. 1.000 insert per second and 1.000 ...
    Anibal David AcostaAnibal David Acosta
    May 17, 2011 at 1:00 pm
    May 17, 2011 at 1:53 pm
  • I've got a stored proc that constructs some aggregation queries as strings and then executes them. I'd like to be able to increase work_mem before running those queries. If I set a new value for ...
    Samuel GendlerSamuel Gendler
    May 12, 2011 at 11:10 pm
    May 13, 2011 at 9:42 am
  • I am using Postgresql 8.2.13 and I found that most of the commits and insert or update statements are taking more than 4s in the db and the app performance is slow for that. My db settings are as ...
    AI RummanAI Rumman
    May 10, 2011 at 7:01 am
    May 10, 2011 at 3:56 pm
  • Working on some optimization as well as finally getting off my backside and moving us to 64bit (32gb+memory). I was reading and at some point it appears on freeBSD the Postgres block size was upped ...
    Tory M BlueTory M Blue
    May 26, 2011 at 10:35 pm
    May 27, 2011 at 11:09 am
  • Hi. First extremely thanks for your works about postgresql . I wonder that after executing 'vaccumdb -z' some other process can not read their own msg queue during 2 ~ 3 minuts. vaccum executed every ...
    Junghwe KimJunghwe Kim
    May 27, 2011 at 1:58 am
    May 27, 2011 at 3:32 am
  • I have a strange situation. I have a table of detail with millones of rows and a table of items with thousands of rows When I do.. select count(*) from wiz_application_response where ...
    Anibal David AcostaAnibal David Acosta
    May 23, 2011 at 9:38 pm
    May 23, 2011 at 11:27 pm
  • Hi, I'm new to postgres and I have the next question. I have a php program that makes 100000 inserts in my database. autoincrement numbers inserted into a table with 5 columns. The script takes about ...
    Ezequiel LovelleEzequiel Lovelle
    May 15, 2011 at 10:02 pm
    May 15, 2011 at 10:27 pm
  • AMD Opteron(tm) Processor 4174 HE vs Intel(R) Xeon(R) CPU E5345 @ 2.33GHz I'm wondering if there is a performance difference running postgres on fedora on AMD vs Intel (the 2 listed above). I have an ...
    Tory M BlueTory M Blue
    May 10, 2011 at 5:29 pm
    May 10, 2011 at 8:53 pm
  • I'm looking for a good ready-to-run broad spectrum (tests cpu bound, i/o bound, various cases, various sizes) benchmark. I tried dbt5 and got it compiled after some effort but it immediately fails ...
    Merlin MoncureMerlin Moncure
    May 9, 2011 at 8:41 pm
    May 9, 2011 at 11:23 pm
  • I had a problem with performance engine database, I use the server with the following specifications 1. its storage configuration? Storage SCSI 15K RAID 5 2. how his network? 2 gigabit bonding. 3. ...
    Didik PrasetyoDidik Prasetyo
    May 5, 2011 at 1:24 am
    May 5, 2011 at 6:08 pm
  • I referred chapter 14.3 of postgres document version 9.0. explicit joins help the planner in planninng & thus improve performance. On what relations are explicit joins to be added?? I am getting data ...
    Rishabh Kumar JainRishabh Kumar Jain
    May 5, 2011 at 6:04 am
    May 5, 2011 at 5:17 pm
  • Hi, I am using contrib/cube code. I am building GIST index on cube data type then it leads to a very large size of log file (nearly 220 MB for only 12k records). While creating index on geometry ...
    Nick RajNick Raj
    May 22, 2011 at 11:43 am
    May 22, 2011 at 11:43 am
May 2011
Group Navigation
period‹ prev | May 2011 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions46
posts420
users99
websitepostgresql.org
irc#postgresql

99 users for May 2011

Robert Haas: 31 posts Greg Smith: 27 posts Merlin Moncure: 22 posts Kevin Grittner: 20 posts Tom Lane: 18 posts Aren Cambre: 15 posts Craig Ringer: 15 posts Shaun Thomas: 13 posts Josh Berkus: 12 posts Tomas Vondra: 12 posts Cédric Villemain: 11 posts Mark Kirkwood: 10 posts Pierre C: 8 posts Scott Marlowe: 8 posts Dave Johansen: 7 posts John Rouillard: 7 posts Claudio Freire: 6 posts Denis de Bernardy: 6 posts Jim Nasby: 6 posts Panam: 6 posts
show more
Archives