FAQ

PostgreSQL > pgsql-performance > April 2004

Search Discussions

59 discussions - 534 posts

  • Hi, I have a query which I think should be using an index all of the time but postgres only uses the index part of the time. The index (ticket_crm_map_crm_id_suppid) has the where clause column ...
    Brad-pgperfBrad-pgperf
    Apr 26, 2004 at 5:11 pm
    May 2, 2004 at 2:31 pm
  • Note the time for the hash join step: ------------------------------------------------------------------------------------------------------------------------------------------ Hash Join ...
    Jim C. NasbyJim C. Nasby
    Apr 16, 2004 at 3:45 pm
    May 4, 2004 at 10:15 pm
  • hello, I have some question when I use postgresql 7.4.1 on redhat adv server 2.1 . I use IBM335 as server, it has 4 cpus, 1G RAM. but I got very bad performance. I can only do about 50 inserts per ...
    Huang yaqinHuang yaqin
    Apr 6, 2004 at 8:04 am
    Apr 8, 2004 at 2:56 pm
  • Hi I have .5 million rows in a table. My problem is select count(*) takes ages. VACUUM FULL does not help. can anyone please tell me how to i enhance the performance of the setup. Regds mallah. ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Apr 14, 2004 at 5:53 pm
    Apr 17, 2004 at 2:29 pm
  • Sorry I should have written that we do VACUUM VERBOSE ANALYZE every night. - Jeremy -----Original Message----- From: pgsql-performance-owner@postgresql.org On Behalf Of Bill Moran Sent: Monday, April ...
    Jeremy DunnJeremy Dunn
    Apr 12, 2004 at 5:08 pm
    Apr 15, 2004 at 11:02 pm
  • This vacuum is running a marathon. Why will it not end and show me free space map INFO? We have deleted a lot of data and I would like to be confident that these deletions will be used as free space, ...
    Shea,Dan [CIS]Shea,Dan [CIS]
    Apr 20, 2004 at 3:37 am
    Apr 25, 2004 at 8:44 pm
  • Hi, Has anyone had a look at: http://people.ac.upc.es/zgomez/ I realize that MySQL & PG cannot really be compared (especially when you consider the issues that MySQL has with things like data ...
    Nick BarrNick Barr
    Apr 21, 2004 at 8:31 am
    Apr 22, 2004 at 7:22 pm
  • I need some help. I have 5 db servers running our database servers, and they all are having various degrees of performance problems. The problems we are experiencing are: 1. General slowness 2. High ...
    Chris HooverChris Hoover
    Apr 23, 2004 at 1:31 pm
    Apr 27, 2004 at 6:03 pm
  • Hello pgsql-performance, I discussed the whole subject for some time in DevShed and didn't achieve much (as for results). I wonder if any of you guys can help out: ...
    Vitaly BelmanVitaly Belman
    Apr 27, 2004 at 9:27 pm
    Apr 29, 2004 at 10:10 pm
  • My first post to this list :) Scenario: I have a database used only with search queries with only one table that holds about 450.000/500.000 records. The table is well indexed so that most of the ...
    Edoardo CeccarelliEdoardo Ceccarelli
    Apr 21, 2004 at 7:17 am
    Apr 21, 2004 at 6:20 pm
  • In the process of optimizing some queries, I have found the following query seems to degrade in performance the more accurate I make the statistics on the table... whether by using increased alter ...
    Robert TreatRobert Treat
    Apr 13, 2004 at 6:02 pm
    Apr 29, 2004 at 4:54 pm
  • I am using the oid of the table as the main key and I've found that is not indexed (maybe because I have declared another primary key in the table) it is a good practice to create an index like this ...
    Edoardo CeccarelliEdoardo Ceccarelli
    Apr 26, 2004 at 4:38 pm
    Apr 28, 2004 at 8:28 am
  • Hi, we have a complex modperl database application using postgresql 7.4.1 on a new Dual Xeon MP Machine with SLES8 which seems to generate too much context switches (way more than 100.000) on higher ...
    Dirk LutzebäckDirk Lutzebäck
    Apr 15, 2004 at 12:10 pm
    Apr 20, 2004 at 2:48 pm
  • hi list, i want to convince people to use postgresql instead of ms-sql server, so i set up a kind of comparission insert data / select data from postgresql / ms-sql server the table i use was pretty ...
    Heiko KehlenbrinkHeiko Kehlenbrink
    Apr 5, 2004 at 3:39 pm
    Apr 7, 2004 at 7:15 am
  • Hi, I remember reading a post ages ago, maybe from Vadim, about the fact that people creating indices on more than two columns will be the first to be put againts the wall when the revolution ...
    Palle GirgensohnPalle Girgensohn
    Apr 1, 2004 at 11:00 pm
    Apr 5, 2004 at 2:08 am
  • Hi, I am using pg from 3 y. and generaly I do not have big problems with it. I am searching for best pg distro to run pg (7.4.1). At the moment I am using RedHat AS 3.0, but I think it have some ...
    PginfoPginfo
    Apr 15, 2004 at 7:17 am
    May 4, 2004 at 12:06 pm
  • To all, Essentials: Running 7.4.1 on OSX on a loaded G5 with dual procs, 8GB memory, direct attached via fibre channel to a fully optioned 3.5TB XRaid (14 spindles, 2 sets of 7 in RAID 5) box running ...
    Sean ShannySean Shanny
    Apr 22, 2004 at 9:57 pm
    Apr 23, 2004 at 4:29 pm
  • Hello all, My apologies if this is not the right mailing list to ask this question, but we are wondering about general performance tuning principles for our main db server. We have a web app with a ...
    Chris KratzChris Kratz
    Apr 16, 2004 at 3:28 pm
    Apr 17, 2004 at 1:12 pm
  • I have a table that is never updated, only INSERTED into. Is there a way I can prevent vacuum wasting time on this table besides vacuuming each table in the db by itself and omitting this table? How ...
    Joseph ShraibmanJoseph Shraibman
    Apr 29, 2004 at 11:15 pm
    May 1, 2004 at 3:04 am
  • Hi We are in the process of building a new machine for our production database. Below you will see some of the harware specs for the machine. I need some help with setting these parameters (shared ...
    Pallav KalvaPallav Kalva
    Apr 22, 2004 at 5:46 pm
    Apr 24, 2004 at 3:38 pm
  • Hi, When I included a subquery, the estimated rows (1240) is way too high as shown in the following example. Can someone explain why? Because of this behavior, some of our queries use hash join ...
    Litao WuLitao Wu
    Apr 16, 2004 at 9:45 pm
    Apr 20, 2004 at 3:11 am
  • I am using postgres 7.4.1 and have a problem with a plpgsql function. When I run the function on the production server it takes approx 33 minutes to run. I dumped the DB and copied it to a similarly ...
    Ron St-PierreRon St-Pierre
    Apr 16, 2004 at 4:40 pm
    Apr 17, 2004 at 12:25 pm
  • Hi everyone, I have done some reading on filesystems and I thought to optimize the settings for my PostgreSQL system. I use the ext3 filesystem and have the PostgreSQL data and WAL on different ...
    Priem, AlexanderPriem, Alexander
    Apr 8, 2004 at 7:58 am
    Apr 8, 2004 at 2:52 pm
  • Hi, I test many times the foolowing query. dps=# explain analyze select next_index_time from url order by next_index_time desc limit 1; QUERY PLAN ...
    Pailloncy Jean-GérardPailloncy Jean-Gérard
    Apr 12, 2004 at 9:27 am
    Apr 13, 2004 at 1:47 pm
  • Hi, I have a query which I think should be using an index all of the time but postgres only uses the index part of the time. The index (ticket_crm_map_crm_id_suppid) has the where clause column ...
    Brad-pgperfBrad-pgperf
    Apr 23, 2004 at 10:21 pm
    Apr 28, 2004 at 4:42 pm
  • I have a query which performs not so well: SELECT * FROM mm_mediasources ORDER BY number DESC LIMIT 20; costs nearly a minute. The table contains over 300 000 records. The table has two extensions, ...
    Michiel MeeuwissenMichiel Meeuwissen
    Apr 20, 2004 at 2:29 am
    Apr 24, 2004 at 4:32 am
  • I run the following command three times to prevent cache/disk results. [...] dps= explain analyze SELECT rec_id FROM url WHERE crc32!=0 AND crc32=764518963 AND status IN (200,304,206) ORDER BY rec_id ...
    Pailloncy Jean-GérardPailloncy Jean-Gérard
    Apr 14, 2004 at 12:39 pm
    Apr 22, 2004 at 6:47 pm
  • We have a large database which recently increased dramatically due to a change in our insert program allowing all entries. PWFPM_DEV=# select relname,relfilenode,reltuples from pg_class where relname ...
    Shea,Dan [CIS]Shea,Dan [CIS]
    Apr 12, 2004 at 2:39 pm
    Apr 20, 2004 at 11:15 am
  • I am trying to find an efficient way to draw a random sample from a complex query. I also want it to be easy to use within my application. So I've defined a view that encapsulates the query. The id ...
    Ken GeisKen Geis
    Apr 6, 2004 at 8:25 pm
    Apr 9, 2004 at 4:50 pm
  • Has anyone tried PostgreSQL on top of OCFS? Personally, I'm not sure it would even work, as Oracle clearly state that OCFS was _never_ meant to be a fully fledged UNIX filesystem with POSIX features ...
    Grega BremecGrega Bremec
    Apr 7, 2004 at 7:19 am
    Apr 9, 2004 at 4:02 pm
  • I am planning to move the pg databases from the internal RAID to external Fiber Channel over SAN. Question is - -With the db size being as big as, say, 30+GB, how do I move it on the new logical ...
    Anjan DaveAnjan Dave
    Apr 20, 2004 at 11:34 pm
    Apr 21, 2004 at 9:50 pm
  • Is there a way to analyze indexes to provide updated sizes? Is a vacuum the only way to determine the size of an index? Analyze updates the stats so I can see table space sizes but I cannot find an ...
    Jeremy M. GuthrieJeremy M. Guthrie
    Apr 15, 2004 at 5:48 pm
    Apr 21, 2004 at 12:41 am
  • Anyone have any ideas why this query would be so slow? stats=# explain analyze SELECT work_units, min(raw_rank) AS rank FROM Trank_work_overall GROUP BY work_units; QUERY PLAN ...
    Jim C. NasbyJim C. Nasby
    Apr 16, 2004 at 3:17 pm
    Apr 18, 2004 at 3:34 am
  • Hello, I've just started using the tsearch2 system. I'm VERY impressed by the speed. I've got one question about query planning. Is it understandable to have the query plan estimation be off by a ...
    Mark LubrattMark Lubratt
    Apr 8, 2004 at 5:33 pm
    Apr 9, 2004 at 5:26 am
  • I am trying to do a spatial join between two tables each of which has a column of type BOX called ERRBOX, with R-TREE indices created on both. The smaller table, xmm1, has 56,711 rows, the larger ...
    Clive PageClive Page
    Apr 2, 2004 at 2:55 pm
    Apr 3, 2004 at 10:34 pm
  • Folks, I have a question about views: I want to have a fairly wide view (lots of columns) where most of the columns have some heavyish calculations in them, but I'm concerned that it will have to ...
    Peter DarleyPeter Darley
    Apr 13, 2004 at 8:49 pm
    Mar 24, 2005 at 1:48 pm
  • All, This is old topic, when I use: select url from urlinfo where url like 'http://www.lycos.de%'; it uses the index, good! but if I use: select url from urlinfo where url like 'http://%.lycos.de'; ...
    Jie LiangJie Liang
    Apr 28, 2004 at 10:02 pm
    May 5, 2004 at 6:13 pm
  • All, After I upgraded postgres from 7.3.4 to 7.4.2, one of my program got following error: DRROR: out of memory DETAIL: Fail on request of size 92. any idea?? does memory management have big ...
    Jie LiangJie Liang
    Apr 28, 2004 at 6:12 pm
    Apr 28, 2004 at 8:41 pm
  • Hi, I came across a very intriguing thing: I had to join two tables and in both tables I wanted to restrict the result set by some (text/varchar) attributes. Here is an example: Table "item" # 147 ...
    Silke TrisslSilke Trissl
    Apr 27, 2004 at 5:32 pm
    Apr 28, 2004 at 12:52 pm
  • Hello, I have a bi-PIII server with 2Gb of RAM with Debian and a PostgreSQL 7.4 running on. What are the bests settings for shared buffers, sort memory and effective cache size? My main database have ...
    Frédéric RobinetFrédéric Robinet
    Apr 21, 2004 at 4:29 pm
    Apr 27, 2004 at 12:09 pm
  • I just want to make sure that I am interpreting this data correctly. From pg_statio_user_tables, I have pulled relname, heap_blks_read, heap_blks_hit. I get several rows like this: relname ...
    Chris HooverChris Hoover
    Apr 21, 2004 at 3:34 pm
    Apr 21, 2004 at 7:04 pm
  • I received a copy of pgbench rewritten in Pro*C, which is similar to embedded C. I think it was done so the same program could be tested on Oracle and PostgreSQL. Are folks interested in this code? ...
    Bruce MomjianBruce Momjian
    Apr 21, 2004 at 1:50 am
    Apr 21, 2004 at 3:31 am
  • Hi Everyone I am new to this group and relatively new to Postgres, having used MSSQL 7 up until now. One table in my database in returning even the simplest of queries extremely slowly. The table is ...
    Gerard IsdellGerard Isdell
    Apr 19, 2004 at 11:02 am
    Apr 19, 2004 at 12:37 pm
  • This is what I got... Two servers, one debian, one fedora Debain dual 3ghz, 1 gig ram, ide, PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4 Fedora: Dual 3ghz, 1 gig ram, scsi, ...
    Andrew MatthewsAndrew Matthews
    Apr 6, 2004 at 1:41 am
    Apr 9, 2004 at 4:12 pm
  • What the statistics are? Where can i view it? where can i find info about its field and why are they valuable information to performance? thanx in advance, Jaime Casanova Protect your PC - get ...
    Jaime CasanovaJaime Casanova
    Apr 7, 2004 at 9:05 pm
    Apr 8, 2004 at 10:42 pm
  • Rather than ask some general, unanswerable question on how to tune my database...I thought I ask where I might find an introduction to...or manual/tutorial for the depths of managing a postgres db. ...
    NidNid
    Apr 7, 2004 at 7:10 pm
    Apr 8, 2004 at 3:06 pm
  • Hello, I've followed the last discussion about the particular case of "select count(*)"s on large tables being somewhat slow. I've seen also this issue already on the todo list, so I know it is not a ...
    Cosimo StrepponeCosimo Streppone
    Apr 8, 2004 at 9:46 am
    Apr 8, 2004 at 2:09 pm
  • Bruno et al, Any self-repsecting lurker would know that oids as row identifiers are depreciated in postgres. Can anyone provide a brief history regarding the reasoning behind using them as row ...
    James RobinsonJames Robinson
    Apr 28, 2004 at 1:29 pm
    May 5, 2004 at 5:16 pm
  • How does the analyzer/planner deal with rows clustered together? Does it just assume that if this col is clustered on then the actual data will be clustered? What if the data in the table happens to ...
    Joseph ShraibmanJoseph Shraibman
    Apr 29, 2004 at 11:15 pm
    Apr 30, 2004 at 7:30 am
  • Lets say I have two columns, A and B. They are each indexed seperately. If I do a query like: SELECT * FROM table WHERE A = 1 AND B = 2; postgres can only use one index. I assume that postgres uses ...
    Joseph ShraibmanJoseph Shraibman
    Apr 29, 2004 at 11:45 pm
    Apr 30, 2004 at 3:58 am
Apr 2004
12
Group Navigation
period‹ prev | Apr 2004 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions59
posts534
users119
websitepostgresql.org
irc#postgresql

119 users for April 2004

Tom Lane: 78 posts Josh Berkus: 39 posts Gary Doades: 26 posts Manfred Koizar: 20 posts Dave Cramer: 17 posts Christopher Kings-Lynne: 14 posts Rod Taylor: 12 posts Shea,Dan [CIS]: 12 posts Bruce Momjian: 11 posts Greg Stark: 11 posts Rajesh Kumar Mallah: 11 posts Scott.marlowe: 11 posts Chris Hoover: 9 posts Edoardo Ceccarelli: 9 posts Aaron Werman: 8 posts Richard Huxton: 8 posts Bruno Wolff III: 7 posts Dennis Bjorklund: 7 posts Joe Conway: 7 posts Pailloncy Jean-Gérard: 7 posts
show more
Archives