FAQ

PostgreSQL > pgsql-performance > September 2007

Search Discussions

57 discussions - 478 posts

  • Hi, We are currently running our DB on a DualCore, Dual Proc 3.Ghz Xeon, 8GB RAM, 4x SAS 146 GB 15K RPM on RAID 5. The current data size is about 50GB, but we want to purchase the hardware to scale ...
    Harsh AzadHarsh Azad
    Sep 6, 2007 at 12:35 pm
    Sep 13, 2007 at 6:27 pm
  • A client is moving their postgresql db to a brand new Windows 2003 x64 server with 2 quad cores and 32GB of RAM. It is a dedicated server to run 8.2.4. The server typically will have less than 10 ...
    Carlo StonebanksCarlo Stonebanks
    Sep 4, 2007 at 10:45 pm
    Sep 11, 2007 at 8:32 pm
  • Hello. We have made some performance tests with DRBD and Postgresql 8.2.3. We have two identical servers in a cluster (Dell 2950) with a partition of 100 GB managed by DRBD: once we checked Postgres ...
    Maila FatticcioniMaila Fatticcioni
    Sep 7, 2007 at 9:45 am
    Sep 17, 2007 at 3:19 pm
  • Can anyone answer this for me: Although I realize my client's disk subsystem (SCSI/RAID Smart Array E200 controller using RAID 1) is less than impressive - is the default setting of 4.0 realistic or ...
    Carlo StonebanksCarlo Stonebanks
    Sep 10, 2007 at 7:25 pm
    Sep 16, 2007 at 8:01 pm
  • Hi all, Postgres version: 8.2.4 Tables: table_a(a bigint, b bigint, primary key(a, b) ); table_b1(b bigint primary key, more columns...); table_b2(b bigint primary key references table_b1(b), more ...
    Csaba NagyCsaba Nagy
    Sep 21, 2007 at 10:03 am
    Sep 28, 2007 at 12:33 pm
  • Hi all. Recently I have installed a brand new server with a Pentium IV 3.2 GHz, SATA Disk, 2GB of Ram in Debian 4.0r1 with PostgreSQL 8.2.4 (previously a 8.1.9). I have other similar server with an ...
    Brauagustin-suscBrauagustin-susc
    Sep 19, 2007 at 5:45 pm
    Sep 24, 2007 at 2:16 pm
  • Hi, I having the same problem I told here a few weeks before. Database is using too much resources again. I do a vacumm full each day, but seems it is not working. I am preparing an update to ...
    Ruben RubioRuben Rubio
    Sep 11, 2007 at 6:34 am
    Sep 24, 2007 at 6:58 am
  • Sorry, I know this is probably more a linux question, but I'm guessing that others have run into this... I'm finding this rather interesting report from top on a Debian box... Mem: 32945280k total, ...
    Decibel!Decibel!
    Sep 20, 2007 at 11:04 pm
    Oct 2, 2007 at 10:18 pm
  • I'm having a problem with long running commits appearing in my database logs. It may be hardware related, as the problem appeared when we moved the database to a new server connected to a different ...
    Brad NicholsonBrad Nicholson
    Sep 13, 2007 at 2:15 pm
    Sep 14, 2007 at 4:22 pm
  • Hello, I have a recurring script that updates some tables from an MS_SQL server. One of the operations sets a field in all records to null in preparation of being updated with values from the other ...
    ShawnShawn
    Sep 1, 2007 at 5:28 pm
    Sep 10, 2007 at 1:29 am
  • Hello all, Old servers that housed 7.4 performed better than 8.1.4 version...are there any MAJOR performance hits with this version??? I set the postgresql.conf setting to equal that of 7.4 and ...
    Smiley2211Smiley2211
    Sep 20, 2007 at 7:10 pm
    Sep 21, 2007 at 2:08 pm
  • I recently had a puzzling experience (performace related). Had a DB running presumably smoothly, on a server with Dual-Core Opteron and 4GB of RAM (and SATA2 drives with Hardware RAID-1). (PostgreSQL ...
    Carlos MorenoCarlos Moreno
    Sep 23, 2007 at 4:45 pm
    Sep 23, 2007 at 11:05 pm
  • Hi guys, I'm have the rare opportunity to spec the hardware for a new database server. It's going to replace an older one, driving a social networking web application. The current server (a quad ...
    Willo van der MerweWillo van der Merwe
    Sep 6, 2007 at 6:55 am
    Sep 12, 2007 at 7:17 am
  • Hi all, I need to improve a query like : SELECT id, min(the_date), max(the_date) FROM my_table GROUP BY id; Stupidly, I create a B-tree index on my_table(the_date), witch is logically not used in my ...
    JS UbeiJS Ubei
    Sep 5, 2007 at 10:00 am
    Sep 8, 2007 at 8:00 am
  • Hi all, Please see the section marked as "PROBLEM" in "ORIGINAL QUERY" plan below. You can see it's pretty slow. Oddly enough, an index for facility_address_id is available but not being used, but I ...
    Carlo StonebanksCarlo Stonebanks
    Sep 17, 2007 at 8:22 pm
    Sep 18, 2007 at 8:07 pm
  • (SORRY FOR THE REPOST, I DON'T SEE MY ORIGINAL QUESTION OR ANY ANSWERS HERE) I am noticing that my queries are spending a lot of time in nested loops. The table/index row estimates are not bad, but ...
    Carlo StonebanksCarlo Stonebanks
    Sep 20, 2007 at 3:20 pm
    Sep 27, 2007 at 6:59 am
  • Hello, My question is about index usage when bitwise operations are invoked. Situation Context: -------------------------- Lets suppose we have 2 tables TBL1 and TBL2 as the following: TBL1 { ...
    W.Alphonse HAROUNYW.Alphonse HAROUNY
    Sep 13, 2007 at 12:30 pm
    Sep 18, 2007 at 10:36 am
  • Hi, Where are the database index files located in the $PGDATA directory? I was thinking on soft linking them to another physical hard disk array. Thanks, Azad
    Harsh AzadHarsh Azad
    Sep 14, 2007 at 2:50 am
    Sep 14, 2007 at 8:29 pm
  • Hi, appreciate if someone can have some pointers for this. PG.8.2.4 1.4G centrino(s/core) 1.5GB ram/5400rpm laptop HD 3 mail tables which has already been selected "out" into separate tables (useing ...
    El-LotsoEl-Lotso
    Sep 11, 2007 at 4:58 pm
    Sep 14, 2007 at 6:31 am
  • hi, i have the following table: CREATE TABLE "main_activity" ( "id" serial NOT NULL PRIMARY KEY, "user_id" integer NOT NULL, "sessionid" varchar(128) NOT NULL, "login" timestamp with time zone NOT ...
    Gábor FarkasGábor Farkas
    Sep 24, 2007 at 2:14 pm
    Sep 24, 2007 at 3:38 pm
  • Hi, I think the query planner is unaware of the possibly best plan in some situations. See the test case below: -- --------------------------------------------------- -- CREATE TABLE tparent ( id ...
    Denes DanielDenes Daniel
    Sep 21, 2007 at 3:38 pm
    Sep 22, 2007 at 12:33 pm
  • Hello everyone: I wanted to ask you about how the VACUUM ANALYZE works. is it possible that something can happen in order to reset its effects forcing to execute the VACUUM ANALYZE comand again? i am ...
    RafaelRafael
    Sep 4, 2007 at 5:27 pm
    Sep 4, 2007 at 11:24 pm
  • Hi All, I've recently run into problems with my kernel complaining that I ran out of memory, thus killing off postgres and bringing my app to a grinding halt. I'm on a 32-bit architecture with 16GB ...
    Richard YenRichard Yen
    Sep 7, 2007 at 8:32 am
    Sep 7, 2007 at 2:56 pm
  • Hello, I have a weird performance issue with a query I'm testing. Basically, I'm trying to port a function that generates user uids, and since postgres offers a sequence generator function, I figure ...
    Peter KoczanPeter Koczan
    Sep 27, 2007 at 10:04 pm
    Oct 1, 2007 at 7:23 pm
  • Hi, Anyone has tried a setup combining tablespaces with NFS-mounted partitions? I'm considering the idea as a performance-booster --- our problem is that we are renting our dedicated server from a ...
    Carlos MorenoCarlos Moreno
    Sep 19, 2007 at 4:16 pm
    Sep 20, 2007 at 7:24 pm
  • Hello, Now that both 4x4 out it's time for us to decide which one should be better for our PostgreSQL and Oracle. And especially for Oracle we really need such server to squeeze everything from ...
    MindaugasMindaugas
    Sep 11, 2007 at 8:18 am
    Sep 11, 2007 at 11:00 pm
  • Hi, I am having some trouble understanding a plan and was wondering if anyone could guide me. The query in question here seems to be showing some incorrect row counts. I have vacuumed and analyzed ...
    PgdbaPgdba
    Sep 26, 2007 at 2:22 pm
    Sep 26, 2007 at 4:56 pm
  • I perform simple INSERT and simple where-clause DELETE. I also force a commit after every DELETE. My two tables are about these: TABLE_A Column_1 | column2 | ....... TABLE_B Column_1B foreign key ...
    Galantucci GiovanniGalantucci Giovanni
    Sep 18, 2007 at 7:17 am
    Sep 19, 2007 at 11:27 am
  • Hello, In Postgres 7.2.4, COPY command is working fine even if tables have 6 fields but we are copying only 5 fields from the file But in Postgres 8.2.0, if table has 6 fields and we need to copy ...
    Soni deSoni de
    Sep 14, 2007 at 10:21 am
    Sep 18, 2007 at 3:05 pm
  • Hi I couldnt find any specifics on this subject in the documentation, so I thought I'd ask the group. how does pg utilise multi cpus/cores, i.e. does it use more than one core? and possibly, how, are ...
    Thomas FinneidThomas Finneid
    Sep 5, 2007 at 10:55 pm
    Sep 7, 2007 at 10:20 am
  • Hello, I was wondering whether any thought has previously been given to having a non-blocking "vacuum full", in the sense of space reclamation and table compactation. The motivation is that it is ...
    Peter SchullerPeter Schuller
    Sep 28, 2007 at 6:12 pm
    Sep 29, 2007 at 8:06 am
  • Hi everybody, Is there a way to find which query is doing large io operations and/or which is using cached data and which is reading from disk. I need to see this on a production server to localize a ...
    Kamen StanevKamen Stanev
    Sep 20, 2007 at 9:37 pm
    Sep 25, 2007 at 7:59 pm
  • Hi, I was looking for opinions on performance for a design involving schemas. We have a 3-tier system with a lot of hand-written SQL in our Java-based server, but we want to start limiting the data ...
    Brennan, Sean \(IMS\)Brennan, Sean \(IMS\)
    Sep 1, 2007 at 3:10 am
    Sep 4, 2007 at 1:08 am
  • Hi - This has been happening more recently. Our database hangs after a VACUUM and is unresponsive when we come in next morning. The vacuum job runs at 03:00 am daily. The command is : ...
    Radhika SRadhika S
    Sep 28, 2007 at 2:28 pm
    Sep 28, 2007 at 3:28 pm
  • I have a database that we want to keep track of counts of rows. We have triggers on the rows which increment, and decrement a count table. In order to speed up deleting many rows we have added the ...
    Dave CramerDave Cramer
    Sep 25, 2007 at 11:08 am
    Sep 25, 2007 at 11:39 am
  • Hello, I have a database with an amount of tables and in several of them I have an attribute for a semantic definition, for which I use a field of type text. I am trying to decide if it would be ...
    Fabiola FernándezFabiola Fernández
    Sep 24, 2007 at 3:21 pm
    Sep 24, 2007 at 4:01 pm
  • Hi all, I have a problem with DELETE performance with postgres 7.4. I have a database with 2 great tables (about 150,000 rows) continuously updated, with 1000 - 1200 INSERT per second and 2 or 3 huge ...
    Galantucci GiovanniGalantucci Giovanni
    Sep 17, 2007 at 8:10 am
    Sep 17, 2007 at 10:21 am
  • hi! I wonder if clustering a table improves perfs somehow ? Any example/ideas about that ? ref : http://www.postgresql.org/docs/8.2/interactive/sql-cluster.html thx, P.
    Patrice CastetPatrice Castet
    Sep 13, 2007 at 1:11 pm
    Sep 13, 2007 at 3:04 pm
  • Hi List; I've recently started cleaning up some postgres db's which previous to my recent arrival had no DBA to care for them. I quickly figured out that there were several tables which were grossly ...
    Kevin KempterKevin Kempter
    Sep 11, 2007 at 4:29 pm
    Sep 11, 2007 at 11:04 pm
  • Hi, I've a question about amount of indices. I explain my issue based on an example: Table which contains person information, one row per person. There will be lots of SELECTS doing search by special ...
    PatricPatric
    Sep 6, 2007 at 8:24 pm
    Sep 6, 2007 at 11:19 pm
  • Hi, I wonder about differences in performance between two scenarios: Background: Table A, ~50,000 records Table B, ~3,000,000 records (~20 cols) Table C, ~30,000,000 records (~10 cols) a query every ...
    Walter MauritzWalter Mauritz
    Sep 4, 2007 at 7:00 pm
    Sep 4, 2007 at 10:48 pm
  • In keeping with some of the recent threads regarding the planner... I have a fair sized data warehouse in which I am trying to perform an aggregation, but getting OOM errors in Postgres(8.2.4). I ...
    Arctic ToucanArctic Toucan
    Sep 28, 2007 at 5:53 pm
    Sep 28, 2007 at 8:56 pm
  • Hi All; I'm preparing to fire up WAL archiving on 8 production servers We will follow up with implementing a warm standby scenariio. Does anyone have any thoughts per how to maximize performance, yet ...
    Kevin KempterKevin Kempter
    Sep 27, 2007 at 5:44 pm
    Sep 28, 2007 at 1:18 pm
  • Hi, I am curious as to why this occurs. Why does an = change the query plan so drastically? When my query is: Select count(*) from View_A WHERE tradedate = '20070801'; The query plan is as below: I ...
    Radhika SRadhika S
    Sep 26, 2007 at 6:00 pm
    Sep 27, 2007 at 12:40 pm
  • Is there a rule of thumb about when the planner's row estimates are too high? In particular, when should I be concerned that planner's estimated number of rows estimated for a nested loop is off? By ...
    Carlo StonebanksCarlo Stonebanks
    Sep 24, 2007 at 7:51 pm
    Sep 24, 2007 at 8:18 pm
  • My PG server came to a screeching halt yesterday. Looking at top saw a very large number of "startup waiting" tasks. A pg_dump was running and one of my scripts had issued a CREATE DATABASE command. ...
    Dan HarrisDan Harris
    Sep 12, 2007 at 7:58 pm
    Sep 13, 2007 at 3:22 am
  • I'm designing a system that will be doing over a million inserts/deletes on a single table every hour. Rather than using a single table, it is possible for me to partition the data into multiple ...
    Matt ChambersMatt Chambers
    Sep 12, 2007 at 9:46 pm
    Sep 12, 2007 at 9:58 pm
  • Hi, I have a table containing some ~13 million rows. Queries on indexed fields run fast, but unanchored pattern queries on a text column are slooooow. Indexing the column doesn't help (this is ...
    Fernan AgueroFernan Aguero
    Sep 11, 2007 at 7:00 pm
    Sep 11, 2007 at 7:08 pm
  • If I delete a whole bunch of tables (like 10,000 tables), should I vacuum system tables, and if so, which ones? (This system is still on 8.1.4 and isn't running autovacuum). Thanks, Craig
    Craig JamesCraig James
    Sep 11, 2007 at 4:17 am
    Sep 11, 2007 at 4:23 am
  • Exactly when does the planner decide that a left-anchored like can use the index? I have replaced a WHEN lower(last_name) = 'smith' with WHEN lower(last_name) like 'smith%' There is an index on ...
    Carlo StonebanksCarlo Stonebanks
    Sep 7, 2007 at 12:06 am
    Sep 7, 2007 at 12:28 am
Sep 2007
12
Group Navigation
period‹ prev | Sep 2007 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions57
posts478
users114
websitepostgresql.org
irc#postgresql

114 users for September 2007

Tom Lane: 31 posts Scott Marlowe: 29 posts Gregory Stark: 20 posts Carlo Stonebanks: 19 posts Decibel!: 17 posts Csaba Nagy: 15 posts Brauagustin-susc: 13 posts Simon Riggs: 13 posts Greg Smith: 12 posts Kevin Grittner: 12 posts Heikki Linnakangas: 11 posts Joshua D. Drake: 11 posts Alvaro Herrera: 9 posts Carlos Moreno: 9 posts Ow Mun Heng: 9 posts Bill Moran: 8 posts Harsh Azad: 8 posts Jean-David Beyer: 8 posts El-Lotso: 7 posts Shawn: 7 posts
show more
Archives