FAQ

PostgreSQL > pgsql-performance > January 2011

Search Discussions

32 discussions - 351 posts

  • Hi all, we are running a fairly big Ruby on Rails application on Postgres 8.4. Our traffic grew quite a bit lately, and since then we are facing DB performance issues. System load occasionally ...
    Michael KohlMichael Kohl
    Jan 27, 2011 at 10:37 am
    Feb 11, 2011 at 5:05 pm
  • HI, I use PostgreSQL basically as a data warehouse to store all the genetic data that our lab generates. The only person that accesses the database is myself and therefore I've had it housed on my ...
    Robert SchnabelRobert Schnabel
    Jan 27, 2011 at 11:11 pm
    Feb 5, 2011 at 9:01 am
  • I have a table EMP, with 14 rows and a description like this: scott= \d+ emp Table "public.emp" Column | Type | Modifiers | Storage | Description ...
    Mladen GogalaMladen Gogala
    Jan 27, 2011 at 3:41 pm
    Jan 27, 2011 at 9:43 pm
  • Hi all, I've come to a dead end in trying to get a commonly used query to perform better. The query is against one table with 10 million rows. This table has been analysed. The table definition is: ...
    Jeremy PalmerJeremy Palmer
    Jan 17, 2011 at 3:22 am
    Jan 25, 2011 at 1:44 pm
  • I was recently asked to look into why one particular set of queries was taking a long time. The queries are all of the same form. They select the UNION of a few columns from around 100 tables. The ...
    Jon NelsonJon Nelson
    Jan 13, 2011 at 3:51 pm
    Jan 15, 2011 at 6:22 pm
  • Hi, We are in the process of moving a web based application from a MySql to Postgresql database. Our main reason for moving to Postgresql is problems with MySql (MyISAM) table locking. We will buy a ...
    LarsLars
    Jan 18, 2011 at 11:02 am
    Jan 31, 2011 at 10:18 am
  • Hello, just coming from this thread : http://archives.postgresql.org/pgsql-admin/2011-01/msg00050.php It started as an admin question and turned out to be a performance question. You may look at it ...
    Achilleas MantziosAchilleas Mantzios
    Jan 17, 2011 at 3:35 pm
    Jan 24, 2011 at 3:40 pm
  • Hi, We are running some performances tests. With a lot of concurrent access, queries get very slow. When there is no load, those queries run fast. We kind of see a trend about these queries: it seems ...
    Anne RossetAnne Rosset
    Jan 25, 2011 at 9:50 pm
    Feb 3, 2011 at 6:23 pm
  • Did anyone try using "shake" while the cluster is active? Any problems with corruption or data loss? I ran the thing on my home directory and nothing was broken. I didn't develop any performance ...
    Mladen GogalaMladen Gogala
    Jan 30, 2011 at 8:19 pm
    Feb 1, 2011 at 11:50 pm
  • I'm using 8.3 and I have a table that contains many revisions of the same entity and I have a query that is super slow. Please help! I'm going to paste in some SQL to set up test cases and some plans ...
    Nikolas EverettNikolas Everett
    Jan 14, 2011 at 9:17 pm
    Jan 21, 2011 at 6:55 pm
  • after i backdb- dropdb- restoredb and then vacuum analy+full - vacuum freeze the XID had been increased by 4 billion in two weeks...is it noraml? what's the definetion of XID? " select * from mybook" ...
    Charles.HouCharles.Hou
    Jan 19, 2011 at 9:25 am
    Jan 21, 2011 at 5:49 pm
  • All, One of my coworkers just pointed this out: "The amount of memory used in shared memory for WAL data. The default is 64 kilobytes (64kB). The setting need only be large enough to hold the amount ...
    Josh BerkusJosh Berkus
    Jan 5, 2011 at 8:43 pm
    Jan 7, 2011 at 6:46 pm
  • I was doing a little testing to see how machine load affected the performance of different types of queries, index range scans, hash joins, full scans, a mix, etc. In order to do this, I isolated ...
    GrantGrant
    Jan 21, 2011 at 6:16 pm
    Jan 25, 2011 at 3:27 pm
  • I am evaluating postgres 9 to migrate away from Oracle. The following query runs too slow, also please find the explain plan: **************************************************************** explain ...
    Yazan suleimanYazan suleiman
    Jan 28, 2011 at 5:30 pm
    Feb 1, 2011 at 5:24 pm
  • Folks, I'm doing a postmortem on an 8.3 database which recently had to be rebuilt. The database was over 200% bloated ... 176GB as opposed to dump/reload size of 55GB. What I find really interesting ...
    Josh BerkusJosh Berkus
    Jan 25, 2011 at 2:26 am
    Feb 1, 2011 at 11:39 pm
  • New to Postgres and am prototyping a migration from Oracle to Postgres 9.0.1 on Linux. Starting with the data warehouse. Current process is to load the data from our OLTP (Oracle), dump it into ...
    David GrecoDavid Greco
    Jan 26, 2011 at 7:47 pm
    Jan 27, 2011 at 4:17 pm
  • I am running a postgres update on one of my machines: Downloading Packages: (1/7): postgresql90-plpython-9.0.2-2PGDG.rhel5.x86_64.rp | 50 kB 00:02 (2/7): ...
    Mladen GogalaMladen Gogala
    Jan 12, 2011 at 1:49 pm
    Jan 18, 2011 at 9:04 am
  • Hi all, I'm using postgres 8.4.2 on a Ubuntu Linux machine. I have several tables, one of which is named Document, which of course represents information I need about my documents. I also have ...
    Γιωργος ΒαλκαναςΓιωργος Βαλκανας
    Jan 7, 2011 at 2:37 am
    Jan 14, 2011 at 7:01 pm
  • This will be simple question to answer. :-) There is a single table: select count(*) from product_price_history -- 12982555 rows This table has exactly one index and on primary key constraint: CREATE ...
    Laszlo NagyLaszlo Nagy
    Jan 12, 2011 at 12:25 pm
    Jan 12, 2011 at 8:15 pm
  • Scott, I don't know if you received my private email, but just in case you did not I am posting the infomration here. I have a new set of servers coming in - Dual Xeon E5620's, 96GB RAM, 18 spindles ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Jan 31, 2011 at 11:55 pm
    Feb 2, 2011 at 6:23 pm
  • It`s just a sample. select c.id from OneRow c join abstract a on a.id=AsInteger(c.id) "Nested Loop (cost=0.00..786642.96 rows=1 width=4) (actual time=91021.167..119601.344 rows=1 loops=1)" " Join ...
    ZotovZotov
    Jan 17, 2011 at 8:03 am
    Jan 18, 2011 at 2:15 pm
  • Hello performance, I need help explaining the performance of a particular query: select * from messages where ((messages.topic = E'/x') AND (messages.processed = 'f')) ORDER BY messages.created_at ...
    Mike BroersMike Broers
    Jan 5, 2011 at 10:57 pm
    Jan 14, 2011 at 6:03 pm
  • hello, i have a table with OID column.. I want to use the copy command to insert bunch of rows (1 million). but iam unable to specify the correct format for the oid type (i have .jpg files to be ...
    Madhu RamachandranMadhu Ramachandran
    Jan 20, 2011 at 8:12 pm
    Feb 6, 2011 at 6:15 pm
  • Hi folks, I have a table like so: create table tagRecord ( uid varchar(60) primary key, [bunch of other fields] location varchar(32), creationTS timestamp ); create index idx_tagdata_loc_creationTS ...
    Dimi PaunDimi Paun
    Jan 24, 2011 at 7:01 pm
    Jan 25, 2011 at 5:03 am
  • Hi there, I have one log file per week and logging all statements = 500 ms execution time. But, with "normal" statements are occuring something like this: 2011-01-13 00:11:38 BRT LOG: duration: ...
    Fernando MertinsFernando Mertins
    Jan 14, 2011 at 7:42 pm
    Jan 14, 2011 at 10:43 pm
  • At one point I was working on a patch to pgbench to have it adopt 64-bit math internally even when running on 32 bit platforms, which are currently limited to a dataabase scale of ~4000 before the ...
    Greg SmithGreg Smith
    Jan 8, 2011 at 1:59 am
    Jan 11, 2011 at 9:41 pm
  • On 9.0, this configuration checkpoint_segments = 512 # in logfile segments, min 1, 16MB each results in 1034 segments, so the effective logfile segment size is 32 MB. The documentation says this: ...
    Florian WeimerFlorian Weimer
    Jan 7, 2011 at 12:45 pm
    Jan 7, 2011 at 1:47 pm
  • Hi there, this is my first post. I have a PostgreSQL 8.3.6, compiled by Visual C++ build 1400 running on Windows with virtual machine, 2 GB ram, and configured the postgresql.conf file to log ...
    Fernando MertinsFernando Mertins
    Jan 4, 2011 at 6:03 pm
    Jan 5, 2011 at 1:52 am
  • Hi, Yesterday I perform a crash test, but I lost the last pg_xlog file. Let me explain: First I did the pg_start_backup Second I copied the phisical files to the slave server Third I did the ...
    WaldomiroWaldomiro
    Jan 27, 2011 at 12:25 pm
    Jan 27, 2011 at 2:51 pm
  • Pg 9.0.2 is performing better than pg8.4.1 There are more transactions per second in pg9.0.2 than in pg8.4.1, which is a better thing. also below are kernel parameters that i used. ------ Shared ...
    DMDM
    Jan 27, 2011 at 7:26 pm
    Jan 30, 2011 at 7:25 pm
  • Hi there, Could someone please tell me why the following query won't work select DISTINCT get_unit(unit) as unit, get_ingredient(ing) as ing, get_ing_aisle(1,ing) as aisle from recipe_ing where ...
    Barbara WoolumsBarbara Woolums
    Jan 15, 2011 at 6:02 pm
    Jan 17, 2011 at 11:42 pm
  • Hello all, I am trying to do comparative study of PostgreSQL and Oracle. Has anybody tried to use same binary for connecting to oracle as well as PostgreSQL at the same time? I mean the program ...
    Divakar SinghDivakar Singh
    Jan 12, 2011 at 6:54 am
    Jan 12, 2011 at 5:12 pm
Jan 2011
Group Navigation
period‹ prev | Jan 2011 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions32
posts351
users85
websitepostgresql.org
irc#postgresql

85 users for January 2011

Mladen Gogala: 26 posts Kevin Grittner: 24 posts Tom Lane: 22 posts Robert Haas: 19 posts Scott Marlowe: 19 posts Greg Smith: 12 posts Andy Colson: 11 posts Shaun Thomas: 9 posts Andres Freund: 8 posts Cédric Villemain: 8 posts Scott Carey: 8 posts Bruce Momjian: 7 posts Jeremy Palmer: 7 posts Jon Nelson: 7 posts Craig Ringer: 6 posts Florian Weimer: 6 posts Grant Johnson: 6 posts Robert Schnabel: 6 posts Achilleas Mantzios: 5 posts Igor Neyman: 5 posts
show more
Archives