FAQ

PostgreSQL > pgsql-performance > July 2007

Search Discussions

66 discussions - 446 posts

  • Folks, I've run into this a number of times with various PostgreSQL users, so we tested it at Sun. What seems to be happening is that at some specific number of connections average throughput drops ...
    Josh BerkusJosh Berkus
    Jul 19, 2007 at 3:28 pm
    Aug 10, 2007 at 8:02 pm
  • Recently, I have been doing extensive profiling of a version 8.1.4 Postgres DB with about 175 tables and 5 GB of data (the server running on Fedora Linux and the clients on Windows XP). Surprisingly, ...
    Adriaan van OsAdriaan van Os
    Jul 11, 2007 at 9:11 pm
    Aug 6, 2007 at 6:46 pm
  • Hello all, I think this result will be useful for performance discussions of postgresql against other databases. http://www.spec.org/jAppServer2004/results/res2007q3/ More on Josh Berkus's blog: ...
    Jignesh K. ShahJignesh K. Shah
    Jul 9, 2007 at 3:57 pm
    Jul 13, 2007 at 12:08 pm
  • We're using Postgres 8.2.4. I'm trying to decide whether it's worthwhile to implement a process that does periodic reindexing. In a few ad hoc tests, where I've tried to set up data similar to how ...
    Steven FlattSteven Flatt
    Jul 18, 2007 at 5:08 pm
    Sep 14, 2007 at 4:23 am
  • Hi I was doing some testing on "insert" compared to "select into". I inserted 100 000 rows (with 8 column values) into a table, which took 14 seconds, compared to a select into, which took 0.8 ...
    Thomas FinneidThomas Finneid
    Jul 17, 2007 at 7:39 pm
    Jul 23, 2007 at 11:52 am
  • Postgres configuration for 64 CPUs, 128 GB RAM... Hello, We have the oppotunity to benchmark our application on a large server. I have to prepare the Postgres configuration and I'd appreciate some ...
    Marc MaminMarc Mamin
    Jul 17, 2007 at 2:31 pm
    Aug 1, 2007 at 6:11 pm
  • I'm having this very disturbing problem. I got a table with about 100,000 rows in it. Our software deletes the majority of these rows and then bulk loads another 100,000 rows into the same table. All ...
    Jozsef SzalayJozsef Szalay
    Jul 22, 2007 at 3:41 pm
    Aug 18, 2007 at 3:04 am
  • Friends, Who can help me? My SELECT in a base with 1 milion register, using expression index = 6seconds. Please, I don't know how to makes it better. Thanks
    Bruno Rodrigues SiqueiraBruno Rodrigues Siqueira
    Jul 28, 2007 at 7:27 pm
    Aug 1, 2007 at 5:59 pm
  • Hi I have the following scenario for a database that I need to design, and would like some hints on what to improve or do differently to achieve the desired performance goal, disregarding hardware ...
    TfinneidTfinneid
    Jul 5, 2007 at 12:39 pm
    Jul 19, 2007 at 7:23 am
  • Dear list, I am having problems selecting the 10 most recent rows from a large table (4.5M rows), sorted by a date column of that table. The large table has a column user_id which either should match ...
    Tilmann SingerTilmann Singer
    Jul 27, 2007 at 5:27 pm
    Jul 30, 2007 at 8:05 pm
  • Assuming we have 24 73G drives is it better to make one big metalun and carve it up and let the SAN manage the where everything is, or is it better to specify which spindles are where. Currently we ...
    Dave CramerDave Cramer
    Jul 11, 2007 at 1:03 pm
    Jul 11, 2007 at 6:45 pm
  • This query is taking less than 5 minutes on 7.4 but over 5 hours on 8.1... PostgreSQL 8.1.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.0 (SUSE Linux) Total runtime: 20448310.101 ms = ...
    Smiley2211Smiley2211
    Jul 3, 2007 at 5:25 pm
    Jul 5, 2007 at 6:05 pm
  • I've got an interesting issue here that I'm running into with 8.2.3 This is an application that has run quite well for a long time, and has been operating without significant changes (other than ...
    Karl DenningerKarl Denninger
    Jul 25, 2007 at 1:40 am
    Jul 25, 2007 at 9:01 pm
  • Sorry for the cross-post, but this is performance and advocacy related... Has anyone benchmarked HEAD against 8.2? I'd like some numbers to use in my OSCon lightning talk. Numbers for both with and ...
    Jim NasbyJim Nasby
    Jul 20, 2007 at 4:59 am
    Jul 25, 2007 at 2:43 pm
  • All, I'm very curious to know if we may expect or guarantee any data consistency with WAL sync=OFF but using file system mounted in Direct I/O mode (means every write() system call called by PG ...
    DimitriDimitri
    Jul 3, 2007 at 2:54 pm
    Jul 10, 2007 at 12:53 pm
  • Hello all, My hard disk is filling up in the /base directory to where it has consumed all 200gig of that drive. All the posts that i see keep saying move to a bigger drive, but at some point a bigger ...
    Brandon ShaltonBrandon Shalton
    Jul 26, 2007 at 1:24 pm
    Jul 31, 2007 at 4:16 pm
  • Hello, I'm currently trying to decide on a database design for tags in my web 2.0application. The problem I'm facing is that I have 3 separate tables i.e. cars, planes, and schools. All three tables ...
    Jay KangJay Kang
    Jul 29, 2007 at 2:22 pm
    Jul 30, 2007 at 8:40 pm
  • Hello all, how to build an multicolumn index with one column order ASCENDING and another column order DESCENDING? The use case that I have is that I use 2 column index where the first column is kind ...
    ValgogValgog
    Jul 23, 2007 at 4:47 pm
    Jul 24, 2007 at 7:33 am
  • Setting spec for a postgresql server. The hard drive distribution is going to be 8 x 750GB Seagate on a 3ware 9650SE RAID 6 2 x 160GB Seagate on a 3ware 2 port The question is, would I be better off ...
    Francisco ReyesFrancisco Reyes
    Jul 11, 2007 at 2:47 pm
    Jul 12, 2007 at 12:27 am
  • Hi, One of our end users was complaining about a report that was taking too much time to execute and I´ve discovered that the following SQL statement was the responsible for it. I would appreciate ...
    Carlos H. ReimerCarlos H. Reimer
    Jul 20, 2007 at 12:41 am
    Aug 4, 2007 at 2:02 pm
  • Hi All, I am trying to find out how to use a trigger function on a table to copy any inserted row to a remote PG server. ie: Row X is inserted into TableX in DB1 on server1....TableX trigger function ...
    Michael DenglerMichael Dengler
    Jul 18, 2007 at 1:36 pm
    Jul 27, 2007 at 6:27 pm
  • Hi, Okay, i know, not really a recent version: PostgreSQL 8.1.4 on i386-pc-linux-gnu, compiled by GCC cc (GCC) 3.3.5 (Debian 1:3.3.5-13) I have a fresh ANALYZED table with some indexes. scholl=*# set ...
    Andreas KretschmerAndreas Kretschmer
    Jul 11, 2007 at 6:33 pm
    Jul 12, 2007 at 5:15 am
  • I have the same schema in two different databases. In "smalldb", the two tables of interest have about 430,000 rows, in "bigdb", the two tables each contain about 5.5 million rows. I'm processing the ...
    Craig JamesCraig James
    Jul 2, 2007 at 11:25 pm
    Jul 12, 2007 at 2:27 pm
  • Hi all, I've got the following two tables running on postgresql 8.1.4 transactions Column | Type | Modifiers ----------------------+-----------------------------+--------------- transaction_id | ...
    ArnauArnau
    Jul 24, 2007 at 6:27 pm
    Jul 25, 2007 at 1:35 pm
  • We're experiencing a query performance problem related to the planner and its ability to perform a specific type of merge. We have created a test case (as attached, or here: ...
    Jonathan GrayJonathan Gray
    Jul 24, 2007 at 8:12 am
    Jul 24, 2007 at 9:50 am
  • Hi, If I have a query such as: SELECT * FROM (SELECT * FROM A) UNION ALL (SELECT * FROM B) WHERE blah='food'; Assuming the table A and B both have the same attributes and the data between the table ...
    Benjamin AraiBenjamin Arai
    Jul 18, 2007 at 4:14 pm
    Jul 19, 2007 at 2:39 pm
  • Hello all, I am a bit confused...I have a database which was performing very POORLY selecting from a view (posted earlier) on one server but extremely fast on another server... I just backed up the ...
    Smiley2211Smiley2211
    Jul 13, 2007 at 4:53 pm
    Jul 13, 2007 at 9:05 pm
  • How can I get the time it takes a query to execute - explain analyze is taking over 5 hours to complete...can I use \timing??? I don't get any time when using the \timing option... Thanks...Marsha -- ...
    Smiley2211Smiley2211
    Jul 11, 2007 at 3:21 pm
    Jul 12, 2007 at 12:39 pm
  • Postgres 8.2.4. We have a large table, let's call it "foo", whereby an automated process periodically inserts many (hundreds of thousands or millions) rows into it at a time. It's essentially INSERT ...
    Steven FlattSteven Flatt
    Jul 27, 2007 at 9:32 pm
    Jul 31, 2007 at 5:19 am
  • I have installed pgAdmin III 1.6. In the tool when you click on a particular table you can select a tab called "Statistics". This tab has all kinds of info on your table. For some reason the only ...
    Campbell, LanceCampbell, Lance
    Jul 24, 2007 at 5:04 pm
    Jul 25, 2007 at 9:00 am
  • Today, I looked at 'top' on my PG server and saw a pid that reported 270 hours of CPU time. Considering this is a very simple query, I was surprised to say the least. I was about to just kill the ...
    Dan HarrisDan Harris
    Jul 20, 2007 at 3:43 pm
    Jul 20, 2007 at 6:12 pm
  • And this has to do with pgsql.performance exactly what? Anyway, as someone who seems to administrates a PostgreSQL production box, you sure have a good backup plan. So just call DELL's support, fix ...
    Hannes DorbathHannes Dorbath
    Jul 14, 2007 at 8:30 am
    Jul 16, 2007 at 9:02 pm
  • Hi, Something I'd like to share. I switched to postgres about 4 months ago. The perfomance after a while got worse. I posted a message here, where the result was that my IO was the problem. I run ...
    Patric de WahaPatric de Waha
    Jul 14, 2007 at 3:51 pm
    Jul 15, 2007 at 2:26 am
  • Hello. I've googled a bit but I think I can't match the keywords, so I thought I'll ask here: Let's say I've got a view with 100 columns and 1mln rows; some of them are calculated "on the fly". For ...
    Marcin StępnickiMarcin Stępnicki
    Jul 12, 2007 at 8:40 am
    Jul 12, 2007 at 2:48 pm
  • Hi, I've two questions for which I not really found answers in the web. Intro: I've a Website with some traffic. 2 Million queries a day, during daylight. Postgres is running on a dedicated server P4 ...
    Patric de WahaPatric de Waha
    Jul 11, 2007 at 3:35 pm
    Jul 11, 2007 at 8:49 pm
  • Hi, I have found under http://www.physiol.ox.ac.uk/Computing/Online_Documentation/postgresql/plpgsql.html#PLPGSQL-OVERVIEW Note: The PL/pgSQL EXECUTE statement is not related to the EXECUTE statement ...
    Andreas TilleAndreas Tille
    Jul 31, 2007 at 2:15 pm
    Aug 1, 2007 at 3:29 am
  • valgog wrote .. I've often gotten what I want by using a calculated index on (f1, -f2). ORDER BY will take an expression, e.g. ORDER BY f1, -f2. Simpler than a custom operator.
    AndrewAndrew
    Jul 24, 2007 at 7:57 am
    Jul 27, 2007 at 8:03 pm
  • Hi all, I have the following scenario, I have users and groups where a user can belong to n groups, and a group can have n users. A user must belogn at least to a group. So when I delete a group I ...
    ArnauArnau
    Jul 6, 2007 at 2:42 pm
    Jul 6, 2007 at 4:19 pm
  • Hi, I've dbase with about 80 relations. On deleting a user, this cascades through all the tables. This is very slow, for 20 users it takes 4 hours, with exclusive access to the dbase. No other users ...
    Patric de WahaPatric de Waha
    Jul 3, 2007 at 6:29 am
    Jul 4, 2007 at 8:02 am
  • Hi, I have a couple questions about how update, truncate and vacuum would work together. 1) If I update a table foo (id int, value numeric (20, 6)) with update foo set value = 100 where id = 1 Would ...
    Scott FeldsteinScott Feldstein
    Jul 26, 2007 at 10:43 pm
    Jul 26, 2007 at 11:59 pm
  • Hi all, whats the benefits of replication by using slony in postgresql?? My office is separate in several difference place..its about hundreds branch office in the difference place..so any one can ...
    Angga erwinaAngga erwina
    Jul 26, 2007 at 8:44 am
    Jul 26, 2007 at 7:04 pm
  • Hi all, I have a serious problem with a server. This server holds severals DB, the problem is thet the CPU's spend most of the time waiting: Cpu0: 4.0% us, 2.3% sy, 0.0% ni, 61.5% id, 32.1% wa, 0.0% ...
    ArnauArnau
    Jul 19, 2007 at 4:44 pm
    Jul 19, 2007 at 5:05 pm
  • I am planning to add a tags (as in the "web 2.0" thing) feature to my web based application. I would like some feedback from the experts here on what the best database design for that would be. The ...
    ListsLists
    Jul 18, 2007 at 9:30 pm
    Jul 18, 2007 at 9:54 pm
  • Seems Linux has IO scheduling through a program called ionice. Has anyone here experimented with using it rather than vacuum sleep settings? http://linux.die.net/man/1/ionice This program sets the io ...
    Ron MayerRon Mayer
    Jul 17, 2007 at 10:29 pm
    Jul 18, 2007 at 6:48 pm
  • Hi During the somes I did I noticed that it does not necessarily seem to be true that one needs the fastest disks to have a pg system that is fast. It seems to me that its more important to: - choose ...
    Thomas FinneidThomas Finneid
    Jul 17, 2007 at 9:44 pm
    Jul 18, 2007 at 8:58 am
  • Hi, I'm having a weird problem on a query : I've simplified it to get the significant part (see end of message). The point is I've got a simple SELECT field FROM table WHERE 'condition1' Estimated ...
    Marc CousinMarc Cousin
    Jul 11, 2007 at 3:52 pm
    Jul 12, 2007 at 8:55 am
  • Hello, How can I know my PostgreSQL 8 is using direct I/O or buffered I/O? If using buffered I/O, how can I enable direct I/O? What is the performance difference of them? This is urgent, Thanks. ...
    Lai yoke hmanLai yoke hman
    Jul 6, 2007 at 2:28 am
    Jul 6, 2007 at 4:03 pm
  • Hello, I would like to better understand the semantics of the statistics shown in PostgreSQL Logs. For example, in the report: DETAIL: ! system usage stats: ! 0.000100 elapsed 0.000000 user 0.000000 ...
    Camilo PortoCamilo Porto
    Jul 31, 2007 at 2:36 pm
    Jul 31, 2007 at 6:22 pm
  • Data_encerramento is a timestamp column I will try your tip. Thanks -----Mensagem original----- De: pgsql-performance-owner@postgresql.org Em nome de Ragnar Enviada em: sábado, 28 de julho de 2007 ...
    Bruno Rodrigues SiqueiraBruno Rodrigues Siqueira
    Jul 28, 2007 at 10:39 pm
    Jul 30, 2007 at 6:54 am
  • I am wondering if reindexing heavily used tables can have an impact on vacuum times. If it does, will the impact be noticeable the next time I vacuum? Please note that I am doing vacuum, not vacuum ...
    Y SidhuY Sidhu
    Jul 25, 2007 at 6:53 pm
    Jul 26, 2007 at 11:28 pm
Jul 2007
12
Group Navigation
period‹ prev | Jul 2007 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions66
posts446
users117
websitepostgresql.org
irc#postgresql

117 users for July 2007

Tom Lane: 43 posts Jignesh K. Shah: 23 posts Jim Nasby: 18 posts Simon Riggs: 15 posts Gregory Stark: 13 posts Heikki Linnakangas: 12 posts Thomas Finneid: 12 posts Alvaro Herrera: 10 posts Greg Smith: 10 posts Josh Berkus: 9 posts Smiley2211: 9 posts Joshua D. Drake: 8 posts Richard Huxton: 8 posts Adriaan van Os: 7 posts Dimitri: 7 posts Andrew Sullivan: 6 posts Bill Moran: 6 posts Bruno Rodrigues Siqueira: 6 posts Craig James: 6 posts Karl Denninger: 6 posts
show more
Archives