FAQ

PostgreSQL > pgsql-performance > June 2010

Search Discussions

48 discussions - 530 posts

  • We have a fairly unique need for a local, in-memory cache. This will store data aggregated from other sources. Generating the data only takes a few minutes, and it is updated often. There will be ...
    JgardnerJgardner
    Jun 15, 2010 at 2:17 am
    Jul 1, 2010 at 5:01 am
  • Hi, I found a slow part of the query: SELECT * date(extract(YEAR FROM m.taken)||'-1-1') d1,* * date(extract(YEAR FROM m.taken)||'-1-31') d2* FROM climate.city c, climate.station s, ...
    David JarvisDavid Jarvis
    Jun 11, 2010 at 12:48 am
    Jul 1, 2010 at 12:43 am
  • Hi, Sorry to revive an old thread but I have had this error whilst trying to configure my 32-bit build of postgres to run on a 64-bit Windows Server 2008 machine with 96GB of RAM (that I would very ...
    Tom WilcoxTom Wilcox
    Jun 2, 2010 at 10:58 am
    Jun 25, 2010 at 4:59 am
  • Some interesting data about different filesystems I tried with PostgreSQL and how it came out. I have an application that is backed in postgres using Java JDBC to access it. The tests were all done ...
    Jon ScheweJon Schewe
    Jun 4, 2010 at 12:27 pm
    Jun 6, 2010 at 7:48 am
  • Hi, I have the following query that needs tuning: psrdb=# explain analyze (SELECT psrdb(# MAX(item_rank.rank) AS maxRank psrdb(# FROM psrdb(# item_rank item_rank psrdb(# WHERE psrdb(# ...
    Anne RossetAnne Rosset
    Jun 10, 2010 at 5:50 pm
    Jun 10, 2010 at 9:20 pm
  • Hi, I was doing some benchmarking while changing configuration options to try to get more performance out of our postgresql servers and noticed that when running pgbench against 8.4.3 vs 8.4.4 on ...
    Max WilliamsMax Williams
    Jun 9, 2010 at 10:55 am
    Jun 11, 2010 at 4:50 pm
  • I cant seem to pinpoint why this query is slow . No full table scans are being done. The hash join is taking maximum time. The table dev4_act_action has only 3 rows. box is a 2 cpu quad core intel ...
    Anj AduAnj Adu
    Jun 3, 2010 at 5:48 pm
    Jun 11, 2010 at 1:49 pm
  • A scary phenomenon is being exhibited by the server , which is the server is slurping all the swap suddenly , some of the relevant sar -r output are: 10:30:01 AM kbmemfree kbmemused %memused ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Jun 25, 2010 at 9:55 am
    Jun 26, 2010 at 1:22 pm
  • Just curious if this would apply to PostgreSQL: http://queue.acm.org/detail.cfm?id=1814327 <http://queue.acm.org/detail.cfm?id=1814327 Now that I've read it, it seems like a no-brainer. So, how does ...
    Eliot GableEliot Gable
    Jun 15, 2010 at 3:21 am
    Jun 20, 2010 at 7:57 pm
  • PasteBin for the vmstat output http://pastebin.com/mpHCW9gt On Wed, Jun 23, 2010 at 8:22 PM, Rajesh Kumar Mallah wrote:
    Rajesh Kumar MallahRajesh Kumar Mallah
    Jun 23, 2010 at 2:54 pm
    Jun 29, 2010 at 3:29 pm
  • Hello, i have a set of unique data which about 150.000.000 rows. Regullary i get a list of data, which contains multiple times of rows than the already stored one. Often around 2.000.000.000 rows. ...
    Torsten ZühlsdorffTorsten Zühlsdorff
    Jun 1, 2010 at 3:30 pm
    Jun 9, 2010 at 10:51 am
  • Hi folks, is there a general problem with raid10 performance postgresql on it? We see very low performance on writes (2-3x slower than on less performant servers). I wonder if it is solely problem of ...
    Grzegorz JaśkiewiczGrzegorz Jaśkiewicz
    Jun 22, 2010 at 9:31 am
    Jun 23, 2010 at 12:56 pm
  • Can anyone please tell me why the following query hangs? This is a part of a large query. explain select * from vtiger_emaildetails inner join vtiger_vantage_email_track on ...
    AI RummanAI Rumman
    Jun 10, 2010 at 10:16 am
    Jun 14, 2010 at 8:16 pm
  • I am reposting as my original query was mangled The link to the explain plan is here as it does not paste well into the email body. http://explain.depesz.com/s/kHa The machine is a 2 cpu quad core ...
    Anj AduAnj Adu
    Jun 4, 2010 at 1:45 am
    Jun 5, 2010 at 9:25 pm
  • I am in the process of moving a system that has been built around FoxPro tables for the last 18 years into a PostgreSQL based system. Over time I came up with decent strategies for making the FoxPro ...
    TonyTony
    Jun 25, 2010 at 8:04 pm
    Jun 30, 2010 at 6:28 pm
  • Dear List, just by removing the order by co_name reduces the query time dramatically from ~ 9 sec to 63 ms. Can anyone please help. Regds Rajesh Kumar Mallah. explain analyze SELECT * from ( SELECT ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Jun 28, 2010 at 11:08 am
    Jun 28, 2010 at 8:19 pm
  • Hi, at the moment we encounter some performance problems with our database server. We have a 12 GB RAM machine with intel i7-975 and using 3 disks "Seagate Barracuda 7200.11, ST31500341AS (1.5 GB)" ...
    JanningJanning
    Jun 24, 2010 at 12:43 pm
    Jun 25, 2010 at 5:30 pm
  • This query seems unreasonable slow on a well-indexed table (13 million rows). Separate indexes are present on guardid_id , from_num and targetprt columns. The table was analyzed with a default stats ...
    Anj AduAnj Adu
    Jun 22, 2010 at 10:24 pm
    Jun 23, 2010 at 5:08 pm
  • I'm helping set up a Red Hat 5.5 system for Postgres. I was going to recommend xfs for the filesystem - however it seems that xfs is supported as a technology preview "layered product" for 5.5. This ...
    Mark KirkwoodMark Kirkwood
    Jun 2, 2010 at 3:06 am
    Jun 2, 2010 at 10:13 pm
  • Hi. I have been wondering if anyone has been experimenting with "really agressive" autovacuuming. The database I'm adminstrating rarely have "long running" transactions (over several minutes). And a ...
    Jesper KroghJesper Krogh
    Jun 20, 2010 at 5:44 pm
    Jun 23, 2010 at 6:49 pm
  • hi, I have a problem space where the main goal is to search backward in time for events. Time can go back very far into the past, and so the table can get quite large. However, the vast majority of ...
    Jori JovanovichJori Jovanovich
    Jun 2, 2010 at 10:17 pm
    Jun 3, 2010 at 3:32 pm
  • I think I have read what is to be read about queries being prepared in plpgsql functions, but I still can not explain the following, so I thought to post it here: Suppose 2 functions: factor(int,int) ...
    Davor J.Davor J.
    Jun 19, 2010 at 7:59 pm
    Aug 12, 2010 at 12:23 pm
  • Hello, When I run an SQL to create new tables and indexes is when Postgres consumes all CPU and impacts other users on the server. We are running Postgres 8.3.7 on a Sun M5000 with 2 x quad core CPUs ...
    Deborah FuentesDeborah Fuentes
    Jun 25, 2010 at 10:26 pm
    Jul 6, 2010 at 5:43 pm
  • Hi, I'm getting low performance on SUM and GROUP BY queries. How can I improve my database to perform such queries. Here is my table schema: = \d acct_2010_25 Tabela "public.acct_2010_25" Coluna | ...
    Sergio Charpinel Jr.Sergio Charpinel Jr.
    Jun 21, 2010 at 2:42 pm
    Jul 2, 2010 at 5:21 pm
  • I have a situation where we are limited by the chassis on the box (and cost). We have a 12 x 600G hot swappable disk system (raid 10) and 2 internal disk ( 2x 146G) We would like to maximize storage ...
    Anj AduAnj Adu
    Jun 23, 2010 at 7:01 pm
    Jun 26, 2010 at 1:15 am
  • Hello,I will have a web application having postgres 8.4+ as backend. At any given time, there will be max of 1000 parallel web-users interacting with the database (read/write)I wish to do performance ...
    Balkrishna SharmaBalkrishna Sharma
    Jun 16, 2010 at 6:28 pm
    Jun 17, 2010 at 11:32 am
  • Hi all, I have 2 data bases trying to perform an update query at the same time on a same table in a third data base using db link. I'm getting a dead lock exception: ERROR: deadlock detected DETAIL: ...
    Elias GhanemElias Ghanem
    Jun 14, 2010 at 12:50 pm
    Jun 14, 2010 at 8:44 pm
  • Hallo all I have a strange problem here. I have a pgsql database running on Intel hardware here, it has 8 cores hyperthreaded so you see 16 cpu's. This box is basically adle @ the moment as it is ...
    MozziMozzi
    Jun 2, 2010 at 11:19 am
    Jun 2, 2010 at 12:56 pm
  • Hi, I've noticed something that I find strange with the hash-aggregate feature of Postgres. I'm currently running Postgres v8.4.1 on Debian Linux 64-bit. I have a simple query that when planned ...
    Jatinder SanghaJatinder Sangha
    Jun 17, 2010 at 5:10 pm
    Jun 21, 2010 at 1:54 pm
  • Hi All, I am using Postgres 8.1.9 for my application. My application also has a clean up module which cleans up specified percentage of total database size at regular intervals. Now the problem is I ...
    Venu madhavVenu madhav
    Jun 17, 2010 at 9:08 am
    Jun 20, 2010 at 8:31 pm
  • Some more on the RHEL 5.5 system I'm helping to setup. Some benchmarking using pgbench appeared to suggest that wal_sync_method=open_sync was a little faster than fdatasync [1]. Now I recall some ...
    Mark KirkwoodMark Kirkwood
    Jun 18, 2010 at 1:39 am
    Jun 18, 2010 at 6:03 am
  • Hi I am performing a DB insertion and update for 3000+ records and while doing so i get CPU utilization to 100% with 67% of CPU used by postgres.... I have also done optimization on queries too... Is ...
    Yogesh NaikYogesh Naik
    Jun 4, 2010 at 4:41 am
    Jun 10, 2010 at 4:44 pm
  • I've been reading this list for a couple of weeks, so I've got some sense of what you folks are likely to recommend, but I'm curious what is considered an ideal storage solution if building a ...
    Samuel GendlerSamuel Gendler
    Jun 29, 2010 at 9:00 pm
    Jun 30, 2010 at 1:52 pm
  • Good morning List In relation to the process of tuning the engine PostgreSQL database, especially 7.3.7 version that is being used currently, agreaceria me clarify a procedure If I have a server with ...
    Juan Pablo Sandoval RiveraJuan Pablo Sandoval Rivera
    Jun 16, 2010 at 7:13 pm
    Jun 16, 2010 at 7:34 pm
  • Hello, We are trying to optimize our box for Postgresql. We have i7, 8GB of ram, 2xSATA RAID1 (software) running on XFS filesystem. We are running Postgresql and memcached on that box. Without any ...
    Szymon KosokSzymon Kosok
    Jun 12, 2010 at 12:10 pm
    Jun 12, 2010 at 8:46 pm
  • Hi. I hope I'm not going to expose an already known problem, but I couldn't find it mailing list archives (I only found http://archives.postgresql.org/pgsql- hackers/2009-12/msg01543.php). On one of ...
    Marc CousinMarc Cousin
    Jun 4, 2010 at 1:39 pm
    Jun 4, 2010 at 3:29 pm
  • Hello there, I've searched the web and can find very little on this issue, so I was hoping those on this list would be able to shed some light on it. Performance has dropped through the floor after ...
    Brant FitzsimmonsBrant Fitzsimmons
    Jun 17, 2010 at 10:37 pm
    Jun 18, 2010 at 4:09 am
  • Hi, I am new to this list so please forgive me if it not fits the standards. I have the following query that I run agains postgresql 8.2: select distinct m.koid, m.name, m.farbe, m.aktennummer, ...
    Kaufhold, Christian (LFD)Kaufhold, Christian (LFD)
    Jun 17, 2010 at 8:20 am
    Jun 17, 2010 at 3:30 pm
  • Whenever I run this query, I get out of memory error: explain analyze *select * email_track.count AS "Emails_Access_Count", activity.subject AS "Emails_Subject", crmentity.crmid AS ...
    AI RummanAI Rumman
    Jun 13, 2010 at 1:25 pm
    Jun 14, 2010 at 2:10 am
  • Dear Experts, I have data about half milllion to 1 million which is populated into the Postgres db using a batch job (A sql script consists of pl/pgsql functions and views) . I am using PostgreSQL ...
    Ambarish BhattacharyaAmbarish Bhattacharya
    Jun 10, 2010 at 8:48 am
    Jun 10, 2010 at 3:27 pm
  • Hi, We are using postgresql-8.4.0 on 64-bit Linux machine (open-SUSE 11.x). It's a master/slave deployment & slony-2.0.4.rc2 is used for DB replication on the slave box. At times we have observed ...
    Sachin KumarSachin Kumar
    Jun 29, 2010 at 7:02 am
    Jul 4, 2010 at 12:38 pm
  • v. 8.4.3 I have a table that has several indexes, one of which the table is clustered on. If I do an ALTER TABLE Foo ADD COLUMN bar integer not null default -1; It re-writes the whole table. * Does ...
    Scott CareyScott Carey
    Jun 22, 2010 at 5:30 pm
    Jun 24, 2010 at 3:03 pm
  • Hi again! I have finally got my Ubuntu VirtualBox VM running PostgreSQL with PL/Python and am now looking at performance. So here's the scenario: We have a great big table: cse=# \d nlpg.match_data ...
    Tom WilcoxTom Wilcox
    Jun 24, 2010 at 10:45 am
    Jun 24, 2010 at 11:20 am
  • Which one is good - join between table or using exists in where condition? Query 1; Select a.* from a where exists ( select 1 from b inner join c on b.id1 = c.id where a.id = b.id) Query 2: select ...
    AI RummanAI Rumman
    Jun 20, 2010 at 8:55 am
    Jun 20, 2010 at 3:02 pm
  • Can any one please help me in tuning the query? explain select * from (select * from crmentity where deleted = 0 and createdtime between (now() - interval '6 month') and now() ) as crmentity inner ...
    AI RummanAI Rumman
    Jun 14, 2010 at 10:41 am
    Jun 14, 2010 at 1:50 pm
  • I'm needing some tutorial to use and understand the graphical feature "Explain" of PgAdmin III? Do you have it? Thanks, Jeres.
    Jeres Caldeira GomesJeres Caldeira Gomes
    Jun 1, 2010 at 5:47 pm
    Jun 5, 2010 at 1:43 am
  • I'm trying to find someone who has a system with an AMD "Magny Cours" 6100 series processor in it, like the Opteron 6174 or 6176 SE, who'd be willing to run a short test for me during an idle period ...
    Greg SmithGreg Smith
    Jun 25, 2010 at 6:48 pm
    Jun 25, 2010 at 6:48 pm
  • Never say never with computer geeks .... http://www.youtube.com/watch?v=mJyAA0oPAwE
    Dave CrookeDave Crooke
    Jun 11, 2010 at 3:58 pm
    Jun 11, 2010 at 3:58 pm
Jun 2010
Group Navigation
period‹ prev | Jun 2010 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions48
posts530
users107
websitepostgresql.org
irc#postgresql

107 users for June 2010

Greg Smith: 33 posts Kevin Grittner: 33 posts Tom Lane: 32 posts Robert Haas: 24 posts Scott Marlowe: 22 posts Anj Adu: 21 posts Bruce Momjian: 18 posts Rajesh Kumar Mallah: 18 posts Matthew Wakeling: 17 posts Craig James: 15 posts David Jarvis: 14 posts Pierre C: 14 posts Alvaro Herrera: 10 posts Anne Rosset: 9 posts Jon Schewe: 9 posts AI Rumman: 8 posts Jonathan Gardner: 8 posts Josh Berkus: 8 posts Mark Kirkwood: 8 posts Dave Crooke: 7 posts
show more
Archives