FAQ

Search Discussions

56 discussions - 375 posts

  • Hi All, I have boiled my situation down to the following simple case: (postgres version 7.3) * Query 1 is doing a sequential scan over a table (courtesy of field ILIKE 'foo%') and index joins to a ...
    Mark AufflickMark Aufflick
    Feb 14, 2005 at 11:34 pm
    Mar 1, 2005 at 5:27 am
  • Hello All I am setting up a hardware clustering solution. My hardware is Dual Opteron 550 with 8GB ram. My external storage is a Kingston Fibre channel Infostation. With 14 15000'k 36GB drives. The ...
    John AllgoodJohn Allgood
    Feb 23, 2005 at 4:39 pm
    Feb 28, 2005 at 8:10 am
  • Hi guys, i'm planning try to do a comparative between some DBMS and postgresql (informix, oracle, m$ sql server, firebird and even mysql) i'm coordinating with people in the irc spanish postgresql ...
    Jaime CasanovaJaime Casanova
    Feb 10, 2005 at 5:49 am
    Feb 14, 2005 at 10:47 am
  • Hi, according to http://www.postgresql.org/docs/8.0/interactive/limitations.html , concurrent access to GiST indexes isn't possible at the moment. I haven't read the thesis mentioned there, but I ...
    Marinos J. YannikosMarinos J. Yannikos
    Feb 3, 2005 at 4:55 am
    Feb 10, 2005 at 1:13 am
  • Hi, here is a query which produces over 1G temp file in pgsql_tmp. This is on pgsql 7.4.2, RHEL 3.0, XEON MP machine with 32GB RAM, 300MB sort_mem and 320MB shared_mem. Below is the query and results ...
    Dirk LutzebaeckDirk Lutzebaeck
    Feb 5, 2005 at 6:21 pm
    Feb 9, 2005 at 9:16 am
  • Hi all, I'm running since one week without use any vacuum full, I'm using ony pg_autovacuum. I expect that disk usage will reach a steady state but is not. PG engine: 7.4.5 Example: The message table ...
    Gaetano MendolaGaetano Mendola
    Feb 22, 2005 at 7:48 pm
    Feb 28, 2005 at 6:22 pm
  • Hi, I've downloaded the latest release (PostgreSQL 8.0) for windows. Installation was OK, but I have tried to restore a database. It had more than ~100.000 records. Usually I use PostgreSQL under ...
    Vig, Sandor (G/FI-2)Vig, Sandor (G/FI-2)
    Feb 22, 2005 at 2:58 pm
    Feb 25, 2005 at 5:02 am
  • Hello All, In contrast to what we hear from most others on this list, we find our database servers are mostly CPU bound. We are wondering if this is because we have postgres configured incorrectly in ...
    Chris KratzChris Kratz
    Feb 9, 2005 at 8:01 pm
    Feb 10, 2005 at 3:50 am
  • I newly installed the postgresql 7.4.5 and FC 3 in my server and transfer the data from 7.3.2 with just a few problems. After I use the webmin 1.8 to config the grant previllage to the users ,I found ...
    AmritAmrit
    Feb 20, 2005 at 3:46 pm
    Feb 23, 2005 at 8:30 pm
  • Hi all, I'm stuck in a select that use the hash join where should not: 6 seconds vs 0.3 ms !! If you need other info in order to improve the planner, let me know. Regards Gaetano Mendola empdb=# ...
    Gaetano MendolaGaetano Mendola
    Feb 20, 2005 at 12:25 pm
    Feb 21, 2005 at 5:11 pm
  • Hi all, A question on how to read and interpret the explain analyse statement (and what to do) I have a query "SELECT A.ordernummer, B.klantnummer FROM orders A LEFT OUTER JOIN klt_alg B ON ...
    Joost KraaijeveldJoost Kraaijeveld
    Feb 11, 2005 at 9:19 am
    Feb 16, 2005 at 9:09 pm
  • Hi all, I have a big table with ~ 10 Milion rows, and is a very pain administer it, so after years I convinced my self to partition it and replace the table usage ( only for reading ) with a view. ...
    Gaetano MendolaGaetano Mendola
    Feb 2, 2005 at 12:16 am
    Feb 6, 2005 at 3:53 pm
  • Hi, I have 3 tables in the database with 80G of data, one of them is almost 40G and the remaining 2 tables has 20G each. We use this database mainly for query and updating is done only quarterly and ...
    Michael Ryan S. PunciaMichael Ryan S. Puncia
    Feb 15, 2005 at 1:29 am
    Feb 15, 2005 at 8:47 am
  • Is there a way to use indexes for queries like: select field from table where field like 'abc%' (i.e. filter for string fields that begin with something) ?
    Ivan VorasIvan Voras
    Feb 14, 2005 at 7:57 pm
    Feb 14, 2005 at 10:31 pm
  • This is probably a very trivial question and I feel foolish in even posting it, but I cannot seem to get it to work. SCENARIO (abstracted): Two tables, "summary" and "detail". The schema of summary ...
    Steven RosensteinSteven Rosenstein
    Feb 6, 2005 at 5:16 pm
    Feb 7, 2005 at 5:26 pm
  • Folks, A lot of people have been pestering me for this stuff, so I've finally finished it and put it up. http://www.powerpostgresql.com/ Hopefully this should help people as much as the last one did. ...
    Josh BerkusJosh Berkus
    Feb 9, 2005 at 9:46 pm
    Apr 11, 2005 at 8:17 pm
  • Hi, we just got a new dual processor machine and I wonder if there is a way to utilize both processors. Our DB server is basically fully dedicated to postgres. (its a dual amd with 4gb mem.) I have a ...
    AlexAlex
    Feb 9, 2005 at 2:26 pm
    Feb 10, 2005 at 1:18 pm
  • Hi all, we have an Sun E3500 running Solaris 9. It's got 6x336MHz CPU and 10GB RAM. I would like to know what /etc/system and postgresql_conf values are recommended to deliver as much system resource ...
    Paul JohnsonPaul Johnson
    Feb 7, 2005 at 10:25 pm
    Feb 9, 2005 at 10:08 pm
  • [This mail goes as X-Post to both pgsql-perform and postgis-users because postgis users may suffer from this problem, but I would prefer to keep the Discussion on pgsql-performance as it is a general ...
    Markus SchaberMarkus Schaber
    Feb 2, 2005 at 5:22 pm
    Feb 7, 2005 at 2:08 pm
  • Trying to determine the best overall approach for the following scenario: Each month our primary table accumulates some 30 million rows (which could very well hit 60+ million rows per month by year's ...
    Sven WillenbergerSven Willenberger
    Feb 28, 2005 at 11:58 pm
    Mar 2, 2005 at 12:58 am
  • Hi, in the #postgresql-es channel someone shows me this: pgsql-7.4.5 + postgis --- begin context --- CREATE TABLE calles ( gid int4 NOT NULL DEFAULT nextval('public.callesstgo_gid_seq'::text), nombre ...
    Jaime CasanovaJaime Casanova
    Feb 13, 2005 at 9:27 pm
    Feb 14, 2005 at 12:48 pm
  • While working on a previous question I posed to this group, I ran a number of EXPLAIN ANALYZE's to provide as examples. After sending up my last email, I ran the same query *without* EXPLAIN ANALYZE. ...
    Steven RosensteinSteven Rosenstein
    Feb 6, 2005 at 7:51 pm
    Feb 7, 2005 at 2:39 pm
  • Hi all, I am facing a strange problem when I run EXPLAIN against a table having more than 100000 records. The query have lot of OR conditions and when parts of the query is removed it is using index. ...
    Antony PaulAntony Paul
    Feb 7, 2005 at 9:07 am
    Feb 7, 2005 at 11:58 am
  • I'm hoping someone can shed some light on these results. The 'factor' compares the ratios of cost to actual for different plans. Perhaps nested loops should be given a discount in the planner? The ...
    David BrownDavid Brown
    Feb 3, 2005 at 11:11 am
    Feb 4, 2005 at 4:39 am
  • Hi ALL, I was wondering if there is a DB performance reduction if there are a lot of IDLE processes. 30786 ? S 0:00 postgres: user1 gmadb 10.10.10.1 idle 32504 ? S 0:00 postgres: user1 gmadb ...
    JMJM
    Feb 18, 2005 at 10:15 am
    Feb 21, 2005 at 11:25 am
  • We just told you - it's nowhere near enough. Vacuum once an hour. Size of the database is not that relevant, its size of changes that is. Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Feb 18, 2005 at 2:53 pm
    Feb 20, 2005 at 12:04 pm
  • Hi All I'm really desparate about this. The problem has occurried in both of my customers first with cygwin and now with FreeBSD 5.3. After 2 months, postgres start get down the performance, and ...
    Rodrigo MorenoRodrigo Moreno
    Feb 18, 2005 at 1:56 pm
    Feb 18, 2005 at 2:45 pm
  • Does anyone have any idea why there be over a 4s difference between running the statement directly and using explain analyze? Multiple runs give the same result and I've tested on several servers. ...
    Chris KratzChris Kratz
    Feb 10, 2005 at 6:34 pm
    Feb 10, 2005 at 8:25 pm
  • Hi, is there a way to tell Postgres which index to use when a query is issued in 7.4.2? I have a query for which costwise a Hash-Join and no Index-Usage is the best, but timewise using the index and ...
    Silke TrisslSilke Trissl
    Feb 9, 2005 at 3:58 pm
    Feb 9, 2005 at 8:50 pm
  • All, When trying to restore my template1 database (7.3.4) I am experiencing very long delays. For 600 users (pg_shadow) and 4 groups (pg_group) it is taking 1hr and 17 minutes to complete. All of the ...
    Ben YoungBen Young
    Feb 8, 2005 at 6:24 pm
    Feb 8, 2005 at 8:32 pm
  • Hi all, A retry of the question asked before. All tables freshly vacuumed an analized. Two queries: one with "set enable_seqscan = on" , the other with "set enable_seqscan = off". The first query ...
    Joost KraaijeveldJoost Kraaijeveld
    Feb 7, 2005 at 4:38 pm
    Feb 7, 2005 at 7:53 pm
  • I've got 2 tables defined as follows: CREATE TABLE "cluster" ( id int8 NOT NULL DEFAULT nextval('serial'::text), clusterid varchar(255) NOT NULL, ... CONSTRAINT pk_cluster PRIMARY KEY (id) ) CREATE ...
    Butkus_charlesButkus_charles
    Feb 23, 2005 at 1:45 am
    Feb 23, 2005 at 1:42 pm
  • Certain queries on my database get slower after running a VACUUM ANALYZE. Why would this happen, and how can I fix it? I am running PostgreSQL 7.4.2 (I also seen this problem on v. 7.3 and 8.0) Here ...
    Werner fragaWerner fraga
    Feb 17, 2005 at 10:24 pm
    Feb 22, 2005 at 11:08 pm
  • Hi, I am just wondering, by default, autocommit is enabled for every client connection. The documentations states that we have to use BEGIN and END or COMMIT so to increase performance by not using ...
    Hasnul Fadhly bin HasanHasnul Fadhly bin Hasan
    Feb 14, 2005 at 8:01 am
    Feb 14, 2005 at 9:34 am
  • Hello, I have a little time and I decided to improve the performance of my server(s). I have found on google many 'tips' in tuning linux kernel and postgresql database ... but I can't decide wich ...
    Din AdrianDin Adrian
    Feb 3, 2005 at 9:52 am
    Feb 3, 2005 at 2:52 pm
  • Doing some rather crude comparative performance tests between PG 8.0.1 on Windows XP and SQL Server 2000, PG whips SQL Server's ass on insert into junk (select * from junk) on a one column table ...
    Andrew MayoAndrew Mayo
    Feb 1, 2005 at 12:41 pm
    Feb 1, 2005 at 1:34 pm
  • Given some recent posts / irc issues with dead tuple bloat.. And given that a lot of these people have at least been smart enough to explain analyze would it be A. possible B. useful C. None of the ...
    JeffJeff
    Feb 25, 2005 at 1:47 pm
    Feb 27, 2005 at 8:31 pm
  • I am running postgreSQL 8.0.1 under the Windows 2000. I want to use COPY FROM STDIN function from Java application, but it doesn't work, it throws: "org.postgresql.util.PSQLException: Unknown ...
    Asatryan, AnahitAsatryan, Anahit
    Feb 19, 2005 at 11:06 am
    Feb 23, 2005 at 2:42 pm
  • Hello my friends, I'd like to know (based on your experience and technical details) which OS is recommended for running PostgreSQL keeping in mind 3 indicators: 1 - Performance (SO, Network and IO) 2 ...
    Lago, Bruno Almeida doLago, Bruno Almeida do
    Feb 1, 2005 at 1:59 am
    Feb 1, 2005 at 10:01 am
  • Hi, Another "funny" thing: I have a query which runs on (Linux) PostgreSQL 7.4.x under 10 sec. I tried to run it on (Windows) PostgreSQL 8.0 yesterday. It didn't finished at all! (I shoot it down ...
    Vig, Sandor (G/FI-2)Vig, Sandor (G/FI-2)
    Feb 25, 2005 at 10:10 am
    Feb 25, 2005 at 2:55 pm
  • Our dual opteron has been performing well for many weeks now (after some simple tuning) when all of a sudden the queries have slowed right down! ie: DUAL 246 OPTERON: select count(*) from ...
    SpaceBallOneSpaceBallOne
    Feb 25, 2005 at 7:41 am
    Feb 25, 2005 at 11:19 am
  • Hi - This is based on a discussion I was having with neilc on IRC. He suggested I post it here. Sorry for the length - I'm including everything he requested I'm comparing the speeds of the following ...
    David HaasDavid Haas
    Feb 22, 2005 at 7:05 am
    Feb 23, 2005 at 4:54 pm
  • The following query plans both result from the very same query run on different servers. They obviously differ drastically, but I don't why as one db is a slonied copy of the other with identical ...
    Luke ChambersLuke Chambers
    Feb 22, 2005 at 10:08 pm
    Feb 23, 2005 at 4:44 pm
  • I forgot you could do this...This would certainly be easier than parsing array values returned from array_accum. It will probably be faster as well...but with the array approach the query would not ...
    Merlin MoncureMerlin Moncure
    Feb 4, 2005 at 5:48 pm
    Feb 4, 2005 at 8:09 pm
  • Hi, I am trying to build a function that would extend the trigger in general tid bits that would only track count changes for table rows. The one i am trying to build would check which column and ...
    Hasnul Fadhly bin HasanHasnul Fadhly bin Hasan
    Feb 2, 2005 at 10:02 am
    Feb 3, 2005 at 8:01 am
  • Hi all, I have a freshly vacuumed table with 1104379 records with a index on zipcode. Can anyone explain why the queries go as they go, and why the performance differs so much (1 second versus 64 ...
    Joost KraaijeveldJoost Kraaijeveld
    Feb 1, 2005 at 6:55 pm
    Feb 1, 2005 at 8:07 pm
  • Hi *, I am looking for the fastest wal_sync_method (postgres 8, Linux (Redhat) 2.4.29, ext3, SCSI HW-Raid 5). Any experiences and/or tips?. Thanks in advance Stefan
    Stefan HansStefan Hans
    Feb 28, 2005 at 9:24 pm
    Feb 28, 2005 at 9:24 pm
  • Hi, All I'm trying to tune a software RAID 0 (striped) on a solaris 9, sparc box. Currently I'm using a raid 1 (mirrored) array on two discs for the data area, and I put in 4 new drives last night ...
    Tom ArthursTom Arthurs
    Feb 27, 2005 at 10:32 pm
    Feb 27, 2005 at 10:32 pm
  • Hello, I'm experiencing performance problems with 7.4.3 on OpenBSD 3.6, at least I think so. It is running on a Xeon 3 GHz with 2 GB RAM. I have a table with 22 columns, all integer, timestamp or ...
    Glenn KusardiGlenn Kusardi
    Feb 26, 2005 at 2:04 pm
    Feb 26, 2005 at 2:04 pm
  • Hi - This is based on a discussion I was having with neilc on IRC. He suggested I post it here. Sorry for the length - I'm including everything he requested. I'm comparing the speeds of the following ...
    David HaasDavid Haas
    Feb 22, 2005 at 6:48 am
    Feb 22, 2005 at 6:48 am
Group Navigation
period‹ prev | Feb 2005 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions56
posts375
users94
websitepostgresql.org
irc#postgresql

94 users for February 2005

Tom Lane: 45 posts Gaetano Mendola: 18 posts Greg Stark: 14 posts John Arbash Meinel: 14 posts Markus Schaber: 12 posts Merlin Moncure: 12 posts Pierre-Frédéric Caillaud: 11 posts Josh Berkus: 9 posts Richard Huxton: 9 posts Bruce Momjian: 8 posts Chris Browne: 8 posts Chris Kratz: 8 posts Joost Kraaijeveld: 7 posts Marinos Yannikos: 7 posts Mark Kirkwood: 7 posts Cosimo Streppone: 6 posts Dirk Lutzebaeck: 6 posts Iain: 6 posts Magnus Hagander: 6 posts Vig, Sandor (G/FI-2): 6 posts
show more
Archives