FAQ

Search Discussions

30 discussions - 269 posts

  • Hi all, I've started to display the effects of changing the Linux block device readahead buffer to the sequential read performance using fio. There are lots of raw data buried in the page, but this ...
    Mark WongMark Wong
    Sep 10, 2008 at 6:53 am
    Sep 15, 2008 at 5:33 pm
  • Hi, I have a single table with about 10 million rows, and two indexes. Index A is on a column A with 95% null values. Index B is on a column B with about 10 values, ie. About a million rows of each ...
    David WestDavid West
    Sep 1, 2008 at 12:31 pm
    Sep 4, 2008 at 7:55 pm
  • Hi, there. I have encountered an issue that there are too many clog file under the .../pg_clog/ directory. Some of them were even produced one month ago. My questions: - Does Vacuum delete the old ...
    Duan LigongDuan Ligong
    Sep 1, 2008 at 11:23 am
    Sep 10, 2008 at 6:04 pm
  • I've just had an interesting encounter with the slow full table update problem that is inherent with MVCC The system is 64 bit linux with 2.6.25 kernel feeding scsi disks. the table is CREATE TABLE ...
    John HuttleyJohn Huttley
    Sep 25, 2008 at 7:25 pm
    Sep 29, 2008 at 4:12 am
  • I'm about to buy a new server. It will be a Xeon system with two processors (4 cores per processor) and 16GB RAM. Two RAID extenders will be attached to an Intel s5000 series motherboard, providing ...
    Laszlo NagyLaszlo Nagy
    Sep 11, 2008 at 4:45 pm
    Sep 23, 2008 at 7:00 pm
  • Hello, postmaster heavily loads processor. The database is accessed from java aplication (with several threads), C applications and from PHP scripts. It seems that one php script, called periodicaly, ...
    KikiKiki
    Sep 25, 2008 at 7:42 pm
    Sep 29, 2008 at 1:15 pm
  • Greetings, I'm relatively new to PostgreSQL but I've been in the IT applications industry for a long time, mostly in the LAMP world. One thing I'm experiencing some trouble with is running a COPY of ...
    Ryan HansenRyan Hansen
    Sep 10, 2008 at 4:48 pm
    Sep 11, 2008 at 1:25 am
  • If like me you've been reading all the flash SSD drive reviews that come out, you might have also noticed that the performance on write-heavy workloads hasn't been too far ahead of traditional ...
    Greg SmithGreg Smith
    Sep 8, 2008 at 11:12 pm
    Sep 24, 2008 at 11:12 am
  • I have the honor to be configuring Postgres to back into a NetApp FAS3020 via fiber. Does anyone know if the SAN protects me from breakage due to partial page writes? If anyone has an SAN specific ...
    Nikolas EverettNikolas Everett
    Sep 3, 2008 at 4:03 pm
    Sep 8, 2008 at 10:35 pm
  • Hello I'm running pgsql 8.1.11 (from debian stable) on a server with 16GB RAM (Linux helios 2.6.18-6-amd64 #1 SMP Tue Aug 19 04:30:56 UTC 2008 x86_64 GNU/Linux). I have a table "tickets" with 1 000 ...
    PaulPaul
    Sep 29, 2008 at 1:43 pm
    Oct 3, 2008 at 10:11 am
  • List, I'm a bit confused as to why this query writes to the disk: SELECT count(*) FROM bigbigtable WHERE customerid IN (SELECT customerid FROM smallcustomertable) AND x != 'special' AND y IS NULL It ...
    Nikolas EverettNikolas Everett
    Sep 18, 2008 at 5:30 pm
    Sep 18, 2008 at 6:58 pm
  • When displaying information about information about an user in our site, I noticed an unreasonable slowdown. The culprit turned out to be a trivial select, which determines the number of comments ...
    EinarsEinars
    Sep 24, 2008 at 12:53 am
    Sep 24, 2008 at 4:07 am
  • Hi, I have a virtual server with 256 MB of RAM. I am using it as a webserver, mailserver and for postgres. So there is something like 150MB left for postgres. Here are my configs (I haven't ...
    UlrichUlrich
    Sep 4, 2008 at 7:24 pm
    Sep 4, 2008 at 8:48 pm
  • I have two identical databases that run the same query each morning. Starting this morning, something caused the first db to start using a different execution plan for the query, resulting in much ...
    Doug EckDoug Eck
    Sep 29, 2008 at 4:00 pm
    Sep 30, 2008 at 12:17 am
  • Hello, I'm running into performance issues with various queries on a PostgreSQL database (of books). I'm having trouble understanding the thinking behind the query planner in this scenario: ...
    Colin CopelandColin Copeland
    Sep 23, 2008 at 9:32 pm
    Sep 24, 2008 at 7:22 pm
  • Hi there, I am still concerned about this problem, because there is a big differences between the two cases, and I don't know how to identify the problem. Can anybody help me, please ? TIA, Sabin
    Sabin CoandaSabin Coanda
    Sep 22, 2008 at 9:04 pm
    Sep 24, 2008 at 11:06 am
  • I've recently installed another drive in my db server and was wondering what the best use of it is. Some thoughts I have are: 1. Move some of the databases to the new drive. If this is a good idea, ...
    Rainer MagerRainer Mager
    Sep 9, 2008 at 2:20 am
    Sep 9, 2008 at 5:13 am
  • Hello, I am running a select on a large table with two where conditions. Explain analyze shows that the estimated number of rows returned (190760) is much more than the actual rows returned (58221), ...
    Kiran MukhyalaKiran Mukhyala
    Sep 4, 2008 at 6:22 pm
    Oct 10, 2008 at 6:46 pm
  • Hi again, Should I use gjournal on FreeBSD 7? Or just soft updates? Here is my opinion: I suspect that gjournal would be much slower than soft updates. Also gjournal is relatively new code, not very ...
    Laszlo NagyLaszlo Nagy
    Sep 24, 2008 at 10:18 am
    Sep 24, 2008 at 3:05 pm
  • Hi everyone, some erp software requires a change of my pgsql cluster from locale C encoding UTF-8 to locale de_DE.UTF-8 encoding UTF-8 Most of my databases have only ASCII text data (8 bit UTF8 code ...
    Axel RauAxel Rau
    Sep 7, 2008 at 11:06 am
    Sep 11, 2008 at 10:33 am
  • I'm trying to optimize postgres performance on a headless solid state hardware platform (no fans or disks). I have the database stored on a USB 2.0 flash drive (hdparm benchmarks reads at 10 MB/s). ...
    George McCollisterGeorge McCollister
    Sep 12, 2008 at 2:48 pm
    Oct 19, 2008 at 5:52 am
  • Hi all. I'm having an interesting time performance-wise with a set of indexes. Any clues as to what is going on or tips to fix it would be appreciated. My application runs lots of queries along the ...
    Matthew WakelingMatthew Wakeling
    Sep 25, 2008 at 12:07 pm
    Sep 25, 2008 at 1:32 pm
  • I have two identical queries except for the date range. In the first case, with the wider date range, the correct (I believe) index is used. In the second case where the date range is smaller a ...
    Rainer MagerRainer Mager
    Sep 19, 2008 at 12:34 am
    Sep 19, 2008 at 6:43 pm
  • Moving this thread to Performance alias as it might make more sense for folks searching on this topic: Greg Smith wrote: I redid a quick test with the same workload on one of my systems with SF 10 ...
    Jignesh K. ShahJignesh K. Shah
    Sep 12, 2008 at 3:30 am
    Sep 12, 2008 at 4:47 am
  • Hi ! To improve our software insert datas performance, we have decided to use partition architecture in our database. It works well for the following volume : 45 main tables and 288 inherited ...
    S CailletS Caillet
    Sep 3, 2008 at 10:00 am
    Sep 4, 2008 at 4:02 pm
  • Hi, Is it possible to put Statement timeout at User Level. Like If i have a user like 'guest', Can i put a statement timeout for it. -- Regards Gauri
    Gauri KanekarGauri Kanekar
    Sep 18, 2008 at 5:07 am
    Sep 18, 2008 at 7:35 am
  • Hi out there, I've some little questions, perhaps you can help me... At the moment, we're planning our new clustered ERP system which consists of a java application server and a postgresql database. ...
    Andre BrandtAndre Brandt
    Sep 9, 2008 at 2:08 pm
    Sep 9, 2008 at 6:15 pm
  • for a short test purpose, I would like to see what queries are running and how long each of them takes.....by reconfiguring postgres.conf on the server level. log_statement = 'all' is giving me the ...
    Jessica RichardJessica Richard
    Sep 2, 2008 at 6:47 pm
    Sep 2, 2008 at 7:41 pm
  • Preliminaries: pg 8.3.3 on ubuntu 7.10 4x1.66GHz CPUs 10G ram interesting postgresql.conf settings: max_connections = 300 shared_buffers = 3000MB work_mem = 32MB random_page_cost = 1.5 ...
    Scott MarloweScott Marlowe
    Sep 8, 2008 at 4:36 pm
    Sep 8, 2008 at 4:36 pm
  • Hello, we had problems with queries via dblink needing more than three times as long as without dblink on the same server. This has been tested with v8.3.3 as well. Is this still an issue?: ...
    Jan-Peter SeifertJan-Peter Seifert
    Sep 3, 2008 at 8:59 am
    Sep 3, 2008 at 8:59 am
Group Navigation
period‹ prev | Sep 2008 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions30
posts269
users73
websitepostgresql.org
irc#postgresql

73 users for September 2008

Scott Marlowe: 26 posts Scott Carey: 23 posts Greg Smith: 20 posts Tom Lane: 15 posts Matthew Wakeling: 13 posts John Huttley: 9 posts Albe Laurenz: 7 posts Nikolas Everett: 7 posts Thomas Finneid: 7 posts Kiki: 6 posts David West: 6 posts Guillaume Cottenceau: 6 posts Matt Smiley: 6 posts David: 5 posts Duan Ligong: 5 posts Gregory Stark: 5 posts Bruce Momjian: 4 posts Kevin Grittner: 4 posts Rainer Mager: 4 posts Alan Hodgson: 3 posts
show more
Archives