FAQ

PostgreSQL > pgsql-performance > July 2006

Search Discussions

53 discussions - 322 posts

  • I have finally gotten my hands on the MSA1500 that we ordered some time ago. It has 28 x 10K 146Gb drives, currently grouped as 10 (for wal) + 18 (for data). There's only one controller (an emulex), ...
    Mikael CarneholmMikael Carneholm
    Jul 16, 2006 at 10:50 pm
    Aug 4, 2006 at 8:06 am
  • Kjell, The Smart Array 5i is a terrible performer on Linux. I would be surprised if you exceed the performance of a single hard drive with this controller when doing I/O from disk. Since your ...
    Luke LonerganLuke Lonergan
    Jul 28, 2006 at 6:54 am
    Aug 9, 2006 at 9:09 pm
  • Hi group, this is a directory tree query for a backup system (http:// sourceforge.net/projects/bacula). You provide a path and get back the names of the children plus a boolean telling if the child ...
    Axel RauAxel Rau
    Jul 31, 2006 at 10:49 am
    Aug 3, 2006 at 5:22 am
  • Tweakers.net has done a database performance test between a Sun T2000 (8 core T1) and a Sun X4200 (2 dual core Opteron 280). The database benchmark is developed inhouse and represents the average ...
    Jochem van DietenJochem van Dieten
    Jul 29, 2006 at 3:03 pm
    Aug 7, 2006 at 1:45 pm
  • Sorry for the delay. Finally I got the oprofile data. It's huge(34MB). If you are interested, I can put somewhere. Please let me know. -- Tatsuo Ishii SRA OSS, Inc. Japan
    Tatsuo IshiiTatsuo Ishii
    Jul 13, 2006 at 9:02 am
    Jul 24, 2006 at 3:35 am
  • There have been dozens, perhaps hundreds, of entries in the pg-admin, pg-general, and pg-performance lists regarding killing a session, but as far as I can tell, there is no Postgres solution. Did I ...
    Craig A. JamesCraig A. James
    Jul 11, 2006 at 6:51 am
    Jul 14, 2006 at 4:25 pm
  • Hi, I am running PostgreSQL 7.3 on a Linux box (RHEL 2.1 - Xeon 2.8GHz with 1GB of RAM) and seeing very high CPU usage (normally over 90%) when I am running the following queries, and the queries ...
    Neil HepworthNeil Hepworth
    Jul 10, 2006 at 12:52 am
    Jul 12, 2006 at 8:41 pm
  • Is there any way to create a reverse index on string columns so that queries of the form: where column like '%2345'; can use an index and perform as fast as searching with like '2345%'? Is the only ...
    GeneGene
    Jul 2, 2006 at 9:50 pm
    Jul 5, 2006 at 12:22 am
  • I am testing a query what that has a sub-select. The query performance is very very poor as shown below due to the use of sequencial scans. The actual row count of both tables is also shown. It ...
    H HaleH Hale
    Jul 31, 2006 at 1:57 am
    Aug 7, 2006 at 1:32 pm
  • I have been testing the performance of PostgreSQL using the simple tool found at http://benchw.sourceforge.net however I have found that all the queries it run execute with sequential scans. The ...
    Robin C SmithRobin C Smith
    Jul 21, 2006 at 10:40 am
    Jul 23, 2006 at 3:04 pm
  • Hello, I am seeking advice/comment/experience you may have had for the performance cost for remote access to postgresql 8.1.X? I have two servers, one is Sun V240 (say server A) and the other is dual ...
    Guoping ZhangGuoping Zhang
    Jul 19, 2006 at 5:40 am
    Jul 20, 2006 at 7:54 pm
  • Hi all! Can anyone explain to me what VACUUM does that REINDEX doesn't? We have a frequently updated table on Postgres 7.4 on FC3 with about 35000 rows which we VACUUM hourly and VACUUM FULL once per ...
    William Scott JordanWilliam Scott Jordan
    Jul 7, 2006 at 10:49 pm
    Jul 8, 2006 at 9:17 am
  • We're in the process of porting from Informix 9.4 to PostgreSQL 8.1.3. Our PostgreSQL server is an AMD Opteron Dual Core 275 with two 2.2 Ghz 64-bit processors. There are two internal drives and an ...
    Andy rostAndy rost
    Jul 5, 2006 at 3:07 pm
    Jul 9, 2006 at 2:48 pm
  • Hello, I've read a lot of mails here saying how good is the Opteron with PostgreSQL, and a lot of people seems to recommend it (instead of Xeon). However, it seems that new Intel processors, Core Duo ...
    Jonathan BalletJonathan Ballet
    Jul 31, 2006 at 12:54 pm
    Aug 3, 2006 at 5:09 am
  • I am currently running FreeBSD 4.11 (due to IT requirements for now) and Adaptec's 2200S RAID controller running in RAID5. I was advised in the past that the 2200S is actually a poor performing ...
    Kenji MorishigeKenji Morishige
    Jul 5, 2006 at 11:59 pm
    Jul 10, 2006 at 2:52 pm
  • Hi all. I have a strange (and serious) problem with an application ported from postgres 8.0 to 8.1. The old installation is postgresql-8.0.4-2.FC4.1 running on a Fedora 4, the new one is ...
    Gabriele TurchiGabriele Turchi
    Jul 15, 2006 at 2:14 pm
    Jul 18, 2006 at 11:29 am
  • Hello! I have a postgresql server serving thousands of tables. Sometime there are queries which involves several tables. In postgresql.conf I have these settings: shared_buffers = 40000 work_mem = ...
    Eugeny N DzhurinskyEugeny N Dzhurinsky
    Jul 6, 2006 at 6:40 am
    Jul 7, 2006 at 8:28 am
  • All, I support a system that runs on several databases including PostgreSQL. I've noticed that the other DB's always put an implicit savepoint before each statement executed, and roll back to that ...
    Mark LewisMark Lewis
    Jul 27, 2006 at 6:41 pm
    Aug 1, 2006 at 1:40 pm
  • Hi! I hope I'm sending my question to the right list, please don't flame if it's the wrong one. I have noticed that while a query runs in about 1.5seconds on a 8.xx version postgresql server on our ...
    EliottEliott
    Jul 27, 2006 at 2:23 pm
    Jul 28, 2006 at 10:07 am
  • I have a problem with a query that in postgres 7.4 and 8.12 has an acceptable response time but in postgres 8.14 is very slow. This is the table I use: create table TEST ( TESTID INT8 not null, ...
    Ioana DanesIoana Danes
    Jul 7, 2006 at 1:38 am
    Jul 27, 2006 at 10:22 pm
  • I have just upgraded from 7.3.4 to 8.1.4 and now *all* db access calls are extremely slow. I didn't need to preserve any old data so at this point all my tables are empty. Just connecting to a db ...
    Medora SchauerMedora Schauer
    Jul 12, 2006 at 8:59 pm
    Jul 13, 2006 at 6:25 pm
  • Hi, please help me with the following problem: I have noticed a strange performance behaviour using a commit statement on two different machines. On one of the machines the commit is many times ...
    Koth, Christian (DWBI)Koth, Christian (DWBI)
    Jul 12, 2006 at 4:43 pm
    Jul 13, 2006 at 8:59 am
  • I can't find an address to complain about the mailing list itself, so apologies but I'm posting directly to this list. Every time I post to this group, I get returned mails about OTHER subscribers' ...
    Craig A. JamesCraig A. James
    Jul 12, 2006 at 5:40 pm
    Jul 13, 2006 at 3:07 am
  • Hello! I have upgraded my server to an HP Proliant DL585. It got two Processor motherboards, each holding an AMD/Opteron 2.6Ghz and 4GIG of memory. I got 4 150GIG SCSI disks in a Smart Array 5i 1+0 ...
    Kjell Tore FossbakkKjell Tore Fossbakk
    Jul 28, 2006 at 6:38 am
    Jul 30, 2006 at 7:18 pm
  • I notice that non-printables in bytea values are being spit out by pg_dump using escaped octet sequences even when the "-Fc" option is present specifying use of the custom binary output format rather ...
    Steve McWilliamsSteve McWilliams
    Jul 12, 2006 at 6:35 pm
    Jul 14, 2006 at 7:05 am
  • Do you really need to create one *DB* per client - that is, is one schema (in the same DB) per client out of the question? If not, I would look into moving all reference tables (read-only data, ...
    Mikael CarneholmMikael Carneholm
    Jul 4, 2006 at 8:02 am
    Jul 5, 2006 at 7:18 pm
  • Hi, We've a fedora core 3 box with PostgreSQL 8.0. There is some performance problems with the server and I discovered with vmstat tool that there is some process writing a lot of information in the ...
    CarlosreimerCarlosreimer
    Jul 28, 2006 at 1:26 am
    Aug 7, 2006 at 11:51 am
  • I have a table with 37000 rows, an integer column, and an index on that column. I've got a function that returns an integer. When I do a select where I restrict that column to being equal to a static ...
    BenBen
    Jul 28, 2006 at 7:19 pm
    Jul 28, 2006 at 9:07 pm
  • Hello, Sorry for my poor english, My problem : I meet some performance problem during load increase. massive update of 50.000.000 records and 2.000.000 insert with a weekly frequency in a huge table ...
    Nuggets72Nuggets72
    Jul 26, 2006 at 3:21 pm
    Jul 26, 2006 at 4:56 pm
  • I have a case where I am partitioning tables based on a date range in version 8.1.4. For example: table_with_millions_of_records interaction_id char(16) primary key start_date timestamp (without ...
    Kevin KeithKevin Keith
    Jul 21, 2006 at 7:17 pm
    Jul 25, 2006 at 8:48 pm
  • I discussed this with a few members of #postgresql freenode this morning. I'll keep it breif; [note: i have cleaned out columns not relevant] I have two tables, brands and models_brands. The first ...
    Kevin McArthurKevin McArthur
    Jul 21, 2006 at 6:46 pm
    Jul 22, 2006 at 5:04 pm
  • Hi, It would seem that doing any changes on a temp table forces a copy of the entire contents of the table to be retained in memory/disk. Is this happening due to MVCC? Is there a way to change this ...
    Rusty ConoverRusty Conover
    Jul 18, 2006 at 11:40 am
    Jul 18, 2006 at 5:27 pm
  • HI, 1. I have a function that given two parameter produces an arbitrary id, and text. However arbitrary the id and text are, they are in certain order. i.e. it is imperative that whatever processing ...
    Hassan AdekoyaHassan Adekoya
    Jul 15, 2006 at 6:05 pm
    Jul 15, 2006 at 11:53 pm
  • Hello! I facing some strange problems with PostgreSQL 8.0 performance. I have application which handles a lot of tasks, each task is keps in separate table. Those tables are dropped and created again ...
    Eugeny N DzhurinskyEugeny N Dzhurinsky
    Jul 5, 2006 at 1:07 pm
    Jul 6, 2006 at 12:33 am
  • I try to partition a large table (~ 120 mio. rows) into 50 smaller tables but using the IMO immutable %-function constraint exclusion does not work as expected: CREATE TABLE tt_m (id1 int, cont ...
    Martin LesserMartin Lesser
    Jul 31, 2006 at 12:25 pm
    Aug 4, 2006 at 7:37 am
  • Hi, If I run the query explain analyze select * from ind_uni_100 where a=1 and b=1 and c=1 I get the following plan: Bitmap Heap Scan on ind_uni_100 (cost=942.50..1411.12 rows=125 width=104) (actual ...
    JkapadJkapad
    Jul 5, 2006 at 6:56 am
    Jul 18, 2006 at 11:19 am
  • Hello! We're facing a performance problem here in a Oracle 10g - PostgreSQL environment. The Oracle DB accesses the PostgreSQL DB via UnixODBC + psqlODBC. There are some 100 records on the Oracle DB ...
    Thomas RadnetterThomas Radnetter
    Jul 12, 2006 at 8:33 am
    Jul 12, 2006 at 2:34 pm
  • Hi all, I got this query, I'm having indexes for PropertyId and Dates columns across all the tables, but still it takes ages to get me the result. What indexes would be proposed on this, or I'm ...
    LuckysLuckys
    Jul 4, 2006 at 4:00 pm
    Jul 7, 2006 at 5:42 pm
  • I'm using PostgreSQL 8.1.4 in a Hibernate Application and I am attempting to use partitioning via Inherited tables. At first I was going to create a rule per sub-table based on a date range, but ...
    GeneGene
    Jul 7, 2006 at 7:51 am
    Jul 7, 2006 at 4:26 pm
  • We are using a BI tool that generates some rather ugly queries. One of the ugly queries is taking much longer to return thin I think it should. The select expression when run alone returns in 2 ...
    Richard RowellRichard Rowell
    Jul 27, 2006 at 9:59 pm
    Aug 3, 2006 at 4:39 pm
  • See Query 200x slower on server [PART 1] before reading any further QUERY PLAN ON MY HOME SERVER Sort (cost=1516.55..1516.59 rows=15 width=640) (actual time=123.008..123.435 rows=1103 loops=1) Sort ...
    NbForYouNbForYou
    Jul 27, 2006 at 4:45 pm
    Jul 31, 2006 at 9:27 am
  • Hello, My name is Hristo Markov. I am software developer. I am developing software systems (with C/C++ program language) that work on Windows operation system and uses ODBC driver and ACCESS ...
    Hristo MarkovHristo Markov
    Jul 27, 2006 at 4:29 pm
    Jul 31, 2006 at 9:24 am
  • Hi all, I execute the following query on postgresql 8.1.0: SELECT u.telephone_number , u.telecom_operator_id , u.name FROM campanas_subcampaign AS sub , agenda_users AS u , agenda_users_groups ug ...
    ArnauArnau
    Jul 26, 2006 at 5:23 pm
    Jul 26, 2006 at 8:25 pm
  • The report below isn't a bug, its a performance question and should have been sent to pgsql-performance@postgresql.org. I am redirecting replies there. You most likely aren't vacuuming often enough ...
    Bruno Wolff IIIBruno Wolff III
    Jul 21, 2006 at 6:28 pm
    Jul 24, 2006 at 7:54 am
  • Hello, does anybody use OSDB benchmarks for postgres? if not, which kind of bechmarks are used for postgres? Thanks, Denis.
    Petronenko D.S.Petronenko D.S.
    Jul 21, 2006 at 1:35 pm
    Jul 23, 2006 at 11:47 pm
  • I'm doing a self join of some shipping data and wanted to get the best query possible. The interesting table is the event table, and it has the following structure: startnode int, endnode int, weight ...
    Worky WorkersonWorky Workerson
    Jul 14, 2006 at 6:57 pm
    Jul 14, 2006 at 7:19 pm
  • with all these unsubscribe requests, we can only extrapolate that the server has no serious performance issues left to solve. good work! :-) merlin
    Merlin MoncureMerlin Moncure
    Jul 6, 2006 at 5:53 pm
    Jul 6, 2006 at 6:01 pm
  • Hello Everyone, I'm trying to find out/understand what causes my 'out of memory' error. I do not have enough experience with such logs to understand what is wrong or how to fix it. So i hope someone ...
    NickyNicky
    Jul 12, 2006 at 7:38 am
    Jul 12, 2006 at 7:38 am
  • I've got a problem where Deletes on a certain table are taking very long ( 5 sec) (PG 8.1.3, linux). Explain Analyze on the delete shows that two (automatically created) triggers caused by foreign ...
    K-Bob bodyK-Bob body
    Jul 7, 2006 at 9:59 pm
    Jul 7, 2006 at 9:59 pm
  • Hi, all. i'm trying to tune application which makes alots of queries with semantics(find LONGEST PREFIX MATCH in a string) like: SELECT cost FROM tarif WHERE $1 LIKE prefix ORDER BY length(prefix) ...
    Hripchenko SergeyHripchenko Sergey
    Jul 7, 2006 at 9:13 am
    Jul 7, 2006 at 9:13 am
Jul 2006
12
Group Navigation
period‹ prev | Jul 2006 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions53
posts322
users111
websitepostgresql.org
irc#postgresql

111 users for July 2006

Tom Lane: 26 posts Craig A. James: 12 posts Markus Schaber: 10 posts Merlin Moncure: 10 posts Mikael Carneholm: 10 posts Jeff Frost: 9 posts Luke Lonergan: 9 posts Scott Marlowe: 9 posts Joshua D. Drake: 8 posts Mark Kirkwood: 8 posts Axel Rau: 7 posts Michael Stone: 6 posts Arjen van der Meijden: 5 posts Denis Lussier: 5 posts Florian Weimer: 5 posts Neil Hepworth: 5 posts Robert Lor: 5 posts Ron Peacetree: 5 posts Alex Turner: 4 posts Andy rost: 4 posts
show more
Archives