FAQ

PostgreSQL > pgsql-performance > June 2004

Search Discussions

64 discussions - 334 posts

  • Hi all, I was running Postgres 7.3 and it was running at about 15% with my application. On Postgres 7.4 on another box, it was running at 100%... My settings are default on both boxes I think. There ...
    Chris ChestonChris Cheston
    Jun 25, 2004 at 6:59 am
    Jun 30, 2004 at 4:32 pm
  • Thank you, Tom! We vacuum and reindex every night and reindex typically took 30 minutes. Today, it ran since 3AM, and has not finished till 8:30AM. The email and its indexe sizes are: tablename ...
    Litao WuLitao Wu
    Jun 8, 2004 at 5:25 pm
    Jul 1, 2004 at 4:12 pm
  • I'm having a performance issue that I just can't resolve and its very, very curious. Thought someone here might be able to shed some light on the subject. I'm using Postgres 7.4.2 on Red Hat 9. I ...
    KenKen
    Jun 9, 2004 at 7:33 pm
    Jun 15, 2004 at 1:52 pm
  • Hi, I am trying to make a cluster out of any database, postgresql or mysql or any other free database. I have looked at openmosix patched with the migshm patch for shared memory support and it seems ...
    BillBill
    Jun 22, 2004 at 2:28 pm
    Jun 23, 2004 at 6:22 pm
  • Hello pgsql-performance, I was using the native windows PostgreSQL 7.5Dev and was adviced by several people to use an emulated PostgreSQL instead, as it is just a beta. Well, I give it a whirl and ...
    Vitaly BelmanVitaly Belman
    Jun 1, 2004 at 10:55 pm
    Jun 3, 2004 at 3:51 am
  • L.S. Could anybody explain why the planner is doing what it is doing? What could I do to make it easier to choose a better plan? ********* Summary ********* On a freshly vacuum/analysed pair of ...
    Frank van VugtFrank van Vugt
    Jun 10, 2004 at 2:24 pm
    Jun 18, 2004 at 3:32 pm
  • I'm running postgrSQL 7.2 on a linux Red Hat 8.0 box with 2GB of RAM When I boot-up the system , this is the TOP situation: 11:59am up 4 min, 1 user, load average: 0.37, 0.26, 0.11 77 processes: 74 ...
    Domenico SgarbossaDomenico Sgarbossa
    Jun 11, 2004 at 1:55 pm
    Jun 22, 2004 at 1:34 pm
  • Hello list, Server is dual Xeon 2.4, 2GBRAM, Postgresql is running on partition: /dev/sda9 29G 8.9G 20G 31% /home2 /dev/sda9 on /home2 type jfs (rw) Version() PostgreSQL 7.4 on i686-pc-linux-gnu, ...
    Josué MaldonadoJosué Maldonado
    Jun 7, 2004 at 10:21 pm
    Jun 8, 2004 at 4:47 pm
  • Actually, I have some queries that are slow, however I was wondering if you could help me write a query that is rather simple, but I, as a true database novice, can't seem to conjure. So we have ...
    BillBill
    Jun 28, 2004 at 3:26 am
    Jun 30, 2004 at 2:27 pm
  • We're looking for an alternative to fiber-channel disk arrays for mass storage. One of the ideas that we're exploring would involve having the cluster on an NFS mounted filesystem. Another technology ...
    Andrew HammondAndrew Hammond
    Jun 21, 2004 at 5:58 pm
    Jun 22, 2004 at 5:16 pm
  • --- lnd@hnit.is wrote: You can roughly estimate time spent for just scaning To answer (I hope) everyones questions at once: 1) Oracle and postmaster were not running at the same time 2) The queries ...
    Gary CowellGary Cowell
    Jun 18, 2004 at 1:25 pm
    Jun 22, 2004 at 5:12 am
  • The pg_resetxlog was run as root. It caused ownership problems of pg_control and xlog files. Now we have no access to the data now through psql. The data is still there under ...
    Shea,Dan [CIS]Shea,Dan [CIS]
    Jun 22, 2004 at 6:43 pm
    Jun 24, 2004 at 5:17 pm
  • I have two instances of a production application that uses Postgres 7.2, deployed in two different data centers for about the last 6 months. The sizes, schemas, configurations, hardware, and access ...
    Michael NonemacherMichael Nonemacher
    Jun 4, 2004 at 3:43 pm
    Jun 5, 2004 at 4:17 am
  • Hi, I've experienced that PG up to current release does not make use of an index when aggregating. Which of course may result in unacceptable answering times This behaviour is reproducable on any ...
    Harald Lau (Sector-X)Harald Lau (Sector-X)
    Jun 29, 2004 at 6:41 am
    Jun 29, 2004 at 6:15 pm
  • I'm trying to migrate an application from an Oracle backend to PostgreSQL and have a performance question. The hardware for the database is the same, a SunFire v120, 2x73GB U2W SCSI disks, 1GB RAM, ...
    Gary CowellGary Cowell
    Jun 18, 2004 at 11:32 am
    Jun 18, 2004 at 11:06 pm
  • I've known about this tool for a while, but it seems many people do not know of its existence and I think it would be useful to a lot of people who have a hard time reading explain analyze output. ...
    JeffJeff
    Jun 16, 2004 at 2:00 pm
    Jun 17, 2004 at 6:14 pm
  • I am batch inserting insert statements into a database with fsync = on. My single disk system is on a 10k drive...even though I am inside a transaction there is at least 1 file sync per row insert. ...
    Merlin MoncureMerlin Moncure
    Jun 11, 2004 at 6:40 pm
    Jun 17, 2004 at 4:35 pm
  • Hello, I'm using PostgreSQL 7.4.2 (package from backports.org) on a Debian (woody) box. The machine is IBM eServer 345 with two 2.8 Xeon CPUs, it has 1024MB of RAM and two 15k RPM SCSI disks running ...
    ElevenEleven
    Jun 29, 2004 at 3:52 pm
    Jul 18, 2004 at 9:42 am
  • Hi! I'd like to know if there is a way to see what queries are running within a certain postgres instance and how much resources (cpu/memory) etc. they are using. Right now it's impossible to see ...
    P.A.M. van DamP.A.M. van Dam
    Jun 25, 2004 at 7:37 pm
    Jun 27, 2004 at 5:31 pm
  • A production system has had a query recently degrade in performance. What once took < 1s now takes over 1s. I have tracked down the problem to a working example. Compare ...
    Dan LangilleDan Langille
    Jun 7, 2004 at 7:45 pm
    Jun 7, 2004 at 10:55 pm
  • I've got a simple database (no indices, 6 columns) that I need to write data quickly into through JDBC connections from multiple such connections simultaneously in a distributed environment. (This is ...
    Steve WamplerSteve Wampler
    Jun 5, 2004 at 8:12 pm
    Jun 7, 2004 at 9:59 pm
  • I am experiencing rather slow INSERTs on loaded server. The table I am inserting to is: CREATE TABLE pagestats ( page_id int4 NOT NULL, viewed timestamptz DEFAULT now(), session int4 NOT NULL ) WITH ...
    Michal TáborskýMichal Táborský
    Jun 29, 2004 at 12:30 pm
    Jun 29, 2004 at 4:03 pm
  • Hi, I have one performance issue... and realy have no idea what's going on... When I set enable_seqscan to 0, query2 runs the same way... upload = 60667 entities uploadfield = 506316 entities Query1: ...
    JimJim
    Jun 28, 2004 at 12:35 am
    Jun 28, 2004 at 5:41 pm
  • Hello all, I have an import function that I have been working on for some time now, and it performed well up until recently. It is doing a lot, and because the queries are not cached, I am not sure ...
    Marcus WhitneyMarcus Whitney
    Jun 2, 2004 at 9:13 pm
    Jun 21, 2004 at 7:42 pm
  • Pg: 7.4.2 RedHat 7.3 Ram: 8gig I have 6 million row table that I vacuum full analyze each night. The time seems to be streching out further and further as I add more rows. I read the archives and ...
    Patrick HatcherPatrick Hatcher
    Jun 17, 2004 at 8:21 pm
    Jun 21, 2004 at 3:35 pm
  • So I have a table with about 50 million entries in it, I have to do a keyword search. The keyword search is done on the title of the entry. For example a entry could be "This is a title string which ...
    BorajettaBorajetta
    Jun 14, 2004 at 10:31 pm
    Jun 17, 2004 at 12:33 am
  • Hi, I currently have a mysql server running with a database of around 800 gb. The problem is that the server is old (500 MHz Pentium III with 512 MB RAM) and I want to change this to a new server and ...
    BillBill
    Jun 16, 2004 at 7:15 pm
    Jun 16, 2004 at 8:49 pm
  • Hi all, I noticed the following. Given two tables, just simply articles and their packages: article(id int) package( id int, article_id int, amount) When taking the minimum package for articles given ...
    Frank van VugtFrank van Vugt
    Jun 15, 2004 at 6:49 am
    Jun 16, 2004 at 8:42 am
  • Hello, Consider the following query: select t1field1, avg(t2fieild2) from t1, t2 where t1.field1 = t2.field2 group by t1field1 That works fine. But I'd really like to see more fields of t1 in this ...
    Vitaly BelmanVitaly Belman
    Jun 13, 2004 at 3:22 am
    Jun 13, 2004 at 5:59 pm
  • Dear All, I have a table with approximately 570k Rows. Table "filter.rules" Column | Type | Modifiers ----------+------------------------+---------------------------------------- rulename | character ...
    Russell SmithRussell Smith
    Jun 8, 2004 at 7:28 am
    Jun 9, 2004 at 4:03 pm
  • Folks, I've been testing varying SPINS_PER_DELAY in a client's installation of PostgreSQL against a copy of a production database, to test varying this statistic as a way of fixing the issue. It does ...
    Josh BerkusJosh Berkus
    Jun 2, 2004 at 7:25 pm
    Aug 31, 2004 at 10:02 pm
  • [...] Matthieu La balle est dans ton camps. Prend contact avec Les Matthieu Projets Importants, fixe moi une date et je te trouve des Matthieu salles et du réseau. Matthieu On a donc la possibilité ...
    Laurent MartelliLaurent Martelli
    Jun 23, 2004 at 4:02 pm
    Jun 24, 2004 at 3:05 am
  • Hello.... I would like to know the performance of pg_fetch_array. Cosider the code: $query = "select * from foo"; $result = pg_query( $db, $query ); while ($row = pg_fetch_array($result)) { $a = ...
    ThanksThanks
    Jun 14, 2004 at 9:25 am
    Jun 21, 2004 at 10:35 am
  • Hi everyone . How much memory should I give to the kernel and postgresql I have 1G of memory and 120G of HD Shared Buffers = ? Vacuum Mem = ? SHMAX = ? Sorry I have so many question .I am a newbie ...
    Michael Ryan S. PunciaMichael Ryan S. Puncia
    Jun 18, 2004 at 1:23 pm
    Jun 18, 2004 at 1:58 pm
  • I have an application which logs interactions on a regular basis. The interaction details (their types, etc) are held in one table (tblitem) and the 'hits' are held in tbltotal. I have written a ...
    Nick TrainorNick Trainor
    Jun 11, 2004 at 11:17 am
    Jun 11, 2004 at 6:01 pm
  • Hello, I have an instance where I have a series of pl/pgsql calls, that report stat results to a common table. When other queries try to hit the stat table (with DML commands; SELECT, INSERT, UPDATE, ...
    Marcus WhitneyMarcus Whitney
    Jun 7, 2004 at 4:36 pm
    Jun 8, 2004 at 2:24 pm
  • Dear Gurus, Please feel free to show me to the archives if my question has already been answered. Last week I fumbled with CPU_TUPLE_COST and revealed that 4 out of 4 tested queries improved by ...
    Szűcs GáborSzűcs Gábor
    Jun 7, 2004 at 7:35 am
    Jun 7, 2004 at 5:18 pm
  • Hi all, I've been dealing with a problem for the past two days where a certain sql statement works 2 out of 5 times, and the other 3 times, it causes the machine (quad Xeon 2.8GHz + 792543232 bytes ...
    StefStef
    Jun 7, 2004 at 11:35 am
    Jun 7, 2004 at 3:36 pm
  • Hello again, This question is related to my previous one (Unused table of view, see http://archives.postgresql.org/pgsql-performance/2004-06/msg00043.php). For the moment, I have queries where I join ...
    Laurent MartelliLaurent Martelli
    Jun 6, 2004 at 11:08 am
    Jun 6, 2004 at 9:12 pm
  • Hello, I'm using postgresql 7.4.2, and I have this view: slooze=# \d userpictures2 Vue «public.userpictures2» Colonne | Type | Modificateurs -------------+--------------------------+--------------- ...
    Laurent MartelliLaurent Martelli
    Jun 5, 2004 at 5:15 pm
    Jun 5, 2004 at 7:01 pm
  • I'm trying to create a trigger (AFTER INSERT, UPDATE, DELETE) as an audit routine inserting into an audit table the "before" and "after" views of the row being acted upon. My problem is I defined the ...
    Duane Lee - EGOVXDuane Lee - EGOVX
    Jun 1, 2004 at 9:04 pm
    Jun 2, 2004 at 5:01 pm
  • Dear all, Have anyone compiled PostgreSQL with kernel 2.6.x if YES 1. Was their any performance gains Else 1. Is it possible 2. What problems would keeping us away from compiling on kernel 2.6 -- ...
    V i s h a l Kashyap @ [Sai Hertz And Control Systems]V i s h a l Kashyap @ [Sai Hertz And Control Systems]
    Jun 2, 2004 at 3:18 am
    Jun 2, 2004 at 3:38 pm
  • I have a problem where a query gets _much_ slower if I add statements to the where clause than if I just get everything and filter in the code. I expected the query to be faster as the where clause ...
    James AntillJames Antill
    Jun 29, 2004 at 9:56 pm
    Jul 1, 2004 at 8:44 pm
  • Hello All, We are building a web based application which is database intensive (we intend to use postgresql). Expect about 600 concurrent users. We are using Zope and python with postgresql on RedHat ...
    Mohan AMohan A
    Jun 29, 2004 at 4:51 pm
    Jun 29, 2004 at 11:30 pm
  • 1

    Hi!

    Hi, I am trying install the postgresql-7.4.3 simple installation. I did ./configure command at the postgresql directory source. While the configuring proccess I receiving the follow message: checking ...
    Janio Rosa da SilvaJanio Rosa da Silva
    Jun 20, 2004 at 4:40 pm
    Jun 22, 2004 at 4:24 pm
  • Hello all, I have a rather large table (~20 GB) of network logs taken over the period of a month and stored under postgres 7.3. I'm trying to create an indexing scheme so that I can do a query with a ...
    Stan BielskiStan Bielski
    Jun 15, 2004 at 9:30 pm
    Jun 20, 2004 at 6:45 pm
  • Vivek, Was there anything specific that helped you decide on a RAID-5 and not a RAID-10? I have my DBs on RAID10, and would soon be moving them on FC drives, and i am considering RAID-10. Thanks, ...
    Anjan DaveAnjan Dave
    Jun 10, 2004 at 4:02 pm
    Jun 10, 2004 at 4:51 pm
  • Right now, I am having trouble getting the planner to optimize queries in the form of select t.key, t.field from t a where ( select count(*) from t b where b.field a.field ) = k The subplan (either ...
    Merlin MoncureMerlin Moncure
    Jun 7, 2004 at 5:30 pm
    Jun 7, 2004 at 8:31 pm
  • Hi! For many small commits it's usually the disk seek, the moving of the head, that produces the overhead. Even if there is only a single byte changed in the clog, it's an independent operation for ...
    CHCH
    Jun 4, 2004 at 2:21 pm
    Jun 4, 2004 at 3:33 pm
  • Hi! I am having a bit of problem with the plan that the planner produces. First a little info: OS: Linux Debian Version: PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc GCC) 3.3.3 (Debian ...
    Mikael KjellströmMikael Kjellström
    Jun 4, 2004 at 12:10 pm
    Jun 4, 2004 at 2:41 pm
Jun 2004
12
Group Navigation
period‹ prev | Jun 2004 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions64
posts334
users104
websitepostgresql.org
irc#postgresql

104 users for June 2004

Tom Lane: 52 posts Josh Berkus: 14 posts Rod Taylor: 11 posts Richard Huxton: 10 posts Scott Marlowe: 10 posts Christopher Kings-Lynne: 8 posts Litao Wu: 8 posts Marcus Whitney: 8 posts Merlin Moncure: 8 posts Bill: 7 posts Chris Cheston: 7 posts Andrew Hammond: 5 posts Bruno Wolff III: 5 posts Dan Langille: 5 posts Frank van Vugt: 5 posts Greg Stark: 5 posts Jeff: 5 posts Ken: 5 posts Laurent Martelli: 5 posts Paul Thomas: 5 posts
show more
Archives