Search Discussions

40 discussions - 330 posts

  • If I run " dd if=/dev/zero bs=1024k of=file count=1000 " iostat shows me: Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn sda 671.50 88.00 113496.00 176 226992 However postgres 8.3.7 doing a bulk ...
    Joseph SJoseph S
    Aug 28, 2009 at 6:58 am
    Aug 31, 2009 at 7:16 pm
  • That's part of your problem. (Well, that's understating it; we don't have any real evidence that you have any performance problems *not* resulting from failure to do normal configuration.) If you ...
    Kevin GrittnerKevin Grittner
    Aug 26, 2009 at 11:03 pm
    Aug 29, 2009 at 9:49 pm
  • The writer process seems to be using inordinate amounts of memory: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 11088 postgres 13 -2 3217m 2.9g 2.9g S 0 38.7 0:10.46 postgres: writer process ...
    Aug 13, 2009 at 4:51 am
    Aug 18, 2009 at 4:33 am
  • All, I've just been tweaking some autovac settings for a large database, and came to wonder: why does vacuum_max_freeze_age default to such a high number? What's the logic behind that? AFAIK, you ...
    Josh BerkusJosh Berkus
    Aug 11, 2009 at 9:14 pm
    Aug 14, 2009 at 3:11 am
  • Hi, AFAIUI, work_mem is used for some operations (sort, hash, etc) for avoiding the use of temp files on disk... In a client server i'm monitoring (pg 8.3.7, 32GB of ram) work_mem is set to 8MB, ...
    Jaime CasanovaJaime Casanova
    Aug 20, 2009 at 12:45 am
    Jan 13, 2010 at 5:02 pm
  • Dear users, I try to optimize the time of my Postgresql-requests, but for that, the first step, I of course need to get that time. I know that with: EXPLAIN ANALYSE SELECT bundesland from bundesland ...
    Kai BehnckeKai Behncke
    Aug 17, 2009 at 4:38 pm
    Sep 1, 2009 at 1:11 am
  • I have a database (699221). It contains of 1.8GB data (707710). I am doing a complex query. Which required to load a 80MB index (732287). I restarted Postgresql so the cache is empty and it has to ...
    Ip Wing Kin JohnIp Wing Kin John
    Aug 6, 2009 at 2:51 am
    Aug 10, 2009 at 12:02 pm
  • I'm on a CentOS 5 OS 64 bit, latest kernel and all of that. PG version is 8.3.7, compiled as 64bit. The memory is 8GB. It's a 2 x Dual Core Intel 5310. Hard disks are Raid 1, SCSI 15 rpm. The server ...
    Phoenix KiulaPhoenix Kiula
    Aug 19, 2009 at 1:33 pm
    Aug 20, 2009 at 12:51 pm
  • Hi, I am using int8 field to pack a number of error flags. This is very common technique for large tables to pack multiple flags in one integer field. For most records - the mt_flags field is 0. Here ...
    Slava MoudrySlava Moudry
    Aug 17, 2009 at 8:17 pm
    Aug 21, 2009 at 8:12 pm
  • I'm seeing some interesting behaviour. I'm executing a query where I perform a merge join between two copies of the same table, completely symmetrically, and the two sides of the merge are sourced ...
    Matthew WakelingMatthew Wakeling
    Aug 18, 2009 at 1:20 pm
    Nov 18, 2009 at 11:39 am
  • Is this a TODO? -- Bruce Momjian <bruce@momjian.us http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
    Bruce MomjianBruce Momjian
    Aug 8, 2009 at 6:02 am
    Aug 8, 2009 at 8:32 pm
  • All, Not sure what's wrong in below execution plan but at times the query runs for 5 minutes to complete and after a while it runs within a second or two. Here is explain analyze out of the query. ...
    Subbiah Stalin-XCGF84Subbiah Stalin-XCGF84
    Aug 3, 2009 at 5:17 pm
    Aug 5, 2009 at 7:42 pm
  • Let's take the following EXPLAIN results: ticker=# explain select * from post, forum where forum.name = post.forum and invisible < 1 and to_tsvector('english', message) @@ to_tsquery('violence') ...
    Karl DenningerKarl Denninger
    Aug 18, 2009 at 8:00 pm
    Aug 19, 2009 at 10:19 am
  • Hi All, We are improving our network appliance monitoring system, and are evaluating using PostgreSQL as the back-end traffic statistics database (we're currently running a home-grown Berkeley-DB ...
    Hrishikesh (हृषीकेश मेहेंदळे)Hrishikesh (हृषीकेश मेहेंदळे)
    Aug 26, 2009 at 5:31 pm
    Sep 1, 2009 at 10:12 pm
  • Hello, We are using PostgreSQL to index a huge collection (570 000) of articles for a french daily newspaper (Libération). We use massively the full text search feature. I attach to this mail the ...
    Gaël Le MignotGaël Le Mignot
    Aug 21, 2009 at 2:14 pm
    Aug 27, 2009 at 10:20 pm
  • Hi all; we've been fighting this query for a few days now. we bumped up the statistict target for the a.id , c.url_hits_id and the b.id columns below to 250 and ran an analyze on the relevant tables. ...
    Kevin KempterKevin Kempter
    Aug 19, 2009 at 4:28 pm
    Aug 20, 2009 at 12:03 pm
  • Just stumbled across this recent article published in the Communications of the ACM: http://cacm.acm.org/magazines/2009/8/34493-the-pathologies-of-big-data/fulltext The author shares some insights ...
    Josh KupershmidtJosh Kupershmidt
    Aug 7, 2009 at 8:18 pm
    Aug 8, 2009 at 9:24 am
  • I'm seeing an interesting phenomenon while I'm trying to performance-optimise a GiST index. Basically, running a performance test appears to be the same thing as running a random number generator. ...
    Matthew WakelingMatthew Wakeling
    Aug 4, 2009 at 4:06 pm
    Aug 5, 2009 at 2:12 pm
  • Hi, Our fine manual says: """ The amount of memory used in shared memory for WAL data. The default is 64 kilobytes (64kB). The setting need only be large enough to hold the amount of WAL data ...
    Jaime CasanovaJaime Casanova
    Aug 20, 2009 at 12:25 am
    Aug 25, 2009 at 9:45 pm
  • Hello All, I'm developing specialized message switching system and I've chosen to use PostgreSQL as general tool to handle transactions, store and manage all the data. This system has pretty strong ...
    Aug 12, 2009 at 4:41 pm
    Aug 13, 2009 at 1:52 pm
  • Hello, I'm trying to optimize the follow query which returns the top users ordered by ranking. I'll show you my schema and "explain analyze" for each case. So, i'm asking two things: 1) Why "ranking" ...
    Aug 8, 2009 at 6:08 am
    Aug 10, 2009 at 1:30 am
  • Hey, I seem to be unable to get postgres to use a gist index we have on a circle data type. Table "public.tradesmen_profiles" Column | Type | Modifiers ...
    Gavin LoveGavin Love
    Aug 24, 2009 at 4:51 pm
    Aug 24, 2009 at 5:47 pm
  • Hi all; I have a simple query against two very large tables ( 800million rows in theurl_hits_category_jt table and 9.2 million in the url_hits_klk1 table ) I have indexes on the join columns and I've ...
    Kevin KempterKevin Kempter
    Aug 20, 2009 at 11:09 pm
    Aug 24, 2009 at 2:45 pm
  • Hi Everyone, I manage a freeBSD server that is dedicated to postgresql. The machine has 4 gigs of ram and there is a single database powering a web application that is hosted on a neighboring ...
    Culley HarrelsonCulley Harrelson
    Aug 7, 2009 at 9:26 pm
    Aug 18, 2009 at 2:12 pm
  • On Thu, 4 Jun 2009 06:57:57 -0400, Robert Haas wrote in http://archives.postgresql.org/pgsql-performance/2009-06/msg00065.php : I apologize if it is bad form to respond to a message that is two ...
    Jeff JanesJeff Janes
    Aug 14, 2009 at 1:18 am
    Aug 16, 2009 at 9:55 pm
  • 8.4 has vastly improved the warm-standby features, but it looks to me like this is still an installation-wide backup, not a per-database backup. That is, if you have (say) a couple hundred databases, ...
    Craig JamesCraig James
    Aug 14, 2009 at 9:26 pm
    Aug 15, 2009 at 8:11 am
  • developer came by and asked me an interesting question. If he has a view with 20 columns in it, and he selects a specific column from the view in his query. Does the engine when accessing the view ...
    David KerrDavid Kerr
    Aug 13, 2009 at 4:08 pm
    Aug 13, 2009 at 11:14 pm
  • Hi, I am using postgresql 8.3 with FreeBSD. FreeBSD is using syslog by default for postgresql logs. I would like to disable syslog in postgresql.conf. Does this change increase the performance? What ...
    Ibrahim HarraniIbrahim Harrani
    Aug 4, 2009 at 9:16 pm
    Aug 7, 2009 at 7:57 pm
  • PostgreSQL 8.3 Linux RedHat 4.X 24G of memory When loading a file generated from pg_dumpall is there a key setting in the configuration file that would allow the load to work faster. Thanks, Lance ...
    Campbell, LanceCampbell, Lance
    Aug 6, 2009 at 6:43 pm
    Aug 7, 2009 at 7:37 am
  • Hi, I have a question about a db-wide vacuum that I am running that is taking a much longer time than normal. We switched over to our warm standby server today -- which is virtually identical to the ...
    Aug 27, 2009 at 11:02 pm
    Aug 28, 2009 at 12:20 am
  • I'm trying to execute a query to take a row from a table, and return multiple rows, one per integer in the range between two of the fields in that row, for all rows in the table. Perhaps a better ...
    Matthew WakelingMatthew Wakeling
    Aug 13, 2009 at 2:16 pm
    Aug 13, 2009 at 2:36 pm
  • Hi All, I encountered an odd issue regarding check constraints complaining when they're not really violated. For this particular machine, I am running 8.3.7, but on a machine running 8.3.5, it seems ...
    Aug 4, 2009 at 6:23 pm
    Aug 4, 2009 at 11:37 pm
  • Dear all, I am migrating a large PhpBB forum to Drupal. What memory monitoring tool would you recommend? I never used one before in PostgreSQL. The only figures I read are those from VACUUM VERBOSE ...
    Jean-Michel PouréJean-Michel Pouré
    Aug 28, 2009 at 9:02 pm
    Aug 28, 2009 at 11:16 pm
  • Dear friends, I contact on Postgresql hackers request. I am running into a systemic problem using Drupal under PostgreSQL 8.4 Drupal relies heavily on a domain derived from int: CREATE DOMAIN ...
    Jean-Michel PouréJean-Michel Pouré
    Aug 26, 2009 at 2:40 pm
    Aug 26, 2009 at 3:00 pm
  • Asking the Performance people as well, since I didn't get any answer from General... I have been unable to create a multi column index with 2 integers as well, same error as the one I get with 2 ...
    Fred JanonFred Janon
    Aug 25, 2009 at 9:30 am
    Aug 26, 2009 at 2:08 pm
  • hi, i have a query that uses a Hash-Join, but it would be faster with Nested-Loop, and i don't know how to persuade postgresql to do it. details: postgresql-8.2 + tsearch2 i have 2 tables, one for ...
    Gábor FarkasGábor Farkas
    Aug 24, 2009 at 6:54 am
    Aug 24, 2009 at 2:37 pm
  • Hi, in a web app we have a query that we want to show in limited results at a time, this one executes in 10 seconds if i use limit but executes in 300ms if i remove it. why is that happening? the ...
    Jaime CasanovaJaime Casanova
    Aug 21, 2009 at 1:50 am
    Aug 23, 2009 at 9:41 pm
  • Hi, As of today, we are still enjoying our Informatica tool but in a few months we will need to change. Basically we do not use our software at its full capacity and don't feel we need it anymore. So ...
    Aug 13, 2009 at 9:22 am
    Aug 16, 2009 at 1:21 pm
  • Hello, I have a problem with an inner join + count(). my query is: explain analyze select k.idn,k.kerdes_subject,k.kerdes_text,u.vezeteknev,u.keresztnev,u.idn as user_id, kg.kategoria_neve, ...
    Adam PAPAIAdam PAPAI
    Aug 2, 2009 at 4:50 pm
    Aug 4, 2009 at 1:46 pm
  • The database is 8gb currently. Use to be a lot bigger but we removed all large objects out and developed a file server storage for it, and using default page costs for 8.4, I did have it changed in ...
    Chris DunnChris Dunn
    Aug 3, 2009 at 2:04 am
    Aug 3, 2009 at 2:17 am
Group Navigation
period‹ prev | Aug 2009 | next ›
Group Overview
grouppgsql-performance @

82 users for August 2009

Tom Lane: 32 posts Robert Haas: 23 posts Kevin Grittner: 22 posts Scott Marlowe: 20 posts Greg Stark: 14 posts Matthew Wakeling: 13 posts Scott Carey: 13 posts Jean-Michel Pouré: 12 posts Alvaro Herrera: 10 posts Pierre Frédéric Caillaud: 8 posts Jeff Janes: 7 posts Merlin Moncure: 7 posts Ip Wing Kin John: 6 posts Josh Berkus: 6 posts Jaime Casanova: 5 posts Jeremy Carroll: 5 posts Karl Denninger: 5 posts Slava Moudry: 5 posts Subbiah Stalin-XCGF84: 5 posts Andy Colson: 4 posts
show more