FAQ

Search Discussions

52 discussions - 350 posts

  • I couldn't find anything in the docs or in the mailing list on this, but it is something that Oracle appears to do as does MySQL. The idea, I believe, is to do a quick (hash) string lookup of the ...
    Scott KirkwoodScott Kirkwood
    Sep 22, 2004 at 7:51 pm
    Dec 24, 2004 at 2:19 am
  • Hi all, I had a difficult time deciding which list to post this to, so please forgive me if this list doesn't perfectly match my questions. My decision will not solely be based on performance, but it ...
    Mark CotnerMark Cotner
    Sep 12, 2004 at 4:24 am
    Sep 17, 2004 at 7:24 am
  • Does postgres cache the entire result set before it begins returning data to the client? I have a table with ~8 million rows and I am executing a query which should return about ~800,000 rows. The ...
    Stephen CrowleyStephen Crowley
    Sep 14, 2004 at 12:51 am
    Sep 23, 2004 at 11:48 pm
  • Ricardo, Hello. I've moved your query to a more appropriate mailing list; on PERFORMANCE we discuss RAID all the time. If you don't mind wading through a host of opinions, you'll get plenty here. ...
    Josh BerkusJosh Berkus
    Sep 16, 2004 at 5:49 pm
    Sep 16, 2004 at 11:00 pm
  • I'm working on a dating/personals/match-making site, that has used many different methods of "match-making", that all seem to be very slow. One I am attempting now that seems to be an efficient ...
    Patrick CleryPatrick Clery
    Sep 16, 2004 at 8:00 am
    Oct 6, 2004 at 7:39 pm
  • Hi all, I'm having performance degradation with a view upgrading from 7.3 to 7.4, the view is a not so complex, one of his field is the result from a function. If I remove the function ( or I use a ...
    Gaetano MendolaGaetano Mendola
    Sep 21, 2004 at 10:52 pm
    Sep 23, 2004 at 2:44 pm
  • Help? Normally, this query takes from 5 minutes to 2 hours to run. On this update, it's been running for more than 10 hours. Can it be helped? UPDATE obs_v SET mag = obs_v.imag + zp.zero_v + ...
    Robert CreagerRobert Creager
    Sep 28, 2004 at 2:20 pm
    Sep 29, 2004 at 1:33 pm
  • Hi, I'd like to help with the topic in the Subject: line. It seems to be a TODO item. I've reviewed some threads discussing the matter, so I hope I've acquired enough history concerning it. I've ...
    MudfootMudfoot
    Sep 13, 2004 at 6:11 am
    Sep 14, 2004 at 6:19 pm
  • Ok, you were right. I made some tests and NTFS is just not very good in the general case. I've seen some benchmarks for Reiser4 that are just amazing. Merlin
    Merlin MoncureMerlin Moncure
    Sep 4, 2004 at 3:57 am
    Sep 9, 2004 at 5:13 pm
  • A recent comment on this (or perhaps another?) mailing list about Sun boxen and the directio mount option has prompted me to read about O_DIRECT on the open() manpage. Has anybody tried this option? ...
    Guy ThornleyGuy Thornley
    Sep 20, 2004 at 7:57 am
    Sep 30, 2004 at 4:33 pm
  • Hi all, don't you think the best statistic target for a boolean column is something like 2? Or in general the is useless have a statistics target data type cardinality ? Regards Gaetano Mendola
    Gaetano MendolaGaetano Mendola
    Sep 27, 2004 at 6:15 pm
    Sep 28, 2004 at 12:45 am
  • Hello, Today, we stumbled about the following query plan on PostGreSQL 7.4.1: logigis=# explain select count(id) from (select distinct id from (select distinct ref_in_id as id from streets union ...
    Markus SchaberMarkus Schaber
    Sep 2, 2004 at 1:43 pm
    Sep 10, 2004 at 1:22 pm
  • OK, I have a situation that might be a performance problem, a bug, or an unavoidable consequence of using prepared statements. The short version is that I am getting function executions for rows not ...
    Merlin MoncureMerlin Moncure
    Sep 30, 2004 at 1:45 pm
    Sep 30, 2004 at 3:02 pm
  • Hi All, I am having a performance problem extracting a large volume of data from Postgres 7.4.2, and was wondering if there was a more cunning way to get the data out of the DB... This isn't a ...
    Damien DouganDamien Dougan
    Sep 13, 2004 at 11:38 am
    Sep 13, 2004 at 1:59 pm
  • Dear all, I am currently experiencing troubles with the performance of my critical's database. The problem is the time that the postgres takes to perform/return a query. For example, trying the \d ...
    G u i d o B a r o s i oG u i d o B a r o s i o
    Sep 1, 2004 at 10:06 am
    Sep 1, 2004 at 3:07 pm
  • Hello. Couple of questions: - Q1: Today I decided to do a vacuum full verbose analyze on a large table that has been giving me slow performance. And then I did it again. I noticed that after each run ...
    Patrick HatcherPatrick Hatcher
    Sep 21, 2004 at 3:59 am
    Sep 23, 2004 at 4:45 pm
  • Our product (Sophos PureMessage) runs on a Postgres database. Some of our Solaris customers have Oracle licenses, and they've commented on the performance difference between Oracle and Postgresql on ...
    Mischa SandbergMischa Sandberg
    Sep 17, 2004 at 7:37 pm
    Sep 19, 2004 at 10:04 am
  • Hi. I hope I'm not asking a too trivial question here... I'm having trouble with a (quite big) query, and can't find a way to make it faster. Here is the information : Tables : ...
    Marc CousinMarc Cousin
    Sep 8, 2004 at 1:50 pm
    Sep 8, 2004 at 3:17 pm
  • Sometimes when you click on a link on my site to access my postgres database it takes forever for it to connect. You can click this link and see how long it takes. ...
    Scott DunnScott Dunn
    Sep 30, 2004 at 2:46 pm
    Sep 30, 2004 at 8:17 pm
  • Well, I think I tracked the problem down to the fact that the column does not have a "not null" constraint on it. Here is a demonstration. Basically, I have 3 tables, tobjects, tdata, and tproject. ...
    John MeinelJohn Meinel
    Sep 29, 2004 at 7:13 am
    Sep 29, 2004 at 5:09 pm
  • #postgresql on Freenode recommended I post this here. I'm seeing some odd behaviour with LIMIT. The query plans are included here, as are the applicable table and index definitions. All table, index, ...
    Joey SmithJoey Smith
    Sep 10, 2004 at 9:02 pm
    Sep 10, 2004 at 10:10 pm
  • Hello, I'll be moving a DB from internal RAID-10 SCSI storage to an EMC CX300 FC RAID-10 LUN, bound to the host. I've setup a test host machine and a test LUN. The /var/lib/pgsql/data folder is ...
    Anjan DaveAnjan Dave
    Sep 22, 2004 at 9:49 pm
    Sep 26, 2004 at 8:37 pm
  • Folks, I'm beginning a series of tests on OSDL's Scalable Test Platform in order to determine some recommended settings for many of the new PostgreSQL.conf parameters as well as pg_autovacuum. Is ...
    Josh BerkusJosh Berkus
    Sep 28, 2004 at 5:52 pm
    Sep 29, 2004 at 10:16 pm
  • My database was converted from MySQL a while back and has maintained all of the indexes which were previously used. Tt the time however, there were limitations on the way PostgreSQL handled the ...
    Martin FosterMartin Foster
    Sep 23, 2004 at 10:45 pm
    Sep 26, 2004 at 1:28 am
  • Hi, I'm using PostgreSQL 7.4 on a table with ~700.000 rows looking like this: Table "public.enkeltsalg" Column | Type | Modifiers ...
    Steinar H. GundersonSteinar H. Gunderson
    Sep 18, 2004 at 5:01 pm
    Sep 18, 2004 at 8:03 pm
  • Sorry for crossposting, didn't know where to post. Any hint/help on this?! db_postgres1=# truncate ref_v2_drs_valid_product ; ERROR: expected both swapped tables to have TOAST tables I need to ...
    G u i d o B a r o s i oG u i d o B a r o s i o
    Sep 7, 2004 at 10:41 am
    Sep 7, 2004 at 2:16 pm
  • Hi , I am sorry that my question is out of line with this group(performance) but I need an urgent help :-( .pls .. I need to know how to change the length of the column. Thanks and hoping that u will ...
    Michael Ryan S. PunciaMichael Ryan S. Puncia
    Sep 1, 2004 at 6:46 am
    Sep 1, 2004 at 4:33 pm
  • Hi all, a small question: I've got this table "songs" and an index on column artist. Since there's about one distinct artist for every 10 rows, it would be nice if it could use this index when ...
    ShiarShiar
    Sep 29, 2004 at 7:41 pm
    Oct 3, 2004 at 3:27 pm
  • Hi, We have been running PostgreSQL 7.3.4 on 64 bit MAC OS X G5 dual processors with 8GB of RAM for a while. Lately, we realized that consistently only about 4GB of RAM is used even when CPUs have ...
    Qing ZhaoQing Zhao
    Sep 24, 2004 at 7:23 pm
    Sep 27, 2004 at 12:15 am
  • Hi all, I searched list archives, but did not found anything about HT of Pentium 4/Xeon processors. I wonder if hyperthreading can boost or decrease performance. AFAIK for other commercial servers ...
    Mariusz CzuładaMariusz Czułada
    Sep 21, 2004 at 8:54 am
    Sep 23, 2004 at 7:02 pm
  • I just realized in my haste to send this email out I provided the wrong table in my example. Below is the same email, but with vsa.dtbl_logged_event_20040922 substituted for vsa.tbl_sad_event. Sorry ...
    Steven RosensteinSteven Rosenstein
    Sep 22, 2004 at 8:33 pm
    Sep 22, 2004 at 10:03 pm
  • Why would postgres use a different query plan for declared cursors than without? I have a relatively simple query that takes about 150ms using explain analyze. However, when I wrap the same query in ...
    Kevin NeufeldKevin Neufeld
    Sep 16, 2004 at 6:10 am
    Sep 16, 2004 at 6:07 pm
  • Hi i have four sample tables ename, esal, edoj and esum All of them have 1000000 records. Im running the following query : select ename.eid, name, sal, doj, summary from ename,esal,edoj,esum where ...
    Vijay MosesVijay Moses
    Sep 13, 2004 at 4:30 am
    Sep 14, 2004 at 4:58 am
  • Hi, I have downloaded the new postgresql (version 8.0 beta2) and I was wondering what performance features I can take advantage of before I start to dump my 3/4 terrabyte database into the new ...
    BillBill
    Sep 13, 2004 at 1:35 am
    Sep 14, 2004 at 4:52 am
  • Here's the query: --------------------------------------------------------------------------- SELECT * FROM bv_reviews r, bv_votes v WHERE r.vote_id = v.vote_id AND v.book_id = 113 ...
    Vitaly BelmanVitaly Belman
    Sep 11, 2004 at 12:45 pm
    Sep 11, 2004 at 3:28 pm
  • I have a problem where I have the table format listed below. I have the primary key tsyslog_id and the index built against it. However, when I select a unique row, it will only ever do a seq scan ...
    Jeremy M. GuthrieJeremy M. Guthrie
    Sep 8, 2004 at 12:49 am
    Sep 11, 2004 at 6:07 am
  • Hello, I saw a few mentions of 'effective_cache_size' parameter. Is this a new PG 7.4 option? I have PG 7.3.4 and didn't see that parameter in my postgresql.conf. Thanks, Otis
    Ogjunk-pgjedanOgjunk-pgjedan
    Sep 10, 2004 at 10:00 pm
    Sep 10, 2004 at 10:03 pm
  • Hello, I'm tuning my PostgreSQL DB (7.3.4) and have come across a query that doesn't use an index I created specially for it, and consequently takes circa 2 seconds to run. :( The ugly query looks ...
    Ogjunk-pgjedanOgjunk-pgjedan
    Sep 9, 2004 at 10:51 pm
    Sep 10, 2004 at 4:17 am
  • I have been experimenting with the 'IPC::Shareable' module under the native implementation of Perl 5 for OpenBSD 3.5. While it is not loaded by default it is a pure pure implementation. I have tested ...
    Martin FosterMartin Foster
    Sep 6, 2004 at 1:34 am
    Sep 6, 2004 at 2:18 am
  • Greetings, I have observed that in a dump/restore scenario the longest time is spent on index creation for larger tables, I have a suggestion of how the performance could be improved thus reducing ...
    Adi AlurkarAdi Alurkar
    Sep 5, 2004 at 4:07 am
    Sep 5, 2004 at 5:07 pm
  • Dear Gurus, Here is this strange query that can't find the optimum plan unless I disable some scan modes or change the costs. (A) is a 2x2.4GHz server with hw raid5 and v7.3.4 database. It chooses ...
    Szűcs GáborSzűcs Gábor
    Sep 29, 2004 at 5:44 pm
    Sep 29, 2004 at 5:44 pm
  • Hi, I have a query where I do not understand that the rows number that explain analyze finds differs so much from what explain estimates (3rd nested loop estimates 1 row but in real it is 4222 rows). ...
    Dirk LutzebäckDirk Lutzebäck
    Sep 29, 2004 at 3:56 pm
    Sep 29, 2004 at 3:56 pm
  • I finished the write-up I mentioned a few weeks ago. Feedback is welcome. Thanks to everyone on this list and especially to all the folks in IRC who helped me get up to speed on PostgreSQL in a very ...
    Mark CotnerMark Cotner
    Sep 27, 2004 at 8:50 am
    Sep 27, 2004 at 8:50 am
  • unsubscribe
    Amol BhutadaAmol Bhutada
    Sep 27, 2004 at 5:15 am
    Sep 27, 2004 at 5:15 am
  • I set nested_loop = off, which is why I have the high cost. @ is a postgis operator between 2 geomotries (both polygons). It's the @ operator which is expensive. Is there a way to force a cheaper way ...
    Rod TaylorRod Taylor
    Sep 25, 2004 at 12:57 am
    Sep 25, 2004 at 12:57 am
  • Gentlefolk, I'm not sure if this is the proper forum for this question, and it might have been answered in a previous thread, but I'm new to PostgreSQL and the research I did in the archives did not ...
    Steven RosensteinSteven Rosenstein
    Sep 22, 2004 at 8:09 pm
    Sep 22, 2004 at 8:09 pm
  • What motherboard are you using, and what distro? Earlier you mentioned that you're on linux 2.6.7 and a 64-bit Opteron 244 machine with 8GB main memory, two 4-disk RAID5 arrays (one for database, one ...
    Ron St-PierreRon St-Pierre
    Sep 15, 2004 at 5:54 pm
    Sep 15, 2004 at 5:54 pm
  • ... It is kinda windy for the list, but the point is that a big part of performance is developer expectation and user expectation. I'd hope to lower expectations before we see an article in eWeek. ...
    Aaron wermanAaron werman
    Sep 14, 2004 at 7:32 pm
    Sep 14, 2004 at 7:32 pm
  • Hi, I have downloaded the new postgresql (version 8.0 beta2) and I was wondering what performance features I can take advantage of before I start to dump my 3/4 terrabyte database into the new ...
    Bill FeffermanBill Fefferman
    Sep 13, 2004 at 4:54 pm
    Sep 13, 2004 at 4:54 pm
  • Well, it depends upon lot of factors. There are few questions to be asked here.. - What is your hardware and OS configuration? - What type of data you are dealing with? Mostly static or frequently ...
    Shridhar DaithankarShridhar Daithankar
    Sep 9, 2004 at 1:39 pm
    Sep 9, 2004 at 1:39 pm
Group Navigation
period‹ prev | Sep 2004 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions52
posts350
users106
websitepostgresql.org
irc#postgresql

106 users for September 2004

Tom Lane: 39 posts Gaetano Mendola: 21 posts Josh Berkus: 17 posts Greg Stark: 13 posts Pierre-Frédéric Caillaud: 13 posts Markus Schaber: 8 posts Chris Browne: 7 posts Joe Conway: 7 posts Simon Riggs: 7 posts G u i d o B a r o s i o: 6 posts Jason Coene: 6 posts Jim C. Nasby: 6 posts Matt Clark: 6 posts Mischa Sandberg: 6 posts Stephen Crowley: 6 posts Aaron Werman: 5 posts Bruce Momjian: 5 posts Dennis Bjorklund: 5 posts Iain: 5 posts Merlin Moncure: 5 posts
show more
Archives