FAQ

PostgreSQL > pgsql-performance > April 2003

Search Discussions

40 discussions - 270 posts

  • as I remember, mysql keeps the record count in a variable and is instantaneaous with that kind of query. Recent posts suggest the Postgres does not keep that variable and has to do the seq scan. ...
    Dennis GearonDennis Gearon
    Apr 8, 2003 at 8:23 pm
    Apr 23, 2003 at 4:34 pm
  • Hello all, I've been the lead developer of a successful (so-far) web application. Currently we run the database and the web application on the same server, but it will soon be necessary to split them ...
    Matthew NuzumMatthew Nuzum
    Apr 9, 2003 at 3:38 am
    Apr 22, 2003 at 8:30 am
  • Folks, Please pardon the cross-posting. A small group of us on the Performance list were discussing the first steps toward constructing a comprehensive Postgresql installation benchmarking tool, ...
    Josh BerkusJosh Berkus
    Apr 3, 2003 at 5:55 pm
    Apr 4, 2003 at 6:07 pm
  • On this table project_id | integer | not null id | integer | not null date | date | not null team_id | integer | not null work_units | bigint | not null Indexes: email_contrib_pkey primary key btree ...
    Jim C. NasbyJim C. Nasby
    Apr 24, 2003 at 11:38 pm
    May 4, 2003 at 4:22 pm
  • Hi, (PostgreSQL 7.3.2 on i386-portbld-freebsd4.7, compiled by GCC 2.95.4) I've a curious performance problem with a function returning set of rows. The query alone is very fast, but not when called ...
    Frederic JollitonFrederic Jolliton
    Apr 23, 2003 at 5:55 pm
    Apr 25, 2003 at 3:09 pm
  • Hi, In the process of developing an API for web/perl/postrgres interactions, I have come up against a peculiar problem; a rather simple query, run on two relatively small tables, takes as much as 0.4 ...
    Victor DanilchenkoVictor Danilchenko
    Apr 17, 2003 at 7:17 pm
    Apr 18, 2003 at 3:01 pm
  • Thanks for all the feedback, this is very informative. My current issues that I'm still not clear on, are: * Is the ia32 architecture going to impose uncomfortable limits on my application? I'm ...
    Matthew NuzumMatthew Nuzum
    Apr 10, 2003 at 1:16 am
    Apr 11, 2003 at 5:38 pm
  • Achilleus, It's perfectly normal for a query to run faster after a VACUUM ANALYZE than after an ANALYZE ... after all, you just vacuumed it, didn't you? If you're demonstrating some other kind of ...
    Josh BerkusJosh Berkus
    Apr 30, 2003 at 4:03 pm
    May 2, 2003 at 2:00 pm
  • Dear Gurus, A nasty query and its EXPLAINs are here. Read on at your own risk :) ABSTRACT: Search for the strings "looping index scan" and "loops=2310" in this message. DETAILS: Yesteray, I spent two ...
    Szűcs GáborSzűcs Gábor
    Apr 29, 2003 at 1:35 pm
    Apr 30, 2003 at 3:14 pm
  • Hi, I am writing to you to discuss the performance problem of postgreSQL database we encountered in our project. I want to get suggestions from you. The postgreSQL database we used need to process ...
    LinweidongLinweidong
    Apr 15, 2003 at 9:47 am
    Apr 16, 2003 at 4:12 pm
  • Hello, We're evaluating postgresql as a backend choice for our next generation software and would like to perform some rough measurements in-house. Where could I get my hands on some reference data, ...
    Boris PopovBoris Popov
    Apr 10, 2003 at 5:21 pm
    Apr 12, 2003 at 8:53 pm
  • Hi, I want to ask the 'which RAID setup is best for PostgreSQL?' question again. I've read a large portion of the archives of this list, but generally the answer is 'depends on your needs' with a few ...
    Vincent van LeeuwenVincent van Leeuwen
    Apr 16, 2003 at 4:26 pm
    Apr 22, 2003 at 5:45 pm
  • Hi Can anyone tell if the case below is an acceptable performance ? I have a query that returns data and creates a table in 3 mins approx. This query is optimised and uses appropriate indexes for the ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Apr 29, 2003 at 7:01 am
    Apr 30, 2003 at 7:38 am
  • Is printing timeofday() at various points a good idea of profiling plpgsql functions? also is anything wrong with following fragment ? RAISE INFO '' % , message here ... '' , timeofday() ; regds ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Apr 29, 2003 at 11:24 am
    May 1, 2003 at 2:57 pm
  • Hi all, Whilst I often use views for convenience, is there any performance advantage at all in using a view rather than running the same query directly on the tables themselves? Is it quicker to run ...
    Robert John ShepherdRobert John Shepherd
    Apr 15, 2003 at 3:49 pm
    Apr 16, 2003 at 8:45 am
  • Hi all, I have a fairly large table with a char(20) field in it which I search on quite a bit. The problem is that I tend to do a lot of "...where field like '%-d%'" type searches on this field. Is ...
    Diehl, JeffreyDiehl, Jeffrey
    Apr 30, 2003 at 4:34 pm
    Apr 30, 2003 at 5:33 pm
  • I'm doing something where I just need to know if we have more than 100 rows in a table. Not wanting to scan the whole table, I thought I'd get cute... explain select count(*) FROM (SELECT * FROM ...
    Jim C. NasbyJim C. Nasby
    Apr 30, 2003 at 6:04 am
    Apr 30, 2003 at 4:22 pm
  • select id into temp NewRetires from stats_participant where retire_to =1 AND retire_date = (SELECT last_date FROM Project_statsrun WHERE project_id = :ProjectID); results in a table with 5 values... ...
    Jim C. NasbyJim C. Nasby
    Apr 28, 2003 at 6:21 pm
    Apr 28, 2003 at 10:54 pm
  • Hello, I have a database that contains a large amount of Large Objects ( 500MB). I am using this database to store images for an e-commerce website, so I have a simple accessor script written in perl ...
    Jeremy AndrusJeremy Andrus
    Apr 28, 2003 at 2:30 am
    Apr 28, 2003 at 8:20 am
  • BEGIN; SET LOCAL enable_seqscan = off; SELECT id, team_id, sum(work_units) AS work_units INTO TEMP email_contrib_summary FROM email_contrib WHERE project_id = :ProjectID GROUP by id, team_id ; ...
    Jim C. NasbyJim C. Nasby
    Apr 26, 2003 at 3:15 pm
    Apr 26, 2003 at 6:40 pm
  • I'm using 7.3.2 on Linux, with a decent amount of muscle behind it (1.5 GHz PPro CPU, 1G mem, 20M/sec disks, xlog on different disk than data). I've got a database that has several foreign keys, and ...
    Kevin BrownKevin Brown
    Apr 18, 2003 at 5:11 am
    Apr 18, 2003 at 6:25 am
  • I am wondering why it uses the O(n^2) nested loop when there is a O(N) methoud using btree indexes for a merg join. I am using 7.2.1 would upgrading fix my problime or is it somthing else? Given the ...
    Jonathan MooreJonathan Moore
    Apr 17, 2003 at 12:03 am
    Apr 17, 2003 at 2:11 pm
  • Folks, What follows is a 7.2.4 EXPLAIN ANALYZE statement for the shown query. This query is currently taking 570 msec, an OK amount of time until you realize that the system only has test data ...
    Josh BerkusJosh Berkus
    Apr 10, 2003 at 12:15 am
    Apr 11, 2003 at 12:13 am
  • We have a perl program that loads data into Postgres version 7.3.1 using deletes and inserts. We find that the load times are about 50% slower when we use a RAID5 disk system as compared to when we ...
    Howard OblowitzHoward Oblowitz
    Apr 7, 2003 at 2:28 pm
    Apr 7, 2003 at 3:35 pm
  • Hmm, what are the before and after explain analyze results? Also, what are your conf settings for shared buffers, sort memory and the fsm parameters? Did you do a regular vacuum or vacuum full? If ...
    Stephan SzaboStephan Szabo
    Apr 4, 2003 at 2:50 pm
    Apr 7, 2003 at 2:25 pm
  • I access Postgresql through the ODBC driver, and always only read small recordsets (never updating them) with forward cursors. The following options are defined in ADO with which I can create a ...
    Robert John ShepherdRobert John Shepherd
    Apr 29, 2003 at 1:53 pm
    Apr 29, 2003 at 3:44 pm
  • Like some other recent messages, this one is about getting postgresql to use an index that it seems it should clearly use. (But this one has nothing to do with count(*)). Here is my table: Column | ...
    Rob MesserRob Messer
    Apr 29, 2003 at 9:03 am
    Apr 29, 2003 at 2:18 pm
  • I now under stand that my join was rong but none of the seguestions are the optimal solution to the problime. You can make this order n if you try. The trick is to use a mearg join using sorted list ...
    Jonathan MooreJonathan Moore
    Apr 17, 2003 at 3:29 pm
    Apr 17, 2003 at 4:31 pm
  • I'd be honestly interested in the circumstances where you made that observation. Yes, it does :-) Out of curiosity I did a few tests with PG 7.2 on my old notebook: CREATE TABLE baz (event int, level ...
    Manfred KoizarManfred Koizar
    Apr 4, 2003 at 7:03 pm
    Apr 5, 2003 at 2:08 am
  • Hi, I am getting poor performance from my postgresql (version 7.3.2 compiled with gcc 2.95.2) database when running load tests on my web application. The database works great until I get above 200 ...
    Scott BuchanScott Buchan
    Apr 1, 2003 at 7:27 pm
    Apr 1, 2003 at 9:48 pm
  • Sorry, this is the good one: I´ve already created an concatenated index in Postgres V3.0 with different datatypes: CREATE INDEX mov_i4 ON movimiento USING btree (id_company, id_status, id_docum, ...
    Cecilia AlvarezCecilia Alvarez
    Apr 25, 2003 at 10:36 pm
    Apr 25, 2003 at 10:49 pm
  • Hello, I'm not sure if this is really a problem. I'm working on a distributed web crawling system which uses several clients on different machines. Results are logged to a central Postgres system. ...
    Ian KnopkeIan Knopke
    Apr 20, 2003 at 6:09 pm
    Apr 20, 2003 at 6:36 pm
  • Hi, I have a visual basic application and the access to postgress is very slow. If I run the query on PGadminII the answer is quite good but if I run the same query from the application it takes a ...
    Cecilia AlvarezCecilia Alvarez
    Apr 10, 2003 at 5:35 pm
    Apr 10, 2003 at 6:58 pm
  • Hi, I´ve already created an concatenated index in Postgres V3.0 with different datatypes: CREATE INDEX mov_i4 ON movimiento USING btree (id_company, id_status, id_docum, id_origen_mov); id_company ...
    Cecilia AlvarezCecilia Alvarez
    Apr 25, 2003 at 10:33 pm
    Apr 25, 2003 at 10:33 pm
  • Hello, Is it more efficient to use a schema with Inherits or schema with Views. I can see logically how to use both for my case and I'm trying to make a decision. I would guess that the overhead of ...
    DexDex
    Apr 17, 2003 at 5:48 pm
    Apr 17, 2003 at 5:48 pm
  • Hello, In building a schema, I'd like to know if it makes sense from a performance standpoint to use views instead of an object oriented structure (i.e. inherits). I would guess that the overhead of ...
    DexDex
    Apr 16, 2003 at 6:10 am
    Apr 16, 2003 at 6:10 am
  • In the following query postgres doesn't use the index. In the hard-coded version below it does. I suppose it can't because it's possible the "target" could have wildcards etc in them. Is there any ...
    Greg StarkGreg Stark
    Apr 15, 2003 at 7:05 pm
    Apr 15, 2003 at 7:05 pm
  • I noticed that when a multicolumn index exists it isn't necessarily fully used when the first column is constrained by an equals condition. However by adding a redundant sort condition you can get ...
    Bruno Wolff IIIBruno Wolff III
    Apr 14, 2003 at 1:45 am
    Apr 14, 2003 at 1:45 am
  • Hello all, This is to announce couple of things regarding OAS Server. 1. Mailing list for OAS Server is up now. It is available at https://lists.sourceforge.net/lists/listinfo/oasserver-general. So I ...
    Shridhar DaithankarShridhar Daithankar
    Apr 9, 2003 at 3:43 pm
    Apr 9, 2003 at 3:43 pm
  • Hello all, I am very glad to announce first public release of Open Application Server. This is an application framework built in C++, to make use of existing APIs in internet application. It provides ...
    Shridhar DaithankarShridhar Daithankar
    Apr 4, 2003 at 11:01 am
    Apr 4, 2003 at 11:01 am
Apr 2003
Group Navigation
period‹ prev | Apr 2003 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions40
posts270
users66
websitepostgresql.org
irc#postgresql

66 users for April 2003

Tom Lane: 36 posts Josh Berkus: 33 posts Jim C. Nasby: 16 posts Scott.marlowe: 13 posts Stephan Szabo: 11 posts Andrew Sullivan: 8 posts Shridhar Daithankar: 8 posts Jeffrey D. Brower: 7 posts Kevin Brown: 6 posts Rajesh Kumar Mallah: 6 posts Andreas Pflug: 5 posts Frederic Jolliton: 5 posts Robert John Shepherd: 5 posts Victor Danilchenko: 5 posts Andreas Kostyrka: 4 posts Chris Hedemark: 4 posts Christopher Kings-Lynne: 4 posts Jean-Luc Lachance: 4 posts Manfred Koizar: 4 posts Szűcs Gábor: 4 posts
show more
Archives