FAQ

PostgreSQL > pgsql-performance > July 2005

Search Discussions

71 discussions - 506 posts

  • I'm not sure how much this has been discussed on the list, but wasn't able to find anything relevant in the archives. The new Spamassassin is due out pretty soon. They are currently testing ...
    Matthew SchumacherMatthew Schumacher
    Jul 27, 2005 at 10:35 pm
    Aug 4, 2005 at 10:43 pm
  • Sigh... I recently upgraded from 7.4.1 to 8.0.3. The application did not change. I'm now running both database concurrently (on different ports, same machine) just so I could verify the problem ...
    Robert CreagerRobert Creager
    Jul 18, 2005 at 3:34 am
    Jul 23, 2005 at 8:37 pm
  • Hi, I'm running Postgres 7.4.6 on a dedicated server with about 1.5gigs of ram. Running scripts locally, it takes about 1.5x longer than mysql, and the load on the server is only about 21%. I upped ...
    Oliver CrosbyOliver Crosby
    Jul 19, 2005 at 5:43 pm
    Jul 26, 2005 at 3:22 pm
  • I have a unique scenerio. My DB is under "continual load", meaning that I am constantly using COPY to insert new data into the DB. There is no "quiet period" for the database, at least not for hours ...
    Christopher PetrilliChristopher Petrilli
    Jul 17, 2005 at 5:08 pm
    Jul 20, 2005 at 4:17 pm
  • Hello, we recently upgraded our dual Xeon Dell to a brand new Sun v40z with 4 opterons, 16GB of memory and MegaRAID with enough disks. OS is Debian Sarge amd64, PostgreSQL is 8.0.3. Size of database ...
    Kari LavikkaKari Lavikka
    Jul 28, 2005 at 9:22 am
    Aug 22, 2005 at 5:18 pm
  • I'm trying to improve the speed of this query: explain select recordtext from eventactivity inner join ( select incidentid from k_r where id = 94 ) a using ( incidentid ) inner join ( select ...
    Dan HarrisDan Harris
    Jul 14, 2005 at 8:05 am
    Jul 18, 2005 at 7:51 am
  • Hi folks, my application reads and writes some table quite often (multiple times per second). these tables are quite small (not more than 20 tuples), but the operations take quite a long time ( 300 ...
    Enrico WeigeltEnrico Weigelt
    Jul 3, 2005 at 11:46 pm
    Jul 8, 2005 at 2:47 pm
  • Gurus, A table in one of my databases has just crossed the 30 million row mark and has begun to feel very sluggish for just about anything I do with it. I keep the entire database vacuumed regularly. ...
    Dan HarrisDan Harris
    Jul 13, 2005 at 6:54 pm
    Jul 14, 2005 at 8:47 pm
  • Hello, I have PostgreSQL 8.0.3 running on a "workstation" with 768 MB of RAM, under FreeBSD. And I have a 47-milion row table: qnex=# explain select * from log; QUERY PLAN ...
    Dawid KuroczkoDawid Kuroczko
    Jul 22, 2005 at 1:06 pm
    Aug 11, 2005 at 1:26 pm
  • Here is the SCSI output: Web Server SCSI subsystem driver Revision: 1.00 megaraid: v1.18j (Release Date: Mon Jul 7 14:39:55 EDT 2003) megaraid: found 0x1028:0x000f:idx 0:bus 4:slot 3:func 0 scsi0 : ...
    Joshua D. DrakeJoshua D. Drake
    Jul 22, 2005 at 5:12 pm
    Aug 2, 2005 at 3:03 pm
  • I saw a review of a relatively inexpensive RAM disk over at anandtech.com, the Gigabyte i-RAM http://www.anandtech.com/storage/showdoc.aspx?i=2480 Basically, it is a PCI card, which takes standard ...
    John A MeinelJohn A Meinel
    Jul 26, 2005 at 4:34 pm
    Jul 26, 2005 at 11:04 pm
  • I am beginning to look at Postgres 8, and am particularly interested in cost-based vacuum/analyze. I'm hoping someone can shed some light on the behavior I am seeing. Suppose there are three threads: ...
    Ian WestmacottIan Westmacott
    Jul 8, 2005 at 4:25 pm
    Jul 13, 2005 at 9:46 pm
  • Hello all I'm running a postgres 7.4.5, on a dual 2.4Ghz Athlon, 1Gig RAM and an 3Ware SATA raid. Currently the database is only 16G with about 2 tables with 500000+ row, one table 200000+ row and a ...
    Ron WillsRon Wills
    Jul 15, 2005 at 8:39 pm
    Jul 16, 2005 at 9:15 pm
  • Help! After recently migrating to Postgres 8, I've discovered to my horror that I can't determine which queries are poorly performing anymore because the logging has drastically changed and no longer ...
    Brent HenryBrent Henry
    Jul 12, 2005 at 9:15 pm
    Jul 13, 2005 at 4:10 pm
  • work_mem = 131072 # min 64, size in KB shared_buffers = 16000 # min 16, at least max_connections*2, 8KB each checkpoint_segments = 128 # in logfile segments, min 1, 16MB each effective_cache_size = ...
    Luke LonerganLuke Lonergan
    Jul 29, 2005 at 7:01 am
    Jul 30, 2005 at 10:36 am
  • ¿where is stored the value set by ALTER TABLE table_name ALTER COLUMN column_name SET STATISTICS = [1-1000]? I've set this to 1000, and I didn't remember in which column (doh!). Is there any table to ...
    DarioDario
    Jul 6, 2005 at 7:49 pm
    Jul 19, 2005 at 9:41 pm
  • I just took delivery of a new system, and used the opportunity to benchmark postgresql 8.0 performance on various filesystems. The system in question runs Linux 2.6.12, has one CPU and 1GB of system ...
    Jeffrey W. BakerJeffrey W. Baker
    Jul 14, 2005 at 1:07 am
    Jul 14, 2005 at 6:37 pm
  • Hi, Our application requires a number of processes to select and update rows from a very small (<10 rows) Postgres table on a regular and frequent basis. These processes often run for weeks at a ...
    Alison WintersAlison Winters
    Jul 14, 2005 at 5:08 am
    Sep 1, 2005 at 11:23 pm
  • Hi, does anybody have expierence with this machine (4x 875 dual core Opteron CPUs)? We run RHEL 3.0, 32bit and under high load it is a drag. We mostly run memory demanding queries. Context switches ...
    Dirk LutzebäckDirk Lutzebäck
    Jul 29, 2005 at 4:45 pm
    Jul 31, 2005 at 9:12 pm
  • Hi, Suppose I have a table with 4 fields (f1, f2, f3, f4) I define 2 unique indexes u1 (f1, f2, f3) and u2 (f1, f2, f4) I have 3 records A, B, C, D (this will be inserted) A, B, C, E (this will pass ...
    Yves VindevogelYves Vindevogel
    Jul 18, 2005 at 7:29 pm
    Aug 17, 2005 at 10:02 pm
  • Hi all; I have a customer who currently uses an application which had become slow. After doing some digging, I found the slow query: SELECT c.accno, c.description, c.link, c.category, ac.project_id, ...
    Chris TraversChris Travers
    Jul 28, 2005 at 5:16 am
    Jul 29, 2005 at 11:19 pm
  • I have an 8.02 postgresql database with about 180 GB in size, running on 2.6 RedHat kernel with 32 GB of RAM and 2 CPUs. I'm running the vacuum full analyze command, and has been running for at least ...
    Tomeh, HusamTomeh, Husam
    Jul 25, 2005 at 9:30 pm
    Jul 27, 2005 at 4:20 pm
  • I am working on a process that will be inserting tens of million rows and need this to be as quick as possible. The catch is that for each row I could potentially insert, I need to look and see if ...
    Dan HarrisDan Harris
    Jul 26, 2005 at 4:49 pm
    Jul 27, 2005 at 1:52 am
  • I need COPY via libpqxx to insert millions of rows into two tables. One table has roughly have as many rows and requires half the storage. In production, the largest table will grow by ~30M rows/day. ...
    Chris IsaacsonChris Isaacson
    Jul 25, 2005 at 10:32 pm
    Jul 26, 2005 at 2:23 pm
  • I'm putting together a road map on how our systems can scale as our load increases. As part of this, I need to look into setting up some fast read only mirrors of our database. We should have more ...
    Stuart BishopStuart Bishop
    Jul 8, 2005 at 1:33 am
    Jul 10, 2005 at 4:50 am
  • I ran into a situation today maintaining someone else's code where the sum time running 2 queries seems to be faster than 1. The original code was split into two queries. I thought about joining ...
    Karim NassarKarim Nassar
    Jul 28, 2005 at 11:06 pm
    Jul 29, 2005 at 4:39 am
  • Hi, I've got a java based web application that uses PostgreSQL 8.0.2. PostgreSQL runs on its own machine with RHEL 3, ia32e kernel, dual Xeon processor, 4 Gb ram. The web application runs on a ...
    DennisDennis
    Jul 13, 2005 at 7:13 pm
    Jul 15, 2005 at 4:03 pm
  • Hi to all, I have a performace problem with the following query: BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT toponimo, wpt FROM wpt_comuni_view WHERE ( wpt && setSRID('BOX3D(4.83 36, 20.16 ...
    Niccolo RigacciNiccolo Rigacci
    Jul 6, 2005 at 9:19 pm
    Jul 7, 2005 at 1:59 pm
  • Hannu, Good question - do they? We had discussed the bypass as an elective option, or an automated one for special conditions (no index on table, empty table) or both. I thought that temp tables was ...
    Luke LonerganLuke Lonergan
    Jul 26, 2005 at 7:30 pm
    Jul 28, 2005 at 12:41 am
  • I created a user with a password. That newly created user now have tables and indexes. I want to ALTER that user to exclude the password. How is this accomplished without dropping and recreating the ...
    Bailey, LarryBailey, Larry
    Jul 8, 2005 at 11:57 pm
    Jul 9, 2005 at 12:58 am
  • Hi, These last two days, I have some troubles with a very strange phenomena: I have a 400 Mb database and a stored procedure written in perl which call 14 millions times spi_exec_query (thanks to Tom ...
    Jean-Max ReymondJean-Max Reymond
    Jul 7, 2005 at 12:49 pm
    Jul 7, 2005 at 2:55 pm
  • We are having terrible performance issues with a production instance of PostgreSQL version 7.4.5, but are struggling with which parameters in the postgresql.conf to change. Our database server is an ...
    Alexander StanierAlexander Stanier
    Jul 5, 2005 at 4:15 pm
    Jul 6, 2005 at 3:06 pm
  • I'm working with an application where the database is entirely resident in RAM (the server is a quad opteron with 16GBytes of memory). It's a web application and handles a high volume of queries. The ...
    Emil BriggsEmil Briggs
    Jul 2, 2005 at 1:59 am
    Jul 5, 2005 at 9:31 pm
  • Hi, I've just been referred here after a conversion on IRC and everybody seemed to think I've stumbled upon some strangeness. The planner (in PG version 8.0.2) is choosing what it thinks is a more ...
    Sam MasonSam Mason
    Jul 1, 2005 at 1:33 pm
    Jul 2, 2005 at 5:24 am
  • Hi, I have one customer who is using PostgreSQL 7.4.8 on Linux . He has some problems with database mirroring . The details are follows. The customer is using Linux on which PostgreSQL 7.4.8 along ...
    Shashi Kanth BoddulaShashi Kanth Boddula
    Jul 25, 2005 at 12:37 pm
    Jul 27, 2005 at 9:21 pm
  • My application is using Firebird 1.5.2 I have at my database: - 150 Doamins - 318 tables - 141 Views - 365 Procedures - 407 Triggers - 75 generators - 161 Exceptions - 183 UDFs - 1077 Indexes My ...
    Roberto Germano Vieweg NetoRoberto Germano Vieweg Neto
    Jul 26, 2005 at 7:35 pm
    Jul 27, 2005 at 7:28 am
  • Hi, I do not under stand the following explain output (pgsql 8.0.3): explain analyze select b.e from b, d where b.r=516081780 and b.c=513652057 and b.e=d.e; QUERY PLAN ...
    Dirk LutzebäckDirk Lutzebäck
    Jul 20, 2005 at 3:25 pm
    Jul 21, 2005 at 5:45 pm
  • Is there any MS-SQL Server like 'Profiler' available for PostgreSQL? A profiler is a tool that monitors the database server and outputs a detailed trace of all the transactions/queries that are ...
    Agha Asif RazaAgha Asif Raza
    Jul 14, 2005 at 5:58 am
    Jul 15, 2005 at 8:19 am
  • The 2 queries are almost same, but ORDER BY x||t is FASTER than ORDER BY x.. How can that be possible? Btw: x and x||t are same ordered phoeniks= explain analyze SELECT * FROM test WHERE i<20 ORDER ...
    JobapplyJobapply
    Jul 9, 2005 at 6:38 pm
    Jul 12, 2005 at 1:52 am
  • Hi all, I hope I am not asking too many questions. :) I have been trying to solve a performance problem in my program for a while now and, after getting an index to work which didn't speed things up ...
    Madison KellyMadison Kelly
    Jul 7, 2005 at 1:14 pm
    Jul 8, 2005 at 1:02 am
  • Hi, I'm having a problem with a query that performs a sequential scan on a table when it should be performing an index scan. The interesting thing is, when we dumped the database on another server, ...
    Marc McIntyreMarc McIntyre
    Jul 14, 2005 at 12:07 am
    Nov 21, 2006 at 8:28 pm
  • Hi, We have a couple of database that are identical (one for each customer). They are all relatively small, ranging from 100k records to 1m records. There's only one main table with some smaller ...
    Yves VindevogelYves Vindevogel
    Jul 12, 2005 at 4:22 pm
    Jul 13, 2005 at 5:18 am
  • In the past week, one guy of Unix Group in Colombia say: "Postgrest in production is bat, if the power off in any time the datas is lost why this datas is in plain files. Postgrest no ssupport data ...
    Alejandro LemusAlejandro Lemus
    Jul 11, 2005 at 12:59 pm
    Jul 11, 2005 at 11:26 pm
  • Hi all, we have the following setup: - Sun V250 server - 2*1.3GHz Sparc IIIi CPU - 8GB RAM - 8*73GB SCSI drives - Solaris 10 - Postgres 8 Disks 0 and 1 are mirrored and contain the OS and the various ...
    Paul JohnsonPaul Johnson
    Jul 6, 2005 at 5:15 pm
    Jul 10, 2005 at 10:07 pm
  • Hello, I was wondering if there is any way to speed up deletes on this table (see details below)? I am running few of these deletes (could become many more) inside a transaction and each one takes ...
    Bendik Rognlien JohansenBendik Rognlien Johansen
    Jul 7, 2005 at 11:16 am
    Jul 7, 2005 at 3:03 pm
  • Does anyone have any suggestions on this? I did not get any response from the admin list. Thanks, Chris ---------- Forwarded message ---------- From: Chris Hoover <[email protected] Date: Jul 27, ...
    Chris HooverChris Hoover
    Jul 28, 2005 at 2:38 pm
    Jul 28, 2005 at 5:35 pm
  • I tuned a query last week to obtain acceptable performance. Here is my recorded explain analyze results: ----- LOG: duration: 826.505 ms statement: explain analyze SELECT c.id AS contact_id, sr.id AS ...
    John MendenhallJohn Mendenhall
    Jul 19, 2005 at 9:06 pm
    Jul 23, 2005 at 4:50 pm
  • The thread below has the test case that we were able to use to reproduce the issue. http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php The last messages on this subject are from ...
    Sailer, Denis (YBUSA-CDR)Sailer, Denis (YBUSA-CDR)
    Jul 19, 2005 at 6:23 pm
    Jul 19, 2005 at 6:40 pm
  • I am working on a system that uses postgresql 7.4.2 (can't change that until 8.1 goes stable). Just figured out that there are about 285,000 connections created over about 11 hours every day. That ...
    Karim NassarKarim Nassar
    Jul 15, 2005 at 7:01 am
    Jul 15, 2005 at 2:16 pm
  • Hello I have a large database with 4 large tables (each containing at least 200 000 rows, perhaps even 1 or 2 million) and i ask myself if it's better to split them into small tables (e.g tables of ...
    Nicolas BeaumeNicolas Beaume
    Jul 13, 2005 at 9:58 am
    Jul 14, 2005 at 6:26 pm
Jul 2005
12
Group Navigation
period‹ prev | Jul 2005 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions71
posts506
users120
websitepostgresql.org
irc#postgresql

120 users for July 2005

Tom Lane: 47 posts John Arbash Meinel: 30 posts Luke Lonergan: 17 posts Pierre-Frédéric Caillaud: 17 posts Dan Harris: 16 posts Christopher Petrilli: 14 posts Robert Creager: 13 posts Enrico Weigelt: 12 posts Josh Berkus: 12 posts Matthew Schumacher: 12 posts Jeffrey W. Baker: 11 posts Simon Riggs: 11 posts Alvaro Herrera: 9 posts Joshua D. Drake: 9 posts Oliver Crosby: 9 posts Dawid Kuroczko: 8 posts Richard Huxton: 8 posts Christopher Kings-Lynne: 7 posts David Mitchell: 6 posts Karim Nassar: 6 posts
show more
Archives