Search Discussions
-
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 Schwarz
Mar 15, 2004 at 8:28 pm
Apr 19, 2004 at 5:39 pm -
41
select slow?
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 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 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 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 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 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 ...
Jeff
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, 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 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 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 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. 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 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 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, 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 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 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 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 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. ...
Pginfo
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 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 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 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 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 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]
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 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 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 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 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 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 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, 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 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 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 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 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]
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 ...
Shiar
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 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 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 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 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: ...
Postgres
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 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 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 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 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 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 ...
Postgres
Mar 14, 2004 at 11:10 pm
Mar 14, 2004 at 11:10 pm
Group Overview
group | pgsql-performance |
categories | postgresql |
discussions | 50 |
posts | 445 |
users | 99 |
website | postgresql.org |
irc | #postgresql |
99 users for March 2004
Archives
- August 2013 (188)
- July 2013 (94)
- June 2013 (119)
- May 2013 (255)
- April 2013 (185)
- March 2013 (210)
- February 2013 (202)
- January 2013 (154)
- December 2012 (283)
- November 2012 (335)
- October 2012 (391)
- September 2012 (213)
- August 2012 (199)
- July 2012 (356)
- June 2012 (156)
- May 2012 (197)
- April 2012 (183)
- March 2012 (195)
- February 2012 (282)
- January 2012 (156)
- December 2011 (215)
- November 2011 (288)
- October 2011 (289)
- September 2011 (446)
- August 2011 (328)
- July 2011 (234)
- June 2011 (283)
- May 2011 (420)
- April 2011 (450)
- March 2011 (382)
- February 2011 (538)
- January 2011 (351)
- December 2010 (342)
- November 2010 (422)
- October 2010 (605)
- September 2010 (213)
- August 2010 (355)
- July 2010 (457)
- June 2010 (530)
- May 2010 (276)
- April 2010 (333)
- March 2010 (427)
- February 2010 (403)
- January 2010 (541)
- December 2009 (265)
- November 2009 (447)
- October 2009 (448)
- September 2009 (352)
- August 2009 (330)
- July 2009 (378)
- June 2009 (412)
- May 2009 (457)
- April 2009 (414)
- March 2009 (447)
- February 2009 (338)
- January 2009 (302)
- December 2008 (243)
- November 2008 (306)
- October 2008 (149)
- September 2008 (269)
- August 2008 (432)
- July 2008 (281)
- June 2008 (249)
- May 2008 (383)
- April 2008 (479)
- March 2008 (538)
- February 2008 (409)
- January 2008 (302)
- December 2007 (423)
- November 2007 (401)
- October 2007 (393)
- September 2007 (478)
- August 2007 (414)
- July 2007 (446)
- June 2007 (651)
- May 2007 (644)
- April 2007 (511)
- March 2007 (471)
- February 2007 (354)
- January 2007 (451)
- December 2006 (557)
- November 2006 (276)
- October 2006 (639)
- September 2006 (443)
- August 2006 (501)
- July 2006 (322)
- June 2006 (504)
- May 2006 (570)
- April 2006 (707)
- March 2006 (644)
- February 2006 (459)
- January 2006 (500)
- December 2005 (658)
- November 2005 (565)
- October 2005 (479)
- September 2005 (463)
- August 2005 (565)
- July 2005 (506)
- June 2005 (604)
- May 2005 (474)
- April 2005 (760)
- March 2005 (699)
- February 2005 (375)
- January 2005 (640)
- December 2004 (315)
- November 2004 (421)
- October 2004 (477)
- September 2004 (350)
- August 2004 (491)
- July 2004 (244)
- June 2004 (334)
- May 2004 (223)
- April 2004 (534)
- March 2004 (445)
- February 2004 (331)
- January 2004 (350)
- December 2003 (315)
- November 2003 (298)
- October 2003 (815)
- September 2003 (382)
- August 2003 (549)
- July 2003 (524)
- June 2003 (210)
- May 2003 (306)
- April 2003 (271)
- March 2003 (209)
- February 2003 (245)
- January 2003 (408)
- December 2002 (228)
- November 2002 (258)
- October 2002 (141)
- September 2002 (17)