FAQ

PostgreSQL > pgsql-performance > August 2005

Search Discussions

77 discussions - 565 posts

  • I just put together a system with 6GB of ram on a 14 disk raid 10 array. When I run my usual big painful queries, I get very little to know memory usage. My production box (raid 5 4GB ram) hovers at ...
    Jeremiah JahnJeremiah Jahn
    Aug 18, 2005 at 2:11 am
    Aug 23, 2005 at 9:48 am
  • Hi all, I like to know the caching policies of Postgresql. What parameter in the postgresql.conf affects the cache size used by the Postgresql? As far as I have searched my knowledge of the ...
    Gokulnathbabu manoharanGokulnathbabu manoharan
    Aug 23, 2005 at 5:10 pm
    Aug 25, 2005 at 12:28 pm
  • Actually some of that readaheads,etc the OS does already if it does some sort of throttling/clubbing of reads/writes. But its not enough for such types of workloads. Here is what I think will help: * ...
    Jignesh ShahJignesh Shah
    Aug 23, 2005 at 9:29 pm
    Aug 25, 2005 at 11:46 pm
  • Hi all, we're running PG8 on a Sun V250 with 8GB RAM and 2*1.3GHz SPARC CPUs running Solaris 10. The DB cluster is on an external fibre-attached Sun T3 array that has 9*36GB drives configured as a ...
    Paul JohnsonPaul Johnson
    Aug 11, 2005 at 12:23 pm
    Aug 17, 2005 at 8:36 pm
  • Hi all, I bet you get tired of the same ole questions over and over. I'm currently working on an application that will poll thousands of cable modems per minute and I would like to use PostgreSQL to ...
    Mark CotnerMark Cotner
    Aug 19, 2005 at 8:24 am
    Aug 22, 2005 at 9:29 am
  • I've got similiar queries that I think should be evaluated (as displayed through 'explain') the same, but don't. Hopefully this is the rigth place to send such a question and one of you can help ...
    Rhett GarberRhett Garber
    Aug 5, 2005 at 6:35 pm
    Aug 9, 2005 at 7:12 pm
  • Consider this setup - which is a gross simplification of parts of our production system ;-) create table c (id integer primary key); create table b (id integer primary key, c_id integer); create ...
    Tobias BroxTobias Brox
    Aug 26, 2005 at 12:27 am
    Aug 29, 2005 at 6:41 pm
  • Hi, I have a perfomance issue : I run PG (8.0.3) and SQLServer2000 on a Windows2000 Server (P4 1,5Ghz 512Mo) I have a table (3200000 rows) and I run this single query : select cod from mytable group ...
    Stéphane COEZStéphane COEZ
    Aug 11, 2005 at 1:19 pm
    Aug 18, 2005 at 2:46 pm
  • Hello, We are using PostgreSQL for our business application. Recently, during testing of our application with large volumes of data, we faced a weird problem. Our query performance dropped ...
    Ümit ÖztosunÜmit Öztosun
    Aug 26, 2005 at 10:04 pm
    Aug 29, 2005 at 10:59 pm
  • Hello, We are about to install a new PostgreSQL server, and despite of being a very humble configuration compared to the ones we see in the list, it's the biggest one we've got till now. The server ...
    Alvaro Nunes MeloAlvaro Nunes Melo
    Aug 30, 2005 at 12:37 pm
    Aug 31, 2005 at 2:51 am
  • Hello, one of our services is click counting for on line advertising. We do this by importing Apache log files every five minutes. This results in a lot of insert and delete statements. At the same ...
    Ulrich WisserUlrich Wisser
    Aug 16, 2005 at 3:37 pm
    Aug 23, 2005 at 12:48 am
  • We have been trying to pinpoint what originally seem to be a I/O bottleneck but which now seems to be an issue with either Postgresql or RHES 3. We have the following test environment on which we can ...
    Rémy BeaumontRémy Beaumont
    Aug 29, 2005 at 1:42 pm
    Aug 30, 2005 at 7:34 pm
  • I have a web page for my customers that shows them count of records and some min/max date ranges in each table of a database, as this is how we bill them for service. They can log in and check the ...
    Dan HarrisDan Harris
    Aug 10, 2005 at 11:35 pm
    Aug 11, 2005 at 3:30 pm
  • Hi, One simple question. For 125 or more checkpoint segments (checkpoint_timeout is 600 seconds, shared_buffers are at 21760 or 170MB) on a very busy database, what is more suitable, a separate 6 ...
    Anjan DaveAnjan Dave
    Aug 15, 2005 at 8:35 pm
    Aug 17, 2005 at 3:10 am
  • I thought I would send this to pg-performance since so many people helped me with my speed issues recently. I was definitely IO- bottlenecked. Since then, I have installed 2 RAID arrays with 7 15k ...
    Dan HarrisDan Harris
    Aug 9, 2005 at 6:02 pm
    Aug 9, 2005 at 10:30 pm
  • Hi, I´ve configured postgresql to use 1GB of shared buffers but meminfo and "top" are indicanting 0 shared buffers page. Why? It´s a Linux Redhat 9 box with 4GB RAM and postgresql 7.3. Thanks in ...
    Carlos Henrique ReimerCarlos Henrique Reimer
    Aug 29, 2005 at 4:23 pm
    Sep 11, 2005 at 12:36 pm
  • Hi list, I'm writing an application that will aggregate records with a few million records into averages/sums/minimums etc grouped per day. Clients can add filters and do lots of customization on ...
    Arjen van der MeijdenArjen van der Meijden
    Aug 26, 2005 at 11:09 am
    Aug 28, 2005 at 2:44 pm
  • [Reposted from General section with updated information] Pg 7.4.5 I'm running an update statement on about 12 million records using the following query: Update table_A set F1 = b.new_data from ...
    Patrick HatcherPatrick Hatcher
    Aug 6, 2005 at 1:16 pm
    Aug 8, 2005 at 3:19 pm
  • Hi all, We're using 8.0.3 and we're seeing a problem where the planner is choosing a seq scan and hash join over an index scan. If I set enable_hashjoin to off, then I get the plan I'm expecting and ...
    Meetesh KariaMeetesh Karia
    Aug 1, 2005 at 10:19 pm
    Aug 3, 2005 at 12:48 pm
  • A clear indication that you need to improve your HD IO subsystem if possible. To be more precise, your server performance at that point is essentially equal to your HD IO subsystem performance. Oh, ...
    RonRon
    Aug 17, 2005 at 6:36 pm
    Sep 20, 2005 at 3:36 pm
  • We have a highly active table that has virtually all entries updated every 5 minutes. Typical size of the table is 50,000 entries, and entries have grown fat. We are currently vaccuming hourly, and ...
    Markus BenneMarkus Benne
    Aug 30, 2005 at 9:13 pm
    Sep 6, 2005 at 1:04 pm
  • Hello, I would like to test the performance of my Java/PostgreSQL applications especially when making full text searches. For this I am looking for a database with 50 to 300 MB having text fields. ...
    Sebastian HennebruederSebastian Hennebrueder
    Aug 16, 2005 at 7:29 am
    Aug 23, 2005 at 12:43 am
  • The short question: Is there any ways to give postgresql a hint that a particular SQL call should be run at lower priority? Since every db connection has a pid, I can manually run "renice" to ...
    Tobias BroxTobias Brox
    Aug 2, 2005 at 4:04 pm
    Aug 4, 2005 at 5:34 pm
  • This is a wild and crazy thought which I am sure is invalid for some good reason. But why can't postgres just vacuum itself as it goes along? When a row is orphaned it's added to a list of possibly ...
    Ralph MasonRalph Mason
    Aug 30, 2005 at 10:19 pm
    Aug 31, 2005 at 1:51 pm
  • Hello Friends, We were having a database in pgsql7.4. The database was responding very slowly even after full vacuum (select count(*) from some_table_having_18000_records was taking 18 Sec). We took ...
    AkshayAkshay
    Aug 27, 2005 at 4:03 pm
    Aug 30, 2005 at 6:37 pm
  • I've read that indexes aren't used for COUNT(*) and I've noticed (7.3.x) with EXPLAIN that indexes never seem to be used on empty tables - is there any reason to have indexes on empty tables, or will ...
    Lenard, Rohan (Rohan)Lenard, Rohan (Rohan)
    Aug 23, 2005 at 3:41 am
    Aug 30, 2005 at 5:43 pm
  • Hi. The company that I'm working for are surveying the djungle of DBMS since we are due to implement the next generation of our system. The companys buissnes is utilizing the DBMS to store data that ...
    TobbeTobbe
    Aug 23, 2005 at 12:14 pm
    Aug 29, 2005 at 9:09 pm
  • Ok, there is always a lot of talk about tuning PostgreSQL on linux and how PostgreSQL uses the linux kernel cache to cache the tables and indexes. My question is, is there anyway to see what files ...
    Chris HooverChris Hoover
    Aug 24, 2005 at 4:57 pm
    Aug 25, 2005 at 7:18 am
  • Hello, i have a pg-8.0.3 running on Linux kernel 2.6.8, CPU Sempron 2600+, 1Gb RAM on IDE HD ( which could be called a "heavy desktop" ), measuring this performance with pgbench ( found on /contrib ) ...
    Alexandre BarrosAlexandre Barros
    Aug 24, 2005 at 2:51 pm
    Aug 24, 2005 at 4:35 pm
  • I need to improve the performance for the following query. Soon after I reboot my server, the following query takes 20 seconds the first time I run it. When I run it after that, it takes ...
    John MendenhallJohn Mendenhall
    Aug 21, 2005 at 3:45 am
    Aug 23, 2005 at 7:05 pm
  • Hello, I am running PostgreSQL 8.0.x on Solaris 10 AMD64. My Tablesize for this test is about 80G. When I run a query on a column which is not indexed, I get a full table scan query and that's what I ...
    Jignesh ShahJignesh Shah
    Aug 22, 2005 at 1:47 pm
    Aug 22, 2005 at 10:48 pm
  • Summary ======= We are writing to the db pretty much 24 hours a day. Recently the amount of data we write has increased, and the query speed, formerly okay, has taken a dive. The query is using the ...
    Roger HandRoger Hand
    Aug 16, 2005 at 5:46 pm
    Aug 20, 2005 at 12:15 pm
  • We just moved a large production instance of ours from Oracle to Postgres 8.0.3 on linux. When running on Oracle the machine hummed along using about 5% of the CPU easily handling the fairly constant ...
    Barry LindBarry Lind
    Aug 17, 2005 at 4:42 am
    Aug 17, 2005 at 12:59 pm
  • Well folks, I've been trying to track down why this Athlon 2800 (2.1ghz) has been handing my 2.5ghz G5 its cake. I have a query that (makes no io - the dataset can live in ram easily) takes about ...
    Jeff TroutJeff Trout
    Aug 26, 2005 at 6:58 pm
    Aug 30, 2005 at 2:04 pm
  • I would like to know if the following kind of database client exists: I need a 'select' query to be sent to say 10 db servers simultaneously in parallel (using threading), the results should be ...
    LigeshLigesh
    Aug 26, 2005 at 3:14 pm
    Aug 26, 2005 at 10:41 pm
  • Hello all, I was hoping someone could explain the plan for a statement. We have a table with a column of longs being used as an index. The query plan in 8.0 was like this: # explain select distinct ...
    Alan StangeAlan Stange
    Aug 26, 2005 at 2:45 pm
    Aug 26, 2005 at 7:02 pm
  • I have a table called 'jobs' with several million rows, and the only columns that are important to this discussion are 'start_time' and 'completion_time'. The sort of queries I want to execute (among ...
    Mark FoxMark Fox
    Aug 24, 2005 at 8:43 pm
    Aug 26, 2005 at 6:12 pm
  • Hi, Say I have a table with column A, B, C, D A has a unique index on it (primary key) B and C have a normal index on it D has no index If I perform a query like update tbl set D = 'whatever' ; that ...
    Yves VindevogelYves Vindevogel
    Aug 21, 2005 at 6:32 pm
    Aug 22, 2005 at 9:11 am
  • Hello all, is there a simple way to limit the number of concurrent callers to a stored proc? The problem we have is about 50 clients come and perform the same operation at nearly the same time. ...
    Alan StangeAlan Stange
    Aug 18, 2005 at 2:02 am
    Aug 18, 2005 at 7:22 pm
  • I'm having an odd case where my system is locking such that if I insert into a table during a transaction, if I start a new connection and transaction, it blocks while trying to do a similar insert ...
    John A MeinelJohn A Meinel
    Aug 11, 2005 at 8:36 pm
    Aug 15, 2005 at 3:19 pm
  • I have a largely table-append-only application where most transactions are read-intensive and many are read-only. The transactions may span many tables, and in some cases might need to pull 70 MB of ...
    Jeffrey TennyJeffrey Tenny
    Aug 11, 2005 at 10:21 pm
    Aug 12, 2005 at 7:32 am
  • Hi, I´m trying to tune a linux box with a 12 GB database and 4 GB RAM. First of all I would like to stop the swapping, so the shared_buffers and sort_mem were decreased but even so it started ...
    Carlos Henrique ReimerCarlos Henrique Reimer
    Aug 31, 2005 at 6:25 pm
    Aug 31, 2005 at 7:33 pm
  • It seems like you are pushing limit of what server can handle. This means: 1. expensive server upgrade. or 2. make software more efficient. Since you sound I/O bound, you can tackle 1. by a. adding ...
    Merlin MoncureMerlin Moncure
    Aug 25, 2005 at 5:30 pm
    Aug 25, 2005 at 8:19 pm
  • The system is a dual Xenon with 6Gig of ram and 14 73Gig 15K u320 scsi drives. Plus 2 raid 1 system dives. RedHat EL ES4 is the OS. Any1 have any suggestions as to the configuration? The database is ...
    Jeremiah JahnJeremiah Jahn
    Aug 15, 2005 at 4:25 pm
    Aug 19, 2005 at 3:26 pm
  • Hi I am using Postgres version *PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 20030222 (Red Hat Linux 3.2.2-5).* for an multy user desktop application using VB 6.0 as a front ...
    Mahesh ShindeMahesh Shinde
    Aug 17, 2005 at 9:48 am
    Aug 17, 2005 at 3:18 pm
  • I have database of company data, and some of them is table of information about employees. I need each employee to have access only to his own row. Postgre cannot do this by system of privileges, ...
    Petr KavanPetr Kavan
    Aug 12, 2005 at 6:53 am
    Aug 15, 2005 at 5:23 am
  • So, I have a table game with a timestamp attribute 'game_end', ranging from jan-2005 to present. The game table also have an attribute state, with live games beeing in state 2, and ended games beeing ...
    Tobias BroxTobias Brox
    Aug 10, 2005 at 5:52 pm
    Aug 11, 2005 at 3:15 am
  • [[I'm posting this on behalf of my co-worker who cannot post to this list at the moment]] Hi, I had installed PostgreSQL on a 4-way AMD Opteron 875 (dual core) and the performance isn't on the ...
    Dirk LutzebäckDirk Lutzebäck
    Aug 5, 2005 at 11:11 am
    Aug 5, 2005 at 1:53 pm
  • Hi all I'm having a strange problem with a query which looks like this: SELECT id FROM orders WHERE id NOT IN (SELECT order_id FROM orders_items); The id fields are varchars (32), both indexed. The ...
    GdhGdh
    Aug 31, 2005 at 10:22 am
    Sep 6, 2005 at 3:53 am
  • I am looking for the latest pgbench and documentation. If someone know where I can locate them it would save a lot of search time. Thanks Philip Pinkerton TPC-C Benchmarks Sybase Independant ...
    Philip PinkertonPhilip Pinkerton
    Aug 23, 2005 at 1:19 am
    Aug 23, 2005 at 1:52 pm
Aug 2005
12
Group Navigation
period‹ prev | Aug 2005 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions77
posts565
users139
websitepostgresql.org
irc#postgresql

139 users for August 2005

Tom Lane: 72 posts John Arbash Meinel: 38 posts Ron: 25 posts Josh Berkus: 16 posts Merlin Moncure: 15 posts Michael Stone: 15 posts Jeremiah Jahn: 14 posts Jeffrey W. Baker: 13 posts Tobias Brox: 11 posts Chris Browne: 9 posts Pierre-Frédéric Caillaud: 9 posts Alan Stange: 8 posts Dan Harris: 8 posts Jim C. Nasby: 8 posts Matthew Schumacher: 8 posts Richard Huxton: 8 posts Mark: 7 posts Gavin Sherry: 7 posts Michael Fuhr: 7 posts Rhett Garber: 7 posts
show more
Archives