FAQ

Search Discussions

17 discussions - 154 posts

  • Hi everybody, I have implemented my first app using PG DB and thought for a minute(may be two) that I know something about PG but below problem totally destroyed my confidence :). Please help me to ...
    Alex VinnikAlex Vinnik
    Jan 3, 2013 at 10:54 pm
    Feb 4, 2013 at 9:14 pm
  • Hey everyone! After much testing and hair-pulling, we've confirmed two kernel settings that should always be modified in production Linux systems. Especially new ones with the completely fair ...
    Shaun ThomasShaun Thomas
    Jan 2, 2013 at 9:46 pm
    Jan 24, 2013 at 3:06 am
  • Centos 5.X kernel 2.6.18-274 pgsql-9.1 from pgdg-91-centos.repo relatively small database 3.2Gb Lot of insert, update, delete. I see non balanced _User_ usage on 14 CPU, exclusively assigned to the ...
    Nobody nowhereNobody nowhere
    Jan 3, 2013 at 11:45 pm
    Jan 7, 2013 at 6:10 pm
  • Hi All, Inspired by Charles' thread and the work of Emmanuel [1], I have made some experiments trying to create a trigger to make partitioning using C language. The first attempt was not good, I ...
    Matheus de OliveiraMatheus de Oliveira
    Jan 10, 2013 at 6:46 pm
    Feb 15, 2013 at 8:47 am
  • Hello, I'm running postgresl 9.0. After partitioning a big table, CPU usage raised from average 5-10% to average 70-80%. - the table contains about 20.000.000 rows - partitions are selected using a ...
    RudiRudi
    Jan 21, 2013 at 3:05 pm
    Jan 22, 2013 at 6:38 pm
  • Hi! I see a massive performance drop when writing a large transaction. I'm writing data for 33 tables with COPY FROM directly from streams in Scala/Java. Over all tables there are 2.2M records which ...
    Horst DehmerHorst Dehmer
    Jan 11, 2013 at 11:55 pm
    Jan 18, 2013 at 11:15 pm
  • Hi All, I think this is not new topic, I try to look for discussions about same subject I find something like http://postgresql.1045698.n5.nabble.com/libpq-or-postgresql-performance-td5723158.html ...
    Belal hamedBelal hamed
    Jan 27, 2013 at 12:15 am
    Jan 28, 2013 at 11:15 am
  • Hi! Small query run on 9.0 very fast: SELECT * from sygma_arrear sar where sar.arrear_import_id = ( select sa.arrear_import_id from sygma_arrear sa, arrear_import ai where sa.arrear_flag_id = 2 AND ...
    Andrzej ZawadzkiAndrzej Zawadzki
    Jan 10, 2013 at 1:32 pm
    Jan 11, 2013 at 5:12 pm
  • Hi Listers, we migrated an oracle datawarehouse to postgresql 9.1 ( ppas 9.1.7.12 ) and are facing massive issues with response times in postgres when compared to the oracle system. Both database run ...
    Daniel WestermannDaniel Westermann
    Jan 3, 2013 at 1:30 pm
    Jan 9, 2013 at 9:30 am
  • Is there a way to force a WAL flush so that async commits (from other connections) are flushed, short of actually updating a sacrificial row? Would be nice to do it without generating anything extra, ...
    JamesJames
    Jan 7, 2013 at 9:49 pm
    Jan 7, 2013 at 11:56 pm
  • If I drop and then recreate a trigger inside of a single transaction, how does it affect other processes trying to use the same table? Can they just merrily go along their way using the table, or ...
    Craig JamesCraig James
    Jan 28, 2013 at 6:54 pm
    Jan 28, 2013 at 7:25 pm
  • Hi, Last weekend, we upgrade a PG from 8.4 to 9.2 version (full pg_dump/restore/vacuum/analyze). After this, some simple join querys became very slow, maybe because the use of nested loops. Bellow, ...
    Alexandre - aldeia digitalAlexandre - aldeia digital
    Jan 25, 2013 at 3:34 pm
    Jan 25, 2013 at 7:30 pm
  • Hi, Updated information in this post. I have installed Postgresql 9.2.2 (complied by gcc) in FreeBSD 9.1 i386. The pgsql base directory is in a ZFS dataset. I have noticed the performance is ...
    Patrick DungPatrick Dung
    Jan 7, 2013 at 5:18 pm
    Jan 8, 2013 at 4:27 pm
  • My best regards for all... Please. I need for an advice. I'm having a trouble, that puting others queries in wait state, becouse of ExclusiveLock granted by an Update that only update one row at each ...
    PostgreSQLPostgreSQL
    Jan 10, 2013 at 6:02 pm
    Jan 10, 2013 at 6:04 pm
  • Hi, I am creating benchmark for postgresql database with tpc-w specification. I expect proper benchmark for postgresql with tpc-w specification. postgresql version:- psql (8.4.13, server 9.2.1) i ...
    Sachin D. KotwalSachin D. Kotwal
    Jan 25, 2013 at 6:38 am
    Jan 25, 2013 at 6:38 am
  • Greetings. I've been playing with a small query that I've been asked to optimize and noticed a strange (for me) effect. Query uses this table: Table "clc06_tiles" Column | Type | Modifiers ...
    Виктор ЕгоровВиктор Егоров
    Jan 22, 2013 at 8:57 pm
    Jan 22, 2013 at 8:57 pm
  • Hi, Every month, I search in the mailing lists and in history of wiki page about table partition for any news. But I don't see any moves to implement this feature (aka transparent table ...
    Alexandre de Arruda PaesAlexandre de Arruda Paes
    Jan 13, 2013 at 9:49 pm
    Jan 13, 2013 at 9:49 pm
Group Navigation
period‹ prev | Jan 2013 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions17
posts154
users51
websitepostgresql.org
irc#postgresql

51 users for January 2013

Jeff Janes: 16 posts Nobody nowhere: 9 posts AJ Weber: 8 posts Alex Vinnik: 8 posts Claudio Freire: 8 posts Merlin Moncure: 8 posts Matheus de Oliveira: 7 posts Heikki Linnakangas: 6 posts Shaun Thomas: 6 posts Horst Dehmer: 5 posts Tom Lane: 5 posts Rudi: 4 posts Alexandre de Arruda Paes: 3 posts Andrzej Zawadzki: 3 posts Belal hamed: 3 posts Charles Gomes: 3 posts Daniel Westermann: 3 posts Ktm: 3 posts Scott Marlowe: 3 posts Stefan Andreatta: 3 posts
show more
Archives