FAQ

Search Discussions

39 discussions - 283 posts

  • Hello I am attempting to run an update statement that copies two fields from one table to another: UPDATE table_A SET ( field_1 , field_2 ) = ( table_B.field_1 , table_B.field_2 ) FROM table_B WHERE ...
    Harry MantheakisHarry Mantheakis
    Jun 23, 2011 at 4:05 pm
    Jun 28, 2011 at 9:49 am
  • We are thiiiiiis close to moving our datawarehouse from Oracle to Postgres. This query is identical on both systems, but runs much, much faster on Oracle. Our Postgres host has far superior hardware ...
    Tony CapobiancoTony Capobianco
    Jun 8, 2011 at 3:18 pm
    Jun 10, 2011 at 2:25 am
  • Version: PostgreSQL 8.3.5 (mammoth replicator) Schema: CREATE TABLE tdiag ( diag_id integer DEFAULT nextval('diag_id_seq'::text), create_time timestamp with time zone default now(), /* time this ...
    Anthony ShipmanAnthony Shipman
    Jun 7, 2011 at 8:21 am
    Jun 10, 2011 at 3:22 pm
  • Hi everybody, I am running PostgreSQL 9.0 which performs well in most of the cases. I would skip all the parameters if these are not necessary. I need to frequently (every min) get the max value of ...
    Svetlin ManavskiSvetlin Manavski
    Jun 16, 2011 at 1:55 pm
    Jun 22, 2011 at 9:35 pm
  • We have a postgresql 8.3.8 DB which consumes 100% of the CPU whenever we run any query. We got vmstat output Machine details are below: # /usr/bin/lscpu Architecture: x86_64 CPU(s): 2 Thread(s) per ...
    BakkiyaBakkiya
    Jun 8, 2011 at 4:19 am
    Jul 7, 2011 at 12:49 pm
  • I'm looking for advice from the I/O gurus who have been in the SSD game for a while now. I understand that the majority of consumer grade SSD drives lack the required capacitor to complete a write on ...
    Dan HarrisDan Harris
    Jun 21, 2011 at 4:04 am
    Jun 22, 2011 at 3:50 pm
  • Hi All; We have a table with approx 200 columns. about a dozen columns are text data types and the rest are a mix of integers , bigint's and double precision types. The table has about 25million ...
    CS DBACS DBA
    Jun 1, 2011 at 8:40 pm
    Jun 2, 2011 at 7:57 pm
  • Hi, I am evaluating hardware for a new PostgreSQL server. For reasons concerning power consumption and available space it should not have more than 4 disks (in a 1U case), if possible. Now, I am not ...
    HaestanHaestan
    Jun 16, 2011 at 3:10 pm
    Jun 17, 2011 at 1:29 pm
  • Hi All, I am facing some performance issue with insert into some table. I am using postgres 8.4.x Table is having 3 before insert trigger and one after insert trigger. With all triggers enable it is ...
    JenishJenish
    Jun 27, 2011 at 2:23 pm
    Jun 27, 2011 at 8:56 pm
  • I have a function in pgsql language, this function do some select to some tables for verify some conditions and then do one insert to a table with NO index. Update are not performed in the function ...
    Anibal David AcostaAnibal David Acosta
    Jun 10, 2011 at 11:58 am
    Jun 12, 2011 at 3:15 pm
  • I originally posted this on admin, but it was suggested to post it to performance so here goes - I am in the process of implementing cascade on delete constraints retroactively on rather large tables ...
    Mike BroersMike Broers
    Jun 6, 2011 at 8:35 pm
    Jun 9, 2011 at 12:04 pm
  • Greetings, I have been thinking a lot about pgsql performance when it is dealing with tables with lots of rows on one table (several millions, maybe thousands of millions). Say, the Large Object use ...
    Jose Ildefonso Camargo TolosaJose Ildefonso Camargo Tolosa
    Jun 19, 2011 at 4:06 am
    Jul 22, 2011 at 12:46 am
  • I have a tsvector column docvector and a gin index on it docmeta1_docvector_idx I have a simple query "select * from docmeta1 where docvector @@ plainto_tsquery('english', 'free');" I find that the ...
    Sushant SinhaSushant Sinha
    Jun 20, 2011 at 3:45 pm
    Jun 30, 2011 at 3:59 am
  • Hello, I have a handful of queries that are performing very slowly. I realize that I will be hitting hardware limits at some point, but want to make sure Ive squeezed out every bit of performance I ...
    Craig McIlweeCraig McIlwee
    Jun 28, 2011 at 9:29 pm
    Jun 29, 2011 at 1:02 am
  • Hello, postgresql guru's When developing ticket export mechanism for our ticketing system I thought the wise thing would be to generate the result (XML file) in stored function. This worked fine for ...
    Julius TuskenisJulius Tuskenis
    Jun 16, 2011 at 7:40 pm
    Jun 20, 2011 at 9:03 am
  • Hi, We have installed postgresql on itanium server (HP rx7640), only on this server we are getting the following error in /var/log/messages and also the postgres performance is very slow. Error: *Jun ...
    Muthu krishnanMuthu krishnan
    Jun 9, 2011 at 9:20 am
    Jun 9, 2011 at 4:20 pm
  • Hi All, I'm having issues with a set of fairly related queries in my application. EXPLAIN ANALYZE is showing them all to be getting stuck performing roughly the same operation: - Bitmap Heap Scan on ...
    John WilliamsJohn Williams
    Jun 8, 2011 at 2:59 am
    Jun 8, 2011 at 4:37 pm
  • Hi all! Please, just look at these query explanations and try to explain why planner does so (PostgreSQL 8.4). There is an index on table sms (number, timestamp). And three fast & simple queries: =# ...
    Vladimir KulevVladimir Kulev
    Jun 20, 2011 at 5:44 am
    Jul 15, 2011 at 7:43 am
  • Hi all, I am running PostgreSQL 9.0 on a number of nodes in an application level cluster (there is different data on different machines). Currently a PL/pgSQL function generates automatically ...
    Svetlin ManavskiSvetlin Manavski
    Jun 29, 2011 at 11:56 am
    Jun 30, 2011 at 12:37 pm
  • Hi list, I use Postgres 9.0.4. I have some tables with bitmask integers. Set bits are the interesting ones. Usually they are sparse. -- Many rows & columns CREATE TABLE a_table ( objectid INTEGER ...
    Marcus EngeneMarcus Engene
    Jun 22, 2011 at 9:34 pm
    Jul 5, 2011 at 5:43 pm
  • Here's the setup: I'm cross joining two dimensions before left outer joining to a fact table so that I can throw a default value into the resultset wherever a value is missing from the fact table. I ...
    Samuel GendlerSamuel Gendler
    Jun 30, 2011 at 8:53 am
    Jul 2, 2011 at 12:51 am
  • Hi, is there a way to change the sample size for statistics (that analyze gathers)? It is said to be 10%. i would like to raise that, because we are getting bas estimations for n_distinct. Cheers, ...
    Willy-Bas LoosWilly-Bas Loos
    Jun 10, 2011 at 12:15 pm
    Jun 29, 2011 at 2:55 am
  • A query I has spends a long time on Hash Joins (and Hash Left Joins). I have a few questions: 1. When does Postgres decide to do a Hash Join, over another type of Join? 2. Do Hash Joins normally ...
    Robert JamesRobert James
    Jun 2, 2011 at 12:10 am
    Jun 3, 2011 at 3:55 am
  • Hi, We did a benchmark comparing a Key-Value-Pairs stored as EAV db schema versus hstore. The results are promising in favor of hstore but there are some question which remain. 1. Obviously the '@ ' ...
    Stefan KellerStefan Keller
    Jun 19, 2011 at 6:59 pm
    Jul 22, 2011 at 5:08 pm
  • PostgreSQL 8.4.8 on CentOS 5.6, x86_64. Default settings except work_mem = 1MB. NOTE: I am using partitioned tables here, and was querying the 'master' table. Perhaps is this a Known Issue. I ran a ...
    Jon NelsonJon Nelson
    Jun 20, 2011 at 4:01 pm
    Jul 19, 2011 at 8:32 pm
  • Hi, Has anyone measured the cost of creating empty WAL segments while the database is running? Actually, when is the new file created? Just after one segment is filled up, or some time before then? ...
    Devrim GündüzDevrim Gündüz
    Jun 24, 2011 at 2:43 pm
    Jun 24, 2011 at 11:26 pm
  • Load testing of postgresql 8.4 for OLTP application suitability showed that throughput of the database significantly degraded over time from thousands of write transactions per second to almost zero. ...
    Kabu TaahKabu Taah
    Jun 17, 2011 at 12:54 pm
    Jun 19, 2011 at 11:14 pm
  • Hi performance gurus, One of the reasons I prefer PostgreSQL is because it does not implement hints. However I have a situation which seems like I am forced to use a hint-like statement: I have 2 ...
    Svetlin ManavskiSvetlin Manavski
    Jun 14, 2011 at 1:55 pm
    Jun 15, 2011 at 8:55 am
  • Hi, everyone. Some people with whom I'm working, and who have an 8.3 system running under Windows, asked me to look into their performance issues. They have a 1.5 GB database with a few dozen tables, ...
    Reuven M. LernerReuven M. Lerner
    Jun 9, 2011 at 3:24 pm
    Jun 12, 2011 at 3:55 am
  • Hi all, I am trying to speed up a query on a DB I inherited and I am falling flat on my face . I changed a query from NOT IN to use NOT EXISTS and my query time went from 19000ms to several hours ...
    MarkMark
    Jun 6, 2011 at 8:38 pm
    Jun 7, 2011 at 12:18 am
  • Hi everyone, I'm having trouble getting rid of a sequential scan on a table with roughly 120k entries it. Creation of an index on that particular column which triggers the sequential scan doesn't do ...
    Jens HoffrichterJens Hoffrichter
    Jun 27, 2011 at 12:46 pm
    Jun 27, 2011 at 11:01 pm
  • Hello All.. This is my first PostgreSql database. It has 8 tables and 4 tables are very huge each with 6million records. I have a simple view on this tables and it is taking more than 3hrs to return ...
    TripuraTripura
    Jun 21, 2011 at 8:34 pm
    Jun 22, 2011 at 8:57 pm
  • hai friend i have problem with performance database in postgre, how to know slowly query in postgre, i want kill or stop query to make postgre slowly, on the server status on the admin pg, sometimes ...
    Didik PrasetyoDidik Prasetyo
    Jun 20, 2011 at 7:57 am
    Jun 20, 2011 at 7:09 pm
  • Hi friend I Want to ask, is there any solutions or tools for monitoring memory performance in postgre automatically, for example, will send allert if Peformance memory has exceeded 90% thank you for ...
    Didik PrasetyoDidik Prasetyo
    Jun 7, 2011 at 7:53 am
    Jun 7, 2011 at 4:55 pm
  • All, Just got this simple case off IRC today: 8.4.4 This plan completes in 100ms: old_prod=# explain analyze select email from u_contact where id not in (select contact_id from u_user); QUERY PLAN ...
    Josh BerkusJosh Berkus
    Jun 6, 2011 at 9:46 pm
    Jun 7, 2011 at 8:19 am
  • Hi. I'm interested in understanding the differences between CLUSTERing a table and making a dedicated one. We have a table with about 1 million records. On a given day, only about 1% of them are of ...
    Robert JamesRobert James
    Jun 1, 2011 at 11:54 pm
    Jun 2, 2011 at 1:33 am
  • Hi, We are running postgresql database server on itanium box. Database - Postgresql 8.3.9 OS - SUSE Linux 11 SP 3 Server - Itanium (ia64) We are trying to enable user login / logout information in ...
    Muthu krishnanMuthu krishnan
    Jun 9, 2011 at 7:50 am
    Jun 9, 2011 at 7:55 am
  • Compañeros buenas noches: Existe una sentencia SQL "fuertemente acoplada" al interios del Sistema Gestor de Bases de Datos Postgresql que me permita "trasponer" tablas, algo similar al contrib cross ...
    Mario GuerreroMario Guerrero
    Jun 21, 2011 at 3:42 am
    Jun 21, 2011 at 3:42 am
  • First off, this is posted to the wrong list -- this list is for discussion of development of the PostgreSQL product. There is a list for performance questions where this belongs: ...
    Kevin GrittnerKevin Grittner
    Jun 6, 2011 at 3:49 pm
    Jun 6, 2011 at 3:49 pm
Group Navigation
period‹ prev | Jun 2011 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions39
posts283
users74
websitepostgresql.org
irc#postgresql

74 users for June 2011

Greg Smith: 21 posts Kevin Grittner: 20 posts Tomas Vondra: 18 posts Merlin Moncure: 11 posts Shaun Thomas: 11 posts Craig Ringer: 10 posts Tom Lane: 10 posts Harry Mantheakis: 9 posts Samuel Gendler: 9 posts Anthony Shipman: 8 posts Pavel Stehule: 8 posts Claudio Freire: 7 posts Tony Capobianco: 7 posts Svetlin Manavski: 6 posts Jenish: 5 posts Julius Tuskenis: 5 posts Robert Haas: 5 posts Robert Klemme: 5 posts Anibal David Acosta: 4 posts CS DBA: 4 posts
show more
Archives