Search Discussions

54 discussions - 639 posts

  • What is the best COPY performance that you have gotten on a "normal" table? I know that this is question is almost too general, but it might help me out a bit, or at least give me the right things to ...
    Worky WorkersonWorky Workerson
    Oct 20, 2006 at 8:33 pm
    Nov 27, 2006 at 6:33 pm
  • Posting here instead of hackers since this is where the thread got started... The argument has been made that producing a hints system will be as hard as actually fixing the optimizer. There's also ...
    Jim C. NasbyJim C. Nasby
    Oct 12, 2006 at 3:14 pm
    Oct 18, 2006 at 5:01 pm
  • I have two tables, SAMPLE and HITLIST that when joined, generate a monsterous sort. HITLIST_ROWS has about 48,000 rows SAMPLE has about 16 million rows The joined column is indexed in SAMPLE ...
    Craig A. JamesCraig A. James
    Oct 7, 2006 at 6:36 am
    Oct 11, 2006 at 8:28 pm
  • Some very helpful people had asked that I post the troublesome code that was generated by my import program. I installed a SQL log feature in my import program. I have posted samples of the SQL ...
    Carlo StonebanksCarlo Stonebanks
    Oct 3, 2006 at 8:33 am
    Oct 18, 2006 at 11:00 pm
  • This SQL sentence is very simple. I need to get better results. I have tried some posibilities and I didn't get good results. SELECT max(idcomment) FROM ficha vf INNER JOIN comment c ON ...
    Ruben RubioRuben Rubio
    Oct 17, 2006 at 9:12 am
    Oct 18, 2006 at 7:37 pm
  • (I tried this question on the interface forum and got no result, but I don't know how to tell if it's an interface issue or not) I have a TCL app which typically takes hours to complete. I found out ...
    Carlo StonebanksCarlo Stonebanks
    Oct 25, 2006 at 3:46 pm
    Oct 31, 2006 at 9:17 pm
  • Hi, Adding DESC to both columns in the SORT BY did not make the query use the multikey index. So both SELECT DISTINCT ON (assetid) assetid, ts FROM asset_positions ORDER BY assetid, ts DESC; and ...
    Graham DavisGraham Davis
    Oct 3, 2006 at 6:41 pm
    Oct 4, 2006 at 1:52 pm
  • Hello all, I am currently working out the best type of machine for a high volume pgsql database that I going to need for a project. I will be purchasing a new server specifically for the database, ...
    Ben SuffolkBen Suffolk
    Oct 20, 2006 at 7:49 am
    Oct 23, 2006 at 9:47 pm
  • Hullo, here's one of those dreadful touchy-feely hand-waving problems. Our 5-node 8.1.3 Slony system has just started taking /much/ longer to VACUUM ANALYZE.. The data set has not increased more than ...
    Gavin HamillGavin Hamill
    Oct 26, 2006 at 9:22 am
    Nov 2, 2006 at 10:11 pm
  • Hi list ! I have two table with a 2-column index on both of them. In the first table, the first colum of the index is the primary key, the second one is an integer field. In the second table, the two ...
    Arnaud LesauvageArnaud Lesauvage
    Oct 18, 2006 at 11:21 am
    Oct 24, 2006 at 9:29 am
  • I just came to think about /proc/sys/swappiness ... When this one is set to a high number (say, 100 - which is maximum), the kernel will aggressively swap out all memory that is not beeing accessed, ...
    Tobias BroxTobias Brox
    Oct 19, 2006 at 1:56 pm
    Oct 20, 2006 at 12:19 pm
  • Hi everyone, I am doing a test for a scenario where I have 2 schemas one (public) for the operational data and another one (archive) for old, archived data. So basically I want to split the data from ...
    Ioana DanesIoana Danes
    Oct 18, 2006 at 7:58 pm
    Oct 19, 2006 at 11:43 am
  • Hello, Shridhar Daithankar and Josh Berkus write on http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html shared_memory """ There is one way to decide what is best for you. Set a high value of ...
    Harald Armin MassaHarald Armin Massa
    Oct 16, 2006 at 9:17 am
    Oct 20, 2006 at 2:33 pm
  • While doing a verbose vacuum, I'm constantly hitting things like: DETAIL: 3606 dead row versions cannot be removed yet. I believe this is a problem, because I still do have some empty tables ...
    Tobias BroxTobias Brox
    Oct 10, 2006 at 4:10 pm
    Oct 10, 2006 at 6:44 pm
  • Hi List ! I have a performance problem, but I am not sure whether it really is a problem or not. I am running a fresh install of PostgreSQL 8.1.4 on Windows2000. The server is a bi-opteron with 2GB ...
    Arnaud LesauvageArnaud Lesauvage
    Oct 3, 2006 at 11:54 am
    Oct 4, 2006 at 5:10 pm
  • I currently have a db supporting what is for the most part an OLAP data warehousing application. One table (good data) has roughly 120 million rows, divided into roughly 40 different relational ...
    Brendan CurranBrendan Curran
    Oct 10, 2006 at 9:44 pm
    Oct 12, 2006 at 6:25 pm
  • Hi We are facing performance problems in postgres while executing a query. When I execute this query on the server it takes 5-10 seconds. Also I get good performance while executing this query from ...
    Behl, Rohit \(Infosys\)Behl, Rohit \(Infosys\)
    Oct 17, 2006 at 7:12 pm
    Oct 22, 2006 at 3:11 pm
  • I have a simple case, selecting on a LIKE where clause over a single column that has an index on it. On windows it uses the index - on linux it does not. I have exactly the same scema and data in ...
    Simon goddenSimon godden
    Oct 4, 2006 at 7:48 am
    Oct 4, 2006 at 2:49 pm
  • Hello- #I am a biologist, and work with large datasets (tables with millions of rows are common). #These datasets often can be simplified as features with a name, and a start and end position (ie: a ...
    John MajorJohn Major
    Oct 31, 2006 at 11:47 pm
    Nov 7, 2006 at 1:37 am
  • Our Windows-based db server has to integrate with users that work regularily with Access.When attempting to import user's data from Access MDB files to PostgreSQL, we try on eof two things: either ...
    Carlo StonebanksCarlo Stonebanks
    Oct 20, 2006 at 10:19 pm
    Oct 24, 2006 at 9:49 pm
  • Hello, I'm working out specs for a new database server to be purchased for our organization. The applications the server will handle are mainly related to network operations (monitoring, logging, ...
    John PhilipsJohn Philips
    Oct 21, 2006 at 4:22 pm
    Oct 24, 2006 at 1:57 pm
  • Hi, we've got performance problems due to repeating SELECT, UPDATE, DELETE, INSERT statements. This statements have to be executed every 10 seconds, but they run into a timeout. To obviate problems ...
    Jens SchipkowskiJens Schipkowski
    Oct 19, 2006 at 1:12 pm
    Oct 19, 2006 at 6:59 pm
  • Hi Please help. I have got a postgres 7.3.4 database running on RedHat ES 3, with 8GB of physical memory in it. The machine is shared with my application which is pretty intensive in doing selects ...
    Mark LonsdaleMark Lonsdale
    Oct 25, 2006 at 8:48 pm
    Oct 26, 2006 at 7:08 pm
  • Hello. Simply jumping on the bandwagon, just my 2 cents: why not just like in some other (commercial) databases: a statement to say: use index ............ I know this is against all though but if ...
    H.J. SandersH.J. Sanders
    Oct 12, 2006 at 7:50 am
    Oct 12, 2006 at 10:26 pm
  • I would like to understand what causes some of my indexes to be slower to use than others with PostgreSQL 8.1. On a particular table, I have an int4 primary key, an indexed unique text 'name' column ...
    Stuart BishopStuart Bishop
    Oct 20, 2006 at 7:31 am
    Nov 6, 2006 at 1:34 am
  • Hi, here is a query which produces over 1G temp file in pgsql_tmp. This is on pgsql 7.4.2, RHEL 3.0, XEON MP machine with 32GB RAM, 300MB sort_mem and 320MB shared_mem. Below is the query and results ...
    Dirk LutzebaeckDirk Lutzebaeck
    Oct 27, 2006 at 11:46 am
    Oct 27, 2006 at 3:49 pm
  • Look at this insane plan: lucas=# explain analyse select huvudklass,sum(summa) from kor_tjanster left outer join prislist on prislista=listid and tjanst=tjanstid where kor_id in (select id from kor ...
    Mattias KregertMattias Kregert
    Oct 30, 2006 at 11:56 am
    Oct 30, 2006 at 3:51 pm
  • I have two systems running 8.2beta1 getting strange difference of results in count(*). Query that illistrates the difference is count(*). this is a synthetic test i use to measure a sytems's cpu ...
    Merlin MoncureMerlin Moncure
    Oct 9, 2006 at 6:22 pm
    Oct 10, 2006 at 6:30 am
  • I'm having an interesting (perhaps anomalous) variability in UPDATE performance on a table in my database, and wanted to see if there was any interest in looking further before I destroy the evidence ...
    Steve PetersonSteve Peterson
    Oct 4, 2006 at 6:01 pm
    Oct 5, 2006 at 1:20 pm
  • Hello All- We have a question about numbers of fields in the select clause of a query and how that affects query speed. The following query simply selects the primary key field from a table with ...
    Tom DarciTom Darci
    Oct 25, 2006 at 5:26 pm
    Oct 26, 2006 at 10:50 pm
  • Hi! I have a problem with ACCESS EXCLUSIVE lock when I drop a reference in transaction. I have 2 tables: create table a(id SERIAL primary key); create table b(id SERIAL primary key references a(id)); ...
    Oct 18, 2006 at 2:58 pm
    Oct 25, 2006 at 5:41 pm
  • [Matthew T. O'Connor - Wed at 02:33:10PM -0400] I was experimenting a bit with autovacuum now. To make the least effect possible, I started with a too high cost_delay/cost_limit-ratio. The effect of ...
    Tobias BroxTobias Brox
    Oct 15, 2006 at 9:53 am
    Oct 18, 2006 at 8:59 pm
  • Hi, I am trying to determine if there is a way to improve the performance when selecting data from the information_schema.columns view. We use data from this view to inform our application ...
    Steve MartinSteve Martin
    Oct 2, 2006 at 2:50 am
    Oct 3, 2006 at 1:50 am
  • Ok, so MVCC is the best thing since a guy put a round stone on a stick and called it "the wheel", but I've seen several references on this list about "indexes not being under MVCC" - at least that's ...
    Ivan VorasIvan Voras
    Oct 31, 2006 at 10:24 pm
    Nov 1, 2006 at 7:02 pm
  • I've got another query I'm trying to optimize: select aj.album from public.track t join public.albumjoin aj on (aj.track = t.id) join (select id from public.albummeta am where tracks between 10 and ...
    Oct 5, 2006 at 1:35 am
    Nov 1, 2006 at 6:04 am
  • Hello, I have been having a problem with the following query ignoring an index on the foos.bar column. SELECT c.id FROM foos c, bars r WHERE r.id != 0 AND r.modified_time '2006-10-20 10:00:00.000' ...
    Leif MortensonLeif Mortenson
    Oct 31, 2006 at 4:21 am
    Oct 31, 2006 at 3:02 pm
  • Hi! I'm just wondering, I've got a table that is partitioned into monthly tables: media_downloads - media_downloads_YYYYMM I\- id (primary key) \- created_on (timestamp criteria for the monthly table ...
    Andreas KostyrkaAndreas Kostyrka
    Oct 28, 2006 at 10:26 pm
    Oct 30, 2006 at 10:47 pm
  • Hello, I was going through the Performance Enhancements of 8.1.0, in that I have read "Bitmap Scan" "*Bitmap Scan:* indexes will be dynamically converted to bitmaps in memory when appropriate, giving ...
    Soni deSoni de
    Oct 17, 2006 at 11:39 am
    Oct 27, 2006 at 1:12 pm
  • (Repost - did not appear to make it to the list the first time) I have written a stored procedure for 8.1 that wraps a single (albeit complex) query, and uses 2 IN parameters (BIGINT, INTEGER) in the ...
    Matthew PetersMatthew Peters
    Oct 26, 2006 at 3:49 pm
    Oct 26, 2006 at 7:20 pm
  • Hello friends, I am responsible for maintaining a high volume website using postgresql 8.1.4. Given the amount of reads and writes, I vacuum full the server a few times a week around 1, 2 AM shutting ...
    Oct 20, 2006 at 1:25 am
    Oct 23, 2006 at 9:36 pm
  • Hello! After upgrade PostgreSQL from 8.0 to 8.1.4 a VACUUM FULL ANALYZE process is much slower, from logs: 8.0 [13666][postgres][2006-10-06 01:13:38 CEST][1340121452] LOG: statement: VACUUM FULL ...
    Andrzej ZawadzkiAndrzej Zawadzki
    Oct 19, 2006 at 1:37 pm
    Oct 20, 2006 at 11:46 am
  • I've recently moved to 8.1 and find that autovacuum doesn't seem to be working, at least not the way I expected it to. I need the tuple count for a table to be updated so indexes will be used when ...
    Medora SchauerMedora Schauer
    Oct 9, 2006 at 2:02 pm
    Oct 9, 2006 at 9:26 pm
  • Look at this: NBET= explain select * from account_transaction where users_id=123456 order by created desc limit 10; QUERY PLAN ...
    Tobias BroxTobias Brox
    Oct 4, 2006 at 6:13 pm
    Oct 4, 2006 at 8:41 pm
  • Hello, My Server is crashed in PQfinish. Below is the core file details: = [1] DLRemHead(0x2b7780, 0xfb6bc008, 0x319670, 0xfb6bc008, 0x21c40, 0x3106f8), at 0xfded10e4 [2] DLFreeList(0x2b7780, 0x0, ...
    Soni deSoni de
    Oct 27, 2006 at 1:09 pm
    Oct 31, 2006 at 11:48 am
  • Hello, I have a query with several join operations and applying the same filter condition over each involved table. This condition is a complex predicate over an indexed timestamp field, depending on ...
    Mara DalponteMara Dalponte
    Oct 23, 2006 at 7:54 pm
    Oct 25, 2006 at 3:32 pm
  • Hello there; I've got an application that has to copy an existing database to a new database on the same machine. I used to do this with a pg_dump command piped to psql to perform the copy; however ...
    Oct 23, 2006 at 10:13 pm
    Oct 25, 2006 at 12:25 am
  • Hello Performancers, has anyone a pgBench tool running on Windows? I want to experiment with various settings to tune; and would prefer using something ready made before coming up with my own ...
    Harald Armin MassaHarald Armin Massa
    Oct 20, 2006 at 8:14 am
    Oct 22, 2006 at 9:56 pm
  • Hello all, I read a paper, which is Query optimization in the presence of Foreign Functions. And the paper , there is a paragraph like below. In order to reduce the number of invocations, caching the ...
    Jungmin shinJungmin shin
    Oct 18, 2006 at 9:15 pm
    Oct 18, 2006 at 9:19 pm
  • Hi, to all! Recently i try increasing the memory values of shared buffers on one IBM xseries 255 (Quad XEON 2.8, 8 GB RAM, 2 disk SCSI 36 GB(Raid 1), 1 Storage. I try change these shared memory ...
    Marcelo CostaMarcelo Costa
    Oct 2, 2006 at 3:50 pm
    Oct 2, 2006 at 4:31 pm
  • Question: I have a big table with 120,000,000 records. Let's assume that I DELETE 4,000,000 records, VACUUM FULL, and REINDEX. Now I have the same table, but with 240,000,000 records. I DELETE ...
    Steve OuallineSteve Oualline
    Oct 20, 2006 at 10:14 pm
    Oct 21, 2006 at 5:02 am
Group Navigation
period‹ prev | Oct 2006 | next ›
Group Overview
grouppgsql-performance @

132 users for October 2006

Jim Nasby: 65 posts Tom Lane: 54 posts Carlo Stonebanks: 35 posts Merlin Moncure: 34 posts Joshua D. Drake: 27 posts Tobias Brox: 27 posts Worky Workerson: 15 posts Craig A. James: 13 posts Markus Schaber: 13 posts Luke Lonergan: 12 posts Mark Kirkwood: 11 posts Graham Davis: 10 posts Richard Huxton: 10 posts Arnaud Lesauvage: 9 posts Bucky Jordan: 9 posts Harald Armin Massa: 9 posts Chris Browne: 8 posts Heikki Linnakangas: 8 posts Jeff Davis: 8 posts Josh Berkus: 8 posts
show more