FAQ

PostgreSQL > pgsql-performance > June 2007

Search Discussions

61 discussions - 651 posts

  • Hi, I have an application which really exercises the performance of postgresql in a major way, and I am running into a performance bottleneck with Postgresql 8.1 that I do not yet understand. Here ...
    Karl WrightKarl Wright
    Jun 18, 2007 at 7:49 pm
    Jun 25, 2007 at 1:07 pm
  • Please read the whole email before replying: I love the feedback I have received but I feel that somehow I did not communicate the intent of this mini project very well. So let me outline a few ...
    Campbell, LanceCampbell, Lance
    Jun 19, 2007 at 4:23 pm
    Jul 6, 2007 at 4:25 am
  • Hi - I'm looking at ways to do clean PITR backups. Currently we're pg_dumping our data in some cases when compressed is about 100GB. Needless to say it's slow and IO intensive on both the host and ...
    Dan GormanDan Gorman
    Jun 21, 2007 at 11:55 pm
    Jun 25, 2007 at 5:12 pm
  • I have several thousand clients. Our clients do surveys, and each survey has two tables for the client data, responders responses Frequent inserts into both table. Right now, we are seeing ...
    Thomas AndrewsThomas Andrews
    Jun 4, 2007 at 6:02 pm
    Jun 7, 2007 at 5:22 am
  • I am a Java Software architect, DBA, and project manager for the University of Illinois, Department of Web Services. We use PostgreSQL to serve about 2 million pages of dynamic content a month; ...
    Campbell, LanceCampbell, Lance
    Jun 18, 2007 at 3:03 pm
    Jun 27, 2007 at 11:18 pm
  • Hello all, one of my customers installed Postgres on a public server to access the data from several places. The problem is that it takes _ages_ to transfer data from the database to the client app. ...
    Rainer BauerRainer Bauer
    Jun 21, 2007 at 2:21 pm
    Jun 22, 2007 at 9:49 pm
  • Hello great gurus of performance: Our 'esteemed' Engr group recently informed a customer that in their testing, upgrading to 8.2.x improved the performance of our J2EE application "approximately ...
    Douglas J HunleyDouglas J Hunley
    Jun 2, 2007 at 1:33 pm
    Jun 6, 2007 at 2:35 pm
  • Gang, Hoping you all can help me with a rather bizarre issue that I've run across. I don't really need a solution, I think I have one, but I'd really like to run it by everyone in case I'm headed in ...
    Kurt OverbergKurt Overberg
    Jun 19, 2007 at 1:57 pm
    Jun 21, 2007 at 12:44 am
  • Looking for replication solutions, I find: Slony-I Seems good, single master only, master is a single point of failure, no good failover system for electing a new master or having a failed master ...
    Craig A. JamesCraig A. James
    Jun 14, 2007 at 11:09 pm
    Jun 21, 2007 at 3:14 pm
  • Aside from the Wikipedia database comparison, I'm not aware of any direct PostgreSQL-to-Oracle comparison. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: ...
    Jonah H. HarrisJonah H. Harris
    Jun 18, 2007 at 4:10 pm
    Jun 20, 2007 at 10:13 pm
  • Hi All, I really hope someone can shed some light on my problem. I'm not sure if this is a posgres or potgis issue. Anyway, we have 2 development laptops and one live server, somehow I managed to get ...
    Christo Du PreezChristo Du Preez
    Jun 11, 2007 at 3:36 pm
    Jun 12, 2007 at 6:43 pm
  • Is it possible that providing 128G of ram is too much ? Will other systems in the server bottleneck ? Dave
    Dave CramerDave Cramer
    Jun 8, 2007 at 4:31 pm
    Jun 11, 2007 at 5:59 pm
  • Hi, I'm currently playing with dbt2 and am wondering, if the results I'm getting are reasonable. I'm testing a 2x Dual Core Xeon system with 4 GB of RAM and 8 SATA HDDs attached via Areca RAID ...
    Markus SchiltknechtMarkus Schiltknecht
    Jun 4, 2007 at 3:01 pm
    Jun 19, 2007 at 11:20 am
  • Hi, I am new for postgresql server. And now i work on a projects which requires postgreSQL 8.0 and Java. I don't know why the server occasionally slow down a bit for every 3 minutes. I have changed ...
    Ho Fat TsangHo Fat Tsang
    Jun 28, 2007 at 6:54 am
    Jul 3, 2007 at 5:21 pm
  • Hi all, I'm trying to do an update of a reasonably large table and it's taking way too long so I'm trying to work out why and if I need to tweak any settings to speed it up. The table is around 3.5 ...
    ChrisChris
    Jun 28, 2007 at 5:19 am
    Jun 28, 2007 at 12:03 pm
  • Gang, I'm running a mid-size production 8.0 environment. I'd really like to upgrade to 8.2, so I've been doing some testing to make sure my app works well with 8.2, and I ran across this weirdness. I ...
    Kurt OverbergKurt Overberg
    Jun 6, 2007 at 11:34 pm
    Jun 7, 2007 at 11:08 pm
  • Hi, In version 8.1.5, I have an rtree index on a 1.5 GB table. The size of this index is 500 MB. After migrating to 8.2.3, the size of this index has increased to 35GB. I've dropped are recreated the ...
    Dolafi, TomDolafi, Tom
    Jun 27, 2007 at 3:27 pm
    Jul 9, 2007 at 9:48 pm
  • We recently upgraded a very large database (~550 GB) from 8.1.4 to 8.2.4 via a pg_dump and pg_restore. (Note that the restore took several days.) We had accepted the default settings: ...
    Steven FlattSteven Flatt
    Jun 21, 2007 at 5:10 pm
    Jun 26, 2007 at 6:49 pm
  • Hello group I have a problem with a simple index scan using the primary key of a table taking too long. Relevant facts: pg version 7.3.4 (yeah very old, we are upgrading asap) postgresql.conf: ...
    Mikko PartioMikko Partio
    Jun 20, 2007 at 2:02 pm
    Jun 25, 2007 at 2:24 pm
  • Hi there, I'd like to understand completely the report generated by VACUUM VERBOSE. Please tell me where is it documented ? TIA, Sabin
    Sabin CoandaSabin Coanda
    Jun 14, 2007 at 2:31 pm
    Jun 18, 2007 at 10:11 pm
  • Hi there, We run a small ISP with a FreeBSD/freeradius/postgresql 8.2.4 backend and 200+ users. Authentication happens via UAM/hotspot and I see a lot of authorisation and accounting packets that are ...
    Gunther MayerGunther Mayer
    Jun 6, 2007 at 7:28 pm
    Jun 8, 2007 at 8:27 am
  • Hey All, I am testing upgrading our database from version 8.1 to 8.2. I ran our worst performing query on this table, an outer join with an "is null" condition, and I was happy to see it ran over ...
    Tyrrill, EdTyrrill, Ed
    Jun 25, 2007 at 9:29 pm
    Jun 29, 2007 at 9:01 pm
  • Hi list members, I have a question regarding hardware issu= es for a SDI (Spatial data infrastructure). It will consist of PostgreSQL w= ith PostGIS and a UMN Mapserver/pmapper set up. At our ...
    Christian BraunChristian Braun
    Jun 19, 2007 at 10:41 am
    Jun 22, 2007 at 12:21 pm
  • I can't seem to find a definitive answer to this. It looks like Postgres does not enforce a limit on the length of an SQL string. Great. However is there some point at which a query string becomes ...
    Steven FlattSteven Flatt
    Jun 21, 2007 at 6:33 pm
    Jun 21, 2007 at 8:59 pm
  • Configuration OS: FreeBSD 6.1 Stable Postgresql: 8.1.4 RAID card 1 with 8 drives. 7200 RPM SATA RAID10 RAID card 2 with 4 drives. 10K RPM SATA RAID10 Besides having pg_xlog in the 10K RPM drives what ...
    Francisco ReyesFrancisco Reyes
    Jun 12, 2007 at 1:14 am
    Jun 19, 2007 at 7:36 pm
  • About six months ago, our normally fast postgres server started having performance issues. Queries that should have been instant were taking up to 20 seconds to complete (like selects on the primary ...
    Joe LesterJoe Lester
    Jun 7, 2007 at 6:22 pm
    Jun 8, 2007 at 2:24 am
  • I have a query that runs about 30-50 seconds. The query is a join between 2 tables (customer and address), each table with about 400,000 rows. My customer table has fields like first_name and ...
    Tom TamulewiczTom Tamulewicz
    Jun 22, 2007 at 6:32 pm
    Jun 22, 2007 at 10:24 pm
  • Hi there, Using explicitly VACUUM command give me the opportunity to fine tune my VACUUM scheduling parameters, after I analyze the log generated by VACUUM VERBOSE. On the other hand I'd like to use ...
    Sabin CoandaSabin Coanda
    Jun 12, 2007 at 3:54 pm
    Jun 13, 2007 at 3:08 pm
  • Hey All, I have a table, let's call it A, whose primary key, a_id, is referenced in a second table, let's call it B. For each unique A.a_id there are generally many rows in B with the same a_id. My ...
    Tyrrill, EdTyrrill, Ed
    Jun 7, 2007 at 8:03 pm
    Jun 12, 2007 at 3:57 pm
  • Hi, While monitioring we noticed that there are no details in the pg_statistics for a particular table. Can you let us know what might be the reason? Also what steps can be taken care for adding the ...
    Nimesh SatamNimesh Satam
    Jun 11, 2007 at 8:50 am
    Jun 11, 2007 at 2:34 pm
  • I have a table: webdigest=# \d wd_urlusermaps 表 "public.wd_urlusermaps" 字段名 | 类型 | 修饰词 ---------+-----------------------------+------------------------------------------------------------- id | ...
    WeipingWeiping
    Jun 6, 2007 at 3:56 am
    Jun 6, 2007 at 2:40 pm
  • Suppose a web application with persistent database connections. I have some queries which take longer to plan than to execute ! I with there was a way to issue a PREPARE (like "PERSISTENT PREPARE"). ...
    PFCPFC
    Jun 23, 2007 at 9:29 pm
    Jun 23, 2007 at 10:27 pm
  • Hello i would like to know if not determining a max size value for a character varying's fields decrease the perfomance (perhaps size of stockage ? or something else ?) If not it is a good way to not ...
    OkparanoidOkparanoid
    Jun 16, 2007 at 9:53 am
    Jun 16, 2007 at 3:07 pm
  • I need some help. I have started taking snapshots of performance of my databases with concerns to io. I created a view on each cluster defined as: SELECT pg_database.datname AS database_name, ...
    Chris HooverChris Hoover
    Jun 8, 2007 at 3:44 pm
    Jun 8, 2007 at 5:52 pm
  • I was wondering if you guys have some suggested settings for our server, i think we are not hardware limited but the configureation is set up incorrectly. For some reason our database seems to have ...
    Evan ReiserEvan Reiser
    Jun 28, 2007 at 12:38 am
    Jun 28, 2007 at 1:39 pm
  • Hello everybody, We're using PostgreSQL 8.1.0 on AIX 5.3 through NFS (a Netapp Filer hosts the database files), and we're encoutering somes issues with vaccums. PostgreSQL binaries are built with xlc ...
    RESTOUX, LoïcRESTOUX, Loïc
    Jun 13, 2007 at 5:02 pm
    Jun 20, 2007 at 3:28 pm
  • Hello, We have installed postgres 8.2.0 default time zone which postgres server using is template1=# SHOW timezone; TimeZone ----------- ETC/GMT-5 (1 row) But we want to set this timezone parameter ...
    Soni deSoni de
    Jun 19, 2007 at 7:43 am
    Jun 19, 2007 at 4:20 pm
  • Hi all, I had a database which uses to hold some 50 Mill records and disk space used was 103 GB. I deleted around 34 Mill records but still the disk size is same. Can some on please shed some light ...
    ChoksiChoksi
    Jun 8, 2007 at 8:22 am
    Jun 18, 2007 at 9:07 am
  • Hi All, Is there some kind of performance testing utility available for postgresql Something I can run after installing postgresql to help me identify if my installation is optimal. I've been ...
    Christo Du PreezChristo Du Preez
    Jun 13, 2007 at 10:18 am
    Jun 13, 2007 at 7:13 pm
  • Hi, I'm doing WAL shipping to do a warm standby system (8.2.4). The problem is that the pg_xlog dir on the master just gets bigger and bigger (never seems to truncate) and the corresponding archive ...
    Michael DenglerMichael Dengler
    Jun 13, 2007 at 1:35 pm
    Jun 13, 2007 at 4:12 pm
  • Hi all, It seems that I have an issue with the performance of a PostgreSQL server. I'm running write-intensive, TPC-C like tests. The workload consist of 150 to 200 thousand transactions. The ...
    Vladimir StankovicVladimir Stankovic
    Jun 11, 2007 at 5:31 pm
    Jun 12, 2007 at 6:21 pm
  • Hi, explain analyze SELECT am.campaign_id, am.optimize_type, am.creative_id, am.optimize_by_days, am.impressions_delta, am.clicks_delta, am.channel_code, am.cost,dm.allocation_map_id, SUM(CASE ...
    Gauri KanekarGauri Kanekar
    Jun 5, 2007 at 1:11 pm
    Jun 5, 2007 at 1:36 pm
  • I have some questions about the performance of certain types of SQL statements. What sort of speed increase is there usually with binding parameters (and thus preparing statements) v. straight sql ...
    Jason LustigJason Lustig
    Jun 5, 2007 at 3:45 am
    Jun 5, 2007 at 1:06 pm
  • We have a search facility in our database that uses full text indexing to search about 300,000 records spread across 2 tables. Nothing fancy there. The problem is, whenever we restart the database ...
    Bryan MurphyBryan Murphy
    Jun 25, 2007 at 8:18 pm
    Jun 25, 2007 at 10:20 pm
  • I have this "poll results" table with just 3 integer fields, which is never updated, only inserted/deleted... Did the Devs consider an option to have VACUUM reduce the row header sizes for tuples ...
    PFCPFC
    Jun 20, 2007 at 7:54 am
    Jun 20, 2007 at 9:05 am
  • I am trying to update a field in one table with a field from another table like: update co set firest_id=fco.firest_id,fire_dist=fco.fire_dist from fco where co.xno=fco.xno Table co has 384964 ...
    Mark MakarowskyMark Makarowsky
    Jun 13, 2007 at 5:13 pm
    Jun 13, 2007 at 7:47 pm
  • Hi, I've a table with 300 000 records and I'm trying to do a search: SELECT * FROM addresses WHERE address ILIKE '%Jean Paul%' AND (l_pc='4250' or r_pc='4250') AND (l_struc='O' or r_struc='O') AND ...
    Tyler DurdenTyler Durden
    Jun 13, 2007 at 11:41 am
    Jun 13, 2007 at 11:50 am
  • Hello List, We've been running PostgreSQL as our web application database for almost a year and it has noticeably slowed down over last few months. Our current setup and pgsql configuration looks ...
    Gregory StewartGregory Stewart
    Jun 1, 2007 at 7:40 pm
    Jun 5, 2007 at 12:57 am
  • Hi, I'm having some problems in performance in a simple select count(id) from.... I have 700 000 records in one table, and when I do: # explain select (id) from table_name; -[ RECORD 1 ...
    Tyler DurdenTyler Durden
    Jun 1, 2007 at 4:49 pm
    Jun 1, 2007 at 5:04 pm
  • Hi, I am new to PostgreSQL database. Can anybody help me (or point me the related post) to install PostgreSQL on windows XP from command line. (From .bat file) Thanks Sachi
    Sachchida OjhaSachchida Ojha
    Jun 28, 2007 at 7:32 pm
    Jun 28, 2007 at 7:44 pm
Jun 2007
12
Group Navigation
period‹ prev | Jun 2007 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions61
posts651
users127
websitepostgresql.org
irc#postgresql

127 users for June 2007

Tom Lane: 54 posts Greg Smith: 22 posts Gregory Stark: 20 posts Heikki Linnakangas: 20 posts Scott Marlowe: 19 posts Francisco Reyes: 18 posts Andrew Sullivan: 17 posts Karl Wright: 17 posts Alvaro Herrera: 16 posts Joshua D. Drake: 16 posts Richard Huxton: 14 posts Kurt Overberg: 13 posts Andreas Kostyrka: 12 posts Craig James: 12 posts Bill Moran: 11 posts Markus Schiltknecht: 11 posts PFC: 11 posts Rainer Bauer: 11 posts David: 10 posts Campbell, Lance: 10 posts
show more
Archives