FAQ

PostgreSQL > pgsql-performance > November 2003

Search Discussions

47 discussions - 298 posts

  • Folks, We're seeing some odd issues with hyperthreading-capable Xeons, whether or not hyperthreading is enabled. Basically, when a small number of really-heavy duty queries hit the system and push ...
    Josh BerkusJosh Berkus
    Nov 25, 2003 at 10:30 pm
    May 20, 2004 at 10:15 pm
  • Shridhar, I was looking at the -V/-v and -A/-a settings in pgavd, and really don't understand how the calculation works. According to the readme, if I set -v to 1000 and -V to 2 (the defaults) for a ...
    Josh BerkusJosh Berkus
    Nov 19, 2003 at 12:01 am
    Nov 25, 2003 at 4:21 am
  • My situation is this. We have a semi-production server where we pre-process data and then upload the finished data to our production servers. We need the fastest possible write performance. Having ...
    William YuWilliam Yu
    Nov 24, 2003 at 3:51 am
    Nov 26, 2003 at 6:54 pm
  • Table structure is simple: CREATE TABLE traffic_logs ( company_id bigint, ip_id bigint, port integer, bytes bigint, runtime timestamp without time zone ); runtime is 'day of month' ... I need to ...
    Marc G. FournierMarc G. Fournier
    Nov 10, 2003 at 8:21 pm
    Nov 12, 2003 at 4:11 pm
  • I was wondering if there is something I can do that would act similar to a index over more than one table. I have about 3 million people in my DB at the moment, they all have roles, and many of them ...
    Jeremiah JahnJeremiah Jahn
    Nov 26, 2003 at 8:14 pm
    Dec 3, 2003 at 2:00 am
  • Hi all, Which one is better (performance/easier to use), tsearch2 or fulltextindex? there is an example how to use fulltextindex in the techdocs, but I checked the contrib/fulltextindex package, ...
    LIANHE SHAOLIANHE SHAO
    Nov 26, 2003 at 8:03 pm
    Dec 1, 2003 at 3:24 pm
  • Yes, I know: very difficult question, but I don't know what to do now. Our Server: Dual-CPU with 1.2 GHz 1.5 GB RAM Our Problem: We are a Community. Between 19 and 21 o clock we have 350 User in the ...
    Torsten SchulzTorsten Schulz
    Nov 24, 2003 at 8:48 pm
    Nov 26, 2003 at 6:07 am
  • Hi. I'm trying to set run-time environment in pgsql7.4 so, that it prints all statements with duration time, but I can't understand why setting log_min_duration_statement to '0' causes printing to ...
    Ryszard LachRyszard Lach
    Nov 17, 2003 at 10:22 pm
    Nov 21, 2003 at 2:55 pm
  • Hi , my database seems to be taking too long for a select count(*) i think there are lot of dead rows. I do a vacuum full it improves bu again the performance drops in a short while , can anyone ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Nov 14, 2003 at 7:19 am
    Nov 16, 2003 at 3:23 pm
  • We are getting ready to spec out a new machine and are wondering about the wisdom of buying a quad versus a dual processor machine. Seing as how postgres in not a threaded application, and this ...
    Chris FieldChris Field
    Nov 11, 2003 at 11:33 pm
    Nov 13, 2003 at 3:52 pm
  • [I originally posted this using the wrong E-Mail account, so a double posting may occur if the first message gets released by the moderator later- sorry!] Hi- I have a query that I'm trying to speed ...
    Nick FankhauserNick Fankhauser
    Nov 12, 2003 at 1:35 pm
    Nov 14, 2003 at 4:38 pm
  • I've scanned some of the archives and have learned a lot about different performance tuning practices. I will be looking into using many of these ideas but I'm not sure they address the issue I am ...
    MK SpamMK Spam
    Nov 24, 2003 at 10:03 pm
    Nov 25, 2003 at 5:08 pm
  • Hi, NOT EXISTS is taking almost double time than NOT IN . I know IN has been optimised in 7.4 but is anything wrong with the NOT EXISTS? I have vaccumed , analyze and run the query many times still ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Nov 13, 2003 at 7:51 am
    Nov 13, 2003 at 7:27 pm
  • I'm moving a webmail service over to use a postgresql database for storage and wanted to get any tips for optimizing performance. The machine will be a multiprocessor (either 2 or 4 cpu ) system with ...
    Suchandra ThapaSuchandra Thapa
    Nov 12, 2003 at 5:38 pm
    Nov 13, 2003 at 1:48 pm
  • version 7.4 results: explain analyse SELECT L.row_id FROM music.logfile L LEFT JOIN music.program P ON music.fn_mri_id_no_program(P.mri_id_no) = L.program_id WHERE L.station = UPPER('kabc')::VARCHAR ...
    Roger GingRoger Ging
    Nov 26, 2003 at 6:39 pm
    Dec 1, 2003 at 6:05 pm
  • Hello All, We will have a very large database to store microarray data (may exceed 80-100G some day). now we have 1G RAM, 2G Hz Pentium 4, 1 CPU. and enough hard disk. I never touched such large ...
    LIANHE SHAOLIANHE SHAO
    Nov 26, 2003 at 8:19 pm
    Feb 17, 2004 at 10:36 am
  • I'm having a problem with a queyr like: INSERT INTO FACT (x,x,x,x,x,x) SELECT a.key,b.key,c.key,d.key,e.key,f.key from x,a,b,c,d,e,f where x=a and x=b .... -- postgres7.4 is running out of memory. ...
    Stephen farrellStephen farrell
    Nov 20, 2003 at 9:05 pm
    Dec 9, 2003 at 8:32 am
  • Dear You all, (please tell me if this has already been discussed, I was unable to find any convincing information) I'm developing a small application, tied to a PG 7.4 beta 5 (i didn't upgrade). The ...
    Stefan ChampaillerStefan Champailler
    Nov 25, 2003 at 9:58 pm
    Nov 27, 2003 at 7:58 pm
  • Hi Everyone, I am using PostgreSQL 7.3.2 and have used earlier versions (7.1.x onwards) and with all of them I noticed same problem with INSERTs when there is a large data set. Just to so you guys ...
    Slavisa GaricSlavisa Garic
    Nov 14, 2003 at 9:45 am
    Nov 17, 2003 at 2:43 pm
  • Hi all, I've one here that I cannot fathom. Any suggestions? We have a table, call it tablename, where we're selecting by a range of dates and an identifier. (This is redacted, obviously): \d ...
    Andrew SullivanAndrew Sullivan
    Nov 13, 2003 at 6:14 pm
    Nov 13, 2003 at 9:53 pm
  • Hi, I plan to put 7.4-RC2 in our production servers in next few hours. Since the hardware config & the performance related GUCs parameter are going to remain the same i am interested in seeing the ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Nov 11, 2003 at 2:47 pm
    Nov 11, 2003 at 9:25 pm
  • Hi all, I have just started with PostgreSQL on Linux and in the past I've done a good bit of work on Interbase (both on Windows and Linux). What I want to know here is What do people here think of ...
    Paul GanainmPaul Ganainm
    Nov 5, 2003 at 1:01 pm
    Nov 6, 2003 at 7:54 pm
  • How do we measure the response time in postgresql? Your response would be very much appreciated. Thanks and Regards, Radha
    Radha ManoharRadha Manohar
    Nov 4, 2003 at 2:50 pm
    Nov 5, 2003 at 6:04 pm
  • Hi all, I want to use index on the gene_symbol column in my query and gene_symbol is indexed. but when I use lower (gene_symbol) like lower('%mif%'), the index is not used. While when I change to ...
    LIANHE SHAOLIANHE SHAO
    Nov 25, 2003 at 7:47 pm
    Nov 26, 2003 at 5:33 pm
  • I have this table: db= \d object_property_value Table "db.object_property_value" Column | Type | Modifiers -----------------------+------------------------+-------------------- obj_property_value_id ...
    Ian BarwickIan Barwick
    Nov 19, 2003 at 9:18 am
    Nov 19, 2003 at 7:17 pm
  • Hi, I have coded some improvements to phpPgAdmin that I think are pretty cool. Basicaly, once you are browsing the results of an arbitrary SELECT query, you can still sort by columns, regardless of ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Nov 13, 2003 at 4:07 am
    Nov 15, 2003 at 3:37 am
  • Hi, with this query I see how much queries running, but the field current_query are free, so i can't see which queries are very slow. Greetings Torsten
    Torsten SchulzTorsten Schulz
    Nov 25, 2003 at 7:39 pm
    Nov 25, 2003 at 10:27 pm
  • I am sure there is no transaction open with the table banner_stats2. Still VACUUM FULL does not seems to effective in removing the dead rows. Can any one please help? Regds mallah tradein_clients=# ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Nov 24, 2003 at 5:14 pm
    Nov 25, 2003 at 2:28 am
  • Heya, Sorry for no updates on the old pg_autoconfig script thing, been rather busy at work the last week or two :-( but i suppose it pays the bills. I do have a few days off work now so I can spend ...
    Nick BarrNick Barr
    Nov 22, 2003 at 11:57 am
    Nov 24, 2003 at 11:26 am
  • I am running RH 7.3 running Apache 1.3.27-2 and PostgreSQL 7.2.3-5.73. When having 100+ users connected to my server I notice that postmaster consumes up wards of 90% of the processor and I hardly am ...
    Benjamin BostowBenjamin Bostow
    Nov 19, 2003 at 1:20 am
    Nov 20, 2003 at 5:58 am
  • Dear Gurus, I have two SQL function that produce different times and I can't understand why. Here is the basic difference between them: CREATE FUNCTION test_const_1234 () RETURNS int4 AS ' SELECT ... ...
    Szűcs GáborSzűcs Gábor
    Nov 14, 2003 at 3:10 pm
    Nov 19, 2003 at 4:07 pm
  • All, This is a straight SQL question, maybe not appropriate for a performance list, but... I have a simple stock holdings setup: = select * from t1; nam | co | num -----+-----------+------ joe | ibm ...
    Rich CullingfordRich Cullingford
    Nov 17, 2003 at 4:39 pm
    Nov 18, 2003 at 5:01 pm
  • Hi- I'm seeing estimates for n_distinct that are way off for a large table (8,700,000 rows). They get better by setting the stats target higher, but are still off by a factor of 10 with the stats set ...
    Nick FankhauserNick Fankhauser
    Nov 14, 2003 at 9:27 pm
    Nov 16, 2003 at 1:53 pm
  • On 7.4 RC2, I'm seeing a case where the query planner estimates are way out of line after grouping the result of a union. I've tried adjusting the statistics targets up to 200, and it made no ...
    Arthur WardArthur Ward
    Nov 13, 2003 at 6:28 pm
    Nov 13, 2003 at 7:19 pm
  • I have a c program called test1.pgc with some sql statements embedded in it. The program was preprocessed, compiled and linked. Now, I have the executable test1. When I run the executable it says, ...
    Radha ManoharRadha Manohar
    Nov 9, 2003 at 3:06 pm
    Nov 10, 2003 at 3:01 pm
  • Hi, I'm trying to set these two options to tune performance but both return 'not a valid option name'. Dumping the pg_settings table confirms that they are missing. I'm using the PostgreSQL packages ...
    Lee HughesLee Hughes
    Nov 3, 2003 at 4:17 pm
    Nov 3, 2003 at 6:42 pm
  • I'v spent a couple days playing with this problem and searching the mailing lists and docs etc but come up with nothing. Any help would be much appreciated. Setup is postgres 7.3.2 on redhat 7.1 on a ...
    Jonathan KnoppJonathan Knopp
    Nov 28, 2003 at 5:58 am
    Nov 28, 2003 at 5:56 pm
  • I just installed v7.4 and restored a database from v7.3.4. I have an index based on a function that the planner is using on the old version, but doing seq scans on left joins in the new version. I ...
    Roger GingRoger Ging
    Nov 26, 2003 at 4:38 pm
    Nov 26, 2003 at 6:00 pm
  • Hi, I understand that it is not possible to occasionally re-plan the queries in a PL/pgSQL function without dropping and re-creating the function. I think it would be useful if the queries in a ...
    Joel JacobsonJoel Jacobson
    Nov 17, 2003 at 2:51 pm
    Nov 20, 2003 at 4:40 am
  • Ever Since i upgraded to 7.4RC2 i am facing problem with select count(*) . In 7.3 the problem was not there select count(*) from data_bank.profiles used to return almost instantly , but in 7.4 ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Nov 19, 2003 at 1:37 am
    Nov 19, 2003 at 3:51 pm
  • When I execute a transaction using embedded sql statements in a c program, I get the error, Error in transaction processing. I could see from the documentation that it means, "Postgres signalled to ...
    Radha ManoharRadha Manohar
    Nov 14, 2003 at 10:07 pm
    Nov 15, 2003 at 2:53 pm
  • Hello guys ! I am trying to connect to pgsql using ODBC from Visual Objects (for the ones who don't know what is Visual Objects, it's an IDE with its own object-oriented language made by Computer ...
    Adrian MaierAdrian Maier
    Nov 6, 2003 at 8:44 am
    Nov 6, 2003 at 2:58 pm
  • Heya, FYI just spotted this and thought I would pass it on, for all those who are looking at new boxes. http://www.theinquirer.net/?article=12665 ...
    Nick BarrNick Barr
    Nov 14, 2003 at 10:12 am
    Nov 14, 2003 at 10:12 am
  • Folks, How would I calculate storage space/required ram on a 50-digit NUMERIC? And the docs state that NUMERIC is slow. Is this just slow for calculations (due to the conversion to float & back) or ...
    Josh BerkusJosh Berkus
    Nov 13, 2003 at 7:39 pm
    Nov 13, 2003 at 7:39 pm
  • Hi, I am trying the PG 7.4 RC1 and RC2 and I see a superb performance improvement compared with 7.3.... Explaining the querys, I see a change of planner that, in my case, prefer Nested Loops in 7.4 ...
    Alexandre :: aldeia digitalAlexandre :: aldeia digital
    Nov 12, 2003 at 3:44 pm
    Nov 12, 2003 at 3:44 pm
  • Dear Gurus, We are planning to add more db server hardware for the apps. The question is, what makes more sense regarding performance/scalability/price of the hardware... There are a couple of apps, ...
    Anjan DaveAnjan Dave
    Nov 11, 2003 at 11:41 pm
    Nov 11, 2003 at 11:41 pm
  • Hi- I have a query that takes too long. I haven't been able to come up with any ideas for speeding it up, so I'm seeking some input from the list. I'm using version 7.3.2 I have three tables: ...
    Nick Fankhauser - DoxpopNick Fankhauser - Doxpop
    Nov 11, 2003 at 10:27 pm
    Nov 11, 2003 at 10:27 pm
Nov 2003
Group Navigation
period‹ prev | Nov 2003 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions47
posts298
users82
websitepostgresql.org
irc#postgresql

82 users for November 2003

Tom Lane: 34 posts Josh Berkus: 23 posts Shridhar Daithankar: 16 posts Rajesh Kumar Mallah: 12 posts Neil Conway: 11 posts Christopher Kings-Lynne: 10 posts Matthew T. O'Connor: 8 posts Nick Fankhauser: 8 posts Marc G. Fournier: 7 posts Radha Manohar: 6 posts Andrew Sullivan: 6 posts Bruce Momjian: 6 posts Greg Stark: 6 posts William Yu: 6 posts Torsten Schulz: 5 posts Chris Browne: 4 posts Hannu Krosing: 4 posts LIANHE SHAO: 4 posts Manfred Koizar: 4 posts Richard Huxton: 4 posts
show more
Archives