FAQ

Search Discussions

26 discussions - 255 posts

  • Hi all, Our application is heavy write and IO utilisation has been the problem for us for a while. We've decided to use RAID 10 of 4x500GB Samsung 840 Pro for the master server. I'm aware of write ...
    Cuong HoangCuong Hoang
    May 16, 2013 at 2:46 pm
    May 24, 2013 at 12:12 pm
  • Hi all, We are running a stress test that executes one select query with multiple threads. The query executes very fast (10ms). It returns 100 rows. I see deterioration in the performance when we ...
    Anne RossetAnne Rosset
    May 1, 2013 at 5:51 am
    May 7, 2013 at 5:53 pm
  • Hi, I have a database with quite some data (millions of rows), that is heavily updated all the time. Once a day I would like to reindex my database (and maybe re cluster it - don't know if that's ...
    Niels Kristian SchjødtNiels Kristian Schjødt
    May 29, 2013 at 12:24 pm
    Jun 1, 2013 at 2:38 am
  • The SARS_ACTS table currently has 37,115,515 rows we have = indexed: idx_sars_acts_acts_run_id ON SARS_ACTS USING btree (sars_run_id)
    FburgessFburgess
    May 21, 2013 at 9:53 pm
    May 29, 2013 at 2:44 pm
  • Hello, We are in the fortunate situation of having more money than time to help solve our PostgreSQL 9.1 performance problem. Our server hosts databases that are about 1 GB in size with the largest ...
    Mike McCannMike McCann
    May 2, 2013 at 11:11 pm
    May 20, 2013 at 3:57 am
  • Postgres 9.1.2 on Ubuntu 12.04 Any reason why a select by primary key would be slower than a select that includes an ORDER BY? I was really hoping using the primary key would give me a boost. I ...
    John MuddJohn Mudd
    May 27, 2013 at 2:02 pm
    May 30, 2013 at 3:59 pm
  • Hi! This has been a pain point for quite a while. While we've had several discussions in the area, it always seems to just kinda trail off and eventually vanish every time it comes up. A really basic ...
    Shaun ThomasShaun Thomas
    May 15, 2013 at 3:31 pm
    May 16, 2013 at 12:47 pm
  • I am fairly new to squeezing performance out of Postgres, but I hope this mailing list can help me. I have read the instructions found at http://wiki.postgresql.org/wiki/Slow_Query_Questions and have ...
    Jonathan MorraJonathan Morra
    May 23, 2013 at 5:20 pm
    May 28, 2013 at 4:04 pm
  • Has the new DB been analyzed? Maybe you had custom stats targets in the old DB that didn't get copied to the new one? regards, tom lane
    Tom LaneTom Lane
    May 6, 2013 at 4:38 pm
    May 15, 2013 at 1:52 pm
  • Hi all, In our server Check pointer process is consuming 8 GB of memory, what could be the possible reason? Can any one please help. Regards, Itishree
    Itishree suklaItishree sukla
    May 30, 2013 at 12:09 pm
    Jun 7, 2013 at 1:53 pm
  • Folks, I'm seeing what may be a major performance bug in BIND in 9.2.4. We have a client who has an application which uses Tomcat+Hibernate+JDBC. They are in the process of upgrading this application ...
    Josh BerkusJosh Berkus
    May 30, 2013 at 12:14 am
    May 31, 2013 at 6:54 pm
  • Hi people, i have a database with 400GB running in a server with 128Gb RAM, and 32 cores, and storage over SAN with fiberchannel, the problem is when i go to do a backup whit pg_dumpall take a lot of ...
    Jeison BedoyaJeison Bedoya
    May 21, 2013 at 1:19 pm
    May 21, 2013 at 8:04 pm
  • Hi All, We've got 3 quite large tables that due to an unexpected surge in usage (!) have grown to about 10GB each, with 72, 32 and 31 million rows in. I've been tasked with cleaning out about half of ...
    Rob EmeryRob Emery
    May 17, 2013 at 11:26 am
    May 20, 2013 at 2:55 am
  • I have a unique constraint on two columns of a supermassive table (est. 1.7 bn rows) that are the only way the table's ever queried - and it's blindingly fast: 51ms to retrieve any single row even ...
    AchAch
    May 13, 2013 at 3:01 pm
    May 20, 2013 at 2:12 pm
  • I have two tables that are nearly identical, yet the same query runs 100x slower on the newer one. The two tables have the same number of rows (+/- about 1%), and are roughly the same size: db= ...
    Craig JamesCraig James
    May 1, 2013 at 11:35 pm
    May 2, 2013 at 1:51 am
  • Hi, I have a database where one of my tables (Adverts) are requested a LOT. It's a relatively narrow table with 12 columns, but the size is growing pretty rapidly. The table is used i relation to ...
    Niels Kristian SchjødtNiels Kristian Schjødt
    May 22, 2013 at 2:37 pm
    Jun 3, 2013 at 4:49 pm
  • Hello, I am testing performance of postgresql application using pgbench. I am getting spike in results(graphs) as shown in attached graph due to throughput drop at that time. pgbench itself doing ...
    Sachin D. Bhosale-KotwalSachin D. Bhosale-Kotwal
    May 23, 2013 at 11:39 am
    May 24, 2013 at 1:22 pm
  • Hello, After executing make install for pg_statsinfo when i start the server i see error ERROR: could not connect to repository WARNING: writer discards 1 items LOG: pg_statsinfo launcher shutting ...
    Sameer ThakurSameer Thakur
    May 21, 2013 at 11:56 am
    May 22, 2013 at 1:27 am
  • Dear Tom, I beg to disagree, the performance of a select * query and the select b.id query are both "hot". The result in a fundamentally different query plan (and performance). Combined with the ...
    Stefan de KoninkStefan de Konink
    May 1, 2013 at 3:45 pm
    May 1, 2013 at 8:07 pm
  • Two questions Please 1.) Is there any wa= y to clear the cache so that we can ensure that when we run "expl= ain analyze" on a query and make some minor adjustments to that query a= nd re-execute, ...
    FburgessFburgess
    May 31, 2013 at 4:33 pm
    May 31, 2013 at 4:58 pm
  • I am using postgresql 9.2, and we are getting error like - System.Data.EntityException: The underlying provider failed on Open. --- Devart.Data.PostgreSql.PgSqlException: Stream already closed!!!. I ...
    Aup20Aup20
    May 25, 2013 at 1:46 pm
    May 25, 2013 at 9:00 pm
  • Howdy, Environment: Postgres 8.4.15 Ubuntu 10.04 Syslog view def: nms=# \d syslog View "public.syslog" Column | Type | Modifiers ----------+-----------------------------+----------- ip | inet | ...
    Samuel StearnsSamuel Stearns
    May 21, 2013 at 11:17 pm
    May 21, 2013 at 11:33 pm
  • Hi, I'm experiencing a very slow CTE query (see below). When I split the three aggregations into three separate views, its' decent fast. So I think it's due to the planner. Any ideas like ...
    Stefan KellerStefan Keller
    May 18, 2013 at 7:54 pm
    May 18, 2013 at 9:44 pm
  • - I have a problem with some files on a postgresql 9.0 on windows: 2013-05-10 12:49:08 EDT ERROR: could not stat file "base/773074/30352481": Permission denied 2013-05-10 12:49:08 EDT STATEMENT ...
    Desbiens, EricDesbiens, Eric
    May 13, 2013 at 1:05 pm
    May 14, 2013 at 12:45 pm
  • Hello, I am trying to find predicate information for a given SQL query plan as provided by Oracle using DBMS_XPLAN. I am looking at the EXPLAIN command for getting this query plan information, with ...
    Sameer ThakurSameer Thakur
    May 14, 2013 at 9:23 am
    May 14, 2013 at 9:30 am
  • Hi, I'm experiencing a very slow CTE query (see below). When I split the three aggregationns into separate views, its' decent fast. So I think it's due to the planner. Any ideas how to reformulate ...
    Stefan KellerStefan Keller
    May 18, 2013 at 7:50 pm
    May 18, 2013 at 7:50 pm
Group Navigation
period‹ prev | May 2013 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions26
posts255
users79
websitepostgresql.org
irc#postgresql

79 users for May 2013

Greg Smith: 16 posts Mark Kirkwood: 16 posts Merlin Moncure: 15 posts Anne Rosset: 9 posts Igor Neyman: 9 posts Robert Haas: 8 posts Simon Riggs: 8 posts Jeff Janes: 7 posts Josh Berkus: 7 posts Scott Marlowe: 7 posts Shaun Thomas: 7 posts Tom Lane: 7 posts Fburgess: 6 posts Jonathan Morra: 6 posts Amit Kapila: 5 posts Tomas Vondra: 5 posts Andres Freund: 4 posts Craig James: 4 posts Cuong Hoang: 4 posts Evgeny Shishkin: 4 posts
show more
Archives