FAQ

PostgreSQL > pgsql-performance > June 2005

Search Discussions

92 discussions - 604 posts

  • Hi all, I have an index on a table that doesn't seem to want to be used. I'm hopig someone might be able to help point me in the right direction. My index is (typed, not copied): tle-bu= \d ...
    LinuxLinux
    Jun 10, 2005 at 3:42 pm
    Jun 15, 2005 at 5:33 pm
  • Hi All, I previously posted the following as a sequel to my SELECT DISTINCT Performance Issue question. We would most appreciate any clue or suggestions on how to overcome this show-stopping issue. ...
    K C LauK C Lau
    Jun 15, 2005 at 2:50 am
    Oct 12, 2005 at 1:00 pm
  • I'm not sure if this is the appropriate list to post this question to but i'm starting with this one because it is related to the performance of Postgresql server. I have a Penguin Computing dual AMD ...
    Mark RinaudoMark Rinaudo
    Jun 6, 2005 at 5:47 pm
    Jun 9, 2005 at 12:20 am
  • A consultant did a project for us and chose MySQL. We thought it was cool that MySQL was free. Turns out, MySQL costs over $500 (USD) if you are a commercial organization like us! Even worse, we have ...
    Bill EwingBill Ewing
    Jun 4, 2005 at 1:51 am
    Jul 8, 2005 at 4:23 pm
  • I need a fast way (sql only preferred) to solve the following problem: I need the smallest integer that is greater than zero that is not in the column of a table. In other words, if an 'id' column ...
    Merlin MoncureMerlin Moncure
    Jun 28, 2005 at 2:21 pm
    Jun 29, 2005 at 6:37 am
  • Hello! I use FreeBSD 4.11 with PostGreSQL 7.3.8. I got a huge database with roughly 19 million records. There is just one table, with a time field, a few ints and a few strings. table test fields ...
    Kjell Tore FossbakkKjell Tore Fossbakk
    Jun 21, 2005 at 7:10 pm
    Jun 23, 2005 at 3:31 pm
  • pgsql performance gurus, We ported an application from oracle to postgresql. We are experiencing an approximately 50% performance hit. I am in the process of isolating the problem. I have searched ...
    John MendenhallJohn Mendenhall
    Jun 30, 2005 at 10:24 pm
    Jul 8, 2005 at 4:37 pm
  • Hi Everyone, I've put together a short article and posted it online regarding performance tuning PostgreSQL in general. I believe it helps to bring together the info in a easy to digest manner. I ...
    Frank WilesFrank Wiles
    Jun 22, 2005 at 2:50 pm
    Jun 24, 2005 at 10:01 pm
  • Hi- Would someone please enlighten me as to why I'm not seeing a faster execution time on the simple scenario below? there are 412,485 rows in the table and the query matches on 132,528 rows, taking ...
    Clark SlaterClark Slater
    Jun 10, 2005 at 5:45 pm
    Jun 11, 2005 at 4:49 pm
  • Hi, I have a very simple query on a big table. When I issue a "limit" and/or "offset" clause, the query is not using the index. Can anyone explain me this ? rvponp=# explain select * from ...
    Yves VindevogelYves Vindevogel
    Jun 21, 2005 at 2:34 pm
    Jun 22, 2005 at 4:17 pm
  • We're in the process of buying another Opteron server to run Postgres, and based on the suggestions in this list I've asked our IT director to get an LSI MegaRaid controller rather than one of the ...
    Stacy WhiteStacy White
    Jun 2, 2005 at 3:42 am
    Jun 3, 2005 at 1:27 pm
  • We have the following function in our home grown mirroring package, but it isn't running as fast as we would like. We need to select statements from the pending_statement table, and we want to select ...
    David MitchellDavid Mitchell
    Jun 28, 2005 at 2:37 am
    Jun 28, 2005 at 8:33 am
  • Hi, I have the following table: person - primary key id, and some attributes food - primary key id, foreign key p_id reference to table person. table food store all the food that a person is eating. ...
    Junaili LieJunaili Lie
    Jun 8, 2005 at 7:34 pm
    Jun 13, 2005 at 2:21 pm
  • Hi: I'm beginning the push at our company to look at running postgreSQL in production here. We have a dual CPU 2.8 GHZ Xeon Box running oracle. Typical CPU load runs between 20% and 90%. Raw DB size ...
    Greg MaplesGreg Maples
    Jun 24, 2005 at 7:50 pm
    Jun 28, 2005 at 2:26 pm
  • I deeply apologize if this has been covered with some similar topic before, but I need a little guidance in the optimization department. We use Postgres as our database and we're having some issues ...
    Todd LandfriedTodd Landfried
    Jun 15, 2005 at 9:06 am
    Jun 24, 2005 at 9:18 pm
  • Hello, Our database increases in size 2.5 times during the day. What to do to avoid this? Autovacuum running with quite aggressive settings, FSM settings are high enough. Database size should be more ...
    Mindaugas RiaubaMindaugas Riauba
    Jun 1, 2005 at 7:43 am
    Jun 6, 2005 at 2:58 pm
  • Hi, I'm trying to update a table that has about 600.000 records. The update query is very simple : update mytable set pagesdesc = - pages ; (I use pagesdesc to avoid problems with sort that have one ...
    Yves VindevogelYves Vindevogel
    Jun 12, 2005 at 5:40 pm
    Jun 13, 2005 at 5:06 pm
  • I'm tasked with specifying a new machine to run a web application prototype. The machine will be serving web pages with a Postgresql backend; we will be making extensive use of plpgsql functions. No ...
    Rory Campbell-LangeRory Campbell-Lange
    Jun 8, 2005 at 4:32 pm
    Jun 9, 2005 at 9:25 pm
  • Greetings all, I am continously encountering an issue with query plans that changes after a pg_dump / pg_restore operation has been performed. On the production database, PostGre refuses to use the ...
    JonanewsJonanews
    Jun 9, 2005 at 6:02 am
    Jun 9, 2005 at 4:10 pm
  • Hi, I am using PostgreSQL (7.4) with a schema that was generated automatically (using hibernate). The schema consists of about 650 relations. One particular query (also generated automatically) ...
    PhilbPhilb
    Jun 2, 2005 at 3:25 pm
    Jun 4, 2005 at 10:04 am
  • Hi All, I have been reading about increasing PostgreSQL performance by relocating the pg_xlog to a disk other than the one where the database resides. I have the following pg_xlogs on my system. ...
    Keith WorthingtonKeith Worthington
    Jun 1, 2005 at 3:31 pm
    Jun 2, 2005 at 2:47 pm
  • Hi, i'm trying to optimise our autovacuum configuration so that it vacuums / analyzes some of our larger tables better. It has been set to the default settings for quite some time. We never delete ...
    Alex StapletonAlex Stapleton
    Jun 20, 2005 at 2:44 pm
    Jun 21, 2005 at 10:23 pm
  • Hi all, I have like a repository table with is very very huge with atleast a few hundreds of millions, may be over that. The information is stored in form of rows in these tables. I need to make that ...
    Amit V ShahAmit V Shah
    Jun 21, 2005 at 2:01 pm
    Jun 21, 2005 at 5:58 pm
  • Hi @ all, i have only a little question. Which filesystem is preferred for postgresql? I'm plan to use xfs (before i used reiserfs). The reason is the xfs_freeze Tool to make filesystem-snapshots. Is ...
    Martin FandelMartin Fandel
    Jun 3, 2005 at 7:07 am
    Jun 8, 2005 at 1:49 pm
  • We've seen PostgreSQL performance as a dspam database be simply stellar on some machines with absolutely no tuning to the postgres.conf, and no statistics target altering. Some months ago, I moved my ...
    Casey Allen ShobeCasey Allen Shobe
    Jun 1, 2005 at 8:19 pm
    Jun 7, 2005 at 9:43 am
  • Hi, We are looking to build a new machine for a big PG database. We were wondering if a machine with 5 scsi-disks would perform better if we use a hardware raid 5 controller or if we would go for the ...
    Yves VindevogelYves Vindevogel
    Jun 17, 2005 at 7:34 pm
    Jun 19, 2005 at 4:58 am
  • Hi, I'm having a hard time finding the poorly performing statements in my plpgsql procedures, many of which are triggers. Am I missing something? I can get the query plans by starting up a new ...
    Karl O. PincKarl O. Pinc
    Jun 27, 2005 at 10:41 pm
    Jun 28, 2005 at 2:49 am
  • Situation: I'm trying to optimize an ETL process with many upserts (~100k aggregated rows) (no duplicates allowed). The source (table t2) table holds around 14 million rows, and I'm grabbing them ...
    Bricklen AndersonBricklen Anderson
    Jun 23, 2005 at 7:38 pm
    Jun 27, 2005 at 6:15 pm
  • Hi again all, My queries are now optimised. They all use the indexes like they should. However, there's still a slight problem when I issue the "offset" clause. We have a table that contains 600.000 ...
    Yves VindevogelYves Vindevogel
    Jun 24, 2005 at 6:18 pm
    Jun 25, 2005 at 11:44 am
  • Folks, OK, I've checked in my first code module and the configurator project is officially launched. Come join us at www.pgfoundry.org/projects/configurator Further communications will be on the ...
    Josh BerkusJosh Berkus
    Jun 21, 2005 at 6:22 pm
    Jun 25, 2005 at 7:48 am
  • Hi, Consider the where-clauses: WHERE lower(col) LIKE 'abc'; WHERE lower(col) LIKE 'abc%'; these will both use a b-tree functional index in lower(col) if one exists. The clause WHERE lower(col) LIKE ...
    Kurt De GraveKurt De Grave
    Jun 22, 2005 at 6:50 pm
    Jun 24, 2005 at 11:41 pm
  • Hi, I have another question regarding indexes. I have a table with a lot of indexes on it. Those are needed to perform my searches. Once a day, a bunch of records is inserted in my table. Say, my ...
    Yves VindevogelYves Vindevogel
    Jun 21, 2005 at 3:17 pm
    Jun 21, 2005 at 7:31 pm
  • I forgot cc Begin forwarded message:
    Yves VindevogelYves Vindevogel
    Jun 13, 2005 at 3:49 pm
    Jun 14, 2005 at 1:28 am
  • Hi, I'm having problems with the query optimizer and FULL OUTER JOIN on PostgreSQL 7.4. I cannot get it to use my indexes with full outer joins. I might be naive, but I think that it should be ...
    Kim BisgaardKim Bisgaard
    Jun 8, 2005 at 9:37 am
    Jun 8, 2005 at 6:54 pm
  • hi first let me draw the outline. we have a database which stores "adverts". each advert is in one category, and one or more "region". regions and categories form (each) tree structure. assume ...
    Hubert lubaczewskiHubert lubaczewski
    Jun 4, 2005 at 8:17 am
    Jun 4, 2005 at 12:13 pm
  • Correct, in that John's query returns the first empty slot above an existing filled slot (correct behavior in my case). You could flip things around a bit to get around thist tho. Merlin
    Merlin MoncureMerlin Moncure
    Jun 28, 2005 at 7:46 pm
    Jun 29, 2005 at 2:54 am
  • Hello! I use FreeBSD 4.11 with PostGreSQL 7.3.8. I got a huge database with roughly 15 million records. There is just one table, with a time field, a few ints and a few strings. table test fields ...
    KjelleKjelle
    Jun 21, 2005 at 6:34 pm
    Jun 28, 2005 at 6:14 pm
  • Postgresql 8.0.3 Hi, I have a query select 1 from census where date < '1975-9-21' and sname = 'RAD' and status != 'A' limit 1; Explain analyze says it always uses the index made by: CREATE INDEX ...
    Karl O. PincKarl O. Pinc
    Jun 27, 2005 at 10:20 pm
    Jun 28, 2005 at 4:27 pm
  • HI! I have a table that I use for about a month. As the month progresses, COPYs performed to this table get much much slower than they were at the beginning, for the same number of rows (about ...
    Jone CJone C
    Jun 6, 2005 at 4:49 pm
    Jun 21, 2005 at 3:19 pm
  • Hey, How does Postgres (8.0.x) buffer changes to a database within a transaction? I need to insert/update more than a thousand rows (mayde even more than 10000 rows, ~100 bytes/row) in a table but ...
    Veikko MäkinenVeikko Mäkinen
    Jun 16, 2005 at 7:28 pm
    Jun 17, 2005 at 5:07 am
  • We have two index's like so l1_historical=# \d "N_intra_time_idx" Index "N_intra_time_idx" Column | Type --------+----------------------------- time | timestamp without time zone btree ...
    Alex StapletonAlex Stapleton
    Jun 13, 2005 at 1:02 pm
    Jun 13, 2005 at 3:39 pm
  • Hi, I have a view that has something like this: select x, y, z from tbl order by x, y I have created a special index on x + y I have run analyze Still, when I use explain, pg says it will first sort ...
    Yves VindevogelYves Vindevogel
    Jun 13, 2005 at 6:54 am
    Jun 13, 2005 at 2:18 pm
  • Hi All, We are testing PostgreSQL 8.0.3 on MS Windows for porting an OLTP system from MS SqlServer. We got a major performance issue which seems to boil down to the following type of query: select ...
    K C LauK C Lau
    Jun 3, 2005 at 1:57 am
    Jun 8, 2005 at 2:51 pm
  • I have a small business client that cannot afford high-end/high quality RAID cards for their next server. That's a seperate argument/issue right there for me, but what the client wants is what the ...
    Steve PoeSteve Poe
    Jun 3, 2005 at 6:47 pm
    Jun 7, 2005 at 3:30 pm
  • I've got some queries generated by my application that will, for some reason, run forever until I kill the pid. Yet, when I run the queries manually to check them out, they usually work fine. To get ...
    Dan HarrisDan Harris
    Jun 20, 2005 at 5:56 pm
    Jul 3, 2005 at 11:29 pm
  • Hi, I have a stored procedure written in perl and I doubt that perl's garbage collector is working :-( after a lot of work, postmaster has a size of 1100 Mb and I think that the keyword "undef" has ...
    Jean-Max ReymondJean-Max Reymond
    Jun 27, 2005 at 8:46 pm
    Jun 28, 2005 at 10:10 pm
  • Hi Everyone, Im having a performance issue with version 7.3.4 which i first thought was Disk IO related, however now it seems like the problem is caused by really slow commits, this is running on ...
    Steve PollardSteve Pollard
    Jun 8, 2005 at 9:09 am
    Jun 10, 2005 at 10:15 am
  • It seems that Postgres is estimating that all rows in a 50k row table will be returned, but only one should match. The query runs slow because of the seqscan. When I set enable_seqscan to off, then ...
    Allan WangAllan Wang
    Jun 8, 2005 at 3:04 pm
    Jun 8, 2005 at 6:06 pm
  • hi, I have two computers, one laptop (1.5 GHz, 512 Mb RAM, 1 disk 4200) and one big Sun (8Gb RAM, 2 disks SCSI). On my laptop, I have this EXPLAIN ANALYZE Sort (cost=7.56..7.56 rows=1 width=28) ...
    Jean-Max ReymondJean-Max Reymond
    Jun 30, 2005 at 3:42 pm
    Jun 30, 2005 at 9:01 pm
  • We are running an application that uses psqlodbc driver on Windows XP to connect to a server and for some reason the download of data from the server is very slow. We have created a very simple test ...
    Milan SekaninaMilan Sekanina
    Jun 30, 2005 at 10:31 am
    Jun 30, 2005 at 2:47 pm
Jun 2005
12
Group Navigation
period‹ prev | Jun 2005 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions92
posts604
users163
websitepostgresql.org
irc#postgresql

163 users for June 2005

Tom Lane: 53 posts John Arbash Meinel: 27 posts Yves Vindevogel: 26 posts Tobias Brox: 19 posts Bruno Wolff III: 18 posts Pierre-Frédéric Caillaud: 15 posts Josh Berkus: 14 posts Martin Fandel: 14 posts Madison Kelly: 13 posts Christopher Kings-Lynne: 12 posts Jacques Caron: 11 posts Merlin Moncure: 11 posts Joshua D. Drake: 10 posts Kevin Grittner: 9 posts Michael Stone: 9 posts Alex Stapleton: 8 posts Jona: 8 posts Karl O. Pinc: 8 posts Michael Fuhr: 8 posts Cosimo Streppone: 7 posts
show more
Archives