FAQ

PostgreSQL > pgsql-performance > August 2010

Search Discussions

34 discussions - 355 posts

  • Hello, I just upgraded with pg_dump/restore from PostgreSQL 8.3.11 to 8.4.4 but I'm having major performance problems with a query with many left joins. Problem is that costs are now very, very, very ...
    Gerhard WiesingerGerhard Wiesinger
    Aug 30, 2010 at 6:39 am
    Jan 5, 2011 at 8:26 pm
  • If anyone is interested I just completed a series of benchmarks of stock Postgresql running on a normal HDD vs a SSD. If you don't want to read the post, the summary is that SSDs are 5 to 7 times ...
    Michael MarchMichael March
    Aug 7, 2010 at 11:48 pm
    Aug 18, 2010 at 11:49 am
  • I am using PostgreSQL 8.3.7 on a dedicated IBM 3660 with 24GB RAM running CentOS 5.4 x86_64. I have a ServeRAID 8k controller with 6 SATA 7500RPM disks in RAID 6, and for the OLAP workload it feels* ...
    Kenneth CoxKenneth Cox
    Aug 5, 2010 at 6:28 pm
    Aug 17, 2010 at 9:37 am
  • Hi, I'm having a strange performance result on a new database server compared to my simple desktop. The configuration of the new server : - OS : GNU/Linux Debian Etch x86_64 - kernel : Linux ...
    Philippe RimbaultPhilippe Rimbault
    Aug 19, 2010 at 8:07 am
    Aug 31, 2010 at 6:57 pm
  • I have two tables: A: ItemID (PK), IsssueID (Indexed) B: ItemID (FK), IndexNumber : PK(ItemID, IndexNumber) Both tables have several million columns, but B has much more than A. Now if I run SELECT ...
    Jann RöderJann Röder
    Aug 23, 2010 at 4:25 am
    Aug 24, 2010 at 1:24 pm
  • Hi, PG 8.4.4 I have an strange problem: carmen=# VACUUM FULL verbose tp93t; INFO: vacuuming "public.tp93t" INFO: "tp93t": found 0 removable, 71984 nonremovable row versions in 17996 pages DETAIL: ...
    Alexandre de Arruda PaesAlexandre de Arruda Paes
    Aug 17, 2010 at 7:19 pm
    Aug 22, 2010 at 6:01 pm
  • Not sure if anyone else saw this, but it struck me as an interesting idea if it could be added to PostgreSQL. GPU accelerated database operations could be very... interesting. Of course, this could ...
    Eliot GableEliot Gable
    Aug 30, 2010 at 1:47 pm
    Sep 21, 2010 at 7:28 pm
  • Hi, I'm running PostgreSQL 8.3 and I have a query with a couple of NOT IN subqueries: DELETE FROM foo WHERE type = 'o' AND b NOT IN (SELECT cqc.b FROM bar cqc) AND b NOT IN (SELECT car.b FROM foo car ...
    Maciek SakrejdaMaciek Sakrejda
    Aug 2, 2010 at 7:13 pm
    Aug 2, 2010 at 10:37 pm
  • Hi, I'm hoping someone can offer some help here. The query and explain analyze and table layout are below and attached in a text file if the formatting is bad. The query is part of a bigger query ...
    Aaron BurnettAaron Burnett
    Aug 17, 2010 at 1:19 am
    Aug 18, 2010 at 11:56 am
  • I'm trying to eke a little bit more performance out of an application, and I was wondering if there was a better way to do the following: I am trying to retrieve, for many sets of rows grouped on a ...
    Matthew WakelingMatthew Wakeling
    Aug 10, 2010 at 3:40 pm
    Aug 11, 2010 at 3:54 pm
  • Hi, I have a colleague that is convinced that the website is faster if enable_seqscan is turned OFF. I'm convinced of the opposite (better to leave it ON), but i would like to show it, prove it to ...
    Willy-Bas LoosWilly-Bas Loos
    Aug 26, 2010 at 10:33 am
    Oct 1, 2010 at 5:51 pm
  • I have a query that Select Distinct VehicleId From Vehicle Where VehicleMileage between 0 and 15000. I have an index on VehicleMileage. Is there another way to put an index on a between? The index is ...
    Ozer, PamOzer, Pam
    Aug 28, 2010 at 12:21 am
    Sep 23, 2010 at 12:51 am
  • I've got this explain: http://explain.depesz.com/s/Xh9 And these settings: default_statistics_target = 50 # pgtune wizard 2010-08-17 maintenance_work_mem = 1GB # pgtune wizard 2010-08-17 ...
    Samuel GendlerSamuel Gendler
    Aug 19, 2010 at 5:24 am
    Aug 19, 2010 at 1:29 pm
  • Hi, Are indices for columns marked with "PRIMARY KEY" automatically generated by postgresql, or do I have to do it manually? The question might seem dumb, I ask because I remember from working with ...
    Clemens EissererClemens Eisserer
    Aug 18, 2010 at 1:51 pm
    Aug 25, 2010 at 6:59 am
  • I'm just starting the process of trying to tune new hardware, which is 2x quad core xeon, 48GB RAM, 8x300GB SAS 15K drives in RAID 1+0, 2x72GB 15K SAS drives in RAID 1 for WAL and system. It is a ...
    Samuel GendlerSamuel Gendler
    Aug 18, 2010 at 7:24 pm
    Aug 28, 2010 at 10:18 am
  • I am new to Postgres and I am trying to understand the Explain Analyze so I can tune the following query. I run the same query using mysql and it takes less than 50ms. I run it on postgres and it ...
    Ozer, PamOzer, Pam
    Aug 27, 2010 at 12:03 am
    Aug 27, 2010 at 5:44 pm
  • I am having severe COPY performance issues after adding indices. What used to take a few minutes (without indices) now takes several hours (with indices). I've tried to tweak the database ...
    Saadat AnwarSaadat Anwar
    Aug 18, 2010 at 4:43 pm
    Aug 20, 2010 at 7:25 am
  • Hi all ; we have an automated partition creation process that includes the creation of an FK constraint. we have a few other servers with similar scenarios and this is the only server that stinks per ...
    Kevin KempterKevin Kempter
    Aug 30, 2010 at 10:26 pm
    Sep 21, 2010 at 7:39 pm
  • we have this application (using jboss/java/hibernate) on linux accessing data on 3 postgres database servers using 8.4.1. One of our many concerns has been the way we handle connections to the ...
    Maria L. WilsonMaria L. Wilson
    Aug 26, 2010 at 8:29 pm
    Aug 30, 2010 at 2:22 pm
  • Howdy all, We're doing some performance testing, and when we scaled it our app up to about 250 concurrent users we started seeing a bunch of processes sititng in "PARSE WAITING" state. Can anyone ...
    David KerrDavid Kerr
    Aug 23, 2010 at 10:16 pm
    Aug 24, 2010 at 1:18 am
  • Hi, I'm curious -- does "vacuum analyze e.g. table1" improve performance on "insert into table1 ...". I understand the vacuum analyze helps out the query -- select, etc., but just not quite sure on ...
    Sean ChenSean Chen
    Aug 5, 2010 at 5:50 pm
    Aug 9, 2010 at 2:03 pm
  • We have been using the C locale for everything at our site, but there is occasionally talk of supporting characters outside the ASCII7 set. In playing around with indexing, to see what the impact of ...
    Kevin GrittnerKevin Grittner
    Aug 4, 2010 at 4:34 pm
    Aug 4, 2010 at 5:00 pm
  • Please forgive the barrage of questions. I'm just learning how to tune things in postgres and I've still got a bit of learning curve to get over, apparently. I have done a lot of reading, though, I ...
    Samuel GendlerSamuel Gendler
    Aug 19, 2010 at 6:14 am
    Aug 19, 2010 at 4:28 pm
  • A little background - I have various multi-column indexes whenever I have queries which restrict the output based on the values of the 2 fields (for example, a client code and the date of a ...
    Benjamin KrajmalnikBenjamin Krajmalnik
    Aug 17, 2010 at 3:26 am
    Aug 17, 2010 at 3:28 pm
  • Hi, I've database of lyrics and I'm using this query for suggest box. SELECT views, title, id FROM songs WHERE title ILIKE 'bey%' ORDER BY views DESC LIMIT 15; In query plan is this line: - Seq Scan ...
    Fiala_marekFiala_marek
    Aug 17, 2010 at 7:26 am
    Aug 17, 2010 at 3:16 pm
  • We are running 8.3.10 64bit. This message is a request for information about the "initplan" operation in explain plan. I want to know if I can take advantage of it, and use it to initialize ...
    Mark RostronMark Rostron
    Aug 1, 2010 at 6:36 am
    Aug 2, 2010 at 5:29 pm
  • Hello There, I have a table x and a history table x_hist, whats the best way to update the history table. should i need to use triggers or embed a code in my script to update the history table? what ...
    DMDM
    Aug 23, 2010 at 6:42 pm
    Aug 25, 2010 at 2:30 pm
  • Ref these two queries against a view: -- QUERY 1, executes < 0.5 secs SELECT * FROM mdx_core.vw_provider AS p WHERE provider_id IN (13083101) -- QUERY 2, executes 13.5 secs SELECT * FROM ...
    Carlo StonebanksCarlo Stonebanks
    Aug 12, 2010 at 9:53 pm
    Aug 13, 2010 at 2:51 pm
  • With a 16 CPU, 32 GB Solaris Sparc server, is there any conceivable reason to use a 32 bit build rather than a 64 bit build? Apparently the Sun PostgreSQL package includes a README that indicates you ...
    Joseph ConwayJoseph Conway
    Aug 11, 2010 at 3:18 pm
    Aug 12, 2010 at 7:32 am
  • Hallo, Im running pg-8,pgpoolII on sol10-zone. After update sol10u7, queries on coltype timestamp are very slow. System: sparc, 2GB RAM This DB is a greylist-DB to fight spam. 500 connections should ...
    Heiko L.Heiko L.
    Aug 4, 2010 at 7:16 am
    Aug 12, 2010 at 4:12 am
  • I don't clearly understand why this happens, but when I try join some tables using arrays I end up with: =# explain select count(*) from urls JOIN rules ON urls.tag && rules.tag; QUERY PLAN ...
    Volodymyr KostyrkoVolodymyr Kostyrko
    Aug 29, 2010 at 1:18 pm
    Aug 30, 2010 at 4:07 am
  • Hi All, I have a poor performance SQL as following. The table has about 200M records, each employee have average 100 records. The query lasts about 3 hours. All I want is to update the flag for ...
    MikeMike
    Aug 26, 2010 at 1:27 am
    Aug 26, 2010 at 5:24 am
  • Hello! We've just installed a couple new servers that will be our new database servers. The basic hardware stats of each are: 2 x Xeon E5620 (2.4GHz quad-core) 32GB DDR3 1333 RAM 6 x 600GB 15krpm SAS ...
    Bob BranchBob Branch
    Aug 25, 2010 at 4:04 pm
    Aug 25, 2010 at 4:25 pm
  • List, I see benefits to using the 8.4 WINDOW clause in some cases but I'm having trouble seeing if I could morph the following query using it. wxd0812=# EXPLAIN ANALYZE wxd0812-# SELECT * FROM ...
    Greg SpiegelbergGreg Spiegelberg
    Aug 13, 2010 at 4:44 pm
    Aug 13, 2010 at 9:17 pm
Aug 2010
Group Navigation
period‹ prev | Aug 2010 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions34
posts355
users85
websitepostgresql.org
irc#postgresql

85 users for August 2010

Greg Smith: 34 posts Scott Marlowe: 34 posts Kevin Grittner: 32 posts Tom Lane: 19 posts Scott Carey: 14 posts Yeb Havinga: 12 posts Samuel Gendler: 11 posts Andres Freund: 7 posts Gerhard Wiesinger: 7 posts Robert Haas: 7 posts Brad Nicholson: 6 posts Hannu Krosing: 6 posts Jann Röder: 6 posts Maciek Sakrejda: 6 posts Alvaro Herrera: 5 posts Jose Ildefonso Camargo Tolosa: 5 posts Pavel Stehule: 5 posts Gnuoytr: 4 posts Alexandre de Arruda Paes: 4 posts Bruce Momjian: 4 posts
show more
Archives