FAQ

Search Discussions

35 discussions - 276 posts

  • Hi, We have an application that is mission critical, normally very fast, but when an I/O or CPU bound transaction appears, the mission critical application suffers. Is there a way go give some kind ...
    Carlos H. ReimerCarlos H. Reimer
    Nov 22, 2006 at 2:11 am
    Jan 20, 2007 at 12:01 am
  • Hi, We've migrated one of our servers from pg 7.4 to 8.1 and from times to times (4 hours) the server start doing a lot of context switching and all transactions become very slow. The average context ...
    CreimerCreimer
    Nov 3, 2006 at 12:34 pm
    Nov 16, 2006 at 9:01 pm
  • I see many of you folks singing the praises of the Areca and 3ware SATA controllers, but I've been trying to price some systems and am having trouble finding a vendor who ships these controllers with ...
    Jeff FrostJeff Frost
    Nov 17, 2006 at 5:45 pm
    Nov 26, 2006 at 11:34 pm
  • I'm trying to optimize a PostgreSQL 8.1.5 database running on an Apple G5 Xserve (dual G5 2.3 GHz w/ 8GB of RAM), running Mac OS X 10.4.8 Server. The queries on the database are mostly reads, and I ...
    Brian WipfBrian Wipf
    Nov 17, 2006 at 12:33 am
    Nov 27, 2006 at 4:21 pm
  • [Madison Kelly - Thu at 10:25:07AM -0500] I think you are right, and in any case, I don't think the niceness value won't help much if the bottleneck is iowait. In our application, I've made a special ...
    Tobias BroxTobias Brox
    Nov 2, 2006 at 4:01 pm
    Nov 9, 2006 at 5:29 pm
  • Hello all, I've been struggling with some performance questions regarding our Postgres databases. Here's the background: We run 4 ~25-30Gb databases which cache information from eBay. These databases ...
    Paul LathropPaul Lathrop
    Nov 30, 2006 at 11:31 pm
    Dec 1, 2006 at 10:36 am
  • Hi, Are there guidelines (or any empirical data) available how to determine how often a table should be vacuumed for optimum performance or is this an experience / trial-and-error thing? TIA -- ...
    Joost KraaijeveldJoost Kraaijeveld
    Nov 26, 2006 at 11:24 am
    Nov 27, 2006 at 6:59 pm
  • Hi all, I have a postgres installation thats running under 70-80% CPU usage while an MSSQL7 installation did 'roughly' the same thing with 1-2% CPU load. Here's the scenario, 300 queries/second ...
    GopalGopal
    Nov 23, 2006 at 10:38 pm
    Nov 28, 2006 at 4:51 pm
  • Hi all, I've got a script (perl, in case it matters) that I need to run once a month to prepare statements. This script queries and updates the database a *lot*. I am not concerned with the ...
    Madison KellyMadison Kelly
    Nov 2, 2006 at 3:15 pm
    Nov 6, 2006 at 1:15 pm
  • I've got a long-running, update-heavy transaction that increasingly slows down the longer it runs. I would expect that behavior, if there was some temp file creation going on. But monitoring vmstat ...
    BenBen
    Nov 1, 2006 at 6:51 am
    Nov 1, 2006 at 7:34 pm
  • [ cc'ing to pgsql-performance because of performance issue for hash indexes ] "Balazs Nagy" <bnagy@thenewpush.com writes: Wow, you're trying to build an 8GB hash index? Considering that hash indexes ...
    Tom LaneTom Lane
    Nov 10, 2006 at 11:55 pm
    Nov 17, 2006 at 3:36 pm
  • Dear All Looking at the processes running on our server, it appears that each time a web server program makes a call to the database server, we start a new process on the database server which ...
    Hilary ForbesHilary Forbes
    Nov 9, 2006 at 12:47 pm
    Nov 17, 2006 at 11:18 am
  • Hi! Im new to PostgreSQL. My current project uses PostgreSQL 7.3.4. the problem is like this: I have a table with 94 fields and a select with only one resultset in only one client consumes about 0.86 ...
    AMIR FRANCO D. JOVENAMIR FRANCO D. JOVEN
    Nov 15, 2006 at 11:44 am
    Nov 16, 2006 at 8:54 am
  • Hi, PostgreSQL 8.1 (and, back then, 7.4) have the tendency to underestimate the costs of sort operations, compared to index scans. The Backend allocates gigs of memory (we've set sort_mem to 1 gig), ...
    Markus SchaberMarkus Schaber
    Nov 22, 2006 at 1:51 pm
    Nov 23, 2006 at 3:20 pm
  • Hello, I do not understand, why Postgres very ofter starts execution from sub-select instead of doing main select and then proceeding to "lite" sub-selects. For example: (example is quite weird, but ...
    Nikolay SamokhvalovNikolay Samokhvalov
    Nov 2, 2006 at 11:07 am
    Nov 3, 2006 at 2:51 pm
  • From where do you recall this? It looks to me like managing the block reservation window seems like a pretty involved process - at first glance way more sophisticated than a hardcoded 8 blocks. ...
    Ron MayerRon Mayer
    Nov 8, 2006 at 5:14 pm
    Nov 23, 2006 at 4:44 pm
  • I have 700 lines of non-performant pgSQL code that I'd like to profile to see what's going on. What's the best way to profile stored procedures? Thanks, Drew
    Drew WilsonDrew Wilson
    Nov 3, 2006 at 11:12 am
    Nov 3, 2006 at 7:40 pm
  • Here is a potential problem with the auto-vacuum daemon, and I'm wondering if anyone has considered this. To avoid transaction ID wraparound, the auto-vacuum daemon will periodically determine that ...
    Steven FlattSteven Flatt
    Nov 1, 2006 at 8:45 pm
    Nov 2, 2006 at 3:54 pm
  • Gentlemen, I use a modeling language which compiles down to a fairly verbose SQL DDL. If I use semantically transparent identifiers in the modeling language, the compiler easily generates identifiers ...
    Alessandro BarettaAlessandro Baretta
    Nov 29, 2006 at 11:32 am
    Dec 1, 2006 at 3:16 pm
  • Hi all, I have a table with statistics with more than 15 million rows. I'd like to delete the oldest statistics and this can be about 7 million rows. Which method would you recommend me to do this? ...
    ArnauArnau
    Nov 24, 2006 at 7:26 pm
    Nov 27, 2006 at 8:44 am
  • I've been trying to optimize a Linux system where benchmarking suggests large performance differences between the various wal_sync_method options (with o_sync being the big winner). I started that by ...
    Greg SmithGreg Smith
    Nov 23, 2006 at 6:40 am
    Nov 24, 2006 at 4:06 am
  • Hi All, I have some problems with my sql query : select distinct INTEGER_VALUE,DATE_VALUE,EI_ID,VALUE_TYPE,FLOAT_VALUE,ID,TEXT_VALUE,CATEGORY_ID,STRING_VALUE,CATEGORYATTR_ID,NAME from ((( select ...
    Jérôme BENOISJérôme BENOIS
    Nov 21, 2006 at 2:45 pm
    Nov 21, 2006 at 5:01 pm
  • Hi, We've migrated one of our servers from pg 7.4 to 8.1 and from times to times (4 hours) the server start doing a lot of context switching and all transactions become very slow. The average context ...
    Carlos H. ReimerCarlos H. Reimer
    Nov 1, 2006 at 5:23 am
    Nov 21, 2006 at 2:48 pm
  • Hi , I wanted to know , how the start up cost is computed in postgresql . can u give me an example to illustrate the estimation of start up cost . thanku raa .
    Rakesh kumarRakesh kumar
    Nov 18, 2006 at 9:33 am
    Nov 19, 2006 at 4:05 am
  • Though I've read recent threads, I'm unsure if any matches my case. We have 2 tables: revisions and revisions_active. revisions contains 117707 rows, revisions_active 17827 rows. DDL: ...
    Hannes DorbathHannes Dorbath
    Nov 6, 2006 at 2:09 pm
    Nov 6, 2006 at 2:33 pm
  • A few months ago a couple guys got "bragging rights" for having the most separate databases. A couple guys claimed several hundred databases and one said he had several thousand databases. The ...
    Craig A. JamesCraig A. James
    Nov 15, 2006 at 4:38 pm
    Nov 15, 2006 at 5:43 pm
  • I'm executing the following query: select hf.mailbox,hf.uid,hf.position,hf.part,hf.field,hf.value, af.address,a.name,a.localpart,a.domain from header_fields hf left join address_fields af using ( ...
    Abhijit Menon-SenAbhijit Menon-Sen
    Nov 10, 2006 at 5:15 am
    Nov 10, 2006 at 7:25 am
  • posting this here instead of the GENERAL list...richard is right, this is more of a performance question than a general question. thanks, Mark Jensen ----- Forwarded Message ---- From: Mark Jensen ...
    Mark JensenMark Jensen
    Nov 29, 2006 at 7:43 pm
    Nov 29, 2006 at 9:55 pm
  • This really should have been asked on pgsql-performance and would probably get a better response there.. On Sun, Nov 26, 2006 at 16:35:52 +0000, Michael Simms wrote: This sounds like you either need ...
    Bruno Wolff IIIBruno Wolff III
    Nov 28, 2006 at 4:25 am
    Nov 28, 2006 at 11:34 am
  • Hi everyone, does anyone have the TPC-H benchmark for PostgreSQL? Can you tell me where can i find the database and queries? Thks, Felipe
    Felipe Rondon RochaFelipe Rondon Rocha
    Nov 24, 2006 at 2:08 pm
    Nov 24, 2006 at 4:31 pm
  • Berner, First, I've corrected you e-mail so that it goes to the list, and not to me directly. Yes. The lead contributor to Bacula is a active PostgreSQL project participant; I'll see if he'll look ...
    Josh BerkusJosh Berkus
    Nov 17, 2006 at 6:45 pm
    Nov 18, 2006 at 10:09 am
  • Hi, The documentation says that function blocks with exceptions are far costlier than without one. So if I need to implement an INSTEAD OF trigger (after checking for unique constraint violations) ...
    RobinsRobins
    Nov 2, 2006 at 12:46 pm
    Nov 2, 2006 at 11:51 pm
  • Hi List; I have a client looking to host/co-locate multiple PostgreSQL clusters (inclusive of PL/pgSQL application code) per server. I did some co-location work several years back with one of the ...
    Kevin KempterKevin Kempter
    Nov 29, 2006 at 6:09 pm
    Nov 29, 2006 at 6:09 pm
  • Hi. After I had my hands on an Intel MacBook Pro (2 GHz Core Duo, 1GB RAM), I made some comparisons between the machines I have here at the company. For the ease of it and the simple way of ...
    Guido NeitzerGuido Neitzer
    Nov 27, 2006 at 8:09 am
    Nov 27, 2006 at 8:09 am
  • To support migration of existing queries, it would be nice not to have to rewrite EXISTS clauses as IN clauses. Here is one example of a query which optimizes poorly: DELETE FROM "CaseDispo" WHERE ...
    Kevin GrittnerKevin Grittner
    Nov 3, 2006 at 7:25 pm
    Nov 3, 2006 at 7:25 pm
Group Navigation
period‹ prev | Nov 2006 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions35
posts276
users98
websitepostgresql.org
irc#postgresql

98 users for November 2006

Tom Lane: 24 posts Richard Huxton: 13 posts Guido Neitzer: 10 posts Jim Nasby: 10 posts Craig A. James: 9 posts Ron Mayer: 9 posts Luke Lonergan: 8 posts Merlin Moncure: 8 posts Andreas Kostyrka: 7 posts Madison Kelly: 7 posts Simon Riggs: 7 posts Ben: 6 posts Joshua D. Drake: 6 posts Markus Schaber: 6 posts Carlos H. Reimer: 5 posts Cosimo Streppone: 5 posts Jeff Frost: 5 posts Arjen van der Meijden: 4 posts Brian Hurt: 4 posts Josh Berkus: 4 posts
show more
Archives