FAQ

PostgreSQL > pgsql-performance > August 2003

Search Discussions

63 discussions - 549 posts

  • I have just installed redhat linux 9 which ships with Pg 7.3.2. Pg has to be setup so that data inserts (blobs) should be able to handle at least 8M at a time. The machine has two P III 933MHz CPU's, ...
    MixoMixo
    Aug 8, 2003 at 10:28 am
    Aug 14, 2003 at 9:52 pm
  • Of course. All IBM hw can do this, because on all ibm hw runs linux, and linux have more ways to do this :) -- Tomka Gergely "S most - vajon barbárok nélkül mi lesz velünk? Ők mégiscsak megoldás ...
    Tomka GergelyTomka Gergely
    Aug 28, 2003 at 6:52 am
    Sep 10, 2003 at 4:08 pm
  • Hey all. I said I was going to do it, and I finally did it. As with all performance tests/benchmarks, there are probably dozens or more reasons why these results aren't as accurate or wonderful as ...
    Bill MoranBill Moran
    Aug 27, 2003 at 1:48 am
    Sep 4, 2003 at 10:13 pm
  • I've been trying to search through the archives, but it hasn't been successful. We recently upgraded from pg7.0.2 to 7.3.4 and things were happy. I'm trying to fine tune things to get it running a ...
    JeffJeff
    Aug 5, 2003 at 12:09 pm
    Aug 6, 2003 at 12:54 pm
  • I'm surprised at the effort pgsql requires to run one of my queries. I don't know how to tune this query. Column | Type | Modifiers ------------+--------------+----------- the_id | integer | not null ...
    Ken GeisKen Geis
    Aug 29, 2003 at 12:11 am
    Aug 30, 2003 at 2:36 pm
  • Hi All! I have installed PostgreSQL 7.3.2 on FreeBSD 4.7, running on PC with CPU Pentium II 400MHz and 384Mb RAM. Problem is that SQL statement (see below) is running too long. With current WHERE ...
    Yaroslav MazurakYaroslav Mazurak
    Aug 6, 2003 at 7:35 am
    Aug 8, 2003 at 7:54 am
  • 19

    Tests

    http://195.199.65.92/~horvaths/pgperformance.html One of my friend do these tests. We think about the best filesystem for the Linux/Postgres systems. The four test was: teszt1 - 10.000 inserts teszt2 ...
    Tomka GergelyTomka Gergely
    Aug 21, 2003 at 2:51 pm
    Aug 30, 2003 at 4:25 am
  • Hi all! Really I don't know what happened with this query. I'm running PG 7.3.1 on solaris, vaccumed (full) every nigth. The cardinality of each table was: cont_contenido: 97 rows juegos_config: 40 ...
    Fernando PapaFernando Papa
    Aug 1, 2003 at 9:17 pm
    Aug 5, 2003 at 6:23 am
  • Hello, We're running a set of Half-Life based game servers that lookup user privileges from a central PostgreSQL 7.3.4 database server (I recently ported the MySQL code in Adminmod to PostgreSQL to ...
    Anders K. PedersenAnders K. Pedersen
    Aug 27, 2003 at 11:07 pm
    Aug 29, 2003 at 8:28 am
  • Folks: I have a live and a test database for an in-production system running on 7.2.4. The test database is a copy of the live one. They are running on the same copy of Postgres, on the same server. ...
    Josh BerkusJosh Berkus
    Aug 11, 2003 at 9:17 pm
    Aug 12, 2003 at 1:12 pm
  • I'm trying to understand how I can get the planner to always do the right thing with this query: EXPLAIN ANALYZE SELECT aa_t.min_date_time FROM aa_t , bb_t , cc_t WHERE bb_t.bb_id = aa_t.bb_id AND ...
    Rob NaglerRob Nagler
    Aug 30, 2003 at 1:36 pm
    Sep 1, 2003 at 9:03 pm
  • Hi all, I have some tables (which can get pretty large) in which I want to record 'current' data as well as 'historical' data. This table has fields 'deleted' and 'deleteddate' (among other fields, ...
    Alexander PriemAlexander Priem
    Aug 29, 2003 at 6:50 am
    Aug 30, 2003 at 12:40 am
  • I'm running into some performance problems trying to execute simple queries. postgresql version 7.3.3 .conf params changed from defaults. shared_buffers = 64000 sort_mem = 64000 fsync = false ...
    Michael GuerinMichael Guerin
    Aug 27, 2003 at 1:56 pm
    Aug 28, 2003 at 9:18 pm
  • Here's an interesting situation, and I think it may be just that Sun stinks. I was recently given the go ahead to switch from Informix to Postgres on one of our properties. (I had dozens of ...
    JeffJeff
    Aug 26, 2003 at 12:34 pm
    Aug 28, 2003 at 3:16 am
  • Hi, I'm running on Redhat 7.2 with postgresql 7.3.2 and I have two schema in the same database 'db' and 'db_dev'. Both contain a set of 20 tables for a total of less than 50 Mb of data each (on the ...
    Sebastien LemieuxSebastien Lemieux
    Aug 6, 2003 at 6:56 pm
    Aug 7, 2003 at 3:04 pm
  • I just ran a handful of tests on a 14-disk array on a SCSI hardware RAID card. From some quickie benchmarks using the bonnie++ benchmark, it appears that the RAID5 across all 14 disks is a bit faster ...
    Vivek KheraVivek Khera
    Aug 28, 2003 at 9:17 pm
    Sep 2, 2003 at 5:33 pm
  • Hi all, Couple of days ago, one of my colleague, Rahul Iyer posted a query regarding insert performance of 5M rows. A common suggestion was to use copy. Unfortunately he can not use copy due to some ...
    Shridhar DaithankarShridhar Daithankar
    Aug 16, 2003 at 8:38 am
    Aug 19, 2003 at 6:31 am
  • I want to know, how can I improve the performance of postgres, I have a java class thar inserts register every 30 min but is very slow. The process of postgres consume the 78% of CPU. I have in ...
    Ingrid martinezIngrid martinez
    Aug 13, 2003 at 2:04 pm
    Aug 13, 2003 at 7:00 pm
  • If a table which will be heavily used has numerous fields, yet only a handfull of them will be used heavily, would it make sense performance wise to split it? Example Table 1 Field 1 .... Field 100 ...
    Francisco ReyesFrancisco Reyes
    Aug 1, 2003 at 4:06 pm
    Aug 1, 2003 at 9:19 pm
  • Hi List, I have posted a subjetc on the admin list but I thought that it might fit better on this list as follow: Hi List, As I said before, I'm not a DBA " yet" , but I'm learning ... and I already ...
    Rhaoni Chiu PereiraRhaoni Chiu Pereira
    Aug 25, 2003 at 3:03 pm
    Sep 10, 2003 at 8:16 pm
  • Bruce Momjian commented: "Uh, the ext2 developers say it isn't 100% reliable" ... "I mentioned it while I was visiting Red Hat, and they didn't refute it." 1. Nobody has gone through any formal ...
    Chris BrowneChris Browne
    Aug 12, 2003 at 3:18 am
    Aug 15, 2003 at 10:05 am
  • OSDL has ported OSDL Database Test Suite 3(OSDL-DBT3) to PostgreSQL. It drives the database with an ad-hoc decision support workload. It helps database developers and users to identify database ...
    Jenny ZhangJenny Zhang
    Aug 1, 2003 at 5:56 pm
    Aug 4, 2003 at 10:48 pm
  • Hi, I'm using PostgreSQL 7.3.4 and noticed a havy performance issue when using the datatype text for PL/pgSQL functions instead of varchar. This is the table: CREATE TABLE user_login_table ( id ...
    Oliver SiegmarOliver Siegmar
    Aug 29, 2003 at 1:55 pm
    Aug 29, 2003 at 4:18 pm
  • I have a table that has about 20 foreign key constraints on it. I think this is a bit excessive and am considering removing them ( they are all related to the same table and I don't think there is ...
    TeknokratTeknokrat
    Aug 28, 2003 at 5:22 pm
    Aug 28, 2003 at 7:22 pm
  • Hi, I have a (big) problem with postgresql when making lots of inserts per second. I have a tool that is generating an output of ~2500 lines per seconds. I write a script in PERL that opens a pipe to ...
    Tarhon-Onu VictorTarhon-Onu Victor
    Aug 27, 2003 at 12:51 pm
    Aug 28, 2003 at 12:57 pm
  • Hi, I'm having a performance problem in postgresql. I have a rather complex view (attached) which, on itself, executes very fast, as it should. Normally this view is unordered. When I order the view ...
    Mathieu De ZutterMathieu De Zutter
    Aug 21, 2003 at 1:36 pm
    Aug 22, 2003 at 10:14 am
  • I have the following setup : Apache 2 + mod_perl 2 Postgres 7.3.2 I need to is measure the perfomance of a ticketing system (written in perl) which has web interface (html::mason, apache2) with Pg as ...
    MixoMixo
    Aug 15, 2003 at 6:34 am
    Aug 17, 2003 at 3:52 am
  • Hi all, I posted this problem on the sql list, and was referred to this list in stead. I have attached an sql statement that normally runs under 3 minutes. That is, until I vacuum analyze the ...
    StefStef
    Aug 11, 2003 at 2:16 pm
    Aug 12, 2003 at 5:30 pm
  • I'm very new to Postgresql, so don't beat me up to bad if you see a problem, just inform me what I've done wrong. I'm use Postgresql 7.2 (PeerDirect's Windows port) on Win2000 384MB RAM 10GB of Free ...
    Bupp PhillipsBupp Phillips
    Aug 25, 2003 at 8:21 pm
    Aug 27, 2003 at 6:22 am
  • Hi , I am using pg 7.3.3 on RH 7.3, dual Athlon 1 GB RAM. I have 2 tables a_acc and a_vid_doc (all PK are int). sizes: select count(IDS) from a_acc; count --------- 1006772 select count(IDS) from ...
    PginfoPginfo
    Aug 18, 2003 at 4:05 pm
    Aug 19, 2003 at 4:32 am
  • Hi all, Hopefully a quick query. Is there anything special I should look at when configuring either PostgreSQL and Linux to work together on an 8-way Intel P-III based system? I currently have the ...
    Castle, LindsayCastle, Lindsay
    Aug 27, 2003 at 4:08 am
    Aug 28, 2003 at 6:56 am
  • I was wondering if anyone found a sweet spot regarding how many inserts to do in a single transaction to get the best performance? Is there an approximate number where there isn't any more ...
    Trevor AstropeTrevor Astrope
    Aug 5, 2003 at 3:59 pm
    Aug 6, 2003 at 10:14 am
  • I didn't get any helpful responses to my previous email so I thought I would try again, this time with example code. Below is my orignal email and code for a dead simple ASCII menu driven application ...
    Medora SchauerMedora Schauer
    Aug 5, 2003 at 5:31 pm
    Aug 5, 2003 at 6:18 pm
  • Hi List, I still have performance problems with this sql: SELECT /*+ */ ftnfco00.estado_cliente , ftcofi00.grupo_faturamento , SUM( DECODE( ftcofi00.atual_fatura, '-', -(NVL(ftnfpr00.qtde_duzias,0)), ...
    Rhaoni Chiu PereiraRhaoni Chiu Pereira
    Aug 29, 2003 at 9:00 pm
    Sep 1, 2003 at 12:11 pm
  • Hello, I recently switched to 7.4 beta 1, one query that used to be corectly executed uder 7.3.3 albeit slowly now abnormaly ends when the backend can't get more memory when it ate about 480 MB of ...
    Bertrand PetitBertrand Petit
    Aug 14, 2003 at 10:21 am
    Aug 14, 2003 at 3:21 pm
  • Hi PostrgeSQL team, My PostrgeSQL installed as part of CYGWIN (Windows XP). I have compared performance PostrgeSQL to MS SQL (I used a little Java program with number of inserts in table). MS SQL is ...
    Serge DorofeevSerge Dorofeev
    Aug 11, 2003 at 9:00 am
    Aug 11, 2003 at 1:22 pm
  • I was ecstatic to hear that postgresql.com is releasing the eRServer replication project to postgresql.org as open source! I'm anxious to get my hands on it -- actually I'm desperate: I'm under ...
    George youngGeorge young
    Aug 29, 2003 at 5:20 pm
    Aug 30, 2003 at 4:51 am
  • Hi all, I did some benchmarking using pgbench and postgresql CVS head, compiled yesterday. The results are attached. It looks like 2.6.0-test4 does better under load but under light load the ...
    Shridhar DaithankarShridhar Daithankar
    Aug 27, 2003 at 3:31 pm
    Aug 28, 2003 at 6:52 am
  • need input on parameter values on confs... our database is getting 1000 transactions/sec on peak periods.. sitting on RH 7.3 2.4.7-10smp RAM: 1028400 SWAP: 2040244 queries are just simple select ...
    JMJM
    Aug 26, 2003 at 1:22 pm
    Aug 26, 2003 at 10:13 pm
  • My database is approximately 8gb in size. My application is 24/7. I'm constantly cycling through data. I analyze every 15 minutes but I'm noticing that during a vacuum the database becomes extremely ...
    Jeremy M. GuthrieJeremy M. Guthrie
    Aug 14, 2003 at 5:56 pm
    Aug 14, 2003 at 7:30 pm
  • Dear master: I have learned postgreSQL for serveral days, now i meet some problems. when I use a TPCC(Transaction Processing Performance Council) test program to test the performance of postgreSQL , ...
    Xin fuXin fu
    Aug 12, 2003 at 2:37 am
    Aug 12, 2003 at 6:03 pm
  • hello!!! what is suggested partitioning schema for postgresql?? the size of my db is 5BG and i have 36GB scsi disk! thanks wilson
    Wilson A. Galafassi Jr.Wilson A. Galafassi Jr.
    Aug 6, 2003 at 8:09 pm
    Aug 6, 2003 at 8:51 pm
  • How To calcute PostgreSQL HDD grow capacity for every byte data, start from installation initialize. Regards, Eko Pranoto
    Eko PranotoEko Pranoto
    Aug 29, 2003 at 3:40 am
    Aug 30, 2003 at 4:48 pm
  • I have found many reasons not to index small tables (see . But I still have questions. 1. How small is small enough? 2. am I supposed to drop primary key index on so called 'label tables' knowing I ...
    AlvisAlvis
    Aug 20, 2003 at 10:04 am
    Aug 20, 2003 at 1:30 pm
  • Hi, Currently we are using postgresql 7.3 with Redhat linux 9. We find that when we try to execute 200,000 update statement through JDBC, the performance of degraded obviously for each update ...
    WhchungWhchung
    Aug 11, 2003 at 11:34 am
    Aug 11, 2003 at 1:24 pm
  • Hello people. I'm installing Postgresql under linux for better performance and i want to know how is the best configuration. My server is a dual pentium3 1ghz/1gb ram/36gb scsi. running only ...
    Wilson A. Galafassi Jr.Wilson A. Galafassi Jr.
    Aug 6, 2003 at 6:03 pm
    Aug 6, 2003 at 9:33 pm
  • hello. my database size is 5GB. what is the block size recommend? thanks wilson
    Wilson A. Galafassi Jr.Wilson A. Galafassi Jr.
    Aug 6, 2003 at 8:39 pm
    Aug 6, 2003 at 8:51 pm
  • I have a table permissions with the fields (party_id integer, permission varchar, key_name varchar, key_value integer) for which I need to a query to see if a person has permission to carry out a ...
    Ara AnjargolianAra Anjargolian
    Aug 5, 2003 at 9:40 am
    Aug 5, 2003 at 9:56 am
  • Hi all, I compared 2.6 with elevator=deadline. It did bring some improvement in performance. But still it does not beat 2.4. Attached are three files for details. I also ran a simple insert benchmark ...
    Shridhar DaithankarShridhar Daithankar
    Aug 29, 2003 at 4:27 pm
    Aug 29, 2003 at 4:27 pm
  • Alright. To anyone who didn't get the news the first time: The first set of benchmarks were terribly skewed because FreeBSD didn't properly work with the hardware I was using. Thanks to those who ...
    Bill MoranBill Moran
    Aug 29, 2003 at 1:08 am
    Aug 29, 2003 at 1:08 am
Aug 2003
12
Group Navigation
period‹ prev | Aug 2003 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions63
posts549
users105
websitepostgresql.org
irc#postgresql

105 users for August 2003

Tom Lane: 49 posts Shridhar Daithankar: 35 posts Scott.marlowe: 28 posts Ron Johnson: 23 posts Josh Berkus: 21 posts Bruce Momjian: 19 posts Andrew Sullivan: 18 posts Bill Moran: 16 posts Jeff: 16 posts Christopher Kings-Lynne: 15 posts Tomka Gergely: 14 posts Ken Geis: 13 posts Rod Taylor: 13 posts Stephan Szabo: 12 posts Matt Clark: 11 posts Chris Browne: 10 posts Bruno Wolff III: 9 posts Christopher Browne: 9 posts Richard Huxton: 9 posts Sean Chittenden: 9 posts
show more
Archives