FAQ

PostgreSQL > pgsql-performance > December 2011

Search Discussions

29 discussions - 215 posts

  • So we are making progress on our performance issues, we are splitting the data, changing the index value etc. So far having some success, but we also want to test out some of the options and changes ...
    Tory M BlueTory M Blue
    Dec 3, 2011 at 4:09 am
    Dec 8, 2011 at 8:15 pm
  • I was experimenting with a few different methods of taking a line of text, parsing it, into a set of fields, and then getting that info into a table. The first method involved writing a C program to ...
    Jon NelsonJon Nelson
    Dec 11, 2011 at 1:27 am
    Dec 15, 2011 at 3:19 am
  • I have IBM x3560 with 2G RAM - RAID 5 3 disk - PostgreSQL 9.0.6 64bit on Windows 2003 64bit I had read some tuning guide, it recomment not use RAID 5. So Raid 5 is bestter than 3 disk independent or ...
    TuanhoanganhTuanhoanganh
    Dec 23, 2011 at 3:36 am
    Dec 25, 2011 at 7:15 am
  • Hi friends I want to know if it's possible to predict (calculate), how long a VACUUM FULL process will consume in a table? can I apply some formula to calculate this? thanks -- ...
    Ernesto QuiñonesErnesto Quiñones
    Dec 3, 2011 at 3:32 am
    Dec 7, 2011 at 3:14 pm
  • Hello I am sending this email to ask if anyone has noticed a change in how a server running postgreSQL 9.1 uses and allocates memory compared to older versions. We upgraded all our systems from 8.3 ...
    Rafael MartinezRafael Martinez
    Dec 19, 2011 at 3:05 pm
    Dec 22, 2011 at 9:59 am
  • Hi all, I am running a load simulation on Debian with PostgreSQL 8.4.9 (standard Debian package). Certain number of clients do the following stepsin a transaction (read commited level) periodically ...
    Havasvölgyi OttóHavasvölgyi Ottó
    Dec 6, 2011 at 9:30 pm
    Dec 8, 2011 at 5:22 pm
  • there are some performance issues on a server and by searching in the logs i noticed that the phases of parse and bind take considerably more time than execute for most of the queries. i guess that ...
    MirrorXMirrorX
    Dec 27, 2011 at 10:52 am
    Dec 29, 2011 at 4:51 pm
  • I have a fairly simple query: SELECT <some columns FROM "tubesite_image" INNER JOIN "tubesite_object" ON ("tubesite_image"."object_ptr_id" = "tubesite_object"."id") WHERE "tubesite_object"."site_id" ...
    Mario SplivaloMario Splivalo
    Dec 6, 2011 at 7:50 pm
    Dec 7, 2011 at 9:37 am
  • PostgreSQL 9.0.2 Mac OS X Server 10.6.8 Autovacuum is on, and I have a script that runs vacuum analyze verbose every night along with the backup. I have a situation where I'm experiencing a seq scan ...
    Jim CrateJim Crate
    Dec 27, 2011 at 5:29 pm
    Jan 11, 2012 at 12:19 am
  • I am doing POC on Posgtresql replication. I am using latest version of postgresql i.e. 9.1. There are multiple replication solutions avaliable in the market (PGCluster, Pgpool-II, Slony-I). ...
    SguptaSgupta
    Dec 29, 2011 at 9:33 am
    Jan 4, 2012 at 11:42 am
  • Hi all! I've ran into a performance problem a few time ago and I've been trying to figure out a solution until now. But since I've failed to come up with anything conclusive, it's time to ask some ...
    Miguel SilvaMiguel Silva
    Dec 30, 2011 at 4:39 pm
    Jan 2, 2012 at 11:57 am
  • Hello, I'm running a fairly complex query on my postgres-8.4.9 Ubuntu box. The box has 8-core CPU, 18G of RAM and no virtualization layer. The query takes many hours to run. The query essentially ...
    Michael SmolskyMichael Smolsky
    Dec 24, 2011 at 7:22 pm
    Dec 27, 2011 at 4:45 pm
  • I have a query that used < against an indexed column. In this case I can use the reverse and use in or = and get the performance I need... but "in general"... will the planner ever use an index when ...
    Roxanne Reid-BennettRoxanne Reid-Bennett
    Dec 17, 2011 at 3:30 pm
    Dec 18, 2011 at 8:19 pm
  • Hello All. We recently upgrade our server from PG8.2 to 8.4. Our current version is: database= SELECT version(); version ...
    Kaloyan Iliev IlievKaloyan Iliev Iliev
    Dec 8, 2011 at 5:29 pm
    Dec 14, 2011 at 5:48 pm
  • Hello, I wanted to ask according such a problem which we had faced with. We are widely using postgres arrays like key- value array by doing like this: {{1,5},{2,6},{3,7}} where 1,2,3 are keys, and ...
    Aleksej TrofimovAleksej Trofimov
    Dec 13, 2011 at 1:55 pm
    Dec 14, 2011 at 10:27 am
  • Hi all, I'm trying to figure out some common slow queries running on the server, by analyzing the slow queries log. I found debug_print_parse, debug_print_rewritten, debug_print_plan, which are too ...
    Daniel Cristian CruzDaniel Cristian Cruz
    Dec 10, 2011 at 4:52 pm
    Dec 11, 2011 at 3:11 am
  • Hi all, I found this presentation from B. Momjian: http://momjian.us/main/writings/pgsql/performance.pdf I'm interested in what he said about " Intersect/Union X AND/OR " , Can I find a transcription ...
    Thiago GodoiThiago Godoi
    Dec 2, 2011 at 3:55 pm
    Dec 7, 2011 at 2:57 pm
  • Hi, I have a two tables that are partitioned by month. I have different results for the same query (query A/query B), the only thing that differ from A and B is the customer id. Query A: SELECT ...
    Matteo SgalaberniMatteo Sgalaberni
    Dec 30, 2011 at 4:00 pm
    Jan 11, 2012 at 11:56 am
  • Hi - I'm running into an OOM-killer issue when running a specific query (no virtual machine running) and, based on researching the issue, I can probably fix by making the following sysctl ...
    Nabble 30 Miller_2555Nabble 30 Miller_2555
    Dec 19, 2011 at 3:52 pm
    Dec 20, 2011 at 8:47 pm
  • I have a couple of tables with about 400millions of records increasing about 5 millions per day. I think that disabling autovac over those tables, and enabling daily manual vacuum (in some idle hour) ...
    Anibal David AcostaAnibal David Acosta
    Dec 12, 2011 at 2:26 pm
    Dec 12, 2011 at 3:26 pm
  • Forwarding this on from someone who may pop up on the list too. This is a new server that's running a query slowly. The rate at which new semops happen may be related. OS is standard RHEL 5.5, kernel ...
    Greg SmithGreg Smith
    Dec 16, 2011 at 6:28 pm
    Feb 3, 2012 at 5:15 pm
  • I'd like to find some measurements/figures of query preparation and planning time to justify the use of prepared statements and stored procedures. I know that complex queries have larger preparation ...
    Igor SchteinIgor Schtein
    Dec 23, 2011 at 7:27 pm
    Dec 31, 2011 at 7:50 am
  • Hi there,  Currently, we are running into serious performance problems with our paritioning setup, because index lookups are mostly done on allpartions, in stead of the one partition it should ...
    Christiaan WillemsenChristiaan Willemsen
    Dec 7, 2011 at 3:16 pm
    Dec 14, 2011 at 4:06 pm
  • for example, the where condition is: where 'aaaa' ~ col1. I created a normal index on col1 but seems it is not used.
    Rural HunterRural Hunter
    Dec 14, 2011 at 4:05 pm
    Dec 15, 2011 at 1:54 am
  • I've got a 5GB table with about 12 million rows. Recently, I had to select the distinct values from just one column. The planner chose an index scan. The query took almost an hour. When I forced ...
    Jon NelsonJon Nelson
    Dec 13, 2011 at 6:13 pm
    Dec 13, 2011 at 8:18 pm
  • hello to all, the situation i am facing is this- table X- 200 mil rows index A (date, columnA) index B (date,columnB,columnC) the query planner is working properly and for a specific query that ...
    MirrorXMirrorX
    Dec 3, 2011 at 2:34 pm
    Dec 3, 2011 at 3:16 pm
  • Well thought it was maybe just going from 8.4.4 to 9.1.1 so upgraded to 8.4.9 and tried pg_upgrade again (this is 64bit) and it's failing -bash-4.0$ /tmp/pg_upgrade --check --old-datadir "/data/db" ...
    Tory M BlueTory M Blue
    Dec 7, 2011 at 11:53 pm
    Jan 10, 2012 at 9:21 pm
  • Hello, I have a postgres 9.0.2 installation. Every works fine, but in some hours of day I got several timeout in my application (my application wait X seconds before throw a timeout). Normally hours ...
    Anibal David AcostaAnibal David Acosta
    Dec 7, 2011 at 3:34 pm
    Dec 7, 2011 at 8:19 pm
  • SOLVED On Tue, Dec 20, 2011 at 3:46 PM, Tom Lane - tgl@sss.pgh.pa.us wrote: I've updated the query to use NOT EXISTS, which does produce a vastly more efficient plan and barely moves memory ...
    Nabble 30 Miller_2555Nabble 30 Miller_2555
    Dec 21, 2011 at 5:09 am
    Dec 21, 2011 at 5:09 am
Dec 2011
Group Navigation
period‹ prev | Dec 2011 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions29
posts215
users64
websitepostgresql.org
irc#postgresql

64 users for December 2011

Scott Marlowe: 19 posts Tom Lane: 13 posts Bruce Momjian: 11 posts Jon Nelson: 9 posts Havasvölgyi Ottó: 8 posts Kevin Grittner: 8 posts MirrorX: 8 posts Tory M Blue: 8 posts Mario Splivalo: 6 posts Pavel Stehule: 6 posts Aleksej Trofimov: 5 posts Marti Raudsepp: 5 posts Matteo Beccati: 5 posts Merlin Moncure: 5 posts Nabble 30 Miller_2555: 4 posts Claudio Freire: 4 posts Ernesto Quiñones: 4 posts Rafael Martinez: 4 posts Tomas Vondra: 4 posts Tuanhoanganh: 4 posts
show more
Archives