FAQ

PostgreSQL > pgsql-performance > October 2003

Search Discussions

76 discussions - 815 posts

  • It seems a simple "vacuum" (not full or analyze) slows down the database dramatically. I am running vacuum every 15 minutes, but it takes about 5 minutes to run even after a fresh import. Even with ...
    Rob NaglerRob Nagler
    Oct 17, 2003 at 3:00 pm
    Oct 31, 2003 at 1:31 am
  • Well, as you guys know I've been tinkering with sun-vs-linux postgres for a while trying to come up with reasons for the HUGE performance differences. We've all had our anecdotal thoughts (fork ...
    JeffJeff
    Oct 8, 2003 at 12:38 pm
    Oct 14, 2003 at 5:00 pm
  • Hi guys, I followed the discussion and here are my 0.2$: I think instead of thinking about where to put the information about tuning, someone should provide a "pgsql-autotune". Maybe even a shell ...
    Oliver ScheitOliver Scheit
    Oct 9, 2003 at 8:29 am
    Oct 14, 2003 at 6:43 pm
  • I've read some posts that says vacuum doesn't lock, but my experience today indicates the opposite. It seemed that "vacuum full analyze" was locked waiting and so were other postmaster processes. It ...
    Rob NaglerRob Nagler
    Oct 3, 2003 at 8:43 pm
    Oct 6, 2003 at 7:15 pm
  • Hi, I downloaded PostgreSQL 7.4beta4 and tried it out. It turns out that the index file is still bloating even after running vacuum or vacuum analyze on the table. Still, only reindex will claim the ...
    Seum-Lim GanSeum-Lim Gan
    Oct 18, 2003 at 9:53 pm
    Oct 24, 2003 at 8:24 pm
  • Hi, I have a somewhat large table, 3 million rows, 1 Gig on disk, and growing. Doing a count(*) takes around 40 seconds. Looks like the count(*) fetches the table from disk and goes through it. Made ...
    Dror MatalonDror Matalon
    Oct 2, 2003 at 7:16 pm
    Oct 6, 2003 at 5:02 pm
  • Hi, Pretty soon, a PowerEdge 6650 with 4 x 2Ghz XEONs, and 8GB Memory, with internal drives on RAID5 will be delivered. Postgres will be from RH8.0. I am planning for these values for the postgres ...
    Anjan DaveAnjan Dave
    Oct 21, 2003 at 3:11 pm
    Dec 14, 2003 at 5:56 pm
  • All, Anyone have any suggestions on how to efficiently compare rows in the same table? This table has 637 columns to be compared and 642 total columns. TIA, Greg -- Greg Spiegelberg Sr. Product ...
    Greg SpiegelbergGreg Spiegelberg
    Oct 8, 2003 at 2:08 pm
    Oct 10, 2003 at 4:45 pm
  • Hi, We're in the process of setting up a new database server. The application is an online rss aggregator which you can see at www.fastbuzz.com (still running with the old hardware). The new machine ...
    Dror MatalonDror Matalon
    Oct 26, 2003 at 7:45 pm
    Oct 27, 2003 at 7:26 pm
  • Hi, I have a query that ran quite well initially, but slowed down quite a bit once I introduced an aggregate into the equation. The average execution time went up from around 15 msec to around 300 ...
    Dror MatalonDror Matalon
    Oct 3, 2003 at 8:40 pm
    Oct 10, 2003 at 6:26 pm
  • Dear PostgreSQL gurus, I really not intend to start a flame war here but i am genuinely seeking help to retain PostgreSQL as my database for my RT system. Few months back i had posted regarding ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Oct 29, 2003 at 7:21 pm
    Nov 19, 2003 at 12:32 pm
  • I was testing to get some idea of how to speed up the speed of pgbench with IDE drives and the write caching turned off in Linux (i.e. hdparm -W0 /dev/hdx). The only parameter that seems to make a ...
    Scott.marloweScott.marlowe
    Oct 2, 2003 at 7:43 pm
    Dec 14, 2003 at 5:44 am
  • Hi, Old: Post 7.3.2, P4 1.8, 1 MB RAM, 2 x IDE SW RAID 1, RedHat 8 New: Post 7.3.4, Xeon 2.4, 1 MB RAM, 2 x SCSI 15k SW RAID 1, RedHat 9 Both use: Only postgresql on server. Buffers = 8192, effective ...
    Alexandre :: aldeia digitalAlexandre :: aldeia digital
    Oct 30, 2003 at 7:52 pm
    Nov 6, 2003 at 10:59 pm
  • ok this time it constructs a query which puts 7.3.4 on a infinite loop but 7.4b5 is able to come out of it. since it may be of interest to the pgsql people i am Ccing it to the pgsql-performance list ...
    Rajesh Kumar MallahRajesh Kumar Mallah
    Oct 29, 2003 at 8:45 pm
    Nov 1, 2003 at 5:48 am
  • I recalled seeing a thread on -HACKERS about some major improvements to the speed of adding an FK to an existing table in 7.4. Naturally I was curious and decided to give it a whirl. My findings are ...
    JeffJeff
    Oct 28, 2003 at 2:17 pm
    Oct 29, 2003 at 2:02 pm
  • Greetings. I have a table that will require 100,000 rows initially. Assume the following (some of the field names have been changed for confidentiality reasons): CREATE TABLE baz ( baz_number ...
    John PagakisJohn Pagakis
    Oct 23, 2003 at 12:18 pm
    Oct 27, 2003 at 10:11 am
  • Hi everyone, I've been trying to find out if some guidelines exist, somewhere, describing how postgres can possibly run on less than 8MB of RAM. (Disk space not an issue). The closest thread I could ...
    StefStef
    Oct 3, 2003 at 2:31 pm
    Oct 7, 2003 at 3:41 pm
  • We're having a problem with a query during our investigation into Postgres (as an Oracle replacement). This query Postgres takes 20-40 seconds (multiple runs). Tom Lan recommended I post it here, ...
    David GriffithsDavid Griffiths
    Oct 1, 2003 at 3:10 am
    Oct 4, 2003 at 12:58 pm
  • Hello all I have two very similar queries which I need to execute. They both have exactly the same from / where conditions. When I execute the first, it takes about 16 seconds. The second is executed ...
    Chris FaulknerChris Faulkner
    Oct 11, 2003 at 9:43 am
    Oct 14, 2003 at 6:16 pm
  • Hi, A simple question about PostgreSQL ... I have a Pentium Xeon Quadri processors ... If I do a SQL request ... does PostgreSQL use one or more processor ? And if it use only one ... why ? Could you ...
    Hervé PiedvacheHervé Piedvache
    Oct 10, 2003 at 4:31 pm
    Oct 13, 2003 at 6:44 pm
  • Asked and answered on the list probably a thousand times, but what else is there to discuss on the performance list? :) I recently built a rather powerful machine to be used in a heavily accessed ...
    Allen LandsidelAllen Landsidel
    Oct 23, 2003 at 1:25 pm
    Oct 27, 2003 at 4:08 pm
  • Boy, I must be getting annoying by now huh? Anyway, after the joys of Solaris being fast I'm moving onto another area - backup & restore. I've been checking the archives and haven't seen any "good" ...
    JeffJeff
    Oct 9, 2003 at 7:35 pm
    Oct 17, 2003 at 5:34 pm
  • I am running an update-query to benchmark various databases; the postgres version is, UPDATE user_account SET last_name = 'abc' WHERE user_account_id IN (SELECT user_account_id FROM ...
    David GriffithsDavid Griffiths
    Oct 11, 2003 at 7:37 pm
    Oct 13, 2003 at 6:56 pm
  • Yet another question.. thanks to everyone responding to all these so far.. ;) This one is basically.. given I have a big table already in COPY format, about 28 million rows, all keys guaranteed to be ...
    Allen LandsidelAllen Landsidel
    Oct 31, 2003 at 4:00 pm
    Oct 31, 2003 at 9:34 pm
  • I'm using pg 7.3.4 to do a select involving a join on 2 tables. The query is taking 15 secs which seems extreme to me considering the indices that exist on the two tables. EXPLAIN ANALYZE shows that ...
    Medora SchauerMedora Schauer
    Oct 22, 2003 at 2:49 pm
    Oct 27, 2003 at 6:33 am
  • Thanks. I googled around and found this page: http://www.domsch.com/linux/ Which says what each model is. It looks like the "RAID" controller they wanna charge me for is about $500 or so, so I'm ...
    Scott.marloweScott.marlowe
    Oct 21, 2003 at 8:48 pm
    Oct 23, 2003 at 5:00 pm
  • The boss cleared my de-company info-ified pg presentation. It deals with PG features, crude comparison to other dbs, install, admin, and most importantly - optimization & quirks. Its avail in ...
    JeffJeff
    Oct 8, 2003 at 3:03 pm
    Oct 8, 2003 at 11:29 pm
  • http://www.ussg.iu.edu/hypermail/linux/kernel/0310.1/0208.html Shridhar
    Shridhar DaithankarShridhar Daithankar
    Oct 9, 2003 at 11:13 am
    Oct 27, 2003 at 3:16 pm
  • Hi List, I got a P4 1.7Ghz , 512MB RAM , HD 7200 RPM, on RED HAT 9 running PostgreSQL 7.3.2-3 Database. I have a Delphi aplication that updates the Oracle database using .dbf file's information ( ...
    Rhaoni Chiu PereiraRhaoni Chiu Pereira
    Oct 20, 2003 at 2:16 pm
    Oct 22, 2003 at 4:59 pm
  • Hi All, We've been experiencing extremely poor batch upload performance on our Postgres 7.3 (and 7.3.4) database, and I've not been able to improve matters significantly using any suggestions I've ...
    Damien DouganDamien Dougan
    Oct 27, 2003 at 4:28 pm
    Oct 29, 2003 at 2:41 pm
  • It has been suggested to me that I resubmit this question to this list, rather than the GENERAL list it was originaly sent to. I asked earlier about ways of doing an UPDATE involving a left outer ...
    Harry BroomhallHarry Broomhall
    Oct 20, 2003 at 4:50 pm
    Oct 21, 2003 at 5:01 pm
  • Hi folks. I notice that immutable flag does nothing when i invoke my plpgsql function within one session with same args. tele=# SELECT version(); version ...
    Andriy TkachukAndriy Tkachuk
    Oct 8, 2003 at 1:17 pm
    Oct 13, 2003 at 7:36 am
  • List, I'm creating this multi company POS database. My inventory table looks like (all items are unique): id,category_id,invoice_id,x,y,z,gid,uid I have a primary key on id, and then an foreign keys ...
    David BusbyDavid Busby
    Oct 10, 2003 at 9:13 pm
    Oct 12, 2003 at 7:40 pm
  • Hi all, I haven't found any official documentation about the postgres sql optimizer on the web, so please forgive me if there is such a document and point me to the right direction. I've got the ...
    Dimitri NagievDimitri Nagiev
    Oct 1, 2003 at 5:31 pm
    Oct 1, 2003 at 7:12 pm
  • Hi, suppose, for simplicity, there is a table with index like this: create table TABLE1 ( A integer ); create index TABLE1_A on TABLE1 (A); My question is: why psql (7.3.3) does not use index when ...
    Cestmir HyblCestmir Hybl
    Oct 28, 2003 at 6:58 pm
    Nov 4, 2003 at 10:44 am
  • I'm running our DBT-2 workload against PostgreSQL 7.3.4 and I'm having some trouble figuring out what I should be looking for when I'm trying to tune the database. I have results for a decent ...
    MarkwMarkw
    Oct 22, 2003 at 12:24 am
    Oct 29, 2003 at 10:27 pm
  • Hi, I did a search in the discussion lists and found several pointers about setting the max_fsm_relations and pages. I have a table that keeps being updated and noticed that after a few days, the ...
    Seum-Lim GanSeum-Lim Gan
    Oct 13, 2003 at 9:11 am
    Oct 13, 2003 at 7:54 pm
  • Hello, I am running 7.3.2 RPMs on RH9, on a celeron 1.7 w/ 1gig ram. I have a table that has 6.9 million rows, 2 columns, and an index on each column. When I run: SELECT DISTINCT column1 FROM table ...
    Seth LaddSeth Ladd
    Oct 10, 2003 at 9:42 am
    Oct 10, 2003 at 11:17 am
  • Hi, I have a select like this: SELECT MAX(transactionid) FROM cbntransaction WHERE transactiontypeid=0; in the query: transactionid is the primary key of cbntransaction table, But transactiontypeid ...
    Rwu Cbnco ComRwu Cbnco Com
    Oct 2, 2003 at 5:04 pm
    Oct 2, 2003 at 8:12 pm
  • Hi When I do a SELECT * FROM pg_shadow, I can have more than one user with the same id. This caused the pg_dump to fail. I read that it happened in v7.1.2 and I am currently using v7.3.2 on Redhat ...
    ChewtcChewtc
    Oct 30, 2003 at 4:14 am
    Oct 30, 2003 at 4:32 am
  • Hi Currently we are running Postgresql v7.3.2 on Redhat Linux OS v9.0. We have Windows2000 client machines inserting records into the Postgresql tables via ODBC. After a few weeks of usage, when we ...
    ChewtcChewtc
    Oct 22, 2003 at 10:26 am
    Oct 23, 2003 at 1:48 am
  • Hello, While writing web application I found that it would be very nice for me to have "null" WHERE clause. Like WHERE 1=1. Then it is easy to concat additional conditions just using $query . " AND ...
    Mindaugas RiaubaMindaugas Riauba
    Oct 1, 2003 at 12:12 pm
    Oct 1, 2003 at 1:06 pm
  • Hi, I'am having major performance issues with post gre 7.3.1 db. Kindly suggest all the possible means by which i can optimize the performance of this database. If not all, some ideas (even if they ...
    Kamalraj Singh MadhanKamalraj Singh Madhan
    Oct 28, 2003 at 6:11 am
    Oct 28, 2003 at 4:15 pm
  • Folks, I’m hoping someone can give me some pointers to resolving an issue with postgres and it’s ability to utilize multiple CPUs effectively. The issue is that no matter how much query load we throw ...
    Simon SadedinSimon Sadedin
    Oct 22, 2003 at 2:58 pm
    Oct 22, 2003 at 6:00 pm
  • Is there any way to determine how much of the free space map is currently in use?(ie. where and what it is tracking?) I vacuum on a regular basis but I never hold in terms of disk space usage. I ...
    Jeremy M. GuthrieJeremy M. Guthrie
    Oct 14, 2003 at 5:01 pm
    Oct 16, 2003 at 9:39 pm
  • I've been having performance issues with Postgres (sequential scans vs index scans in an update statement). I've read that optimizer will change it's plan based on the resources it thinks are ...
    David GriffithsDavid Griffiths
    Oct 13, 2003 at 7:35 pm
    Oct 14, 2003 at 7:37 pm
  • Hello, Thanks to all the previous suggestions for my previous question. I've done a lot more research and playing around since then, and luckily I think I have a better understanding of postgresql. I ...
    Seth LaddSeth Ladd
    Oct 13, 2003 at 11:48 pm
    Oct 14, 2003 at 8:18 am
  • Hi, One other small question ... Does PostgreSQL is scalable ? I mean ... is it possible to have two servers, one rack of disks connected to the 2 servers to get access in same time to the same ...
    Hervé PiedvacheHervé Piedvache
    Oct 10, 2003 at 4:36 pm
    Oct 10, 2003 at 6:33 pm
  • We've a table with about 8 million rows, and we need to get rows by the value of two of its fields( the type of the fields are int2 and int4, the where condition is v.g. partido=99 and partida=123). ...
    Adrian DemaestriAdrian Demaestri
    Oct 8, 2003 at 2:09 pm
    Oct 8, 2003 at 3:21 pm
  • Ok, I asked this on [novice], but I was told it's be better to post it here... I've got some money to spend on a new servers. The biggest concern is the PostgreSQL database server that will "be the ...
    Jason HihnJason Hihn
    Oct 6, 2003 at 3:17 pm
    Oct 6, 2003 at 4:36 pm
Oct 2003
12
Group Navigation
period‹ prev | Oct 2003 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions76
posts815
users121
websitepostgresql.org
irc#postgresql

121 users for October 2003

Josh Berkus: 75 posts Tom Lane: 63 posts Jeff: 44 posts Bruce Momjian: 39 posts Scott.marlowe: 37 posts Vivek Khera: 28 posts Greg Stark: 25 posts Neil Conway: 24 posts Andrew Sullivan: 22 posts Shridhar Daithankar: 22 posts Dror Matalon: 21 posts Rob Nagler: 19 posts Christopher Kings-Lynne: 17 posts Rod Taylor: 16 posts Chris Browne: 15 posts David Griffiths: 14 posts Rajesh Kumar Mallah: 14 posts Hannu Krosing: 12 posts Oleg Lebedev: 12 posts Seum-Lim Gan: 10 posts
show more
Archives