FAQ

PostgreSQL > pgsql-performance > March 2012

Search Discussions

28 discussions - 195 posts

  • I'd be grateful for advice on specifying the new server We presently have one main database server which is performing well. As our services expand we are thinking of bringing another database server ...
    Rory Campbell-LangeRory Campbell-Lange
    Mar 4, 2012 at 9:59 am
    Mar 8, 2012 at 4:18 pm
  • Hi, We're running a web-based application powered by PostgreSQL. Recently, we've developed a "new" separate Java-based standalone (daemon process) threaded program that performs both read and write ...
    GnanakumarGnanakumar
    Mar 22, 2012 at 7:29 am
    Mar 23, 2012 at 2:09 pm
  • Hi folks, I have a system that racks up about 40M log lines per day. I'm able to COPY the log files into a PostgreSQL table that looks like this: CREATE TABLE activity_unlogged ( user_id ...
    Alessandro GagliardiAlessandro Gagliardi
    Mar 1, 2012 at 6:27 pm
    Mar 1, 2012 at 8:12 pm
  • PostgreSQL 9.0.x We have around ten different applications that use the same database. When one particular application is active it does an enormous number of inserts. Each insert is very small ...
    Campbell, LanceCampbell, Lance
    Mar 29, 2012 at 5:59 pm
    Apr 2, 2012 at 7:14 am
  • Disclaimer: this is a re-post, since I wasn't subscribed the first time I posted. Pardon if this is a duplicate.] The following query is abysmally slow (e.g. 7 hours+). The goal is to find "among the ...
    Robert PoorRobert Poor
    Mar 17, 2012 at 8:56 pm
    Mar 19, 2012 at 4:46 pm
  • Hi, we are currently seeing some strange performance issues related to our Postgresql Database. Our Setup currently contains: - 1 Master with 32GB Ram and 6 x 100GB SSDs in RAID10 and 2 Quad Core ...
    Sebastian MelchiorSebastian Melchior
    Mar 23, 2012 at 12:39 am
    May 8, 2012 at 4:18 pm
  • Hello, my example query (and explain) is: $ explain SELECT count(*) from (select * from users_profile order by id) u_p; QUERY PLAN ...
    Marcin MirosławMarcin Mirosław
    Mar 1, 2012 at 11:45 am
    Mar 1, 2012 at 9:29 pm
  • Have run across some memory behavior on Linux I've never seen before. Server running RHEL6 with 96GB of RAM. Kernel 2.6.32 PostgreSQL 9.0 208GB database with fairly random accesses over 50% of the ...
    Joshua BerkusJoshua Berkus
    Mar 27, 2012 at 8:06 pm
    Sep 13, 2012 at 7:00 pm
  • PostgreSQL 9.0.x When PostgreSQL storage is using a relatively large raid 5 or 6 array is there any value in having your tables distributed across multiple tablespaces if those tablespaces will ...
    Campbell, LanceCampbell, Lance
    Mar 30, 2012 at 2:46 pm
    Mar 31, 2012 at 1:43 pm
  • Where I work we are starting to look at using SSDs for database server storage. Despite the higher per unit cost it is quite attractive to replace 6-8 SAS drives in RAID 10 by a pair of SSD in RAID 1 ...
    Mark KirkwoodMark Kirkwood
    Mar 5, 2012 at 10:37 pm
    Mar 7, 2012 at 9:45 am
  • (from #postgresql IRC on freenode) darkblue_b I did an interesting experiment the other day davidfetter_vmw .. davidfetter_vmw do tell darkblue_b well you know I do these huge monolithic postGIS ...
    MaplabsMaplabs
    Mar 15, 2012 at 4:29 am
    Mar 17, 2012 at 4:16 pm
  • It is a discussion about the transaction ID wraparound in PostgreSQL. However, what is the fundamental definition if transaction ID. select * from table where ID=1:10000 it is consider as one ...
    DdgsDdgs
    Mar 9, 2012 at 3:30 pm
    Mar 12, 2012 at 4:57 pm
  • Hi group, I have the following table with millions of rows CREATE TABLE table1 ( col1 text, col1 text, doc text ) select col1 from table1 group by col1 limit 2; select distinct on (col1) col1 from ...
    Francois DeliegeFrancois Deliege
    Mar 27, 2012 at 8:58 pm
    Mar 28, 2012 at 4:40 pm
  • Hi folks; I am trying to continue profiling which in turn feeds query and index tuning changes for the AKCS-WWW forum software, and appear to have no good way to do what I need to do -- or I've ...
    Karl DenningerKarl Denninger
    Mar 16, 2012 at 2:32 pm
    Mar 16, 2012 at 3:38 pm
  • I've taken the liberty of reposting this message as my addendum to a long thread that I started on the subject of adding a new db server to our existing 4-year old workhorse got lost in discussion. ...
    Rory Campbell-LangeRory Campbell-Lange
    Mar 9, 2012 at 11:16 am
    Mar 10, 2012 at 3:12 pm
  • I've complained many times that select (f()).*; will execute f() once for each returned field of f() since the server essentially expands that into: select f().a, f().b; try it yourself, see: create ...
    Merlin MoncureMerlin Moncure
    Mar 5, 2012 at 11:15 pm
    Mar 6, 2012 at 7:29 pm
  • Hi, (Sorry about double post, I just registered on the performance mailing list, but sent the mail from the wrong account - if anyone responds, please respond to this address) Another issue I have ...
    Claus StadlerClaus Stadler
    Mar 3, 2012 at 10:43 pm
    Apr 3, 2012 at 3:35 pm
  • Hello I am wondering why the time reported by \timing in psql is not the same as the time reported by duration in the log file when log_duration or log_min_duration_statement are on?. I can not find ...
    Rafael MartinezRafael Martinez
    Mar 21, 2012 at 11:42 am
    Mar 21, 2012 at 2:49 pm
  • I'm using gin index for my full text search engine in production. These days the gin index size grows to 20-30G and the system started to suffer with periodical insert hanging. This is same as ...
    Rural HunterRural Hunter
    Mar 13, 2012 at 5:43 am
    Mar 15, 2012 at 3:49 am
  • I just upgraded to 9.1 and downloaded EnterpriseDB Tuning wizard, but the list of servers in ComboBox support only 8.2, 8.3 i 8.4 version and x86 build. How can I tune 9.1, 64 bit version? Is there ...
    Michael KopljanMichael Kopljan
    Mar 9, 2012 at 3:07 pm
    Mar 13, 2012 at 12:55 am
  • Hi all, today I've noticed this link on HN: http://plasma.cs.umass.edu/emery/hoard Seems like an interesting option for systems with a lot of CPUs that are doing a lot of alloc operations. Right now ...
    Tomas VondraTomas Vondra
    Mar 26, 2012 at 9:50 am
    Mar 26, 2012 at 4:00 pm
  • Hello We are having some performance problems with an application that uses prepared statement heavily. We have found out that it creates-executes-destroys a prepared statement *per* statement it ...
    Rafael MartinezRafael Martinez
    Mar 21, 2012 at 11:21 am
    Mar 21, 2012 at 1:44 pm
  • We are looking for advice on the RAID controller cards with battery back cache for 10K SAS disks with RAID 10. Any suggestion for the best card and settings to use for heavy write transactions. See ...
    See Sing LauSee Sing Lau
    Mar 7, 2012 at 5:49 pm
    Mar 12, 2012 at 4:43 pm
  • We have an optimizer problem regarding partitioned tables on 8.4.11. We started partitioning a large table containing approx. 1 billion records. So far, there is only the master table, called ...
    Marc SchablewskiMarc Schablewski
    Mar 5, 2012 at 3:11 pm
    Mar 5, 2012 at 3:44 pm
  • Hello, We have a table with about 60M records, almost all of which in one of two statuses ('done', 'failed') and a few of them, usually < 1000, in different transient statuses. We also have a partial ...
    Daniele VarrazzoDaniele Varrazzo
    Mar 1, 2012 at 4:40 pm
    Mar 1, 2012 at 9:18 pm
  • Baron Swartz's recent post [1] on working set size got me to thinking. I'm well aware of how I can tell when my database's working set exceeds available memory (cache hit rate plummets, performance ...
    Peter van HardenbergPeter van Hardenberg
    Mar 26, 2012 at 7:11 am
    Mar 27, 2012 at 7:58 pm
  • I have a table with serveral million records. they are divided into about one hundred catagory(column cid). I created index includes the cid as the first column. I had a problem with some cids they ...
    Rural HunterRural Hunter
    Mar 15, 2012 at 8:32 am
    Mar 15, 2012 at 11:44 am
  • Hello, Due to a large database size, my weekend database backup (pg_dumpall) takes about 12 hours to complete. Additionally, I add the --no-unlogged-table-data option to skip any volatile tables. One ...
    McGehee, RobertMcGehee, Robert
    Mar 11, 2012 at 5:38 pm
    Mar 11, 2012 at 5:38 pm
Mar 2012
Group Navigation
period‹ prev | Mar 2012 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions28
posts195
users61
websitepostgresql.org
irc#postgresql

61 users for March 2012

Tomas Vondra: 17 posts Kevin Grittner: 13 posts Scott Marlowe: 13 posts Merlin Moncure: 9 posts Rory Campbell-Lange: 9 posts Tom Lane: 8 posts Claudio Freire: 7 posts Alessandro Gagliardi: 6 posts Gnanakumar: 6 posts Andrew Dunstan: 5 posts Craig James: 5 posts Andy Colson: 4 posts Jeff Janes: 4 posts Joshua Berkus: 4 posts Peter van Hardenberg: 4 posts Robert Poor: 4 posts Rural Hunter: 4 posts Sebastian Melchior: 4 posts Yeb Havinga: 4 posts Ants Aasma: 3 posts
show more
Archives