FAQ

PostgreSQL > pgsql-performance > July 2009

Search Discussions

48 discussions - 378 posts

  • Hi, list. I've just upgraded pgsql from 8.3 to 8.4. I've used pgtune before and everything worked fine for me. And now i have ~93% cpu load. Here's changed values of config: default_statistics_target ...
    Rauan MaemirovRauan Maemirov
    Jul 30, 2009 at 12:35 pm
    Aug 5, 2009 at 5:00 pm
  • Just wondering is the issue referenced in http://archives.postgresql.org/pgsql-performance/2005-11/msg00415.php is still present in 8.4 or if some tunable (or other) made the use of hyperthreading a ...
    Doug HunleyDoug Hunley
    Jul 21, 2009 at 1:49 pm
    Jul 29, 2009 at 1:39 pm
  • Hi, I'm trying to solve big performance issues with PostgreSQL + bacula while inserting very big sets of records. I'm sorry, this email will be a long one, as I've already spent quite a lot of time ...
    Marc CousinMarc Cousin
    Jul 13, 2009 at 2:01 pm
    Jul 27, 2009 at 11:17 am
  • Hello, I'm having a bit of an issue with full text search (using tsvectors) on PostgreSQL 8.4. I have a rather large table (around 12M rows) and want to use full text search in it (just for one of ...
    KradeKrade
    Jul 18, 2009 at 10:16 pm
    Jul 29, 2009 at 3:37 pm
  • Hi, I am transplanting an application to use PostgreSQL8.2.4 instead of DB2 9.1. CLI was used to connect to DB2, and ODBC is used to connect to PostgreSQL. The query statement is as follows: SELECT ...
    NingNing
    Jul 15, 2009 at 3:59 am
    Jul 17, 2009 at 1:26 am
  • Hi folks, We have problems with performance of a simple SQL statement. If we add a LIMIT 50, the query is about 6 times slower than without a limit (query returns 2 rows). I have read this ...
    Kees van DierenKees van Dieren
    Jul 31, 2009 at 11:06 am
    Aug 10, 2009 at 6:46 pm
  • Hi, I have some 99,000 records in a table (OBSERVATION_ALL) in a Postgres DB as well as a Greenplum DB. The Primary key is a composite one comprising of 2 columns (so_no, serial_no). The execution of ...
    Suvankar RoySuvankar Roy
    Jul 13, 2009 at 11:34 am
    Jul 17, 2009 at 6:24 am
  • I use poker software (HoldemManager) to keep track of the statistics (and show nice graphs) of millions of poker hand histories. This software (also PokerTracker 3) imports all the poker hands in ...
    PatvsPatvs
    Jul 4, 2009 at 6:51 pm
    Jul 7, 2009 at 5:51 am
  • HI Gurus , i have this query (i think is a simple one) it takes me 1,7s to run it, it's not to long, but considering it takes 1,7s to return 71lines makes me wonder... is there anyother way to do ...
    Rui CarvalhoRui Carvalho
    Jul 1, 2009 at 9:40 am
    Jul 3, 2009 at 11:29 am
  • Hi. I notice that when I do a WHERE x, Postgres uses an index, and when I do WHERE y, it does so as well, but when I do WHERE x OR y, it doesn't. Why is this so? And how can I shut this off? select * ...
    Robert JamesRobert James
    Jul 19, 2009 at 11:03 pm
    Jul 27, 2009 at 2:33 pm
  • Below is a query that takes 16 seconds on the first run. I am having generally poor performance for queries in uncached areas of the data and often mediocre (500ms-2s+) performance generallly, ...
    AlexAlex
    Jul 9, 2009 at 9:44 pm
    Jul 26, 2009 at 9:17 pm
  • I'm considering rewriting a postgres extension (GiST index bioseg) to make it use version 1 calling conventions rather than version 0. Does anyone have any ideas/opinions/statistics on what the ...
    Matthew WakelingMatthew Wakeling
    Jul 17, 2009 at 2:02 pm
    Jul 21, 2009 at 2:13 pm
  • Hello again! I did test on my local test server I created up 500 000 users in function loop very quickly - within 48 seconds. I did again this script reaching up to 1 billion users - results was the ...
    Lauris UlmanisLauris Ulmanis
    Jul 15, 2009 at 12:21 pm
    Jul 16, 2009 at 12:09 pm
  • Howdy. Some months back, when advised on one of these lists that it should not be necessary to issue VACUUM FULL/REINDEX DATABASE, we quit this nightly "maintenance" practice. We've been very happy ...
    Wayne ConradWayne Conrad
    Jul 13, 2009 at 7:38 pm
    Jul 16, 2009 at 3:05 pm
  • Hi, We are bundling PostgreSQL 8.3.7 with our Java based application. We observe that in some systems the Database access becomes very slow after running it for couple of days. We understand that ...
    Saurabh DaveSaurabh Dave
    Jul 6, 2009 at 5:48 am
    Jul 7, 2009 at 1:41 pm
  • Hi I'm storing historical meteorological gridded data from GFS ( http://www.nco.ncep.noaa.gov/pmb/products/gfs/) into an array field in a table like this: CREATE TABLE grid_f_data_i2 ( //Specifies ...
    Victor de Buen (Bayes)Victor de Buen (Bayes)
    Jul 21, 2009 at 11:43 pm
    Jul 22, 2009 at 7:08 pm
  • Hi. I'm seeing some weird behavior in Postgres. I'm running read only queries (SELECT that is - no UPDATE or DELETE or INSERT is happening at all). I can run one rather complicated query and the ...
    Robert JamesRobert James
    Jul 28, 2009 at 12:54 am
    Jul 28, 2009 at 10:36 pm
  • Hi Performance Wizards! I need advice on this. I have a db which is being constantly updated and queried by a few computers. We are doing datamining. The machine is running on a moderately powered ...
    Kelvin QueeKelvin Quee
    Jul 22, 2009 at 3:47 am
    Jul 22, 2009 at 7:47 pm
  • Hi, We use a typical counter within a transaction to generate order sequence number and update the next sequence number. This is a simple next counter - nothing fancy about it. When multiple clients ...
    Raji Sridar (raji)Raji Sridar (raji)
    Jul 16, 2009 at 5:09 am
    Jul 17, 2009 at 7:13 pm
  • Dear All, We are using Postgres 8.3.7 in our java application. We are doing performances tuning and load testing in our setup. we have noticed that ,some of our queries to the database taking long ...
    ParimalaParimala
    Jul 30, 2009 at 2:53 pm
    Aug 3, 2009 at 11:46 am
  • Hi all, Has anybody worked on Greenplum MapReduce programming ? I am facing a problem while trying to execute the below Greenplum Mapreduce program written in YAML (in blue). The error is thrown in ...
    Suvankar RoySuvankar Roy
    Jul 30, 2009 at 12:25 pm
    Aug 3, 2009 at 9:50 am
  • Hi, subject is the following type of query needed in a function to select data: SELECT ' 13.04.2009 12:00:00 ' AS zeit, 'M' AS ganglinientyp, m.zs_nr AS zs, j_ges, de_mw_abh_j_lkw(mw_abh) AS j_lkw, ...
    Thomas ZaksekThomas Zaksek
    Jul 27, 2009 at 2:16 pm
    Jul 29, 2009 at 10:39 am
  • Apologies for a slightly off-topic question ... a friend is overseeing the demise of a company and has several computers that they need to get rid of. She's an attorney and knows little about them ...
    Craig JamesCraig James
    Jul 20, 2009 at 3:25 pm
    Jul 21, 2009 at 6:36 pm
  • Hello, I am trying to optimize the count of files when I am using filters (select by some row/s parameter/s) In this case I think that postgresql really count all files. Resulting in unacceptable ...
    DeveloperDeveloper
    Jul 27, 2009 at 9:51 am
    Jul 27, 2009 at 7:05 pm
  • I noticed a bit of a performance regression in embedded sql queries when moving from the client libraries in verison 8.2.4 to 8.3.7. My application does a whole lot of queries, many of which don't ...
    Haszlakiewicz, EricHaszlakiewicz, Eric
    Jul 9, 2009 at 5:28 pm
    Jul 14, 2009 at 9:41 am
  • Hi, I would like to know if my configuration is ok, We run a web application with high transaction rate and the database machine on Mondays / Tuesdays is always at 100% CPU with no IO/Wait . the ...
    Chris DunnChris Dunn
    Jul 31, 2009 at 4:28 am
    Aug 2, 2009 at 5:30 pm
  • I'm storing a lot of words in a database. What's the fastest format for finding them? I'm going to be doing a lot of WHERE w LIKE 'marsh%' and WHERE w IN ('m', 'ma'). All characters are lowercase ...
    Robert JamesRobert James
    Jul 20, 2009 at 1:47 am
    Jul 20, 2009 at 9:25 pm
  • Hi all have a dought about explain of postgres Let's see: Who have more cost for database: Index Scan using xix3_movimento_roteiro_empresa on movimento_roteiro_empresa movimentor0_ ...
    Paulo matadrPaulo matadr
    Jul 10, 2009 at 2:46 pm
    Jul 13, 2009 at 12:22 pm
  • [ Attempting to resend, because it didn't seem to get through last time. ] We have a query that runs very slowly on our 8.3 database. (I can't tell you exactly how slowly, because it has never ...
    Robin HoustonRobin Houston
    Jul 9, 2009 at 4:35 pm
    Jul 9, 2009 at 5:46 pm
  • Hi, Everyone says "load test using your app" - out of interest how does everyone do that at the database level? I've tried playr (https://area51.myyearbook.com/trac.cgi/wiki/Playr) but haven't been ...
    ChrisChris
    Jul 31, 2009 at 6:50 am
    Aug 1, 2009 at 3:57 pm
  • Hello! I posted you a message about slowness of creation users more than 500 000 (#4919). It seems there is no workaround of this problem because of using pg_auth flat file. To override this problem ...
    Lauris UlmanisLauris Ulmanis
    Jul 23, 2009 at 10:48 am
    Jul 27, 2009 at 2:00 am
  • Hello, It seems to me that the following query should be a lot faster. This runs in 17 seconds (regardless how many times I run it) select ac.* from application_controls_view ac, refs r where ...
    Greg CaultonGreg Caulton
    Jul 26, 2009 at 5:02 am
    Jul 26, 2009 at 4:30 pm
  • Hey all! Is there a better way to increase or decrease the value of an integer than doing something like: --- UPDATE the_table SET the_int = the_int + 1 WHERE the_id = 123 ; --- We seem to be getting ...
    William Scott JordanWilliam Scott Jordan
    Jul 16, 2009 at 6:07 pm
    Jul 16, 2009 at 7:19 pm
  • Hi Can anyone tell me what are the tools to monitor postgres server. ? I am running my Postgres server on RHEL 5 machine. -- View this message in context: ...
    MukeshpMukeshp
    Jul 31, 2009 at 5:50 am
    Aug 2, 2009 at 6:08 pm
  • When reviewing the vacuum logs, I notice that on any given day autovacuum only seems to touch four of the tables in one of our schemas (not counting toast tables). However, if I look at the ...
    Doug HunleyDoug Hunley
    Jul 29, 2009 at 4:47 pm
    Jul 30, 2009 at 9:45 pm
  • I understand that checkpointing is a necessary part of a pgsql database, but I am also under the impression that you want to find a balance between how frequently you checkpoint and how much a given ...
    Doug HunleyDoug Hunley
    Jul 28, 2009 at 5:18 pm
    Jul 29, 2009 at 2:09 am
  • Hi, I posted this question at stackoverflow. Please follow there to see the question in a nice format as I also posted the code that I used for benchmarking. ...
    WANGRUNGVICHAISRI, SHIVESHWANGRUNGVICHAISRI, SHIVESH
    Jul 23, 2009 at 11:55 pm
    Jul 24, 2009 at 6:14 am
  • Hi, I'm using both IN and ANY() operators extensively my application. Can anybody answer me on the following questions: 1) Which operator is advantage over the another, interms of performance? 2) If ...
    GnanamGnanam
    Jul 8, 2009 at 6:50 am
    Jul 23, 2009 at 11:22 pm
  • 8.4 from CVS HEAD: EXPLAIN ANALYZE select * from (select n, 1 as r from generate_series(1, 100000) as n union all select n, 2 from generate_series(1, 100000) as n) as x where r = 3; QUERY PLAN ...
    Sergey BurladyanSergey Burladyan
    Jul 2, 2009 at 12:08 am
    Jul 22, 2009 at 7:02 pm
  • I can't figure what is going on below; first of all, this count which returns 1.5 million from a ~2 million row table: woome=# explain analyze SELECT COUNT(*) FROM "webapp_person" WHERE ...
    Frank JoerdensFrank Joerdens
    Jul 13, 2009 at 8:46 pm
    Jul 22, 2009 at 7:02 pm
  • Hi, I have been playing around with PostgreSQL's XML support lately (cf. <URI:news:m3ljmocolf.fsf@passepartout.tim-landscheidt.de ) and stumbled upon some performance issues related to XMLPARSE(). In ...
    Tim LandscheidtTim Landscheidt
    Jul 20, 2009 at 7:05 pm
    Jul 20, 2009 at 7:54 pm
  • I am using Postgres with Rails. Each rails application "thread" is actually a separate process (mongrel) with it's own connection. Normally, the db connection processes (?) look something like this ...
    AlexAlex
    Jul 15, 2009 at 8:45 am
    Jul 17, 2009 at 9:06 am
  • When users count in Postgres database reaches up to 500 000 - database command of creating users 'CREATE USER' slows down to 5-10 seconds per user. What could be a reason of this problem and is there ...
    Lauris UlmanisLauris Ulmanis
    Jul 14, 2009 at 1:21 pm
    Jul 15, 2009 at 9:38 pm
  • Hello everybody, I have a simple query which selects data from not very large table ( 434161 rows) and takes far more time than I'd expect. I believe it's due to a poor disk performance because when ...
    Martin ChlupacMartin Chlupac
    Jul 9, 2009 at 10:34 am
    Jul 9, 2009 at 10:53 am
  • Hi, As far as I recall postgres does not have built-in support for "insert or replace" feature. But there is a lot of ways to obtain the same result. The problem is that performance of these ...
    Sergei PolitovSergei Politov
    Jul 3, 2009 at 11:06 am
    Jul 3, 2009 at 11:23 am
  • auto vacuum of ts_user_sessions_map has been running for 17 hours. This table has 2,204,488 rows. I hope that I've captured enough info. Thanks, Brian cemdb=# select procpid,current_query,query_start ...
    Brian CoxBrian Cox
    Jul 10, 2009 at 6:13 pm
    Jul 10, 2009 at 6:13 pm
  • Hi All, I would like to know if there is a limitation on the size of the XML document that can be contained in a table? Do you think inserting a large XML, say with 100 elements, will be a problem? ...
    Franclin FopingFranclin Foping
    Jul 8, 2009 at 5:21 pm
    Jul 8, 2009 at 5:21 pm
  • I looked into that. There is one piece of documentation that is less than ten pages long. There is no users group, no listserve, no community that I can discern. Do you have experience with it and if ...
    Tim UckunTim Uckun
    Jul 8, 2009 at 2:27 am
    Jul 8, 2009 at 2:27 am
Jul 2009
Group Navigation
period‹ prev | Jul 2009 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions48
posts378
users112
websitepostgresql.org
irc#postgresql

112 users for July 2009

Kevin Grittner: 25 posts Scott Marlowe: 25 posts Scott Carey: 23 posts Tom Lane: 20 posts Greg Smith: 12 posts Matthew Wakeling: 12 posts Robert Haas: 12 posts Greg Stark: 10 posts Marc Cousin: 9 posts Mike Ivanov: 7 posts Ning: 7 posts Віталій Тимчишин: 7 posts Merlin Moncure: 6 posts Robert James: 6 posts Alex: 5 posts Alvaro Herrera: 5 posts Andres Freund: 5 posts Craig Ringer: 5 posts Haszlakiewicz, Eric: 5 posts Krade: 5 posts
show more
Archives