FAQ

PostgreSQL > pgsql-performance > August 2011

Search Discussions

40 discussions - 328 posts

  • Hope all is well. I have received tremendous help from this list prior and therefore wanted some more advice. I bought some new servers and instead of RAID 5 (which I think greatly hindered our ...
    OgdenOgden
    Aug 17, 2011 at 1:41 am
    Sep 13, 2011 at 2:15 am
  • Hello all, I have a query which takes about 20 minutes to execute and retrieves 2000-odd records. The explain for the query is pasted here http://explain.depesz.com/s/52f The same query, with similar ...
    Jayadevan MJayadevan M
    Aug 31, 2011 at 9:01 am
    Sep 6, 2011 at 3:30 am
  • Hello Everyone, I am working on an alert script to track the number of connections with the host IPs to the Postgres cluster. 1. I need all the host IPs making a connection to Postgres Cluster (even ...
    Venkat BalajiVenkat Balaji
    Aug 24, 2011 at 7:35 am
    Sep 12, 2011 at 5:00 pm
  • Dear all, From the last few days, I researched a lot on Postgresql Performance Tuning due to slow speed of my server. My application selects data from mysql database about 100000 rows , process it & ...
    Adarsh SharmaAdarsh Sharma
    Aug 4, 2011 at 4:56 am
    Aug 17, 2011 at 9:17 pm
  • I have PostgreSQL 8.4.8 on Ubuntu Linux x64. Server is a Core i7 950 with 6GB of RAM. 2GB of RAM us used by Java, some small amount by the kernel / services and the rest is available to PostgreSQL. ...
    Waldo NellWaldo Nell
    Aug 12, 2011 at 12:03 am
    Aug 12, 2011 at 9:07 pm
  • hi, We recently bought a 4 8core 128G memory database server and I am setting it up to replace our old 4 4cores 128G memory database server as a master. The memory related settings that we use on the ...
    Claire ChangClaire Chang
    Aug 4, 2011 at 8:27 pm
    Aug 9, 2011 at 3:59 am
  • I am in the progress of an 8.3 to 8.4 upgrade for a customer. I seem to have stumbled upon what looks like a regression. The two databases (8.3.14 and 8.4.8) have identical tuning parameters (where ...
    Mark KirkwoodMark Kirkwood
    Aug 23, 2011 at 4:52 am
    Sep 4, 2011 at 10:15 pm
  • News update for anyone else who's trapped like me, waiting for a fix to the Intel 320 SSD bug where they can truncate themselves to 8MB. Over the weekend Intel has announced a firmware fix for the ...
    Greg SmithGreg Smith
    Aug 15, 2011 at 11:50 pm
    Aug 24, 2011 at 8:27 pm
  • Dear All, I have some problems with regexp queries performance - common sense tells me that my queries should run faster than they do. The database - table in question has 590 K records, table's size ...
    Grzegorz BlinowskiGrzegorz Blinowski
    Aug 10, 2011 at 2:26 pm
    Aug 12, 2011 at 3:25 pm
  • Hi, I'm looking for summaries (or best practices) on SSD usage with PostgreSQL. My use case is mainly a "read-only" database. Are there any around? Yours, Stefan
    Stefan KellerStefan Keller
    Aug 30, 2011 at 5:23 pm
    Sep 6, 2011 at 2:07 pm
  • Apologies if this has already been posted here (I hadn't seen it before today, and can't find a previous post). This will be of interest to anyone looking at using SSDs for database storage : ...
    David BorehamDavid Boreham
    Aug 24, 2011 at 5:01 pm
    Aug 24, 2011 at 8:51 pm
  • I'm in the process of upgrading from postgres 7.4.8 to 9.0.4 and wanted to run my decisions past some folks who can give me some input on whether my decisions make sense or not. It's basically a LAPP ...
    Midge BrownMidge Brown
    Aug 18, 2011 at 9:55 pm
    Aug 22, 2011 at 4:53 pm
  • Hi All , Can you please help me out with the following questions . Our application is running on Postgres 7.4.X . I agree that this is a very old version of Postgres and we should have upgraded . The ...
    Sumeet JauharSumeet Jauhar
    Aug 3, 2011 at 7:35 am
    Aug 9, 2011 at 4:13 am
  • Hi, I've run a lot of pgbench tests recently (trying to compare various fs, block sizes etc.), and I've noticed several really strange results. Eeach benchmark consists of three simple steps: 1) ...
    Tomas VondraTomas Vondra
    Aug 12, 2011 at 11:37 pm
    Aug 15, 2011 at 8:36 pm
  • I have postgresql 9.0.1 on windows 2003 ent with 6GB ram, 4 disk SATA RAID 10. I am running SymmetricDS to replication over WAN. But yesterday there was a big problem, i updated alot of rows and ...
    TuanhoanganhTuanhoanganh
    Aug 5, 2011 at 4:43 pm
    Aug 8, 2011 at 6:35 pm
  • I'm buying a bunch of new machines (all will run an application that heavily writes to PG). These machines will have 2 spindle groups in a RAID-1 config. Drives will be either 15K SAS, or 10K SATA (I ...
    David BorehamDavid Boreham
    Aug 23, 2011 at 2:42 am
    Aug 24, 2011 at 3:28 am
  • Hi everyone, I'm using postgres 9.0.3, and here's the OS I'm running this on: Linux 2.6.18-238.12.1.el5xen #1 SMP Tue May 31 14:02:29 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux I have a fairly straight ...
    Anish KejariwalAnish Kejariwal
    Aug 17, 2011 at 6:23 pm
    Aug 18, 2011 at 6:46 pm
  • Hello all, We are planning to test one of our products, which works with Oracle, on PostgreSQL. The database size is about 100 GB. It is a product with a not-so-high load ( about 10 tps - mostly ...
    Jayadevan MJayadevan M
    Aug 1, 2011 at 12:14 pm
    Aug 4, 2011 at 1:58 pm
  • Hi all, I am running a simple query: SELECT * FROM public."Frame" Time taken: 35.833 ms (i.e. roughly 35 seconds) Number of rows: 121830 Number of columns: 38 This is extremely slow for a database ...
    Kai OttoKai Otto
    Aug 31, 2011 at 1:17 pm
    Sep 5, 2011 at 9:21 am
  • Greetings, I've been hitting a "out of memory error" during autovacuum of relatively large tables (compared to the amount of RAM available). I'm trying to trace the cause of the issue; the answer is ...
    Alexis Lê-QuôcAlexis Lê-Quôc
    Aug 10, 2011 at 3:58 pm
    Aug 10, 2011 at 7:28 pm
  • Hi all, I have read things someplace saying not exists was better than not in... or something like that. Not sure if that was for in/exists and not in/not exists, and for a lot of records or not. ...
    Andy ColsonAndy Colson
    Aug 30, 2011 at 8:29 pm
    Sep 23, 2011 at 1:32 am
  • Hello, I asked that question on StackOverflow, but didn't get any valuable response, so I'll ask it here. :) I have such query: SELECT "spoleczniak_tablica"."id", "spoleczniak_tablica"."postac_id", ...
    Szymon KosokSzymon Kosok
    Aug 30, 2011 at 5:41 am
    Aug 30, 2011 at 8:20 am
  • Hello, I need to compare quiery execution : I have 2 tables partitioned by Datex ( daily): summary_daily ( counter | bigint datasource_id | integer application_id | integer action | character(1) ...
    HyelluasHyelluas
    Aug 12, 2011 at 9:29 pm
    Aug 17, 2011 at 6:52 pm
  • I had done some testing for my application (WIP) and I had executed same SQL script and queries on real physical 64-bit Windows 7 and on virtualized 64-bit CentOS 6. Both database servers are tuned ...
    Dusan MisicDusan Misic
    Aug 3, 2011 at 4:37 pm
    Aug 9, 2011 at 3:52 am
  • Can a transaction committed asynchronously report an error, duplicate key or something like that, causing a client with a OK transaction but server with a FAILED transaction. Thanks
    Anibal David AcostaAnibal David Acosta
    Aug 1, 2011 at 3:23 pm
    Aug 3, 2011 at 12:08 am
  • Hello everyone, This is my first post on this list, I tried to look after possible solutions in the archive, as well as in google, but I could not find an explanation for such a specific situation. I ...
    Jan WielgusJan Wielgus
    Aug 2, 2011 at 10:03 am
    Oct 24, 2011 at 7:31 pm
  • Hello, I have an old application that was written on Postgres 8.1. There are a few hundreds tables, 30-40 columns per table, hundreds of views, and all the sql is inside java code. We are moving it ...
    HyelluasHyelluas
    Aug 17, 2011 at 10:40 pm
    Aug 19, 2011 at 9:15 pm
  • Is there any performance benefit of using constant size tuples?
    Krzysztof ChodakKrzysztof Chodak
    Aug 19, 2011 at 9:04 am
    Aug 19, 2011 at 3:20 pm
  • Hi, I encountered a problem while trying to improve the performance of a certain select query I have made. here is a simplified code for the function I am using CREATE OR REPLACE FUNCTION ...
    Eyal WildeEyal Wilde
    Aug 16, 2011 at 4:30 am
    Aug 17, 2011 at 8:50 pm
  • Dear all, Just want to know which join is better for querying data faster. I have 2 tables A ( 70 GB ) & B ( 7 MB ) A has 10 columns & B has 3 columns.Indexes exist on both tables's ids. select p.* ...
    Adarsh SharmaAdarsh Sharma
    Aug 2, 2011 at 6:42 am
    Aug 3, 2011 at 12:16 am
  • Hi, I'm looking for a hint how array access performs in PostgreSQL in respect to performance. Normally I would expect access of a 1-dimensional Array at slot i (array[i]) to perform in constant time ...
    Andreas BrandlAndreas Brandl
    Aug 2, 2011 at 1:06 pm
    Aug 2, 2011 at 3:16 pm
  • Hi all, I'm testing Streamin replication with one hot standby node and I'm experiencing high delay of hot standby node. When I reach aprox. 50 transactions per second where every transaction includes ...
    Antonin FaltynekAntonin Faltynek
    Aug 11, 2011 at 2:46 pm
    Aug 16, 2011 at 8:03 pm
  • Hello PG perf junkies, Sorry this may get a little long winded. Apologies if the formatting gets trashed. Also apologies if this double posts. (I originally set it yesterday with the wrong account ...
    MarkMark
    Aug 9, 2011 at 2:06 am
    Aug 9, 2011 at 4:14 am
  • Hey, I'm a new user of PostgreSQL. I found one of my tables is taking unexpectedly large space: select pg_size_pretty(pg_relation_size('archive_files')); pg_size_pretty ---------------- 1113 MB The ...
    Jian ShiJian Shi
    Aug 4, 2011 at 6:59 pm
    Aug 4, 2011 at 11:47 pm
  • Hi. I have a table called work (id bigserial, userid int4, kind1 enum, kind2 enum, kind3 enim, value bigint, modified timestamp) Table will have about 2*10^6 rows (at same time - overall it can have ...
    Tasdassa AsdasdaTasdassa Asdasda
    Aug 29, 2011 at 9:19 am
    Aug 29, 2011 at 8:38 pm
  • I have a index in a table. The value of the reltuples value in the pg_class table for this index is less than the number of rows in the table where the index is present. For eg. if i have 800 rows in ...
    ParulParul
    Aug 24, 2011 at 10:04 am
    Aug 25, 2011 at 2:43 pm
  • hi pgpool Expert my architecture as follows: Master/Slave with Streaming Replication and pgpool-II version of pgpool-II is pgpool-II.3.0.4 version of PostgreSQL is 9.0.2 I am using pgpool works as ...
    JenopobJenopob
    Aug 12, 2011 at 10:58 am
    Aug 12, 2011 at 4:44 pm
  • Hello PG perf junkies, Sorry this may get a little long winded. Apologies if the formatting gets trashed. Background: I have been setting up some new servers for PG and I am getting some odd numbers ...
    MarkMark
    Aug 8, 2011 at 6:25 am
    Aug 8, 2011 at 6:27 am
  • In this example it looks to me like the planner is choosing a Seq Scan resulting in 18x running time compared to running it with enable_seqscan = 'off'. Adding more indexes to public.gene (please see ...
    Nassib NassarNassib Nassar
    Aug 4, 2011 at 1:45 pm
    Aug 4, 2011 at 3:07 pm
  • Dear all, I research a lot on Postgresql Performance Tuning and find some parameters to increase the select performance in postgresql. By increasing shared_buffers,effective_cache_size ,work_mem, ...
    Adarsh SharmaAdarsh Sharma
    Aug 1, 2011 at 7:31 am
    Aug 1, 2011 at 1:57 pm
Aug 2011
Group Navigation
period‹ prev | Aug 2011 | next ›
Group Overview
grouppgsql-performance @
categoriespostgresql
discussions40
posts328
users84
websitepostgresql.org
irc#postgresql

84 users for August 2011

Kevin Grittner: 29 posts Greg Smith: 20 posts Tomas Vondra: 16 posts Scott Marlowe: 15 posts Ogden: 14 posts Tom Lane: 12 posts Andy Colson: 11 posts Mark Kirkwood: 10 posts Merlin Moncure: 10 posts Craig Ringer: 9 posts David Boreham: 9 posts Jayadevan M: 7 posts Robert Klemme: 7 posts Waldo Nell: 7 posts Robert Ayrapetyan: 6 posts Віталій Тимчишин: 6 posts Adarsh Sharma: 5 posts Dusan Misic: 5 posts Hyelluas: 5 posts Ktm: 5 posts
show more
Archives