FAQ

PostgreSQL > pgsql-performance > February 2006

Search Discussions

68 discussions - 459 posts

  • Platform: FreeBSD 6.0, Postgresql 8.1.2 compiled from the ports collection. Not sure if this belongs in performance or bugs.. A pg_restore of my 2.5GB database was taking up to 2 hours to complete ...
    Gary DoadesGary Doades
    Feb 15, 2006 at 8:02 pm
    Mar 22, 2006 at 12:25 pm
  • Good morning, I try to understand how optimizer uses HashAggregate instead of GroupAggregate and I want to know what is exactly this two functionnality (benefits /inconvenients) In my case, I've this ...
    Martial BizelMartial Bizel
    Feb 15, 2006 at 3:56 pm
    Feb 25, 2006 at 3:50 pm
  • As I recall, the idea behind vacuum_threshold was to prevent too-frequent vacuuming of small tables. I'm beginning to question this reasoning: Small tables vacuum very, very quickly, so 'extra' ...
    Jim C. NasbyJim C. Nasby
    Feb 1, 2006 at 9:16 pm
    Feb 9, 2006 at 12:21 am
  • I am running some simple queries to benchmark Postgres 8.1 against MS Access and Postgres is 2 to 3 times slower that Access. Hardware: Dell Optiplex GX280 P4 3.20 GHz 3GB RAM Windows XP SP1 Database ...
    Jay GreenfieldJay Greenfield
    Feb 14, 2006 at 3:51 pm
    Feb 16, 2006 at 1:32 pm
  • So I'm trying to figure out how to optimize my PG install (8.0.3) to get better performance without dropping one of my indexes. Basically, I have a table of 5M records with 3 columns: pri_key ...
    Aaron TurnerAaron Turner
    Feb 10, 2006 at 8:16 am
    Feb 14, 2006 at 11:14 pm
  • Hi all, My database has an SQL function. The result comes in 30-40 seconds when i use the SQL function. On the other hand; The result comes 300-400 milliseconds when i run the SQL statement. Any idea ...
    Adnan DURSUNAdnan DURSUN
    Feb 12, 2006 at 8:25 pm
    Feb 14, 2006 at 10:36 pm
  • I am trying to join two tables and keep getting a sequential scan in the plan even though there is an index on the columns I am joining on. Basically this the deal ... I have two tables with docid in ...
    Tim JonesTim Jones
    Feb 10, 2006 at 10:06 pm
    Feb 13, 2006 at 4:22 pm
  • hi, i load data from files using copy method. Files contain between 2 and 7 millions of rows, spread on 5 tables. For loading all the data, it takes 40mn, and the same processing takes 17mn with ...
    FERREIRA, William (VALTECH)FERREIRA, William (VALTECH)
    Feb 14, 2006 at 9:47 am
    Feb 15, 2006 at 3:18 pm
  • Hello, I've error "out of memory" with these traces : TopMemoryContext: 32768 total in 3 blocks; 5152 free (1 chunks); 27616 used TopTransactionContext: 8192 total in 1 blocks; 8136 free (0 chunks); ...
    Martial BizelMartial Bizel
    Feb 14, 2006 at 3:25 pm
    Feb 15, 2006 at 4:45 pm
  • Just a "wouldn't it be nice if" sort of feature request. I'm not sure how practical it is. Someone in our organization wrote a data fix query, which has sort of odd logic, but it does what they need. ...
    Kevin GrittnerKevin Grittner
    Feb 28, 2006 at 3:44 pm
    Feb 28, 2006 at 9:15 pm
  • I am issing a query like this: SELECT * FROM users users LEFT JOIN phorum_users_base ON users.uid = phorum_users_base.user_id LEFT JOIN useraux ON useraux.uid = users.uid; The joins are all on the ...
    Ryan grothRyan groth
    Feb 22, 2006 at 5:27 pm
    Feb 23, 2006 at 10:21 am
  • Hi all Is it secure to disable fsync havin battery-backed disk cache? Thx Javier Somoza Oficina de Dirección Estratégica mailto:[email protected] Panda Software Buenos Aires, 12 48001 BILBAO - ...
    Javier SomozaJavier Somoza
    Feb 27, 2006 at 10:03 am
    Feb 28, 2006 at 9:09 pm
  • Hello All, I've inherited a postgresql database that I would like to refactor. It was origionally designed for Postgres 7.0 on a PIII 500Mhz and some design decisions were made that don't make sense ...
    Orion HenryOrion Henry
    Feb 9, 2006 at 7:07 pm
    Feb 22, 2006 at 10:07 pm
  • I am concerned with performance issues involving the storage of DV on a database. I though of some options, which would be the most advised for speed? 1) Pack N frames inside a "container" and store ...
    Rodrigo MaderaRodrigo Madera
    Feb 1, 2006 at 12:32 am
    Feb 11, 2006 at 8:32 pm
  • We're converting from a commercial database product to PostgreSQL, and generally things are going well. While the licensing agreement with the commercial vendor prohibits publication of benchmarks ...
    Kevin GrittnerKevin Grittner
    Feb 1, 2006 at 6:33 pm
    Feb 2, 2006 at 4:58 pm
  • hi, i have btree index on a text type field. i want see rows which starts with certain characters on that field. so i write a query like this: SELECT * FROM mytable WHERE myfield LIKE 'john%' since ...
    Ibrahim TekinIbrahim Tekin
    Feb 21, 2006 at 3:57 pm
    Feb 23, 2006 at 12:52 pm
  • Hello We are running an application via web that use a lot of time to perform some operations. We are trying to find out if some of the sql statements used are the reason of the slow speed. We have ...
    Rafael Martinez GuerreroRafael Martinez Guerrero
    Feb 9, 2006 at 3:10 pm
    Feb 10, 2006 at 6:05 am
  • Good morning, I've increased sort_mem until 2Go !! and the error "out of memory" appears again. Here the request I try to pass with her explain plan, Nested Loop (cost=2451676.23..2454714.73 ...
    Martial BizelMartial Bizel
    Feb 15, 2006 at 3:55 pm
    Feb 17, 2006 at 3:18 pm
  • Hi everybody! Which wal sync method is the fastest under linux 2.6.x? I'm using RAID-10 (JFS filesystem), 2xXEON, 4 Gb RAM. I've tried to switch to open_sync which seems to work faster than default ...
    Evgeny GridasovEvgeny Gridasov
    Feb 27, 2006 at 12:08 pm
    Mar 1, 2006 at 11:58 am
  • I hesitate to raise this issue again, but I've noticed something which I thought might be worth mentioning. I've never thought the performance of count(*) on a table was a significant issue, but I'm ...
    Kevin GrittnerKevin Grittner
    Feb 22, 2006 at 4:57 pm
    Feb 23, 2006 at 8:45 pm
  • I have some quite huge queries, inside functions, so debugging is kind of hard. But I have located the query that for some reason gets 4 times as slow after an analyze. Before analyze the plan for ...
    Fredrik OlssonFredrik Olsson
    Feb 18, 2006 at 4:04 pm
    Feb 20, 2006 at 3:01 pm
  • Hi Guys, Apologies if this is a novice queston, but I think it is a performance one nevertheless. We are running a prototype of a system running on PHP/Postgresql on an Intel Xeon 2ghz server, 1GB ...
    James DeyJames Dey
    Feb 10, 2006 at 8:22 am
    Feb 10, 2006 at 8:13 pm
  • Hi, I have 2 tables both have an index on ID (both ID columns are an oid). I want to find only only rows in one and not the other. Select ID from TableA where ID not IN ( Select ID from Table B) This ...
    Ralph MasonRalph Mason
    Feb 1, 2006 at 8:18 pm
    Feb 1, 2006 at 10:13 pm
  • Hi there, I'm running a simple query with 2 inner joins (say A, B and C). Each of the join columns has indexes. If I run queries that join just A and B, or just B and C, postgres uses indexes. But if ...
    James RussellJames Russell
    Feb 1, 2006 at 3:14 am
    Feb 1, 2006 at 5:08 am
  • I have run pg_dump and had no errors. I also got this error when creating one index but not another. When I lowered my maintenance_work_mem, the create index succeeded. Regards, ---- Husam ...
    Tomeh, HusamTomeh, Husam
    Feb 14, 2006 at 10:01 pm
    Feb 23, 2006 at 7:57 pm
  • I assume we have such? Ron
    RonRon
    Feb 17, 2006 at 4:51 pm
    Feb 20, 2006 at 4:47 am
  • I have a table that has only a few records in it at the time, and they get deleted every few seconds and new records are inserted. Table never has more than 5-10 records in it. However, I noticed a ...
    NikNik
    Feb 27, 2006 at 2:48 pm
    Mar 1, 2006 at 6:45 am
  • Hi, I'm developing a search engine using the postgresql's databas. I've already doing some tunnings looking increase the perform. Now, I'd like of do a realistic test of perfom with number X of ...
    MarcosMarcos
    Feb 20, 2006 at 12:57 pm
    Feb 24, 2006 at 8:06 pm
  • Select and update statements are quite slow on a large table with more than 600,000 rows. The table consists of 11 columns (nothing special). The column "id" (int8) is primary key and has a btree ...
    Kjeld PetersKjeld Peters
    Feb 23, 2006 at 12:35 pm
    Feb 23, 2006 at 2:09 pm
  • Hello! This is Chethana. I need to know how to improve the performance of postgresql. It is rich in features but slow in performance. Pls do reply back ASAP. Thank you, Chethana.
    Chethana, Rao (IE10)Chethana, Rao (IE10)
    Feb 22, 2006 at 10:39 am
    Feb 22, 2006 at 4:32 pm
  • Hi, I have query where I do two inline queries (which involves grouping) and then join them with an outer join. The individual queries run in 50-300 ms. However the optimizer is choosing a nested ...
    Virag SaksenaVirag Saksena
    Feb 21, 2006 at 5:13 am
    Feb 21, 2006 at 6:34 am
  • Hi List, I would like some insight from the experts here as to how I can alter which index PostgreSQL is choosing to run a query. First off, I'm running an active web forum (phpBB) with sometimes ...
    Adam AlkinsAdam Alkins
    Feb 16, 2006 at 5:03 pm
    Feb 18, 2006 at 7:39 am
  • hi, i have a database storing XML documents. The main table contains the nodes of the document, the other tables contain data for each node (depending on the node's type : ELE, Text, PI, ...) My test ...
    FERREIRA, William (VALTECH)FERREIRA, William (VALTECH)
    Feb 1, 2006 at 10:15 am
    Feb 6, 2006 at 8:21 pm
  • Hi list I'm fairly new to Postgres so bear with me. Googling and searching the list, I didn't find anything that resembled my problem. I have a large table with ca. 10 million inserts per day (fairly ...
    JcfischerJcfischer
    Feb 24, 2006 at 2:13 pm
    Mar 1, 2006 at 7:54 am
  • Hi All, I ' m using the postgresql datbase to stores cookies. Theses cookies become invalid after 30 mn and have to be deleted. i have defined a procedure that will delete all invalid cookies, but i ...
    Jamal GhaffourJamal Ghaffour
    Feb 27, 2006 at 5:06 pm
    Feb 27, 2006 at 6:04 pm
  • Hi all, Short story: I have a quite big table (about 200 million records, and ~2-3 million updates/~1 million inserts/few thousand deletes per day). I started a vacuum on it on friday evening, and it ...
    Csaba NagyCsaba Nagy
    Feb 27, 2006 at 1:31 pm
    Feb 27, 2006 at 3:03 pm
  • Hi, We're executing a query that has the following plan and we're wondering given the size of the data set, what's a better way to write the query? It's been running since 2pm 2 days ago. explain ...
    Brendan DuddridgeBrendan Duddridge
    Feb 24, 2006 at 6:54 am
    Feb 24, 2006 at 7:24 am
  • Where "*" == {print | save to PDF | save to <mumble format | display on screen} Anyone know of one? TiA Ron
    Ron PeacetreeRon Peacetree
    Feb 23, 2006 at 4:38 pm
    Feb 23, 2006 at 5:06 pm
  • I am running 7.4.8 and have a query that I have been running for a while that has recently have experienced a slowdown. The original query involves a UNION but I have narrowed it down to this half of ...
    George WoodringGeorge Woodring
    Feb 21, 2006 at 8:12 pm
    Feb 22, 2006 at 3:04 pm
  • HI ALL, I have query for a report. Explain analyze result is below. The execution plan tells that it would use "t_koltuk_islem_pkey" index on table "t_koltuk_islem" to scan. However, there is another ...
    Adnan DURSUNAdnan DURSUN
    Feb 16, 2006 at 5:01 pm
    Feb 16, 2006 at 10:16 pm
  • Hi, I have an unique requirement. I have a feed of 2.5 - 3 million rows of data which arrives every 1/2 an hour. Each row has 2 small string values (about 50 chars each) and 10 int values. I need ...
    David drummardDavid drummard
    Feb 10, 2006 at 8:20 pm
    Feb 13, 2006 at 11:49 am
  • Hi, I'm fairly new to PostgreSQL. I was trying pgbench , but could not understand the output . Can anyone help me out to understand the output of pgbench ----Pradeep
    Pradeep ParmarPradeep Parmar
    Feb 2, 2006 at 7:10 am
    Feb 10, 2006 at 3:40 pm
  • Postgres doesn't seem to optimize away unnecessary joins in a view definition when the view is queried in such a way that the join need not be executed. In the example below, I define two tables, foo ...
    Jacob CostelloJacob Costello
    Feb 8, 2006 at 1:54 pm
    Feb 8, 2006 at 3:46 pm
  • I am using triggers for all the events (insert,delete,update) please find the details below. trg_delpointtable BEFORE DELETE ON pointtable FOR EACH ROW EXECUTE PROCEDURE pp_delpointtable() ...
    Jeevanandam, Kathirvel (IE10)Jeevanandam, Kathirvel (IE10)
    Feb 28, 2006 at 5:54 am
    Mar 1, 2006 at 6:48 pm
  • Hi all I've a question about vacuuming, ... Vacuum: cleans out obsolete and deleted registers... Analyze: update statistics for the planner Reindex: rebuild indexes I think the correct order to ...
    Javier SomozaJavier Somoza
    Feb 28, 2006 at 12:10 pm
    Feb 28, 2006 at 1:38 pm
  • Hi, How should i set this configuration? Depending on the memory? And then is it necessary to perform a benchmarking test? What did you do? Thx! Javier Somoza Oficina de Dirección Estratégica ...
    Javier SomozaJavier Somoza
    Feb 27, 2006 at 12:42 pm
    Feb 27, 2006 at 1:17 pm
  • Hello all, I have this small set of questions that i have been looking to ask and here it comes. Lets imagin we have a setup where we have multiple databases instances on one server, and we are ...
    Eric LauzonEric Lauzon
    Feb 24, 2006 at 8:03 pm
    Feb 25, 2006 at 4:03 pm
  • What's more interesting is this: When I first connect to the database via "psql" and issue the "create index" statement, of course, I get the "out of memory" error. If I don't quit my current session ...
    Tomeh, HusamTomeh, Husam
    Feb 23, 2006 at 10:42 pm
    Feb 23, 2006 at 10:47 pm
  • 1

    Re:

    If there were a simple formula for doing it, it would already have been written up as a program that runs once you install postgres. You have to monitor your usage, use your understanding of your ...
    Vivek KheraVivek Khera
    Feb 23, 2006 at 2:38 pm
    Feb 23, 2006 at 8:28 pm
  • I am running a query that joins against several large tables (~5 million rows each). The query takes an exteremely long time to run, and the explain output is a bit beyond my level of understanding. ...
    Jeremy HaileJeremy Haile
    Feb 22, 2006 at 7:16 pm
    Feb 23, 2006 at 5:25 pm
Feb 2006
12
Group Navigation
period‹ prev | Feb 2006 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions68
posts459
users113
websitepostgresql.org
irc#postgresql

113 users for February 2006

Tom Lane: 54 posts Jim C. Nasby: 23 posts Ron Peacetree: 22 posts Scott Marlowe: 21 posts Markus Schaber: 19 posts Kevin Grittner: 12 posts Martial Bizel: 11 posts Luke Lonergan: 11 posts Adnan DURSUN: 9 posts PFC: 9 posts FERREIRA, William (VALTECH): 8 posts Gary Doades: 8 posts Steinar H. Gunderson: 8 posts Aaron Turner: 7 posts Chris Browne: 7 posts Javier Somoza: 7 posts Richard Huxton: 7 posts Vivek Khera: 7 posts Christopher Kings-Lynne: 6 posts Craig A. James: 6 posts
show more
Archives