FAQ

Search Discussions

66 discussions - 500 posts

  • hi, I'm curious as to why autovacuum is not designed to do full vacuum. I know that the necessity of doing full vacuums can be reduced by increasing the FSM, but in my opinion that is the wrong ...
    Michael RiessMichael Riess
    Jan 17, 2006 at 10:19 am
    Jan 20, 2006 at 7:02 pm
  • [ thread moved to pgsql-performance ] I've obtained a gprof profile on Stephan's sample case (many thanks for providing the data, Stephan). The command is CREATE INDEX foo ON publications_test USING ...
    Tom LaneTom Lane
    Jan 20, 2006 at 7:14 pm
    Jan 27, 2006 at 7:52 am
  • Does anyone have any experience with extremely large data sets? I'm mean hundreds of millions of rows. The queries I need to run on my 200 million transactions are relatively simple: select month, ...
    Mike BiamonteMike Biamonte
    Jan 28, 2006 at 1:27 am
    Feb 2, 2006 at 7:41 pm
  • I am aware that what I am dreaming of is already available through cursors, but in a web application, cursors are bad boys, and should be avoided. What I would like to be able to do is to plan a ...
    Alessandro BarettaAlessandro Baretta
    Jan 16, 2006 at 10:12 am
    Jan 23, 2006 at 10:31 am
  • Hello, I've a performance problem with the planner algorithm choosen in a website. See the difference between this: http://klive.cpushare.com/?scheduler=cooperative and this: ...
    Andrea ArcangeliAndrea Arcangeli
    Jan 10, 2006 at 1:44 am
    Jan 12, 2006 at 12:48 am
  • I have questions about how to improve the write performance of PostgreSQL for logging data from a real-time simulation. We found that MySQL 4.1.3 could log about 1480 objects/second using MyISAM ...
    Steve EckmannSteve Eckmann
    Jan 3, 2006 at 11:49 pm
    Jan 7, 2006 at 6:28 pm
  • Hi, I'm running version 8.1 on a dedicated Sun v20 server (2 AMD x64's) with 4Gb of RAM. I have recently noticed that the performance of some more complex queries is extremely variable and irregular. ...
    Jean-Philippe CôtéJean-Philippe Côté
    Jan 11, 2006 at 7:48 pm
    Jan 20, 2006 at 4:42 pm
  • Howdy. I'm running into scaling problems when testing with a 16gb (data +indexes) database. I can run a query, and it returns in a few seconds. If I run it again, it returns in a few milliseconds. I ...
    Peter royalPeter royal
    Jan 6, 2006 at 10:59 pm
    Jan 11, 2006 at 6:03 am
  • We have a large database system designed around partitioning. Our application is characterized with - terabytes of data - billions of rows in dozens of base tables (and 100s of paritions) - 24x7 ...
    Marc MorinMarc Morin
    Jan 31, 2006 at 11:51 pm
    Feb 8, 2006 at 8:30 am
  • Hi, Will simple queries such as "SELECT * FROM blah_table WHERE tag='x'; work any faster by putting them into a stored procedure? Benjamin Arai barai@cs.ucr.edu http://www.benjaminarai.com ...
    Benjamin AraiBenjamin Arai
    Jan 19, 2006 at 5:38 pm
    Jan 23, 2006 at 5:24 pm
  • Hi, I am currently doing large weekly updates with fsync=off. My updates involves SELECT, UPDATE, DELETE and etc. Setting fsync=off works for me since I take a complete backup before the weekly ...
    Benjamin AraiBenjamin Arai
    Jan 18, 2006 at 6:09 pm
    Jan 19, 2006 at 10:54 pm
  • I'm trying to query a table with 250,000+ rows. My query requires I provide 5 colums in my "order by" clause: select column from table where column = '2004-3-22 0:0:0' order by ds.receipt desc, ...
    JJ
    Jan 17, 2006 at 10:03 pm
    Jan 18, 2006 at 7:37 pm
  • Hi, We have a horribly designed postgres 8.1.0 database (not my fault!). I am pretty new to database design and management and have really no idea how to diagnose performance problems. The db has ...
    AntoineAntoine
    Jan 16, 2006 at 10:07 pm
    Jan 17, 2006 at 1:52 pm
  • Hey folks, I'm working with a query to get more info out with a join. The base query works great speed wise because of index usage. When the join is tossed in, the index is no longer used, so the ...
    Robert CreagerRobert Creager
    Jan 10, 2006 at 4:30 am
    Jan 12, 2006 at 4:21 am
  • Hi all, Is PostgreSQL able to throw unnecessary joins? For example I have two tables, and I join then with their primary keys, say type of bigint . In this case if I don't reference to one of the ...
    Ottó HavasvölgyiOttó Havasvölgyi
    Jan 12, 2006 at 12:18 pm
    Jan 14, 2006 at 12:22 am
  • Hi to all, I have the following query: SELECT count(*) FROM orders o INNER JOIN report r ON r.id_order=o.id WHERE o.id_status 3 Explaing analyze: Aggregate (cost=8941.82..8941.82 rows=1 width=0) ...
    AndyAndy
    Jan 5, 2006 at 3:16 pm
    Jan 11, 2006 at 6:25 pm
  • Hello gentlemen, Although this is my first post on the list, I am a fairly experienced PostgreSQL programmer. I am writing an ERP application suite using PostgreSQL as the preferred DBMS. Let me ...
    Alessandro BarettaAlessandro Baretta
    Jan 9, 2006 at 1:51 pm
    Jan 11, 2006 at 9:42 am
  • I do a load of sql joins using primary and foreign keys. What i would like to know if PostgreSQL creates indexes on these columns automatically (in addition to using them to maintain referential ...
    Burak SeydiogluBurak Seydioglu
    Jan 11, 2006 at 10:38 pm
    Jan 12, 2006 at 4:48 am
  • Hi, I've created a table like this : CREATE TABLE tmp_A ( c "char", i int4 ); And another one CREATE TABLE tmp_B ( i int4, ii int4 ); I then inerted a bit more than 19 million rows in each table ...
    Paul MackayPaul Mackay
    Jan 26, 2006 at 10:06 am
    Jan 26, 2006 at 5:13 pm
  • Hi, We are running Postgresql 8.1, and getting dramatically inconsistant results after running VACUUM ANALYZE. Sometimes after analyzing the database, the query planner chooses a very efficient plan ...
    Daniel GishDaniel Gish
    Jan 24, 2006 at 11:19 pm
    Jan 25, 2006 at 4:47 pm
  • Hi All, I have seen it on occasion that the total runtime reported by explain analyze was much higher than the actual time the query needed to complete. The differences in my case ranged between ...
    Jozsef SzalayJozsef Szalay
    Jan 26, 2006 at 3:50 pm
    Jan 26, 2006 at 6:03 pm
  • I'm investigating a potential IO issue. We're running 7.4 on AIX 5.1. During periods of high activity (reads, writes, and vacuums), we are seeing iostat reporting 100% disk usage. I have a feeling ...
    Brad NicholsonBrad Nicholson
    Jan 24, 2006 at 4:35 pm
    Jan 24, 2006 at 9:00 pm
  • Hi all, I have a performance problem and I don't know where is my bottleneck. I have postgresql 7.4.2 running on a debian server with kernel 2.4.26-1-686-smp with two Xeon(TM) at 2.80GHz and 4GB of ...
    Arnau Rebassa VillalongaArnau Rebassa Villalonga
    Jan 24, 2006 at 6:40 pm
    Feb 2, 2006 at 12:14 pm
  • The following query took 17 seconds: select count(LogSN), min(LogSN), max(LogSN) from Log where create_time < '2005/10/19'; Figuring that getting the count will involve scanning the database, I took ...
    K C LauK C Lau
    Jan 20, 2006 at 4:39 am
    Jan 21, 2006 at 1:39 pm
  • Hi, I already read the documentation for to use the SPI_PREPARE and SPI_EXEC... but sincerely I don't understand how I will use this resource in my statements. I looked for examples, but I din't good ...
    MarcosMarcos
    Jan 17, 2006 at 11:09 am
    Jan 19, 2006 at 12:20 pm
  • Hi! I need to write a few pages about Postgresql, to convince some suits. They have a few millions of records, on a few site, but they want to know the practical limits of Postgresql. So i need some ...
    Tomka GergelyTomka Gergely
    Jan 14, 2006 at 12:13 pm
    Jan 17, 2006 at 8:36 pm
  • Hello! Has anyone got any tips for speeding up this query? It currently takes hours to start. PostgreSQL v8.x on (SuSe Linux) Thanks! no_people=# explain SELECT r.id AS r_id, r.firstname || ' ' || ...
    Bendik Rognlien JohansenBendik Rognlien Johansen
    Jan 11, 2006 at 10:59 am
    Jan 13, 2006 at 11:34 pm
  • Hi, I'm working on a project, whose implementation deals with PostgreSQL. A brief description of our application is given below. I'm running version 8.0 on a dedicated server 1Gb of RAM. my database ...
    Jamal GhaffourJamal Ghaffour
    Jan 12, 2006 at 12:32 am
    Jan 13, 2006 at 5:41 pm
  • Hello, We have a web-application running against a postgres 8.1 database, and basically, every time I run a report after no other reports have been run for several hours, the report will take ...
    Mark LibermanMark Liberman
    Jan 4, 2006 at 10:49 pm
    Jan 6, 2006 at 3:14 am
  • Hi everybody, I have the following problem, on a test server, if I do a fresh import of production data then run 'explain analyze select count(*) from mandats;' I get this result: Aggregate ...
    Emmanuel LacourEmmanuel Lacour
    Jan 30, 2006 at 10:57 pm
    Jan 31, 2006 at 1:55 am
  • Hi, I've got a set-returning function, defined as STABLE, that I reference twice within a single query, yet appears to be evaluated via two seperate function scans. I created a simple query that ...
    Mark LibermanMark Liberman
    Jan 12, 2006 at 12:41 am
    Jan 14, 2006 at 12:43 am
  • Hi , I am having problem optimizing this query, Postgres optimizer uses a plan which invloves seq-scan on a table. And when I choose a option to disable seq-scan it uses index-scan and obviously the ...
    Pallav KalvaPallav Kalva
    Jan 11, 2006 at 3:20 pm
    Jan 11, 2006 at 7:02 pm
  • Hi, I've been reading an interesting article which compared different database systems, focusing on materialized views. I was wondering how the postgresql developers feel about this feature ... is it ...
    Michael RiessMichael Riess
    Jan 16, 2006 at 2:36 pm
    Jan 16, 2006 at 4:27 pm
  • OIDs seem to be on their way out, and most of the time you can get a more helpful result by using a serial primary key anyway, but I wonder if there's any extension to INSERT to help identify what ...
    Michael StoneMichael Stone
    Jan 13, 2006 at 8:10 pm
    Jan 13, 2006 at 10:48 pm
  • Pg: 7.4.9 RH: ES v3 Quad-Xeon 16G ram The following SQL takes 4+ mins to run. I have indexes on all join fields and I've tried rearranging the table orders but haven't had any luck. I have done the ...
    Patrick HatcherPatrick Hatcher
    Jan 6, 2006 at 12:53 am
    Jan 6, 2006 at 8:24 pm
  • I have a table which stores cumulative values I would like to display/chart the deltas between successive data collections If my primary key only increments by 1, I could write a simple query select ...
    Virag SaksenaVirag Saksena
    Jan 4, 2006 at 4:12 am
    Feb 20, 2006 at 6:42 am
  • Can you delete me from the mail list Please?
    23864292386429
    Jan 31, 2006 at 4:24 pm
    Jan 31, 2006 at 7:23 pm
  • Hi folks, I'm not sure if this is the right place for this but thought I'd ask. I'm relateively new to postgres having only used it on 3 projects and am just delving into the setup and admin for the ...
    Pgsql-performancePgsql-performance
    Jan 22, 2006 at 7:53 am
    Jan 22, 2006 at 8:29 pm
  • Hi there, I am running a website where each page connects to the DB to retrieve and write information. Each page load uses a separate connection (rather than just sharing one as is the common case) ...
    James RussellJames Russell
    Jan 20, 2006 at 9:14 am
    Jan 20, 2006 at 3:14 pm
  • Hi, I have a postges 8.1.1 table with over 29 million rows in it. The colunm (file_name) that I need to search on has entries like the following: MOD04_L2.A2005311.1400.004.2005312013848.hdf ...
    Yantao ShiYantao Shi
    Jan 17, 2006 at 8:14 pm
    Jan 18, 2006 at 3:06 pm
  • I have been working on optimizing a PostgreSQL server for weekly updates where data is only updated once a week then for the remaining portion of the week the data is static. So far I have set fsync ...
    Benjamin AraiBenjamin Arai
    Jan 14, 2006 at 6:13 pm
    Jan 17, 2006 at 8:40 pm
  • Hello what is the best for a char field with less than 1000 characters? a text field or a varchar(1000) thanks
    TNOTNO
    Jan 9, 2006 at 10:58 am
    Jan 9, 2006 at 11:50 pm
  • We recently segmented a large table into calendar month slices and were going to to replace the original, but we are not getting the results we think it should... Everything is vacuumed, and we are ...
    Jen SaleJen Sale
    Jan 25, 2006 at 4:09 pm
    Jan 30, 2006 at 3:50 am
  • With big thanks to Josh Berkus and Devrim Gunduz, I'm happy to announce that Sun has just released a Solaris distribution of PostgreSQL 8.1.2 with ready-to-install packages for both Sparc and x86. ...
    Robert LorRobert Lor
    Jan 26, 2006 at 1:46 am
    Jan 26, 2006 at 2:56 pm
  • Hi, Thanks for your response. The actual query is below; the joins are only 4 deep. Adjusting the stats target did help, but not dramatically. EFFICIENT PLAN: # explain analyze SELECT ev.eid FROM ...
    Daniel GishDaniel Gish
    Jan 25, 2006 at 1:02 am
    Jan 25, 2006 at 9:05 am
  • Hello, Our application uses typical queries similar to following (very simplified): SELECT part_id, part_name, (SELECT SUM(amount) FROM part_movements M WHERE P.part_id = M.part_id ) as part_amount ...
    Ümit ÖztosunÜmit Öztosun
    Jan 21, 2006 at 8:55 pm
    Jan 23, 2006 at 7:19 pm
  • Greetings - I am really love Postgres and do enjoy hacking around it but I just met a libpq performance issue that I would like to get your help with. I have Postgres 8.0.1 running on Linux version ...
    Constantine FilinConstantine Filin
    Jan 21, 2006 at 11:49 pm
    Jan 22, 2006 at 12:40 am
  • Hello; I am going through a post mortem analysis of an infrequent but recurring problem on a Pg 8.0.3 installation. Application code connects to Pg using J2EE pooled connections. PostgreSQL 8.0.3 on ...
    Jerry SieversJerry Sievers
    Jan 20, 2006 at 9:57 pm
    Jan 20, 2006 at 10:14 pm
  • Hi, I have a query that does a left outer join. The query gets some text from a reference table where one of the query's main tables may or may not have the text's tables id. It wasn't super fast, ...
    AntoineAntoine
    Jan 20, 2006 at 6:32 pm
    Jan 20, 2006 at 7:04 pm
  • Hi, I am trying to perform the following type of query 'select patientname ... from patient were patientname LIKE 'JONES%, %' order by patientname asc limit 100'. There about 1.4 million rows in the ...
    Tim JonesTim Jones
    Jan 19, 2006 at 10:20 pm
    Jan 19, 2006 at 10:27 pm
Group Navigation
period‹ prev | Jan 2006 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions66
posts500
users120
websitepostgresql.org
irc#postgresql

120 users for January 2006

Tom Lane: 63 posts Jim C. Nasby: 36 posts Luke Lonergan: 15 posts Alessandro Baretta: 14 posts Ron: 12 posts Michael Fuhr: 11 posts Steinar H. Gunderson: 11 posts Andrew Sullivan: 10 posts Michael Riess: 10 posts J: 9 posts Andrea Arcangeli: 9 posts Chris Browne: 9 posts Markus Schaber: 9 posts Martijn van Oosterhout: 8 posts Michael Stone: 8 posts Marcos: 7 posts Scott Marlowe: 7 posts Steve Eckmann: 7 posts Bruce Momjian: 6 posts Craig A. James: 6 posts
show more
Archives