FAQ

PostgreSQL > pgsql-performance > October 2010

Search Discussions

47 discussions - 605 posts

  • I know that there haven been many discussions on the slowness of count(*) even when an index is involved because the visibility of the rows has to be checked. In the past I have seen many suggestions ...
    Neil WhelchelNeil Whelchel
    Oct 9, 2010 at 11:26 pm
    Oct 21, 2010 at 11:10 pm
  • I'm weighing options for a new server. In addition to PostgreSQL, this machine will handle some modest Samba and Rsync load. I will have enough RAM so the virtually all disk-read activity will be ...
    Steve CrawfordSteve Crawford
    Oct 7, 2010 at 11:38 pm
    Dec 23, 2010 at 2:12 am
  • Hello Experts, My application uses Oracle DB, and makes use of OCI interface. I have been able to develop similar interface using postgreSQL library. However, I have done some tests but results for ...
    Divakar SinghDivakar Singh
    Oct 25, 2010 at 6:16 pm
    Oct 28, 2010 at 3:29 pm
  • Hi pgsql-performance, I was doing mass insertions on my desktop machine and getting at most 1 MB/s disk writes (apart from occasional bursts of 16MB). Inserting 1 million rows with a single integer ...
    Marti RaudseppMarti Raudsepp
    Oct 31, 2010 at 12:14 pm
    Nov 19, 2010 at 2:52 pm
  • I have an app which imports a lot of data into a temporary table, does a number of updates, creates some indexes, and then does a bunch more updates and deletes, and then eventually inserts some of ...
    Jon NelsonJon Nelson
    Oct 27, 2010 at 5:30 pm
    Nov 14, 2010 at 3:55 pm
  • Hello, What is the general view of performance CPU's nowadays when it comes to PostgreSQL performance? Which CPU is the better choice, in regards to RAM access-times, stream speed, cache ...
    Christian Elmerot @ One.comChristian Elmerot @ One.com
    Oct 25, 2010 at 10:00 am
    Dec 3, 2010 at 5:35 pm
  • Hi, for whom it may concern: http://pdos.csail.mit.edu/mosbench/ They tested with 8.3.9, i wonder what results 9.0 would give. Best regards and keep up the good work Hakan
    Hakan KocamanHakan Kocaman
    Oct 4, 2010 at 3:16 pm
    Oct 7, 2010 at 8:31 pm
  • currently PG 8.1.3. See attached for my postgresql.conf. Server is freebsd 6.2 w/ a fast 3TB storage array and only 2GB of ram. We're running RTG which is a like mrtg, cricket, etc. basically queries ...
    Aaron TurnerAaron Turner
    Oct 7, 2010 at 5:48 pm
    Oct 12, 2010 at 4:59 pm
  • We are in the process of testing migration of our oracle data warehouse over to postgres. A potential showstopper are full table scans on our members table. We can't function on postgres effectively ...
    Tony CapobiancoTony Capobianco
    Oct 14, 2010 at 7:49 pm
    Oct 15, 2010 at 7:23 pm
  • There was some doubt as for the speed of doing the select count(*) in PostgreSQL and Oracle. To that end, I copied the most part of the Oracle table I used before to Postgres. Although the copy ...
    Mladen GogalaMladen Gogala
    Oct 16, 2010 at 4:52 pm
    Oct 28, 2010 at 1:34 pm
  • Hello, We are using PostgreSQL for storing data and full-text search indexes for the webiste of a daily newspaper. We are very happy overall with the results, but we have one "weird" behaviour that ...
    Gael Le MignotGael Le Mignot
    Oct 21, 2010 at 12:52 pm
    Oct 22, 2010 at 3:11 pm
  • hello -- my last email was apparently too long to respond to so i'll split it up into shorter pieces. my first question : my understanding of how range partitioning and constraint exclusion works ...
    BenBen
    Oct 28, 2010 at 4:37 pm
    Oct 29, 2010 at 4:28 pm
  • Hi all, We are tuning a PostgreSQL box with AIX 5.3 and got stucked in a very odd situation. When a query got ran for the second time, the system seems to deliver the results to slow. Here´s some ...
    André VolpatoAndré Volpato
    Oct 25, 2010 at 6:28 pm
    Oct 28, 2010 at 12:33 pm
  • Folks, I am running into a problem with the postmaster: from time to time, it runs for a long time. E.g., from top: 23425 postgres 20 0 22008 10m 10m R 99.9 0.5 21:45.87 postmaster I'd like to figure ...
    Dimi PaunDimi Paun
    Oct 20, 2010 at 7:07 pm
    Oct 21, 2010 at 2:39 am
  • I have the following query: select distinct Region.RegionShort as RegionShort ,County.County as County from Region join PostalCodeRegionCountyCity on ...
    Ozer, PamOzer, Pam
    Oct 26, 2010 at 11:27 pm
    Oct 29, 2010 at 10:10 pm
  • Hi, We have done the following test with PostgreSQL 9.0. create table bytea_demo ( index int, part1 bytea)"); Then we have instantiated a loop (1000) with the following action: insert into bytea_demo ...
    Sander, Ingo (NSN - DE/Munich)Sander, Ingo (NSN - DE/Munich)
    Oct 5, 2010 at 7:32 am
    Oct 12, 2010 at 12:36 pm
  • I have the following query running on 8.4, which takes 3516 ms. It is very straight forward. It brings back 116412 records. The explain only takes 1348ms select VehicleUsed.VehicleUsedId as ...
    Ozer, PamOzer, Pam
    Oct 19, 2010 at 6:22 pm
    Oct 28, 2010 at 4:18 pm
  • CentOS 5.4 and 5.5 Query SELECT sum(usramt) as givensum, sum (case when usedid 0 then usramt else 0 end) as usedsum FROM argrades WHERE userstatus in (5) and membid in (select distinct members.membid ...
    Francisco ReyesFrancisco Reyes
    Oct 27, 2010 at 12:48 pm
    Dec 29, 2010 at 2:27 am
  • postgres 8.4.4 on openSUSE 11.3 (2.6.36rc7, x86_64). I was watching a fairly large query run and observed that the disk light went out. I checked 'top' and postgres was using 100% CPU so I strace'd ...
    Jon NelsonJon Nelson
    Oct 15, 2010 at 5:23 am
    Oct 27, 2010 at 3:57 am
  • At present for reporting I use following types of query: select crm.*, crm_cnt.cnt from crm, (select count(*) as cnt from crm) crm_cnt; Here count query is used to find the total number of records. ...
    AI RummanAI Rumman
    Oct 18, 2010 at 5:16 am
    Oct 28, 2010 at 6:18 pm
  • 8.4.5 I consistently see HashJoin plans that hash the large table, and scan the small table. This is especially puzzling in some cases where I have 30M rows in the big table and ~ 100 in the small... ...
    Scott CareyScott Carey
    Oct 19, 2010 at 1:39 am
    Oct 27, 2010 at 7:56 pm
  • Which one is faster? select count(*) from talble or select count(id) from table where id is the primary key.
    AI RummanAI Rumman
    Oct 26, 2010 at 10:56 am
    Oct 26, 2010 at 12:33 pm
  • Hi, I have a Linux Server (Debian) with Postgres 8.3 and I have problems with a massive update, about 400000 updates/inserts. If I execute about 100000 it seems all ok, but when I execute 400000, I ...
    Trenta sisTrenta sis
    Oct 27, 2010 at 6:38 pm
    Oct 28, 2010 at 10:28 pm
  • Hello, I have heard it said that if a stored procedure is declared as VOLATILE, then no good optimizations can be done on queries within the stored procedure or queries that use the stored procedure ...
    Damon SnyderDamon Snyder
    Oct 11, 2010 at 11:40 pm
    Oct 25, 2010 at 11:54 pm
  • Hi, everyone. I'm working with a client to try to optimize their use of PostgreSQL. They're running 8.3 on a Windows platform, packaged as part of a physical product that is delivered to customers. ...
    Reuven M. LernerReuven M. Lerner
    Oct 13, 2010 at 7:40 am
    Oct 14, 2010 at 2:41 pm
  • Simon, Greg, etc., Just barked my nose against a major performance issue with CE & partitioning, and was wondering if anyone had poked at it. The issue is this: when a partitioned table is evaluated ...
    Josh BerkusJosh Berkus
    Oct 1, 2010 at 11:46 pm
    Oct 4, 2010 at 11:37 pm
  • We currently have log_min_duration_statement = 5000 and are seeing statements like the following logged 2010-10-16 05:55:52 EDT [6334]: [1-1] LOG: duration: 5572.517 ms statement: EXECUTE <unnamed ...
    Eric ComeauEric Comeau
    Oct 16, 2010 at 12:53 pm
    Oct 19, 2010 at 2:25 pm
  • I don't know why seq scan is running on the following query where the same query is giving index scan on other servers: explain analyze select * from act where act.acttype in ( ...
    AI RummanAI Rumman
    Oct 21, 2010 at 5:25 am
    Oct 21, 2010 at 8:14 pm
  • Hi Guys, I am interested in finding out the pros/cons of using UUID as a primary key field. My requirement states that UUID would be perfect in my case as I will be having many small databases which ...
    Navkirat SinghNavkirat Singh
    Oct 16, 2010 at 1:58 am
    Oct 16, 2010 at 7:35 pm
  • I hit an issue with window aggregate costing while experimenting with providing a count of the full match along side a limited result set. Seems that the window aggregate node doesn't take into ...
    Ants AasmaAnts Aasma
    Oct 13, 2010 at 5:16 pm
    Oct 14, 2010 at 10:17 am
  • Are there any performance implications (benefits) to executing queries in a transaction where SET TRANSACTION READ ONLY; has been executed? -- Jon
    Jon NelsonJon Nelson
    Oct 12, 2010 at 5:25 pm
    Oct 12, 2010 at 9:17 pm
  • I've been having trouble with a query. The query is a cross join between two tables. Initially, I mis-typed the query, and one of the columns specified in the query doesn't exist, however the query ...
    Jon NelsonJon Nelson
    Oct 29, 2010 at 4:45 pm
    Oct 29, 2010 at 7:07 pm
  • Now that some of my recent writing has gone from NDA protected to public sample, I've added a new page to the PostgreSQL wiki that provides a good starting set of resources to learn about an ever ...
    Greg SmithGreg Smith
    Oct 21, 2010 at 2:08 pm
    Oct 21, 2010 at 4:09 pm
  • All, There's a number of blog tests floating around comparing XFS and Ext3, and the various Linux schedulers, for PGDATA or for an all-in-one mount. However, the WAL has a rather particular write ...
    Josh BerkusJosh Berkus
    Oct 6, 2010 at 11:11 pm
    Oct 11, 2010 at 6:59 pm
  • Hi experts, I have a (near) real-time application in which inserts into the database needs to be visible to queries from other threads with minimal delay. The inserts are triggered by real-time ...
    Steve WongSteve Wong
    Oct 25, 2010 at 6:46 pm
    Oct 29, 2010 at 5:18 pm
  • I have a table with an array column. I added a GIN index to the array: CREATE INDEX foo_idx ON t USING GIN (alternatecodes) WHERE alternatecodes IS NOT NULL; That's all well and good. However, some ...
    Jon NelsonJon Nelson
    Oct 18, 2010 at 8:59 pm
    Oct 19, 2010 at 2:48 am
  • Hello people, I'm having trouble to persuade index scan to check all of the conditions I specify _inside_ index cond. That is, _some_ condition always get pushed out of index cond and applied later ...
    Nikolai ZhubrNikolai Zhubr
    Oct 14, 2010 at 3:37 pm
    Oct 15, 2010 at 8:47 pm
  • I have more than 1300000 records in crm table and I partioned the table with deleted = 0 key. It is working fine except that after partioion query is taking more time than the previous one. I already ...
    AI RummanAI Rumman
    Oct 10, 2010 at 9:52 am
    Oct 10, 2010 at 11:05 am
  • Hey Turned on log_min_duration_statement today and started getting timings on sql statements (version 8.3.10). Can anyone please tell me how to interpret the (S_nn/C_nn) information in the log line. ...
    Mark RostronMark Rostron
    Oct 25, 2010 at 10:37 pm
    Oct 25, 2010 at 10:54 pm
  • Hello I have an application hosted on Heroku. They use postgres. It's more or less abstracted away, but I can get some performance data from New Relic. For the most part, performance is ok, but now ...
    Brandon CasciBrandon Casci
    Oct 14, 2010 at 9:43 am
    Oct 15, 2010 at 6:35 pm
  • I've got a few tables that periodically get entirely refreshed via a COPY. I don't really have a good mechanism for detecting only rows which have changed so even though the differences are small, a ...
    Samuel GendlerSamuel Gendler
    Oct 12, 2010 at 9:16 pm
    Oct 12, 2010 at 9:22 pm
  • I need to join two tales say TAB_A and TAB_B, where TAB_A is greater than TAB_B in size and records. Which Table should I put first in join order? Any idea please.
    AI RummanAI Rumman
    Oct 11, 2010 at 6:43 am
    Oct 11, 2010 at 6:47 am
  • Hi All, We have been trying to implement the streaming replication on one of our test servers. We have set archive_xlogs to on. But on the standby server, when we start the database we get error the ...
    Nimesh SatamNimesh Satam
    Oct 5, 2010 at 9:11 am
    Oct 5, 2010 at 9:05 pm
  • Hello, Does anyone have any experience with running postgreSQL on Blue Arc's network storage products? In particular, we are interested in the the Titan and Mercury series: ...
    Tim GoodaireTim Goodaire
    Oct 21, 2010 at 7:00 pm
    Oct 21, 2010 at 7:00 pm
  • Hello I have an application hosted on Heroku. They use postgres. It's more or less abstracted away, but I can get some performance data from New Relic. For the most part, performance is ok, but now ...
    Brandon CasciBrandon Casci
    Oct 14, 2010 at 11:17 am
    Oct 14, 2010 at 11:17 am
  • Sorry to forget to give the postgres version as 8.1 -- regards, Srikanth Kata
    Srikanth KSrikanth K
    Oct 7, 2010 at 9:37 am
    Oct 7, 2010 at 9:37 am
  • Hi all. I laready posted this a couple of months ago on -hackers: http://archives.postgresql.org/pgsql-hackers/2010-07/msg01519.php I've also been directed to ask here for better and deeper details. ...
    Vincenzo RomanoVincenzo Romano
    Oct 7, 2010 at 7:15 am
    Oct 7, 2010 at 7:15 am
Oct 2010
Group Navigation
period‹ prev | Oct 2010 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions47
posts605
users113
websitepostgresql.org
irc#postgresql

113 users for October 2010

Tom Lane: 54 posts Mladen Gogala: 35 posts Robert Haas: 35 posts Merlin Moncure: 30 posts Greg Smith: 28 posts Kevin Grittner: 27 posts Jon Nelson: 22 posts Craig Ringer: 17 posts Neil Whelchel: 16 posts Scott Carey: 15 posts Scott Marlowe: 15 posts Josh Berkus: 12 posts Samuel Gendler: 12 posts Divakar Singh: 11 posts Jesper Krogh: 11 posts Bruce Momjian: 9 posts Joshua D. Drake: 9 posts David: 8 posts AI Rumman: 8 posts Ozer, Pam: 8 posts
show more
Archives