FAQ

PostgreSQL > pgsql-performance > May 2010

Search Discussions

31 discussions - 276 posts

  • Hi, I wrote a query (see below) that extracts climate data from weather stations within a given radius of a city using the dates for which those weather stations actually have data. The query uses ...
    David JarvisDavid Jarvis
    May 25, 2010 at 5:54 am
    Jul 7, 2010 at 2:43 pm
  • Hi, I recently switched to PostgreSQL from MySQL so that I can use PL/R for data analysis. The query in MySQL form (against a more complex table structure) takes ~5 seconds to run. The query in ...
    David JarvisDavid Jarvis
    May 20, 2010 at 5:06 am
    Jun 2, 2010 at 4:55 am
  • Machine: 8 core AMD opteron 2.1GHz, 12 disk RAID-10, 2 disk pg_xlog, RHEL 5.4 pg version 8.3.9 (upgrading soon to 8.3.11 or so) This query: SELECT sum(f.bytes) AS sum FROM files f INNER JOIN events ...
    Scott MarloweScott Marlowe
    May 19, 2010 at 12:17 am
    May 28, 2010 at 2:56 am
  • Greetings, in http://archives.postgresql.org/message-id/[email protected], it is stated that the performance of temporary tables is "the same as a regular table but without WAL on the ...
    Joachim WorringenJoachim Worringen
    May 25, 2010 at 8:16 am
    Jun 6, 2010 at 10:44 pm
  • Hi all, In my database application, I've a table whose records can reach 10M and insertions can happen at a faster rate like 100 insertions per second in the peak times. I configured postgres to do ...
    Venu madhavVenu madhav
    May 11, 2010 at 8:48 am
    May 26, 2010 at 4:26 am
  • I have been Googling for answers on this for a while, and have not been able to find anything satisfactory. Imagine that you have a stored procedure which is currently written using PL/PGSQL. This ...
    Eliot GableEliot Gable
    May 26, 2010 at 4:06 pm
    Jun 1, 2010 at 4:28 pm
  • Hi all! We moved from MySQL to Postgresql for some of our projects. So far we're very impressed with the performance (especially INSERTs and UPDATEs), except for a strange problem with the following ...
    ThiloThilo
    May 8, 2010 at 11:41 am
    May 17, 2010 at 12:36 pm
  • Sample code: SELECT * FROM MyTable WHERE foo = 'bar' AND MySlowFunc('foo') = 'bar' Let's say this required a SEQSCAN because there were no indexes to support column foo. For every row where foo < ...
    Carlo StonebanksCarlo Stonebanks
    May 27, 2010 at 7:29 pm
    Dec 27, 2011 at 11:38 pm
  • Hi I have a situation at my work which I simply don't understand and hope that here I can find some explanations. What is on the scene: A - old 'server' PC AMD Athlon64 3000+, 2GB RAM, 1 ATA HDD ...
    Piotr LegieckiPiotr Legiecki
    May 14, 2010 at 1:54 pm
    May 24, 2010 at 3:45 am
  • Hi I have a situation at my work which I simply don't understand and hope that here I can find some explanations. What is on the scene: A - old 'server' PC AMD Athlon64 3000+, 2GB RAM, 1 ATA HDD ...
    Piotr LegieckiPiotr Legiecki
    May 14, 2010 at 8:51 am
    May 21, 2010 at 12:15 pm
  • Jignesh, All: Most of our Solaris users have been, I think, following Jignesh's advice from his benchmark tests to set ZFS page size to 8K for the data zpool. However, I've discovered that this is ...
    Josh BerkusJosh Berkus
    May 8, 2010 at 12:10 am
    May 12, 2010 at 1:02 am
  • Hi. I'm trying to get the planner to do sort of the correct thing when choosing between index-scans on btree indices and bitmap heap scans. There has been several things going on in parallel. One is ...
    Jesper KroghJesper Krogh
    May 30, 2010 at 5:41 pm
    Jun 5, 2010 at 1:29 am
  • Hi All, In my application we are using postgres which runs on an embedded box. I have configured autovacuum to run once for every one hour. It has 5 different databases in it. When I saw the log ...
    Venu madhavVenu madhav
    May 21, 2010 at 9:38 am
    Jun 2, 2010 at 8:14 pm
  • We're using a function that when run as a select statement outside of the function takes roughly 1.5s to complete whereas running an identical query within a function is taking around 55s to ...
    Tyler HildebrandtTyler Hildebrandt
    May 25, 2010 at 9:59 am
    May 25, 2010 at 4:19 pm
  • Hello, I'm about to embark on a partitioning project to improve read performance on some of our tables: db=# select relname,n_live_tup,pg_size_pretty(pg_relation_size(relid)) from pg_stat_all_tables ...
    Richard YenRichard Yen
    May 5, 2010 at 8:25 pm
    May 10, 2010 at 2:39 am
  • Anybody on the list have any experience with these drives? They get good numbers but I can't find diddly on them on the internet for the last year or so. http://www.stec-inc.com/product/zeusiops.php
    Scott MarloweScott Marlowe
    May 28, 2010 at 7:49 pm
    Jun 1, 2010 at 1:17 pm
  • Hello, Sorry for the re-post - not sure list is the relevant one, I included slightly changed query in the previous message, sent to bugs list. I have an ORM-generated queries where parent table keys ...
    Krzysztof NienartowiczKrzysztof Nienartowicz
    May 20, 2010 at 2:00 pm
    May 28, 2010 at 12:04 am
  • Hello all, A query ran twice in succession performs VERY poorly the first time as it iterates through the nested loop. The second time, it rips. Please see SQL, SLOW PLAN and FAST PLAN below. I don't ...
    Carlo StonebanksCarlo Stonebanks
    May 11, 2010 at 5:42 am
    May 26, 2010 at 4:13 am
  • Hi everyone, I use DBD::Pg to interface with our 8.4.2 database, but for a particular query, performance is horrible. I'm assuming that the behavior of $dbh- prepare is as if I did PREPARE foo AS ...
    Richard YenRichard Yen
    May 21, 2010 at 10:53 pm
    May 25, 2010 at 7:02 pm
  • Hello, We've been a satified user of PostgreSQL for several years, and use it to power a national pet adoption website: http://www.adoptapet.com/ Recently we've had a regularly-timed ...
    Mark StosbergMark Stosberg
    May 7, 2010 at 1:38 pm
    May 7, 2010 at 7:23 pm
  • Hi group, I could really use your help with this one. I don't have all the details right now (I can provide more descriptions tomorrow and logs if needed), but maybe this will be enough: I have ...
    Łukasz DejnekaŁukasz Dejneka
    May 24, 2010 at 4:50 pm
    Jun 2, 2010 at 9:26 pm
  • I'm using PostgreSQL 9.0 beta 1. I've got the following table definition: # \d parts_2576 Table "public.parts_2576" Column | Type | Modifiers ...
    Thom BrownThom Brown
    May 28, 2010 at 6:27 pm
    May 29, 2010 at 5:01 pm
  • This is not a rigorous test and should not be used as a direct comparison between operating systems. My objective was to estimate the ZFS toll in Postgres, and what to expect in performance, ...
    Joao.pinheiroJoao.pinheiro
    May 15, 2010 at 4:42 pm
    May 17, 2010 at 7:06 am
  • Hi, I am trying to have synchronous master-master replication in PostgreSQL8.4 using PgPool II. I am not able to configure PgPool on the system, it gives me an error, libpq is not installed or libpq ...
    Neha MehtaNeha Mehta
    May 6, 2010 at 4:24 am
    May 6, 2010 at 10:28 pm
  • Dear all and Tom， Recently my company’s postgres DB server sluggish suddenly with a hight Context-switching value as below: 2010-04-07 04:03:15 procs memory swap io system cpu 2010-04-07 04:03:15 r b ...
    黄永卫黄永卫
    May 27, 2010 at 7:27 am
    May 28, 2010 at 4:11 am
  • We're using a function that when run as a select statement outside of the function takes roughly 1.5s to complete whereas running an identical query within a function is taking around 55s to ...
    Tyler HildebrandtTyler Hildebrandt
    May 21, 2010 at 2:28 pm
    May 27, 2010 at 3:56 pm
  • Hello, I work for a web app to send email newsletters, and I have one question about postgres' performance in two different setups. Actually we have one 4GB Ram VPS running our app server (it's a ...
    Pedro AxelrudPedro Axelrud
    May 24, 2010 at 9:03 pm
    May 25, 2010 at 5:07 pm
  • I have a message posted in pgsql-general that outlines what I thought was an indexing problem - it's not, so I'm bringing it here. I dumped the table from our production system and stuffed it into a ...
    Karl DenningerKarl Denninger
    May 8, 2010 at 8:35 pm
    May 9, 2010 at 9:36 am
  • Hi, I have two similar queries that calculate "group by" summaries over a huge table (74.6mil rows). The only difference between two queries is the number of columns that group by is performed on. ...
    Slava MoudrySlava Moudry
    May 27, 2010 at 7:44 pm
    Jun 5, 2010 at 1:40 am
  • Good day list I would appreciate some comments to the following: I have a Dell PowerEdge SC1420 server with 2 GB of RAM 1 DD 73 Gb SCSI Ulltra320 2 Xeon (4 cache) with PGSQL 7.3.7 running GNU / Linux ...
    Juan Pablo Sandoval RiveraJuan Pablo Sandoval Rivera
    May 25, 2010 at 2:04 pm
    May 25, 2010 at 2:27 pm
  • Hi all, Are there any HP Smart Array disk controller users running linux that have experimented with the new scsi based hpsa driver over the block based cciss driver? I have a p800 controller that ...
    Mark WongMark Wong
    May 28, 2010 at 1:24 am
    May 28, 2010 at 1:24 am
May 2010
Group Navigation
period‹ prev | May 2010 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions31
posts276
users75
websitepostgresql.org
irc#postgresql

75 users for May 2010

David Jarvis: 28 posts Scott Marlowe: 25 posts Tom Lane: 18 posts Kevin Grittner: 11 posts Cédric Villemain: 10 posts Venu madhav: 9 posts Josh Berkus: 8 posts Konrad Garus: 7 posts Matthew Wakeling: 7 posts Merlin Moncure: 7 posts Robert Haas: 7 posts Stephen Frost: 7 posts Thom Brown: 7 posts Yeb Havinga: 7 posts Joachim Worringen: 6 posts Craig James: 5 posts Grzegorz Jaśkiewicz: 5 posts Greg Smith: 4 posts Jesper Krogh: 4 posts Piotr Legiecki: 4 posts
show more
Archives