FAQ

PostgreSQL > pgsql-performance > March 2004

Search Discussions

50 discussions - 445 posts

  • We're in the throes of an MS SQL to PostgreSQL migration; our databases include a number of ~5M row tables. We decided to take this opportunity to clean up and slightly re-normalize our schemas, ...
    Rosser SchwarzRosser Schwarz
    Mar 15, 2004 at 8:28 pm
    Apr 19, 2004 at 5:39 pm
  • hi all, i have an amd athlon with 256 ram (i know, this is not a *real* server but my tables are small) i'm using vb6 (win98) with pgsql-7.3.4 (rh8) trough the psqlodbc. when i do a select in took ...
    Jaime CasanovaJaime Casanova
    Mar 30, 2004 at 7:25 pm
    Apr 16, 2004 at 7:24 am
  • I have updated my program with your suggested changes and put in src/tools/fsync. Please see how you like it. --------------------------------------------------------------------------- Zeugswetter ...
    Bruce MomjianBruce Momjian
    Mar 18, 2004 at 5:34 pm
    Mar 26, 2004 at 11:22 pm
  • All: We have a Quad-Intel XEON 2.0GHz (1MB cache), 12GB memory, running RH9, PG 7.4.0. There's an internal U320, 10K RPM RAID-10 setup on 4 drives. We are expecting a pretty high load, a few ...
    Anjan DaveAnjan Dave
    Mar 1, 2004 at 4:31 pm
    Mar 15, 2004 at 10:51 pm
  • I have a query which get's data from a single table. When I try to get data from for an RFQ which has around 5000 rows, it is breaking off at 18th row. If i reduce some columns , then it returns all ...
    Qing ZhaoQing Zhao
    Mar 25, 2004 at 5:58 pm
    Mar 30, 2004 at 8:13 pm
  • I'm trying to troubleshoot a performance issue on an application ported from Oracle to postgres. Now, I know the best way to get help is to post the schema, explain analyze output, etc, etc -- ...
    Joe ConwayJoe Conway
    Mar 13, 2004 at 1:42 am
    Mar 17, 2004 at 8:57 pm
  • I'm guessing the answer to this is "no" Is there any performance advantage to using a fixed width row (with PG)? I've heard this theory a few times and I think it is based on older, different ...
    JeffJeff
    Mar 5, 2004 at 1:35 pm
    Mar 8, 2004 at 9:39 am
  • As anyone done benchmarking tests with postgres running on solaris and linux (redhat) assuming both environment has similar hardware, memory, processing speed etc. By reading few posts here, i can ...
    Subbiah, StalinSubbiah, Stalin
    Mar 23, 2004 at 12:05 am
    Mar 24, 2004 at 5:05 pm
  • I've been waiting all day for a pg_restore to finish on a test system identically configured as our production in hardware and software with the exception prod is 7.3.5 and test is 7.4.1. The file ...
    Greg SpiegelbergGreg Spiegelberg
    Mar 9, 2004 at 8:29 pm
    Mar 15, 2004 at 4:01 pm
  • Hello fellow PostgreSQL users. We've been working on this interesting issue for some time now, and we're hoping that someone can help. We've recently integrated postgres into an existing mature app. ...
    Fabio EspositoFabio Esposito
    Mar 23, 2004 at 7:25 pm
    Mar 29, 2004 at 8:24 pm
  • Given an index like this: CREATE UNIQUE INDEX i1 ON t1 (c1) WHERE c1 IS NOT NULL; and a query like this: SELECT * FROM t1 WHERE c1 = 123; I'd like the planner to be smart enough to use an index scan ...
    John SiracusaJohn Siracusa
    Mar 3, 2004 at 9:41 pm
    Mar 8, 2004 at 5:55 pm
  • Guys, I got a Java program to tune. It connects to a 7.4.1 postgresql server running Linux using JDBC. The program needs to update a counter on a somewhat large number of rows, about 1200 on a ~130k ...
    Marcus Andree S. MagalhaesMarcus Andree S. Magalhaes
    Mar 10, 2004 at 3:35 am
    Mar 12, 2004 at 5:39 pm
  • Subject: FreeBSD, PostgreSQL, semwait and sbwait! Date: March 23, 2004 12:02 pm From: "Jason Coene" <jcoene@gotfrag.com To: <freebsd-performance@freebsd.org Hello all, We're having a substantial ...
    Darcy BuskermolenDarcy Buskermolen
    Mar 23, 2004 at 8:48 pm
    May 4, 2004 at 7:37 am
  • First let me explain the situation: I came into the #postgresql irc channel talking about this problem, and someone advised me to use this mailing list (so i'm not just wasting your time i hope). I'm ...
    Eric BrownEric Brown
    Mar 12, 2004 at 1:47 am
    Mar 28, 2004 at 5:17 pm
  • Hi All, We are evaluating the options for having multiple databases vs. schemas on a single database cluster for a custom grown app that we developed. Each app installs same set of tables for each ...
    Subbiah, StalinSubbiah, Stalin
    Mar 22, 2004 at 9:00 pm
    Mar 24, 2004 at 3:31 am
  • Dear PostgresQL Experts, I am trying to get to the bottom of some efficiency problems and hope that you can help. The difficulty seems to be with INTERSECT expressions. I have a query of the form ...
    Phil EndecottPhil Endecott
    Mar 23, 2004 at 2:12 pm
    Mar 23, 2004 at 5:21 pm
  • explain SELECT COUNT(u.ukey) FROM u, d WHERE d.ukey = u.ukey AND u.pkey = 260 AND (u.status = 3 ) AND NOT u.boolfield ; QUERY PLAN ...
    Joseph ShraibmanJoseph Shraibman
    Mar 18, 2004 at 9:24 pm
    Mar 22, 2004 at 8:44 pm
  • Hi, we need to optimize / speed up a simple select: explain analyze select ((t0.int_value-t1.int_value)*(t0.int_value-t1.int_value)) from job_property t0, job_property t1 where t0.id_job_profile = 5 ...
    David TeranDavid Teran
    Mar 7, 2004 at 11:42 am
    Mar 9, 2004 at 3:37 pm
  • Hi, Shouldn't the optimizer use indices if the like condition does not have any wildcards? An example: girgen=# explain analyze select * from person where userid = 'girgen'; QUERY PLAN ...
    Palle GirgensohnPalle Girgensohn
    Mar 30, 2004 at 11:06 pm
    Mar 31, 2004 at 5:33 am
  • Hi, I am running pg 7.4.1 on linux box. I have a midle size DB with many updates and after it I try to run vacuum full analyze. It takes about 2 h. If I try to dump and reload the DB it take 20 min. ...
    PginfoPginfo
    Mar 24, 2004 at 11:34 am
    Mar 24, 2004 at 6:23 pm
  • Hi list, I was more or less toying with an idea for a project I have, which includes renumbering a primary key (don't ask, it's necessary :/ ) Anyway, I was looking into the usefullness of a INSERT ...
    Arjen van der MeijdenArjen van der Meijden
    Mar 14, 2004 at 7:33 pm
    Mar 15, 2004 at 8:34 pm
  • ok. if i don't misunderstand you (english is not my mother tongue, so i can be wrong). your point is that speed is not necesarily performance, that's right. so, the real question is what is the best ...
    Jaime CasanovaJaime Casanova
    Mar 29, 2004 at 9:56 pm
    Mar 30, 2004 at 9:53 pm
  • Hi, I've recently converted a database to use bigint for the indices. Suddenly simple queries like select * from new_test_result where parent_id = 2 are doing full table scans instead of using the ...
    Steven ButlerSteven Butler
    Mar 8, 2004 at 12:27 am
    Mar 8, 2004 at 4:46 pm
  • After an upgrade to 7.4.1 (from 7.3) we see a severe performance regression in bulk INSERTs. This is apparently caused by constant checkpointing (every 10 to 20 seconds). I've already increased the ...
    Florian WeimerFlorian Weimer
    Mar 3, 2004 at 9:25 am
    Mar 4, 2004 at 10:06 am
  • Hi all, we have a question about the pagesize in PostgreSQL: Using different pagesizes: 4K, 8K, 16K, 32K, when we store different record sizes such as in the following example: CREATE TABLE TEST_1 ( ...
    Seum-Lim GanSeum-Lim Gan
    Mar 17, 2004 at 11:49 pm
    Mar 18, 2004 at 5:58 pm
  • I have a few questions about cluster and vacuum. We have a table that is 56 GB in size and after a purge based on dates 16GB was made available as reported below. PWFPM_DEV=# vacuum full verbose ...
    Shea,Dan [CIS]Shea,Dan [CIS]
    Mar 9, 2004 at 8:18 pm
    Mar 10, 2004 at 5:36 pm
  • Hello all, I have a performance issue that I cannot seem to solve and am hoping that someone might be able to make some suggestions. First some background information. We are using PostgreSQL 7.3.4 ...
    Chris KratzChris Kratz
    Mar 3, 2004 at 9:50 pm
    Mar 31, 2004 at 3:42 pm
  • Hello, I am using postgres 7.4.2 as a backend for geocode data for a mapping application. My question is why can't I get a consistent use of my indexes during a query, I tend to get a lot of seq scan ...
    Woody WoodringWoody Woodring
    Mar 23, 2004 at 6:49 pm
    Mar 24, 2004 at 4:44 pm
  • In porting an application from v7.2 and v7.3, I noticed that a join on a varchar column and a text column was ignoring indices that were helpful in v7.2. When I explicitly cast the text to a varchar ...
    Michael AdlerMichael Adler
    Mar 18, 2004 at 6:52 pm
    Mar 20, 2004 at 12:17 am
  • I sent this message to the list and although it shows up in the archives, I did not receive a copy of it through the list, so I'm resending as I suspect others did not see it either. ---------- ...
    Kris JurkaKris Jurka
    Mar 17, 2004 at 7:33 am
    Mar 19, 2004 at 1:59 am
  • I've been running Postgresql 7.4.1 for a couple weeks after upgrading from 7.2. I noticed today that the postmaster had been using 99% of the dual CPUs (on a PowerEdge 2650) non-stop for the last ...
    Mike BridgeMike Bridge
    Mar 10, 2004 at 3:52 am
    Mar 15, 2004 at 9:47 pm
  • Hi all, I've got what should be a relatively simple join between two tables that is taking forever and I can't work out why. Version 7.3.4RH. It can't be upgraded because the system is kept in sync ...
    Chris SmithChris Smith
    Mar 8, 2004 at 6:57 am
    Mar 8, 2004 at 9:43 pm
  • Hi everyone, I am building a query which uses a clause like "Where doc_description like '%keyword%'". I know a normal index won't be of any use here, but since the table in question will get fairly ...
    Priem, AlexanderPriem, Alexander
    Mar 31, 2004 at 9:50 am
    Apr 1, 2004 at 1:14 am
  • I've run into this odd planner choice which I don't quite understand. I have two tables articles, users and articles.article_id and users.user_id are primary keys. Insides articles there are two ...
    Ara AnjargolianAra Anjargolian
    Mar 26, 2004 at 5:54 am
    Mar 26, 2004 at 11:08 pm
  • I am trying to optimize a query that does a lot of aggregation. I have a large number of columns that are part of the result, and most are aggregates. They are acting on two temporary tables, the ...
    A PalmbladA Palmblad
    Mar 23, 2004 at 8:09 pm
    Mar 24, 2004 at 3:42 am
  • greetings! on a dedicated pgsql server is putting pg_xlog in drive as OS almost equivalent to putting on a seperate drive? in both case the actual data files are in a seperate drive. regds mallah
    Rajesh Kumar MallahRajesh Kumar Mallah
    Mar 12, 2004 at 7:18 pm
    Mar 12, 2004 at 9:52 pm
  • Hello people! I have a question, I am going to begin a project for the University in the area of Data Warehousing and I want to use postgres. Do you have some recommendation to me? Thanks!! ...
    Pablo MarreroPablo Marrero
    Mar 11, 2004 at 1:59 pm
    Mar 11, 2004 at 3:09 pm
  • I have had a cluster failure on a table. It most likely was due to space. I do not not have the error message anymore, but it was indicating that it was most likely a space problem. The partition was ...
    Shea,Dan [CIS]Shea,Dan [CIS]
    Mar 10, 2004 at 1:56 pm
    Mar 10, 2004 at 3:39 pm
  • We've got a table containing userdata, such as a bigint column 'icq'. To easily check whether a user has an icq number entered, we made the following index: userinfo_icq_ne0_id_key btree (id) WHERE ...
    ShiarShiar
    Mar 24, 2004 at 12:11 pm
    Mar 26, 2004 at 11:14 pm
  • Hello all, I have a question/observation about vacuum performance. I'm running Solaris 9, pg 7.4.1. The process in questions is doing a vacuum: bash-2.05$ /usr/ucb/ps auxww | grep 4885 fiasco 4885 ...
    Alan StangeAlan Stange
    Mar 19, 2004 at 4:23 am
    Mar 19, 2004 at 6:18 am
  • Hello there !!! I am using postgresql7.2.1 as the backend for an E.R.P system running on Linux Redhat 7.2(Enigma) The database size is around 20-25GB Dropping of an individual table whose size is ...
    Maneesha NunesManeesha Nunes
    Mar 10, 2004 at 7:36 am
    Mar 14, 2004 at 3:52 pm
  • Hello to everybody. I ask your help for a severe problem when doing a query that LEFT JOINs one table to another ON a field, and then LEFT JOINs again to another "instance" of a table ON another ...
    Octavio AlvarezOctavio Alvarez
    Mar 12, 2004 at 5:41 am
    Mar 12, 2004 at 6:09 am
  • Hi. I have two existing tables, A and B. A has a 'varchar(1000)' field and B has a 'text' field, each with btree indexes defined. When I do a join between these, on this field, it seems to a hash ...
    Mike MoranMike Moran
    Mar 11, 2004 at 6:26 pm
    Mar 11, 2004 at 7:02 pm
  • Hi, nobody has an idea? :-( -----Ursprüngliche Nachricht----- Von: pgsql-performance-owner@postgresql.org Im Auftrag von postgres@countup.de Gesendet: Freitag, 27. Februar 2004 17:53 An: ...
    PostgresPostgres
    Mar 2, 2004 at 1:06 am
    Mar 2, 2004 at 11:48 am
  • Do you know if postgres made assumption on the access time time stamp for the files on his own file sistem ? If not I'm wondering if mount a partition with the option "anotime" can improve the disk ...
    Gaetano MendolaGaetano Mendola
    Mar 31, 2004 at 11:50 pm
    Mar 31, 2004 at 11:50 pm
  • *statistics target = 100 *INFO: index "timeseries_tsid" now contains *16,677,521* row versions in 145605 pages DETAIL: 76109 index pages have been deleted, 20000 are currently reusable. CPU ...
    Michael GuerinMichael Guerin
    Mar 31, 2004 at 5:17 pm
    Mar 31, 2004 at 5:17 pm
  • Hi, Can someone provide some insight for me as to why this query takes so long on 6655 rows of data. I'm beginning to think something is seriously wrong with my config wrt to memory settings. I note ...
    Rob FieldingRob Fielding
    Mar 30, 2004 at 2:10 pm
    Mar 30, 2004 at 2:10 pm
  • http://www.databasejournal.com/features/postgresql/article.php/3323561 Shridhar
    Shridhar DaithankarShridhar Daithankar
    Mar 17, 2004 at 7:46 am
    Mar 17, 2004 at 7:46 am
  • This apeared on the Freebsd-perfomace list and though people here could help as well. ---------- Forwarded Message ---------- Subject: Configuring disk cache size on postgress Date: March 16, 2004 ...
    Darcy BuskermolenDarcy Buskermolen
    Mar 16, 2004 at 6:54 pm
    Mar 16, 2004 at 6:54 pm
  • Hi, i have 2 Functions, one ist called by page visitors (something about 2,000 times / 1 hour) and the other just by the admin (let say 1 time per hour or per login) i often get a deadlock error ...
    PostgresPostgres
    Mar 14, 2004 at 11:10 pm
    Mar 14, 2004 at 11:10 pm
Mar 2004
Group Navigation
period‹ prev | Mar 2004 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions50
posts445
users99
websitepostgresql.org
irc#postgresql

99 users for March 2004

Tom Lane: 70 posts Josh Berkus: 38 posts Andrew Sullivan: 15 posts Scott.marlowe: 15 posts Bruce Momjian: 14 posts Rosser Schwarz: 13 posts Joe Conway: 11 posts Christopher Kings-Lynne: 10 posts Anjan Dave: 9 posts Stephan Szabo: 9 posts Richard Huxton: 8 posts Rod Taylor: 8 posts Joseph Shraibman: 7 posts Subbiah, Stalin: 7 posts Vivek Khera: 7 posts Greg Stark: 6 posts Mark Kirkwood: 6 posts Neil Conway: 6 posts Markw: 5 posts Aaron Werman: 5 posts
show more
Archives