FAQ

PostgreSQL > pgsql-performance > September 2006

Search Discussions

54 discussions - 443 posts

  • I'm experiment with RAID, looking for an inexpensive way to boost performance. I bought 4 Seagate 7200.9 120 GB SATA drives and two SIIG dual-port SATA cards. (NB: I don't plan to run RAID 0 in ...
    Craig A. JamesCraig A. James
    Sep 14, 2006 at 6:21 pm
    Sep 25, 2006 at 2:25 pm
  • I am a software developer who is acting in a (temporary) dba role for a project. I had recommended PostgreSQL be brought in to replace the proposed MySQL DB - I chose PostgreSQL because of its ...
    Carlo StonebanksCarlo Stonebanks
    Sep 28, 2006 at 4:44 pm
    Oct 3, 2006 at 9:36 am
  • Hi All, I migrated Postgres server from 7.4.6 to 8.1.4, But my server is completely full, by moment load average 40 All queries analyzed by EXPLAIN, all indexes are used .. IO is good ... My ...
    Jérôme BENOISJérôme BENOIS
    Sep 14, 2006 at 1:27 pm
    Oct 3, 2006 at 7:36 am
  • Christoph NellesChristoph Nelles
    Sep 13, 2006 at 5:56 pm
    Oct 6, 2006 at 5:26 am
  • Hello, I have a big table called products. Table size: 1123MB. Toast table size: 32MB. Indexes size: 380MB. I try to do a query like this: select id,name from products where name like '%Mug%'; Yes, I ...
    Laszlo NagyLaszlo Nagy
    Sep 12, 2006 at 10:17 am
    Sep 18, 2006 at 8:50 am
  • My setup: Freebsd 6.1 Postgresql 8.1.4 Memory: 8GB SATA Disks Raid 1 10 spindles (2 as hot spares) 500GB disks (16MB buffer), 7200 rpm Raid 10 Raid 2 4 spindles 150GB 10K rpm disks Raid 10 ...
    Francisco ReyesFrancisco Reyes
    Sep 14, 2006 at 3:23 pm
    Sep 19, 2006 at 12:21 am
  • I am having problems performing a join on two large tables. It seems to only want to use a sequential scan on the join, but that method seems to be slower than an index scan. I've never actually had ...
    Joshua MarshJoshua Marsh
    Sep 12, 2006 at 10:17 pm
    Sep 14, 2006 at 2:18 pm
  • Hi I am trying to run sql-bench against PostgreSQL 8.1.4 on Linux. Some of the insert tests seems to be ver slow For example: select_join_in Are there any tuning parameters that can be changed to ...
    Yoav xYoav x
    Sep 13, 2006 at 12:24 pm
    Sep 15, 2006 at 12:32 am
  • Hi, probably this is a very frequenfly question... I read archivies of this list but I didn't found a finally solution for this aspect. I'll explain my situation. PSQL version 8.1.3 configuration of ...
    Matteo SgalaberniMatteo Sgalaberni
    Sep 1, 2006 at 1:25 pm
    Sep 5, 2006 at 3:17 am
  • Hello, we are running a 7.3 postgres db with only a big table (avg 500.000records) and 7 indexes for a search engine. we have 2 of this databases and we can switch from one to another. Last week we ...
    Edoardo CeccarelliEdoardo Ceccarelli
    Sep 27, 2006 at 4:08 pm
    Sep 28, 2006 at 8:44 am
  • List, I posted a little about this a while back to the general list, but never really got any where with it so I'll try again, this time with a little more detail and hopefully someone can send me in ...
    Matthew SchumacherMatthew Schumacher
    Sep 27, 2006 at 6:37 pm
    Sep 28, 2006 at 5:40 pm
  • Our application has a number of inserters posting rows of network statistics into a database. This is occuring continously. The following is an example of a stats table (simplified but maintains key ...
    Marc MorinMarc Morin
    Sep 25, 2006 at 8:34 pm
    Sep 27, 2006 at 3:45 am
  • Hi, a week ago we migrate a Woody(postgre 7.2.1) server to Sarge(postgre 7.4.7). To migrate the database we use a dump, using pg_dump with this options: pg_dump -U <username -c -F p -O -v -f ...
    PiñeiroPiñeiro
    Sep 11, 2006 at 6:50 pm
    Sep 14, 2006 at 7:25 pm
  • I have some odd cases here joining two tables - the planner insists on Merge Join, but Nested Loop is really faster - and that makes sense, since I'm selecting just a small partition of the data ...
    Tobias BroxTobias Brox
    Sep 26, 2006 at 7:54 pm
    Sep 27, 2006 at 7:01 pm
  • Hi After upgrading DBI and DBD::Pg, this benchmark still picks MySQL as the winner (at least on Linux RH3 on a Dell 1875 server with 2 hyperthreaded 3.6GHz CPUs and 4GB RAM). I've applied the ...
    Yoav xYoav x
    Sep 21, 2006 at 2:52 pm
    Sep 27, 2006 at 3:46 am
  • A colleague pointed me to this site tomorrow: http://tweakers.net/reviews/642/13 I can't read the language, so can't get a grip on what exactly the "benchmark" was about. Their diagrams show `Request ...
    Hannes DorbathHannes Dorbath
    Sep 22, 2006 at 8:29 am
    Sep 23, 2006 at 2:19 pm
  • Hi, I've been looking at the results from the pg_statio* tables, to view the impact of increasing the shared buffers to increase performance. As expected, increasing from the default by a factor of ...
    Guillaume CottenceauGuillaume Cottenceau
    Sep 1, 2006 at 7:35 pm
    Sep 5, 2006 at 6:13 pm
  • Hi, I have the following query which has been running very slowly and after a lot of testing/trial and error I found an execution plan that ran the query in a fraction of the time (and then lost the ...
    Tim TrumanTim Truman
    Sep 27, 2006 at 6:39 am
    Oct 4, 2006 at 12:56 am
  • Hi, for this simple join of two tables, SELECT * FROM large_rel n, smaller_rel a WHERE n.field_1 = a.field_2 AND a.key = '127.0.0.1'; PostgreSQL 8.1.4 chooses an extremely bad query plan: Hash Join ...
    Florian WeimerFlorian Weimer
    Sep 11, 2006 at 1:48 pm
    Sep 13, 2006 at 12:40 am
  • Hey guys, I've got a query that is inherently expensive, because it has to do some joins against some large tables. But it's currently *very* expensive (at least for a web app), and I've been ...
    BenBen
    Sep 28, 2006 at 10:19 pm
    Oct 6, 2006 at 5:24 am
  • Hi, We've been running our "webapp database"-benchmark again on mysql and postgresql. This time using a Fujitsu-Siemens RX300 S3 machine equipped with a 2.66Ghz Woodcrest (5150) and a 3.73Ghz Dempsey ...
    Arjen van der MeijdenArjen van der Meijden
    Sep 8, 2006 at 5:51 am
    Sep 8, 2006 at 4:46 pm
  • Honorable members of the list, I would like to share with you a side effect that I discovered today on our postgresql 8.1 server. We ve been running this instance with PITR for now 2 months without ...
    Cedric BoudinCedric Boudin
    Sep 28, 2006 at 8:14 pm
    Oct 2, 2006 at 4:25 pm
  • Hello Lister, I am curios whether I can emulate the Oracle pipelined functions functionality in PG too (using RETURN NEXT ). For more information and examples about Oracle pipelined functions see: ...
    Milen KulevMilen Kulev
    Sep 19, 2006 at 8:44 pm
    Sep 19, 2006 at 11:54 pm
  • I have a query which really should be lightning fast (limit 1 from index), but which isn't. I've checked the pg_locks table, there are no locks on the table. The database is not under heavy load at ...
    Tobias BroxTobias Brox
    Sep 28, 2006 at 6:56 am
    Oct 6, 2006 at 5:26 am
  • The query expain analyze looks like this: click-counter=# explain analyze select count(*) as count, to_char(date_trunc('day',c.datestamp),'DD-Mon') as day from impression c, url u, handle h where ...
    Alex TurnerAlex Turner
    Sep 22, 2006 at 3:35 pm
    Sep 27, 2006 at 3:46 am
  • I am in the process of speccing out a new box for a highly utilized (updates, inserts, selects) 40GB+ database. I'm trying to maximize performance on a budget, and I would appreciate any feedback on ...
    Brian WipfBrian Wipf
    Sep 8, 2006 at 8:22 am
    Sep 11, 2006 at 11:37 pm
  • Hi!.. I noticed that the age of template0 is increasing very rapidly..Can you please let me know how we can control this ....and what causes such problems. We also noticed that the database slow ...
    Nimesh SatamNimesh Satam
    Sep 7, 2006 at 10:31 am
    Sep 7, 2006 at 1:04 pm
  • Hi all, I was searching tips to speed up/reduce load on a Pg8 app. Thank you for all your suggestions on the matter. Thread is archived here: ...
    Cosimo StrepponeCosimo Streppone
    Sep 20, 2006 at 9:09 am
    Sep 27, 2006 at 3:15 am
  • I've just fired off a "DELETE FROM table" command (i.e. unfiltered DELETE) on a trivially small table but with many foreign key references (on similar-sized tables), and I'm waiting for it to finish. ...
    Ivan VorasIvan Voras
    Sep 19, 2006 at 1:48 pm
    Sep 19, 2006 at 8:39 pm
  • Sorry I answer the message only to Scott Marlowe. I re-send the response --------- Mensaje reenviado -------- De: Piñeiro <[email protected] Para: Scott Marlowe <[email protected] Asunto: ...
    PiñeiroPiñeiro
    Sep 12, 2006 at 4:07 pm
    Sep 12, 2006 at 7:21 pm
  • I'm experiencing a problem with our postgres database. Queries that normally take seconds suddenly start taking hours, if they complete at all. This isn't a vacuuming or analyzing problem- I've been ...
    Brian HurtBrian Hurt
    Sep 29, 2006 at 7:24 pm
    Sep 30, 2006 at 1:24 am
  • I've got this query with an IN clause: select count(*),public.album.gid,public.album.name,public.album.id from public.album,public.albumjoin,public.puid,public.puidjoin where albumjoin.album = ...
    BenBen
    Sep 24, 2006 at 5:12 pm
    Sep 27, 2006 at 3:22 am
  • Hi all, I still have an dual dual-core opteron box with a 3Ware 9550SX-12 sitting here and I need to start getting it ready for production. I also have to send back one processor since we were ...
    Charles SprickmanCharles Sprickman
    Sep 22, 2006 at 5:53 pm
    Sep 23, 2006 at 11:52 am
  • Hi, I am running bechmark test in a 50 GB postgresql database. I have the postgresql.conf with all parameters by default. In this configuration the database is very, very slow. Could you please tell ...
    Nuno AlvesNuno Alves
    Sep 20, 2006 at 3:28 pm
    Sep 20, 2006 at 10:05 pm
  • Hi, Is there anyway we can optimize this sql ? it is doing full table scan on listing and address table . Postgres version 8.0.2 Thanks! Pallav. explain analyze select listing0_.listingid as ...
    Pallav KalvaPallav Kalva
    Sep 15, 2006 at 3:09 pm
    Sep 18, 2006 at 7:36 am
  • Hi listers, I wanted to try PG partitioning (aka constraint exclusion) with two levels . I am using PG 8.1.3 on RHEL4U2, My setup: CREATE TABLE part ( id1 int not null, id2 int not null, id3 int not ...
    Milen KulevMilen Kulev
    Sep 17, 2006 at 10:12 pm
    Sep 18, 2006 at 6:10 am
  • Hi, I have two table: customers and salesorders. salesorders have a foreign key to the customer If I run this query: SELECT salesOrders.objectid, salesOrders.ordernumber, salesOrders.orderdate, ...
    Joost KraaijeveldJoost Kraaijeveld
    Sep 15, 2006 at 8:51 am
    Sep 15, 2006 at 4:17 pm
  • Hi i have a severe performance problem with one of my views which has 6 to 8 joins .. any help will be appreciated.. the view is: CREATE OR REPLACE VIEW thsn.trade_view AS SELECT tra.tra_id, ...
    Fardeen memonFardeen memon
    Sep 8, 2006 at 12:50 pm
    Sep 11, 2006 at 2:22 pm
  • Hi, I am trying to vaccum one of the table using the following command: VACUUM FULL ANALYZE VERBOSE table_name; But for some reason the table vaccuming is not going ahead. Can you guys let me know ...
    Nimesh SatamNimesh Satam
    Sep 30, 2006 at 9:26 am
    Oct 2, 2006 at 7:08 pm
  • Hi, I am working on datamigration from older version of informix to postgres 8.1 I need to increase performance on postgres, since informix(older version,older hardware, little bigger DB data) is 4-5 ...
    GurkanGurkan
    Sep 29, 2006 at 5:12 pm
    Sep 30, 2006 at 9:50 am
  • Hello All I am getting this message in my log files for my database. LOG: out of file descriptors: Too many open files; release and retry. At some point the memomy didn't get released and the ...
    JallgoodJallgood
    Sep 12, 2006 at 7:44 pm
    Sep 28, 2006 at 6:54 pm
  • Hi all, I'm having some confusion with the 7.4 query planner. I have two identical queries, whereby the passed (varchar) parameter appears to be the deciding factor between a sequential or an index ...
    Anthony PresleyAnthony Presley
    Sep 22, 2006 at 11:23 pm
    Sep 23, 2006 at 12:25 am
  • I'm having a problem with a simple query, that finds children of a node, using a materialized path to the node. The query: select n1.id from nodes n1, nodes n2 where n1.path like n2.path || '%' and ...
    Marc McIntyreMarc McIntyre
    Sep 19, 2006 at 12:07 am
    Sep 19, 2006 at 3:17 am
  • Hi, How do I optimize postgres8.1? I have 'vacuum full analyze' I have posted output of 'explain analyze select ..' I have created some indexes I am running Mixed-Mode server,4GB ram running ...
    GurkanGurkan
    Sep 29, 2006 at 9:36 pm
    Sep 29, 2006 at 9:58 pm
  • Hello! I got two AMD Opteron 885 processors (2.6ghz) and 8 gig of memory. Harddrives are 4 scsi disks in 10 raid. I'm running gentoo, and the kernel finds and uses all of my 2 (4) cpu's. How can i ...
    Kjell Tore FossbakkKjell Tore Fossbakk
    Sep 25, 2006 at 8:30 am
    Sep 25, 2006 at 8:47 am
  • Greetings: I'm running 8.1.4, and have noticed major differences in execution time for plpgsql functions running queries that differ only in use of an array such as: slower_function( vals integer[] ) ...
    Benjamin MinshallBenjamin Minshall
    Sep 15, 2006 at 8:04 pm
    Sep 15, 2006 at 8:19 pm
  • Hi All I have installed a application with postgres-8.1.4 , I have to optimize the performance, As a measure i thought of enabling Auto commit , is it a right decision to take , If correct please ...
    krishnaraj Dkrishnaraj D
    Sep 12, 2006 at 3:10 pm
    Sep 12, 2006 at 3:18 pm
  • Hi, I have a customer who wants a database solution for a 7 TB database. Insert will be the main action in the database. There are some case studies with detail information about performance and ...
    Nuno Alexandre AlvesNuno Alexandre Alves
    Sep 8, 2006 at 10:01 am
    Sep 8, 2006 at 4:19 pm
  • hi plz unsubscribe me.. i am sending mail to this id.. for unsubscribing.. is it correct.. my mail box is gettin flooded..
    PhadnisPhadnis
    Sep 8, 2006 at 3:04 pm
    Sep 8, 2006 at 3:08 pm
  • Hi. My config: gentoo linux "2005.1" on amd64x2 in 64-bit mode, kernel 2.6.16.12 glibc 3.3.5(NPTL), gcc 3.4.3. I had not used portage for building. I built two versions of postgres from sources: ...
    Roman KrylovRoman Krylov
    Sep 4, 2006 at 8:44 pm
    Sep 7, 2006 at 5:55 pm
Sep 2006
12
Group Navigation
period‹ prev | Sep 2006 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions54
posts443
users109
websitepostgresql.org
irc#postgresql

109 users for September 2006

Tom Lane: 40 posts Jim Nasby: 22 posts Luke Lonergan: 21 posts Markus Schaber: 21 posts Dave Cramer: 17 posts Jeff Davis: 13 posts Scott Marlowe: 13 posts Carlo Stonebanks: 12 posts Jérôme BENOIS: 12 posts Merlin Moncure: 12 posts Bucky Jordan: 11 posts Tobias Brox: 10 posts Francisco Reyes: 9 posts Joshua Marsh: 9 posts Arjen van der Meijden: 8 posts Dave Dutcher: 7 posts Laszlo Nagy: 7 posts Bill Moran: 6 posts Guillaume Cottenceau: 6 posts Guillaume Smet: 6 posts
show more
Archives