FAQ

Search Discussions

53 discussions - 538 posts

  • There are many other things to fix first. One of them would be optimizer decisions when a temp table is involved. I would also vote for wait event interface, tracing and hints, much rather than ...
    Mladen GogalaMladen Gogala
    Feb 1, 2011 at 11:44 pm
    Jun 6, 2011 at 8:21 am
  • I am having huge performance problems with a table. Performance deteriorates every day and I have to run REINDEX and ANALYZE on it every day. auto vacuum is on. yes, I am reading the other thread ...
    FelixFelix
    Feb 4, 2011 at 2:46 pm
    Feb 17, 2011 at 3:22 pm
  • Hi list, first time for me here, hope you're not dealing too severely with me regarding guidelines. Giving my best. We are running PostgreSQL 8.4.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc ...
    Thomas PöhlerThomas Pöhler
    Feb 15, 2011 at 5:56 pm
    Feb 17, 2011 at 10:17 am
  • Each night we run over a 100,000 "saved searches" against PostgreSQL 9.0.x. These are all complex SELECTs using "cube" functions to perform a geo-spatial search to help people find adoptable pets at ...
    Mark StosbergMark Stosberg
    Feb 3, 2011 at 3:24 pm
    Feb 7, 2011 at 10:02 am
  • Hi foks This is an old chestnut which I've found a number of online threads for, and never seen a clever answer to. It seems a common enough idiom that there might be some slicker way to do it, so I ...
    Dave CrookeDave Crooke
    Feb 24, 2011 at 7:55 pm
    Feb 26, 2011 at 9:53 pm
  • Hi, We have installed PostgreSQL9 and setup standby(s). Now we have to test the performance before we migrate all the data from Informix. The PostgreSQL9 that we installed is the Linux version from ...
    Selva manickarajaSelva manickaraja
    Feb 28, 2011 at 3:26 am
    Mar 3, 2011 at 5:20 am
  • Hi, all. All this optimizer vs hint thread reminded me about crazy idea that got to my head some time ago. I currently has two problems with postgresql optimizer 1) Dictionary tables. Very usual ...
    Віталій ТимчишинВіталій Тимчишин
    Feb 4, 2011 at 8:03 am
    Mar 1, 2011 at 3:37 pm
  • I'm setting up a dedicated linux postgres box with 2x300GB 15k SAS drive in a RAID 1, though if future load dictates we would like to be able to upgrade to RAID 10. The hosting provider offers the ...
    Dan BirkenDan Birken
    Feb 2, 2011 at 11:21 pm
    Feb 6, 2011 at 12:15 pm
  • Hi, I've been facing a very large (more than 15 seconds) planning time in a partitioned configuration. The amount of partitions wasn't completely crazy, around 500, not in the thousands. The problem ...
    Marc CousinMarc Cousin
    Feb 28, 2011 at 9:38 am
    Mar 2, 2011 at 3:40 pm
  • We perform over 1,000,000 searches each day for "adoptable shelter pets near your zipcode". We already have adequate performance for these searches using the "cube" contrib, but the new KNN work in ...
    Mark StosbergMark Stosberg
    Feb 17, 2011 at 2:41 pm
    Oct 29, 2011 at 2:46 pm
  • Dear list, Is there an exhaustive list of what takes what locks and how long they last? I'm asking because we just had some trouble doing a hot db change to an 8.3.6 system. I know it is an old ...
    Nikolas EverettNikolas Everett
    Feb 1, 2011 at 7:19 pm
    Feb 23, 2011 at 5:59 pm
  • Hi, How can we boost performance of queries containing pattern matching characters? In my case, we're using a percent sign (%) that matches any string of zero or more characters. QUERY: DELETE FROM ...
    GnanakumarGnanakumar
    Feb 14, 2011 at 7:03 am
    Feb 14, 2011 at 4:53 pm
  • I'm using PostgreSQL 8.3.3 and I have a view that does a UNION ALL on two joins and it doesn't seem to want to push the IN (subquery) optimization down into the plan for the two queries being ...
    Dave JohansenDave Johansen
    Feb 24, 2011 at 4:10 am
    Mar 2, 2011 at 2:26 pm
  • I'm running all this on a 9.0 server with good enough hardware. The query is: SELECT news.id AS news_id , news.layout_id , news.news_relation_id , news.author_id , news.date_created , ...
    Ivan VorasIvan Voras
    Feb 4, 2011 at 12:08 pm
    Mar 9, 2011 at 4:48 pm
  • This query: select p.id,p.producer_id,visa.variation_item_id, vi.qtyavail from variation_item_sellingsite_asin visa inner join product p on p.id = visa.product_id inner join variation_item vi on ...
    Laszlo NagyLaszlo Nagy
    Feb 8, 2011 at 2:24 pm
    Sep 1, 2012 at 4:25 pm
  • Hi all, Running PostgreSQL 8.4.7 (backport package from Debian Lenny). I have some queries that are based on views, and an engine adds a few clauses (like NULLS LAST). One of these queries has a ...
    Mathieu De ZutterMathieu De Zutter
    Feb 23, 2011 at 7:27 pm
    Mar 11, 2011 at 4:46 am
  • All, Seeing an issue which is new on me. On a mostly idle PostgreSQL server, the stats collector is rewriting the entire stats file twice per second. Version: 8.4.4 Server: Ubuntu, kernel 2.6.32 ...
    Josh BerkusJosh Berkus
    Feb 4, 2011 at 7:08 pm
    Feb 8, 2011 at 9:10 am
  • I am searching what would be the best hardware combination to a new server i have to install, the new server will have a Postgresql 9.0 with a database of about 10gb, the database part it is not the ...
    LinosLinos
    Feb 6, 2011 at 6:23 pm
    Feb 6, 2011 at 11:35 pm
  • I found that "LIKE", "= ANY (...)", "LIKE .. OR LIKE .." against a text field used the index correctly, but not "LIKE ANY (...)". Would that be a bug? ---- Here is my table and index: CREATE TABLE ...
    Sam WongSam Wong
    Feb 25, 2011 at 1:31 pm
    Jun 6, 2011 at 9:47 am
  • Hi, We were running full vacuum on DB when we encountered the error below; INFO: analyzing "public.bkup_access_control" INFO: "bkup_access_control": scanned 14420 of 14420 pages, containing 1634113 ...
    Bhakti GhatkarBhakti Ghatkar
    Feb 26, 2011 at 7:07 am
    Mar 4, 2011 at 2:14 pm
  • Hi, I am trying to understand how indexes works to get the most of them. First I would like to know if there is more advantage than overhead to split an index in several ones using conditions e.g. ...
    Sylvain RabotSylvain Rabot
    Feb 8, 2011 at 12:15 am
    Feb 27, 2011 at 6:21 pm
  • Hello, I got a disk array appliance of 8 disks 1T each (UltraStor RS8IP4). It will be used solely by PostgresQL database and I am trying to choose the best RAID level for it. The most priority is for ...
    SergeySergey
    Feb 13, 2011 at 8:12 pm
    Feb 14, 2011 at 8:02 am
  • Hey, Does anyone have the hardware to test FlashCache with PostgreSQL? http://perspectives.mvdirona.com/2010/04/29/FacebookFlashcache.aspx I'd be interested to hear how it performs ... -- -- Josh ...
    Josh BerkusJosh Berkus
    Feb 28, 2011 at 7:10 pm
    Mar 7, 2011 at 3:48 pm
  • I am trying to clean up our schema by removing any indices which are not being used frequently or at all. Using pgadmin, looking at the statistics for an index, I see various pieces of information: ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Feb 23, 2011 at 7:14 pm
    Feb 24, 2011 at 7:36 pm
  • Hi, We're using PostgreSQL v8.2.3 on RHEL5. I'm developing a PostgreSQL plpgsql function for one of our application report. When I try to run the function multiple times (even twice or thrice), I'm ...
    GnanakumarGnanakumar
    Feb 24, 2011 at 9:56 am
    Feb 24, 2011 at 3:59 pm
  • Hello, When executing huge (10kb), hibernate-generated queries I noticed that when executed remotly over high-latency network (ping to server 200-400ms), the query takes a lot longer to complete. ...
    Clemens EissererClemens Eisserer
    Feb 19, 2011 at 10:30 am
    Feb 21, 2011 at 9:08 pm
  • Hello list, does `postgres (PostgreSQL) 8.4.5' use the LIMIT of a query when it is run on a partitioned-table or am I doing something wrong? It looks as if postgres queries all partitions and then ...
    Kim A. BrandtKim A. Brandt
    Feb 15, 2011 at 2:30 pm
    Feb 16, 2011 at 7:24 am
  • Hi My question is: Was there any major optimizer change between 8.3.10 to 8.3.14? I'm getting a difference in explain plans that I need to account for. We are running production pg8.3.10, and are ...
    Mark RostronMark Rostron
    Feb 14, 2011 at 1:57 am
    Feb 14, 2011 at 4:40 am
  • I implemented table partitioning, and it caused havoc with a "select max(id)" on the parent table - the query plan has changed from a lightningly fast backwards index scan to a deadly seq scan. Both ...
    Tobias BroxTobias Brox
    Feb 4, 2011 at 11:25 pm
    Feb 5, 2011 at 8:49 am
  • I run into performance problem when I pass the condition/variable in binding ways, however if I put them in the query string it's absolutely fine. ---- Here is my table and index: CREATE TABLE ...
    Sam WongSam Wong
    Feb 25, 2011 at 3:09 am
    Feb 25, 2011 at 1:24 pm
  • create table a( address1 int,address2 int,address3 int) create table b(address int[3]) I have created two tables. In the first table i am using many fields to store 3 address. as well as in b table, ...
    DbaDba
    Feb 14, 2011 at 11:33 am
    Feb 24, 2011 at 8:23 am
  • Hello, I was under the impression that pg_dumpall didn't affect database performance when dumping while the db is live. However I have evidence to the contrary now - queries that are run during the ...
    Mark MikulecMark Mikulec
    Feb 15, 2011 at 6:41 pm
    Feb 15, 2011 at 7:13 pm
  • Hi all, I have a execution planner related issue that I'd like to have some help in understanding a bit deeper - I have a table which basically contains fields for a value, a timestamp and a record ...
    Mikkel LauritsenMikkel Lauritsen
    Feb 4, 2011 at 3:29 pm
    Feb 7, 2011 at 10:48 am
  • Hi, I have a Server with Fedora Core 11, Tomcat and Postgresql 8.3. With Hardware: * 8GB RAM * 8 processors Intel Xeon E5520 @2.27GHz * 250GB SATA DISK Actually, it serves at most 250 connections. ...
    Cesar ArrietaCesar Arrieta
    Feb 2, 2011 at 6:15 pm
    Feb 3, 2011 at 2:55 am
  • We're building a new database box. With the help of Gregory Smith's book, we're benchmarking the box: We want to know that we've set it up right, we want numbers to go back to if we have trouble ...
    Wayne ConradWayne Conrad
    Feb 2, 2011 at 12:28 am
    Feb 2, 2011 at 8:22 pm
  • Hi, im César, im developing an app that saves information included in "pg_stat_activity" view in order to monitor querys. The objective of this app is to gather information about querys that take to ...
    Cesar ArrietaCesar Arrieta
    Feb 2, 2011 at 3:21 pm
    Feb 2, 2011 at 5:24 pm
  • Hi, I came across some tools such as Tsung and Bristlecone. Are these fine or are there any better tools well suited for this DB? Thank you. Warmest Regards, Selvam
    Selva manickarajaSelva manickaraja
    Feb 28, 2011 at 4:26 pm
    Mar 1, 2011 at 1:48 am
  • Hi, I have a java application which generates inperformant query plans. I checked the query plan from the java application via auto_explain module and I compared the plan which I generate in psql. ...
    Uwe BartelsUwe Bartels
    Feb 18, 2011 at 2:29 pm
    Feb 18, 2011 at 3:06 pm
  • All, I'm trying to estimate the size of my hot data set, and wanted to get some validation that I'm doing this correctly. Basically, I'm using the sum(heap_blks_read + idx_blks_read) from ...
    Chris HooverChris Hoover
    Feb 16, 2011 at 8:51 pm
    Feb 16, 2011 at 10:02 pm
  • Greetings to all, I use to run below query on my Postgres Database Server very often : select m.doc_category,p.heading,l.lat,l.lon,p.crawled_page_url,p.category,p.dt_stamp,p.crawled_page_id,p.content ...
    Adarsh SharmaAdarsh Sharma
    Feb 28, 2011 at 7:18 am
    Mar 3, 2011 at 9:07 am
  • Hi! can you help me with performance optimization on my machine I have 8 databases with ca. 1-2GB processor is: processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 23 model name : Intel(R) ...
    CroolycCroolyc
    Feb 28, 2011 at 9:41 am
    Feb 28, 2011 at 6:32 pm
  • Hi! can you help me with performance optimization on my machine I have 8 databases with ca. 1-2GB processor is: processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 23 model name : Intel(R) ...
    CroolycCroolyc
    Feb 28, 2011 at 9:44 am
    Feb 28, 2011 at 2:57 pm
  • P.S. I noticed inadvertently (by making a typo ;-) that not all of the columns in the DISTINCT ON are required to be part of the output, in which case it appears to reduce the DISTINCT ON to the ...
    Dave CrookeDave Crooke
    Feb 24, 2011 at 11:53 pm
    Feb 25, 2011 at 12:23 am
  • In normal circumstances does locking a table in access exclusive mode improve insert, update and delete operation performance on that table. Is MVCC disabled or somehow has less work to do? Cheers ...
    Jeremy PalmerJeremy Palmer
    Feb 17, 2011 at 5:14 am
    Feb 17, 2011 at 5:18 am
  • During heavy writes times we get the checkpoint too often error, what's the real knock down effect of checkpointing too often? The documents don't really say what is wrong with checkpointing too ...
    Strange, John WStrange, John W
    Feb 15, 2011 at 11:52 am
    Feb 15, 2011 at 5:51 pm
  • I have two identical tables. But the with of the fields are different. Need to know whether changing from varchar(100) to varchar(30) will increase the performance, or its just the memory access. -- ...
    DbaDba
    Feb 14, 2011 at 12:06 pm
    Feb 14, 2011 at 12:30 pm
  • Hi, I wanted to know, if there is some configuration in order tables dont get blocked for too long time?
    Cesar ArrietaCesar Arrieta
    Feb 11, 2011 at 6:35 pm
    Feb 11, 2011 at 7:20 pm
  • Howdy, Environment: Postgres 8.3.13 Solaris 10 I have a SELECT query that runs no problem standalone but when running within a perl script it intermittently core dumps. Random, no pattern to the ...
    Sam StearnsSam Stearns
    Feb 8, 2011 at 11:50 pm
    Feb 8, 2011 at 11:58 pm
  • Hi. I do small test of plsql and perl.Result is that perl may be 2xfaster in simple loops. CREATE OR REPLACE FUNCTION _.test1() RETURNS void AS $BODY$ declare i integer; j bigint := 0; begin for i in ...
    Pasman PasmańskiPasman Pasmański
    Feb 8, 2011 at 10:35 am
    Feb 8, 2011 at 10:46 am
  • Before I deploy some new servers, I figured I would do some benchmarking. Server is a Dual E5620, 96GB RAM, 16 x 450GB SAS(15K) drives. Controller is an Areca 1680 with 2GB RAM and battery backup. So ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Feb 6, 2011 at 8:04 am
    Feb 7, 2011 at 1:37 am
Group Navigation
period‹ prev | Feb 2011 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions53
posts538
users120
websitepostgresql.org
irc#postgresql

120 users for February 2011

Greg Smith: 46 posts Scott Marlowe: 41 posts Robert Haas: 34 posts Kevin Grittner: 25 posts Shaun Thomas: 25 posts Mladen Gogala: 24 posts Tom Lane: 18 posts Felix: 15 posts Josh Berkus: 14 posts Віталій Тимчишин: 14 posts Bruce Momjian: 11 posts David: 9 posts Mark Kirkwood: 9 posts Dave Johansen: 8 posts Mark Stosberg: 8 posts Dave Crooke: 7 posts Marti Raudsepp: 7 posts Pierre C: 7 posts Kenneth Marshall: 6 posts Merlin Moncure: 6 posts
show more
Archives